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