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.
Course Outline
Foundations of SQL
- Definition of SQL
- Concepts of relational databases
- Database management engines and associated tools
Primary Data Extraction
- Utilizing SELECT commands
- Data refinement using WHERE
- Data ordering via ORDER BY
Managing Columns and Rows
- Application of DISTINCT
- Assigning column aliases
- Restricting result sets
Refinement and Comparison Logic
- Comparison operators
- Use of BETWEEN, IN, and LIKE
- Logical operators (AND, OR, NOT)
Summarization and Data Grouping
- Functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY instruction
- HAVING instruction
Introduction to Table Joins
- Concept of primary and foreign keys
- INNER JOIN operations
- LEFT and RIGHT JOIN operations
Application of Subqueries
- Overview of subqueries
- Subqueries within SELECT
- Subqueries within WHERE
Conclusion and Future Directions
Requirements
- Knowledge of fundamental computer usage
- Experience with spreadsheet or tabular data formats
- No previous coding background is necessary
Target Audience
- Business analysts
- Information entry specialists
- Individuals starting to work with database systems
14 Hours
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
