Introduction to SQL Programming

...
This is 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.

A discount is available when:
  • a single customer proceeds with more than three registrations for a particular session;
  • a learner is not currently employed.
Please contact us to receive your discount coupon if you meet any of the above-mentioned criteria.

Please also note that the upcoming sessions are guaranteed to run once they have a minimum number of learners registered.
Total price:
540.00660.00 final price

Available Sessions

DateTimezoneTraining TypeWeekend-WeekdayDescriptionPrice 
8, 9, 10 & 11/4/2024, 10:00 am-2:00 pm (EEST)Europe/AthensLive VirtualWeekday540.00660.00 final price
3, 4, 5 & 6/6/2024, 10:00 am-2:00 pm (EEST)Europe/AthensLive VirtualWeekday540.00660.00 final price

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
Date

8, 9, 10 & 11/4/2024, 10:00 am-2:00 pm (EEST), 3, 4, 5 & 6/6/2024, 10:00 am-2:00 pm (EEST)

Timezone

Training Type

Weekend-Weekday