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
- Comprehending database structures
- Overview of SQL syntax
- Working with tables and schemas
Basic Querying Techniques
- Selecting and projecting data
- Filtering rows using the WHERE clause
- Ordering results via ORDER BY
Joining Multiple Tables
- Inner, left, right, and full joins
- Merging datasets from various sources
- Defining and resolving join conditions
Aggregations and Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX functions
- Effective application of GROUP BY
- Filtering aggregated data using HAVING
Subqueries and Nested Statements
- Scalar subqueries
- Correlated subqueries
- Leveraging subqueries for filtering and calculations
Data Manipulation and Modification
- Inserting new records
- Modifying existing data
- Safely deleting data
Database Objects and Constraints
- Understanding primary and foreign keys
- Managing and using views
- Implementing constraints and rules
Advanced SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
- Basics of performance considerations and query tuning
Summary and Next Steps
Requirements
- Foundational understanding of basic data concepts
- Experience working with spreadsheets or tabular data
- Familiarity with general business applications
Target Audience
- Data analysts
- IT professionals
- Users required to manage, query, and analyze 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
