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
- Grasping database architecture
- Interacting with tables and schemas
Foundational Querying Techniques
- Selecting and retrieving data
- Filtering records using WHERE clauses
- Arranging output with ORDER BY
Joining Multiple Tables
- Inner, left, right, and full outer joins
- Merging datasets from various sources
- Establishing join conditions
Aggregation and Grouping Data
- Utilizing COUNT, SUM, AVG, MIN, and MAX
- Effectively applying GROUP BY
- Filtering aggregated results with HAVING
Subqueries and Nested Statements
- Scalar subqueries
- Correlated subqueries
- Leveraging subqueries for filtering and computations
Data Manipulation and Modification
- Inserting new records
- Modifying existing entries
- Safely removing data
Database Objects and Constraints
- Understanding primary and foreign keys
- Working with database views
- Applying constraints and rules
Advanced SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
- Query performance tuning and optimization basics
Conclusion and Future Steps
Requirements
- A grasp of fundamental data concepts
- Experience with spreadsheets or tabular formats
- Knowledge of general business applications
Intended Audience
- Data analysts
- IT specialists
- Individuals 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
The lecture about cte