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 Database Architectures
- Grasping the underlying structures of databases
- A look at SQL syntactic rules
- Interacting with tables and schemas
Fundamental Query Construction
- Selecting specific fields and projecting data
- Using the WHERE clause to filter rows
- Arranging output with ORDER BY
Connecting Multiple Tables
- Exploring Inner, Left, Right, and Full joins
- Merging data from various sources
- Establishing and resolving join criteria
Aggregation and Grouping Data
- Leveraging functions like COUNT, SUM, AVG, MIN, and MAX
- Strategic use of GROUP BY
- Filtering grouped outcomes with HAVING
Subqueries and Nested Logic
- Implementing scalar subqueries
- Working with correlated subqueries
- Utilizing subqueries for complex filtering and computations
Data Modification and Maintenance
- Adding new entries to the database
- Modifying existing records
- Executing safe deletion processes
Database Objects and Data Constraints
- Conceptualizing primary and foreign keys
- Creating and utilizing views
- Enforcing constraints and business rules
Sophisticated SQL Strategies
- Application of window functions
- Utilizing Common Table Expressions (CTEs)
- Basics of performance optimization and query tuning
Recap and Future Learning Paths
Requirements
- A foundational grasp of core data concepts
- Prior experience working with spreadsheets or tabular formats
- General familiarity with business-oriented applications
Target Audience
- Data analysts
- Information technology 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
