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
- Grasping database architecture
- Overview of SQL syntax
- Interacting with tables and schemas
Basic Querying Methods
- Selecting and projecting specific data
- Narrowing rows using the WHERE clause
- Ordering outcomes with ORDER BY
Merging Multiple Tables
- Inner, left, right, and full outer joins
- Integrating data from various sources
- Defining join criteria
Aggregations and Grouping
- Leveraging COUNT, SUM, AVG, MIN, and MAX
- Strategic use of GROUP BY
- Filtering aggregated data with HAVING
Subqueries and Nested Structures
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and computation
Data Manipulation and Changes
- Adding new records
- Modifying existing entries
- Securely removing data
Database Objects and Constraints
- Comprehending primary and foreign keys
- Utilizing views
- Setting up constraints and rules
Advanced SQL Strategies
- Window functions
- Common Table Expressions (CTEs)
- Performance optimization and basic query tuning
Recap and Future Steps
Requirements
- Fundamental grasp of data principles
- Hands-on experience with spreadsheets or tabular formats
- Knowledge of standard business software
Target Audience
- Data analysts
- IT specialists
- Professionals responsible for data management, querying, and analysis
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
