SQL For Beginners - Essential Query Skills
Master SELECT statements, WHERE clauses, aggregates, and joins for effective data retrieval.
Course overview
Build a practical foundation in SQL and relational databases. This self-paced course introduces the query techniques used to retrieve, filter, summarize, and combine information, with hands-on labs to help reinforce the concepts.
Course coverage
Progress from relational database concepts to increasingly useful queries and data analysis patterns.
- 01 Introduction
- 02 Relational database foundations
- 03 SELECT statements
- 04 Filtering with WHERE
- 05 Computed columns
- 06 Aggregate functions
- 07 SQL built-in functions
- 08 Joins and subqueries
- 09 CASE statements and UNIONs
- 10 Conclusion
Participants will learn to
- Navigate and query relational databases.
- Retrieve and filter data with SELECT and WHERE.
- Create computed columns for analysis.
- Order and group results.
- Summarize data with SUM, AVG, COUNT, MAX, and MIN.
- Combine tables with joins and use subqueries.
- Use CASE and UNION to shape query results.
- Recognize the value of data integrity and normalization.
Format and audience
For: Beginners, aspiring data scientists, analysts, developers, and anyone who wants to learn how to query information in relational databases.
Prerequisites: No prior programming or database background is required. A working PC is listed as a requirement.
How it works: On-demand lectures and practical labs that learners can work through at their own pace.
Explore the course
Review the current course details and enrollment options on Udemy.
Additional one day Instructor Lead program is also available upon request! Request a Quote