Introduction to SQL Programming

...
This is now a virtual classroom course. You can find more information about our virtual classroom here

This is a 16-hour hands-on workshop on Structured Query Language (SQL) with ultimate goal to make participants feel comfortable with the fundamentals of SQL

Total price:
490.00600.00 final price
Clear
Quantity

This is a 16-hour hands-on workshop on Structured Query Language (SQL) with ultimate goal to make participants feel comfortable with the fundamentals of SQL

Who should attend

Anyone wishing to gain knowledge of SQL, as well as those wishing to refresh their SQL skills. This includes End Users of business systems, Business Analysts, Test Analysts, Test Managers, Software Engineers, and anyone who might want to query data from a database management system.

What will you learn

During this theory and hands-on course, participants will cover the following areas:

  • Introduction to relational databases
    • History of DBMS
    • Relational databases
    • Course Database: Description of the database used in the course for queries
  • Data Modeling
    • Relational Model
    • Third Normal Form
    • Entity Relationship Model
    • Constraints
      • Foreign key constraints
      • Referential Integrity
      • Not NULL constraints
    • Schema Design engineering trade-offs
    • Course project: Schema design for the course project
  • SQL basics
    • Relational algebra
    • Projections
    • NULL values
    • Ordering
    • Joins
    • Subqueries
    • Groupings and Aggregations
    • Insert, Update, Delete
    • Course project: Develop main project queries
  • Transactions
    • Why we need transactions
    • Course Project: Add transaction where needed on project queries
  • Triggers
    • Motivation
    • Engineering trade offs
  • Views
    • Virtual views
    • Materialized views
    • Course Project: Develop project views
  • Stored procedures
    • Motivation
    • Engineering trade offs
  • Query Execution
    • Query Planner
    • Query Parsing
    • Logical Query Plan
    • Physical Plan
    • Understanding query plans
    • Course Project: Optimize project queries by analyzing query plans