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 Architecture
- Grasping database structural components
- Overview of SQL syntax standards
- Interacting with tables and schemas
Foundational Querying Methods
- Data selection and projection techniques
- Filtering specific rows using WHERE clauses
- Ordering result sets with ORDER BY
Integrating Multiple Tables via Joins
- Inner, left, right, and full outer joins
- Merging datasets from various sources
- Defining and resolving join conditions
Data Aggregation and Grouping Strategies
- Utilizing COUNT, SUM, AVG, MIN, and MAX functions
- Effective application of GROUP BY
- Filtering aggregated results with HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for enhanced filtering and calculations
Data Modification and Maintenance
- Inserting new data records
- Updating existing entries
- Safely executing data deletions
Database Objects and Integrity Constraints
- Understanding primary and foreign key relationships
- Creating and using views
- Implementing constraints and business rules
Advanced SQL Methodologies
- Window functions
- Common Table Expressions (CTEs)
- Performance optimization and query tuning fundamentals
Key Takeaways and Future Steps
Requirements
- Foundational knowledge of core data concepts
- Practical experience with spreadsheets or tabular formats
- General familiarity with business application environments
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
