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 Systems
- Comprehending database architectures
- Fundamental overview of SQL syntax
- Interacting with tables and schemas
Foundational Querying Methods
- Selecting and projecting specific data
- Filtering records using the WHERE clause
- Arranging results via the ORDER BY clause
Connecting Multiple Tables
- Inner, left, right, and full outer joins
- Merging data from various sources
- Addressing join conditions and logic
Aggregation and Data Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX functions
- Effective application of the GROUP BY clause
- Filtering aggregated results using HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Leveraging subqueries for filtering and computations
Data Manipulation and Alteration
- Adding new entries
- Modifying existing records
- Safely removing data
Database Objects and Integrity Constraints
- Understanding primary and foreign key relationships
- Working with database views
- Enforcing constraints and business rules
Advanced SQL Capabilities
- Window functions
- Common Table Expressions (CTEs)
- Performance optimization and basic query tuning
Recap and Future Directions
Requirements
- A foundational grasp of basic data principles
- Practical experience with spreadsheets or tabular structures
- Familiarity with common 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
