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 14 hours
Course Outline
Introduction to SQL
- Definition of SQL
- Overview of relational databases
- Database engines and associated tools
Foundational Data Retrieval
- Using SELECT statements
- Applying filters with WHERE
- Ordering results with ORDER BY
Managing Columns and Rows
- Utilizing DISTINCT
- Creating column aliases
- Restricting result sets
Advanced Filtering and Comparisons
- Comparison operators
- Using BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Data Aggregation and Grouping
- Functions: COUNT, SUM, AVG, MIN, MAX
- The GROUP BY clause
- The HAVING clause
Basics of Table Joins
- Concepts of primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Introduction to subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Wrap-up and Future Directions
Requirements
- Basic knowledge of computer operations
- Experience with spreadsheets or tabular data
- No prior programming background necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database environments
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,
