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 Systems
- Grasping database architectures
- Surveying SQL syntax standards
- Interacting with tables and schemas
Fundamental Querying Methods
- Retrieving and projecting specific data
- Applying WHERE clauses to filter rows
- Arranging output using ORDER BY
Merging Multiple Tables
- Inner, left, right, and full outer joins
- Integrating datasets from various sources
- Defining join criteria
Aggregation and Grouping Operations
- Leveraging COUNT, SUM, AVG, MIN, MAX
- Utilizing GROUP BY effectively
- Applying HAVING to filter grouped results
Subqueries and Nested Structures
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and computation
Data Manipulation and Modification
- Adding new records
- Modifying existing entries
- Removing data with caution
Database Entities and Constraints
- Understanding primary and foreign key relationships
- Utilizing views
- Establishing constraints and rules
Sophisticated SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
- Performance insights and introductory query optimization
Recap and Future Directions
Requirements
- A grasp of fundamental data principles
- Prior experience with spreadsheets or structured tabular data
- General familiarity with business software applications
Target Audience
- Data analysts
- Information technology specialists
- Professionals responsible for managing, querying, and interpreting 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
