SQL Training Course

Learn the fundamentals of SQL, and how to apply it

Duration

  • 5 Days

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.
  • Competency : If you have also completed all the practical projects as described the Outcomes section, you qualify for the Competency Certificate.

Pre-requisites

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

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

Day One

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 Two

  • 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 Three

    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 Four

  • 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 Five

  • 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
  • Back to top