SQL Database Design and Querying Training Course | Code College


SQL Training Course

Learn the fundamentals of SQL Databases and SQL Querying, and how to apply it practically



Duration

  • 5 Days Full-time

What do I need?

  • Webinar : A laptop, and a stable internet connection. The recommended minimum speed is around 10 Mbps.
  • Classroom Training : A laptop, please notify us if you are not bringing your own laptop. Please see the calendar below for the schedule

Certification

  • Attendance : If you have attended 80% of the sessions and completed all the class work, you qualify for the Attendance Certificate. (Course Price : R14 995)
  • Competency : Only offered as part of a Coding Bootcamp
  • You may apply for credits in NQF level 5 but these are ordered seperataly as it incurs additional processing

Pre-requisites

  • None - this is one of our entry-level courses

Delivery

  • In-Person (Woodmead Classroom)
  • Remote (Discord Webinar)

Who will benefit

  • School leavers intending to do one of our Coding Bootcamps.
  • You have been using spreadsheets, but are getting readu for somethin bigger and more sustainable, a database!
  • Junior Developers should know SQL and databases - you cannot develop software without a solid data base foundation

What you will learn

  • Understand Tables and how to design them, maintain them and query them
  • How to query single and multiple tables with the SELECT statement
  • The DELETE and UPDATE statments and how to use them safely
  • ALTER - how to modify existing tables and databases
  • Advanced querying functions like GROUP By etc. and when are they useful
  • Subqueries - when to use and not
  • Outer Joins - when they are useful
  • Constraints - why do we need them
  • UML - how to design a normalised database with UML
  • Forward Engineering - how to forward engineer a schema from a UML disgram
  • Reverse Engineering - how to reverse engineer a UML Diagram from an existing schema

Content



Day 1

Setting Up

  • Data and Tables a place for everything
  • Data in categories
  • What's in a Database
  • CREATE TABLE
  • Statement Data types DESCribed
  • INSERT Statement
  • NULL, NOT NULL
  • DEFAULT The SELECT Statement
  • data retrieval
  • How to query data types
  • Comparison Operators
  • AND, OR, LIKE, BETWEEN, IN, NOT IN

    • Day 2

  • DELETE and UPDATE –
  • a change will do you good
  • Smart table design
  • why be normal?
  • Atomic data mary KeyPri ALTER
  • Rewriting the past Renaming the table
  • DROP column
  • UPDATE, SET

    • Day 3

  • Advanced SELECT
  • Seeing your data with new eyes
  • CASE expression
  • ORDER BY SUM, MIN, MAX, AVG, GROUP BY COUNT,
  • LIMIT Multi-table Database Design
  • Outgrowing your table Schema
  • How to go from one table to two
  • Create a table with a Foreign Key
  • Relationships between tables
  • Patterns of data Junction table
  • 1NF Partial functional dependency
  • Transitive functional dependency 2NF 3NF

    • Day 4

  • JOINS and multi table operations
  • CREATE, SELECT, INSERT at the same time AS, column aliases
  • Inner JOINS
  • Subqueries Queries within queries
  • Natural Join
  • Noncorrelated subqueries
  • Correlated subqueries
  • EXISTS and NOT EXISTS
  • OUTER JOINS, SELF JOINS and UNIONS
  • Left and right outer join
  • A self-referencing foreign key
  • INTERSECT and EXCEPT
  • Turning a subquery into a join

    • Day 5

  • Constraints, Views and Transactions
  • CHECK CONSTRAINT
  • with views
  • Creating a view
  • Inserting, updating and deleting
  • Transactions
  • The ACID Test
  • Security protecting your assets
  • GRANT statement
  • GRANT variations
  • REVOKE privileges
  • REVOKING a used GRANT OPTION
  • MTA-Exam 98-364 Review Prep
  • Comptency Assesment Project

    • Calendar