Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to SQL and Relational Databases
- Comprehending database structures
- Overview of SQL syntax
- Working with tables and schemas
Basic Querying Techniques
- Selecting and projecting data
- Filtering rows using WHERE clauses
- Sorting results with ORDER BY
Joining Multiple Tables
- Inner, left, right, and full joins
- Combining datasets from various sources
- Resolving join conditions
Aggregations and Grouping
- Using COUNT, SUM, AVG, MIN, and MAX functions
- Applying GROUP BY effectively
- Filtering grouped data using HAVING
Subqueries and Nested Statements
- Scalar subqueries
- Correlated subqueries
- Utilizing subqueries for filtering and calculations
Data Manipulation and Modification
- Inserting new data
- Updating existing records
- Deleting data safely
Database Objects and Constraints
- Understanding primary and foreign keys
- Working with views
- Implementing constraints and rules
Advanced SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
- Performance considerations and basics of query tuning
Summary and Next Steps
Requirements
- Basic understanding of data concepts
- Experience working with spreadsheets or tabular data
- Familiarity with standard business applications
Target Audience
- Data analysts
- IT professionals
- Users responsible for managing, querying, and analyzing data
10 Hours
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
