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
Fundamentals of SQL and Relational Databases
- Exploring database architectures
- Introduction to SQL syntax
- Managing tables and schemas
Core Querying Methods
- Data selection and projection
- Row filtering via WHERE clauses
- Result sorting with ORDER BY
Integrating Multiple Tables
- Inner, left, right, and full outer joins
- Merging data from various sources
- Defining join conditions
Aggregation and Data Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX functions
- Effective application of GROUP BY
- Filtering aggregated data using HAVING
Subqueries and Nested Logic
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and complex calculations
Data Manipulation and Modification
- Inserting new records
- Modifying existing entries
- Securely deleting data
Database Objects and Integrity Constraints
- Comprehending primary and foreign keys
- Creating and using views
- Enforcing constraints and rules
Sophisticated SQL Strategies
- Window functions
- Common Table Expressions (CTEs)
- Performance analysis and query optimization fundamentals
Conclusion and Future Directions
Requirements
- A foundational grasp of basic data principles
- Proficiency with spreadsheets or tabular data formats
- General familiarity with standard business applications
Target Audience
- Data analysts
- IT specialists
- Professionals requiring the ability to administer, query, and analyze 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
