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
- Overview of SQL syntax
- Managing tables and schemas
Fundamental Querying Methods
- Selecting and projecting data
- Filtering rows using WHERE
- Ordering results with ORDER BY
Connecting Multiple Tables
- Inner, left, right, and full joins
- Merging datasets from various sources
- Managing join conditions
Aggregation and Grouping Strategies
- Utilizing COUNT, SUM, AVG, MIN, MAX
- Effective application of GROUP BY
- Filtering aggregated data with HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Leveraging subqueries for filtering and calculations
Data Manipulation and Modification
- Inserting new records
- Updating existing entries
- Safely deleting data
Database Objects and Constraints
- Understanding primary and foreign keys
- Working with views
- Implementing constraints and rules
Advanced SQL Concepts
- Window functions
- Common Table Expressions (CTEs)
- Performance considerations and basic query tuning
Recap and Future Directions
Requirements
- A foundational grasp of basic data concepts
- 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 (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
