SQL Training Course

Learn the fundamentals of SQL, and how to apply your SQL knowledge

Pre-requisites

Our Intro To Programming level is required for entry into this course

Who will benefit

  • School leavers intending to do one of our Coding Bootcamps.
  • Professionals who are already familiar with another programming language
  • This course is also the first module in all our our Coding Bootcamps
  • 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.

    What you will learn

    • Know the Fundamentals of HTML, CSS, JavaScript and how they work together to build apps.
    • Know how to debug JavaScript programs in the browser.
    • Know how to use data structures, control flow to build 5-10 useful small apps combining HTML, CSS and JavaScript.
    • Have enough JavaScript knowledge to pass a recognised international JavaScript Quiz.
    • Build an HTML Web Site showing off your portfolio of projects and host it online.

    What do I need?

    Live Online Training : 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 brining your own laptop. Please see the calendar below for the schedule

    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