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 database structures
- SQL syntax overview
- Interacting with tables and schemas
Fundamentals of Querying
- Selecting and projecting specific data
- Filtering rows using WHERE clauses
- Sorting output with ORDER BY
Joining Multiple Tables
- Inner, left, right, and full joins
- Merging datasets from various sources
- Defining and resolving join conditions
Aggregation and Grouping
- Leveraging COUNT, SUM, AVG, MIN, and MAX
- Effectively applying GROUP BY
- Filtering grouped results with HAVING
Subqueries and Nested Statements
- Scalar subqueries
- Correlated subqueries
- Utilizing subqueries for filtering and computation
Data Manipulation and Modification
- Inserting new records
- Modifying existing data
- Safely deleting information
Database Objects and Constraints
- Comprehending primary and foreign keys
- Managing views
- Implementing constraints and rules
Advanced SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
- Performance best practices and query optimization
Summary and Future Directions
Requirements
- A foundational understanding of basic data concepts
- Prior experience with spreadsheets or tabular data
- General familiarity with business applications
Target Audience
- Data analysts
- IT specialists
- Professionals 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
