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.
Course Outline
Overview of SQL and Relational Database Systems
- Grasping database architecture.
- Fundamental review of SQL syntax.
- Managing tables and schemas.
Core Querying Methods
- Selecting specific data fields.
- Applying row filters using WHERE clauses.
- Ordering output via ORDER BY.
Integrating Multiple Tables
- Mastering inner, left, right, and full outer joins.
- Merging data from various sources.
- Defining and resolving join criteria.
Data Aggregation and Grouping Strategies
- Utilizing functions like COUNT, SUM, AVG, MIN, and MAX.
- Effective application of GROUP BY.
- Refining grouped results using HAVING.
Nested Queries and Subqueries
- Working with scalar subqueries.
- Constructing correlated subqueries.
- Leveraging subqueries for complex filtering and computations.
Modifying and Manipulating Data
- Inserting new records.
- Amending existing entries.
- Securely deleting data.
Database Objects and Integrity Constraints
- Comprehending primary and foreign key relationships.
- Utilizing database views.
- Enforcing data integrity through constraints and rules.
Sophisticated SQL Methods
- Applying window functions.
- Using Common Table Expressions (CTEs).
- Fundamentals of query optimization and performance tuning.
Recap and Future Learning Paths
Requirements
- A foundational grasp of core data concepts.
- Practical experience with spreadsheets or structured tabular data.
- General familiarity with standard business software applications.
Target Audience
- Data analysts.
- Information technology professionals.
- Individuals responsible for managing, querying, and interpreting data.
10 Hours
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