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.
Duration 10 hours
Course Outline
Introduction to SQL and Relational Database Architecture
- Grasp the underlying structure of databases
- Overview of SQL syntax conventions
- Managing tables and schema definitions
Core Querying Methods
- Selecting and projecting specific data fields
- Filtering records using the WHERE clause
- Ordering output with the ORDER BY clause
Connecting Multiple Tables
- Mastering inner, left, right, and full joins
- Merging data from diverse sources
- Defining and resolving join conditions
Aggregation and Data Grouping
- Leveraging functions like COUNT, SUM, AVG, MIN, and MAX
- Effective application of the GROUP BY clause
- Filtering aggregated results using the HAVING clause
Subqueries and Nested Logic
- Working with scalar subqueries
- Implementing correlated subqueries
- Using subqueries for enhanced filtering and computation
Data Modification and Manipulation
- Inserting new records into the database
- Modifying existing data entries
- Safely removing obsolete data
Database Objects and Data Integrity
- Understanding primary and foreign key relationships
- Utilizing views for data abstraction
- Enforcing constraints and business rules
Advanced SQL Methodologies
- Implementing window functions
- Using Common Table Expressions (CTEs)
- Introduction to performance optimization and query tuning
Course Wrap-up and Future Learning Pathways
Requirements
- Foundational knowledge of core data concepts
- Practical experience with spreadsheets or tabular structures
- General familiarity with business application workflows
Target Audience
- Data analysts
- IT specialists
- Professionals responsible for data management, querying, and analysis
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
