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
SQL and Relational Database Introduction
- Grasping database architectures
- An overview of SQL syntax standards
- Interacting with tables and schemas
Fundamental Querying Methods
- Selecting and projecting specific data fields
- Filtering records using the WHERE clause
- Ordering output with the ORDER BY clause
Combining Data from Multiple Tables
- Inner, left, right, and full outer joins
- Merging datasets from various sources
- Defining and resolving join conditions
Data Aggregation and Grouping
- Utilizing functions such as COUNT, SUM, AVG, MIN, and MAX
- Effective application of GROUP BY
- Filtering grouped results with the HAVING clause
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and computational tasks
Data Manipulation and Modification
- Inserting new records
- Modifying existing entries
- Securely removing data
Database Objects and Constraints
- Understanding primary and foreign key relationships
- Managing views
- Implementing integrity constraints and rules
Advanced SQL Methodologies
- Window functions
- Common Table Expressions (CTEs)
- Basic query tuning and performance optimization strategies
Recap and Future Directions
Requirements
- A foundational grasp of core data concepts
- Prior experience with spreadsheet software or tabular data structures
- General familiarity with business software 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
