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
- What is SQL?
- Grasping relational databases
- Database engines and associated tools
Foundational Data Retrieval
- SELECT commands
- Filtering data using WHERE
- Sorting results with ORDER BY
Handling Columns and Rows
- Utilizing DISTINCT
- Assigning column aliases
- Restricting result sets
Advanced Filtering and Comparison
- Comparison operators
- BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Aggregation and Grouping of Data
- COUNT, SUM, AVG, MIN, MAX
- GROUP BY clause
- HAVING clause
Basics of Table Joins
- Understanding primary and foreign keys
- INNER JOIN
- LEFT JOIN and RIGHT JOIN
Utilizing Subqueries
- Introduction to subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Summary and Future Steps
Requirements
- A grasp of fundamental computer operations
- Comfort with using spreadsheets or tabular data
- No previous programming experience is necessary
Target Audience
- Business analysts
- Data entry specialists
- Individuals new to database work
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,
