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 Databases
- Grasping database architectures
- Overview of SQL syntax
- Interacting with tables and schemas
Fundamental Querying Methods
- Selecting and projecting data
- Filtering rows using the WHERE clause
- Ordering results with the ORDER BY clause
Combining Multiple Tables
- Inner, left, right, and full outer joins
- Merging datasets from various sources
- Defining join conditions
Aggregations and Grouping
- Utilizing COUNT, SUM, AVG, MIN, and MAX
- Effectively applying the GROUP BY clause
- Filtering grouped data with the HAVING clause
Subqueries and Nested Statements
- Scalar subqueries
- Correlated subqueries
- Employing subqueries for filtering and calculations
Data Manipulation and Modification
- Inserting new data
- Modifying existing records
- Safely deleting data
Database Objects and Constraints
- Understanding primary and foreign keys
- Working with views
- Implementing constraints and rules
Advanced SQL Techniques
- Window functions
- Common Table Expressions (CTEs)
- Performance considerations and query optimization basics
Recap and Future Steps
Requirements
- A grasp of fundamental data concepts
- Familiarity with spreadsheets or tabular data formats
- Knowledge of general business applications
Target Audience
- Data analysts
- IT professionals
- Individuals requiring the ability to manage, query, and analyze data
Testimonials (3)
Need more self-learning and exercise to improve my skill
Alvin Wilta - PT LENTERA DANA NUSANTARA
Course - SQL Intermediate
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,