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
SQL and Relational Database Introduction
- Grasping database architecture
- Introduction to SQL syntax
- Managing tables and schemas
Fundamental Querying Methods
- Selecting and projecting data fields
- Filtering specific rows using WHERE clauses
- Ordering results with ORDER BY
Connecting Multiple Tables
- Inner, left, right, and full outer joins
- Merging datasets from various sources
- Defining and resolving join conditions
Aggregation and Data Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX functions
- Effective use of GROUP BY
- Filtering aggregated data with HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Applying subqueries for filtering and complex calculations
Data Modification and Manipulation
- Inserting new records
- Modifying existing entries
- Safe data deletion practices
Database Structures and Constraints
- Understanding primary and foreign key relationships
- Utilizing views
- Establishing constraints and data rules
Advanced SQL Strategies
- Window functions
- Common Table Expressions (CTEs)
- Performance optimization and query tuning fundamentals
Course Recap and Future Directions
Requirements
- A foundational understanding of core data concepts
- Familiarity with spreadsheets or tabular data formats
- General experience 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
