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 Databases
- Grasping database structures
- A brief overview of SQL syntax
- Working with tables and schemas
Basic Querying Techniques
- Retrieving and projecting data
- Filtering rows using the WHERE clause
- Ordering results with ORDER BY
Joining Multiple Tables
- Implementing inner, left, right, and full joins
- Merging datasets from various sources
- Defining and resolving join conditions
Aggregations and Grouping
- Utilizing functions like COUNT, SUM, AVG, MIN, and MAX
- Effectively applying GROUP BY
- Filtering grouped results with HAVING
Subqueries and Nested Statements
- Using scalar subqueries
- Implementing correlated subqueries
- Leveraging subqueries for filtering and complex calculations
Data Manipulation and Modification
- Inserting new records
- Modifying existing entries
- Safely removing data
Database Objects and Constraints
- Understanding primary and foreign key relationships
- Working with database views
- Enforcing constraints and rules
Advanced SQL Techniques
- Working with window functions
- Using Common Table Expressions (CTEs)
- Basic query tuning and performance optimization
Summary and Next Steps
Requirements
- A foundational understanding of basic data concepts
- Prior experience working with spreadsheets or tabular data
- General familiarity with business applications
Target Audience
- Data analysts
- IT professionals
- Individuals responsible for managing, querying, and analyzing data
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
