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
Getting Started with SQL
- The definition and role of SQL
- The nature of relational databases
- Key database engines and associated tools
Retrieving Basic Data
- Constructing SELECT queries
- Applying filters using WHERE
- Arranging output with ORDER BY
Managing Columns and Rows
- Removing duplicates with DISTINCT
- Assigning temporary names to columns
- Restricting the number of results returned
Advanced Filtering and Conditions
- Various comparison operators
- Utilizing BETWEEN, IN, and LIKE
- Applying logical connectors (AND, OR, NOT)
Summarizing and Grouping Information
- Applying COUNT, SUM, AVG, MIN, and MAX
- Organizing data with the GROUP BY clause
- Filtering groups using the HAVING clause
Introduction to Table Joins
- The function of primary and foreign keys
- Using INNER JOIN
- Working with LEFT JOIN and RIGHT JOIN
Implementing Subqueries
- Overview of subqueries
- Nesting subqueries within SELECT
- Using subqueries inside WHERE
Review and Further Learning
Requirements
- A solid grasp of fundamental computer operations
- Experience with spreadsheets or managing tabular data
- No previous coding background is necessary
Target Audience
- Business analysts
- Professionals specializing in data entry
- Individuals newly entering the field of database management
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,
