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
Introduction to SQL and Relational Databases
- Comprehending database structures.
- Overview of SQL syntax.
- Working with tables and schemas.
Basic Querying Techniques
- Selecting and projecting data.
- Filtering rows using the WHERE clause.
- Sorting results with ORDER BY.
Joining Multiple Tables
- Understanding inner, left, right, and full joins.
- Combining datasets from various sources.
- Resolving join conditions.
Aggregations and Grouping
- Utilizing functions such as COUNT, SUM, AVG, MIN, and MAX.
- Applying GROUP BY effectively.
- Filtering grouped data with the HAVING clause.
Subqueries and Nested Statements
- Working with scalar subqueries.
- Implementing correlated subqueries.
- Leveraging subqueries for filtering and calculations.
Data Manipulation and Modification
- Inserting new data records.
- Updating existing records.
- Deleting data securely.
Database Objects and Constraints
- Understanding primary and foreign keys.
- Working with views.
- Implementing constraints and rules.
Advanced SQL Techniques
- Exploring window functions.
- Utilizing Common Table Expressions (CTEs).
- Basics of performance considerations and query tuning.
Summary and Next Steps
Requirements
- A foundational understanding of basic data concepts.
- Prior experience working with spreadsheets or tabular data.
- Familiarity with general business applications.
Target Audience
- Data analysts.
- IT professionals.
- Individuals responsible for managing, querying, and analyzing 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
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
