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
Intro to SQL and Relational Databases
- Grasping database architecture
- Introduction to SQL syntax
- Interacting with tables and schemas
Fundamental Querying Methods
- Selecting and projecting information
- Filtering rows via the WHERE clause
- Ordering results with ORDER BY
Connecting Multiple Tables
- Inner, left, right, and full outer joins
- Merging datasets from various sources
- Addressing join conditions
Aggregation and Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX
- Effectively applying GROUP BY
- Filtering aggregated data using HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and computations
Data Alteration and Manipulation
- Inserting new entries
- Modifying current records
- Removing data securely
Database Objects and Restrictions
- Comprehending primary and foreign keys
- Utilizing views
- Enforcing constraints and rules
Advanced SQL Strategies
- Window functions
- Common Table Expressions (CTEs)
- Performance factors and basic query tuning
Recap and Future Directions
Requirements
- A foundational grasp of basic data concepts
- Experience working with spreadsheets or tabular formats
- 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
