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 architecture
- Fundamentals of SQL syntax
- Interacting with tables and schemas
Fundamental Querying Methods
- Selecting and projecting specific data
- Filtering records using the WHERE clause
- Ordering output via ORDER BY
Connecting Multiple Tables
- Executing inner, left, right, and full joins
- Merging data from various sources
- Defining and resolving join conditions
Aggregation and Grouping Strategies
- Applying functions like COUNT, SUM, AVG, MIN, and MAX
- Utilizing GROUP BY for structured output
- Filtering aggregated results with HAVING
Subqueries and Nested Logic
- Implementing scalar subqueries
- Working with correlated subqueries
- Using subqueries for advanced filtering and calculations
Data Modification and Maintenance
- Inserting new records
- Updating existing entries
- Safely removing data
Database Objects and Integrity Constraints
- Understanding primary and foreign key relationships
- Creating and using views
- Enforcing constraints and rules
Advanced SQL Methodologies
- Exploring window functions
- Using Common Table Expressions (CTEs)
- Performance optimization and basic query tuning
Recap and Future Directions
Requirements
- A grasp of fundamental data concepts
- Experience working with spreadsheets or tabular information
- Familiarity with common 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
