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
- Exploring the structure of databases.
- An overview of SQL syntax.
- Interacting with tables and schemas.
Foundational Querying Techniques
- Selecting and projecting specific 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.
- Effective application of GROUP BY.
- Filtering grouped results using HAVING.
Subqueries and Nested Statements
- Working with scalar subqueries.
- Understanding correlated subqueries.
- Applying subqueries for complex filtering and calculations.
Data Manipulation and Modification
- Inserting new data records.
- Updating existing entries.
- Safely deleting data.
Database Objects and Constraints
- Grasping the role of primary and foreign keys.
- Managing views.
- Implementing constraints and validation rules.
Advanced SQL Techniques
- Leveraging window functions.
- Using Common Table Expressions (CTEs).
- Basics of performance considerations and query tuning.
Summary and Next Steps
Requirements
- A foundational understanding of core data concepts.
- Prior experience handling spreadsheets or tabular data.
- General familiarity with business applications.
Target Audience
- Data analysts.
- IT professionals.
- Individuals responsible for managing, querying, and analyzing data.
Testimonials (2)
The SQL simulator designed by Philippe
Jean-Pierre ABRIAL - AGL
Course - SQL Fundamentals
Machine Translated
Small group, in-person for 3 days,
