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
Foundations of SQL and Relational Database Systems
- Grasping database architecture
- Introduction to SQL syntax standards
- Interacting with tables and schemas
Essential Querying Methods
- Retrieving and projecting specific data fields
- Applying row filters using the WHERE clause
- Ordering output results via ORDER BY
Combining Multiple Data Sources
- Utilizing inner, left, right, and full outer joins
- Integrating datasets from diverse origins
- Defining and resolving join conditions
Data Aggregation and Grouping Strategies
- Deploying functions such as COUNT, SUM, AVG, MIN, and MAX
- Effective application of the GROUP BY clause
- Filtering aggregated groups using the HAVING clause
Subqueries and Nested Logic
- Implementing scalar subqueries
- Working with correlated subqueries
- Leveraging subqueries for precise filtering and computation
Data Modification and Maintenance
- Adding new records
- Modifying existing entries
- Removing data with precision and safety
Database Structures and Integrity Constraints
- Comprehending primary and foreign key relationships
- Creating and managing views
- Enforcing data integrity through constraints and rules
Sophisticated SQL Methods
- Applying window functions
- Using Common Table Expressions (CTEs)
- Addressing performance factors and basic query optimization
Conclusion and Future Learning Paths
Requirements
- Fundamental comprehension of core data principles
- Prior exposure to spreadsheet tools or tabular data formats
- General familiarity with standard business applications
Target Audience
- Data analysts
- IT specialists
- Professionals responsible for data management, querying, and analysis
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
