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 Databases
- Grasping database architecture
- Introductory look at SQL syntax
- Navigating tables and schemas
Fundamental Querying Methods
- Selecting and displaying data fields
- Filtering records using WHERE clauses
- Arranging output with ORDER BY
Connecting Multiple Tables
- Inner, left, right, and full outer joins
- Merging data from various sources
- Defining and resolving join conditions
Aggregation and Data Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX functions
- Effectively implementing GROUP BY
- Filtering aggregated results with HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Leveraging subqueries for filtering and computation
Data Modification and Management
- Adding new records
- Modifying existing entries
- Securely removing data
Database Objects and Restrictions
- Comprehending primary and foreign keys
- Utilizing views
- Establishing constraints and rules
Sophisticated SQL Strategies
- Window functions
- Common Table Expressions (CTEs)
- Performance analysis and introductory query optimization
Recap and Future Directions
Requirements
- Foundational knowledge of data concepts
- Practical experience with spreadsheets or tabular formats
- 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
