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
- Exploring the underlying structure of databases
- A high-level overview of SQL syntax
- Interacting with tables and schemas
Fundamental Querying Techniques
- Extracting and projecting specific data
- Filtering rows using the WHERE clause
- Arranging output with ORDER BY
Combining Data from Multiple Tables
- Mastering inner, left, right, and full joins
- Merging datasets from various sources
- Defining and resolving join conditions
Data Aggregation and Grouping
- Utilizing aggregate functions like COUNT, SUM, AVG, MIN, and MAX
- Effective application of the GROUP BY clause
- Filtering aggregated results with HAVING
Subqueries and Nested Logic
- Working with scalar subqueries
- Understanding correlated subqueries
- Leveraging subqueries for filtering and complex calculations
Data Manipulation and Modification
- Adding new records to the database
- Modifying existing data entries
- Safely removing unwanted data
Database Objects and Integrity Constraints
- Grasping the role of primary and foreign keys
- Creating and utilizing views
- Implementing constraints to enforce data rules
Advanced SQL Concepts
- Implementing window functions
- Using Common Table Expressions (CTEs)
- Introducing performance tuning and optimization basics
Recap and Future Learning Paths
Requirements
- A solid grasp of fundamental data concepts
- Prior experience working with spreadsheets or tabular formats
- Basic familiarity with standard business software applications
Target Audience
- Data analysts
- IT specialists and professionals
- Individuals responsible for managing, querying, and analyzing organizational 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
The lecture about cte