Microsoft SQL for Beginners

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

4.54 (31318 reviews)

Udemy

platform

English

language

Programming Languages

What you will learn

Complete literal SELECT statements.

Complete basic SELECT statements querying against a single table

Filter data using the WHERE clause

Sort data using the ORDER BY clause

Learn about database design and normalization

Using joins, return columns from multiple tables in the same query

Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN

Complete SQL statements that use aggregate functions

Group data together using the GROUP BY clause

Filter groups of data using the HAVING clause

Course Gallery

Microsoft SQL for Beginners – Screenshot 1 — Screenshot 1 – Microsoft SQL for Beginners

Microsoft SQL for Beginners – Screenshot 2 — Screenshot 2 – Microsoft SQL for Beginners

Microsoft SQL for Beginners – Screenshot 3 — Screenshot 3 – Microsoft SQL for Beginners

Microsoft SQL for Beginners – Screenshot 4 — Screenshot 4 – Microsoft SQL for Beginners

Loading charts...

Comidoc Review

Our Verdict

This Microsoft SQL for Beginners course offers a comprehensive look into SQL queries with a hands-on approach using Microsoft SQL Server and T-SQL language. While setting up the environment may present issues due to varying configurations, the real-world examples and progressive lessons provide a strong foundation in fundamental SQL concepts. However, it could benefit from including T-SQL examples directly and offering more guidance on table management. Regardless, this course is an excellent starting point for those venturing into the world of SQL, providing confidence as learners build their skills on Microsoft's popular platform.

What We Liked

Comprehensive coverage of SQL queries using Microsoft SQL Server and T-SQL language
Real-world examples and AdventureWorks database provided for practice
Clear explanations and well-structured lessons that build upon each other
Addresses database design, normalization, and various join operations

Potential Drawbacks

Setting up the database and connecting it to SQL Server can be challenging
Lacks information on creating new tables or deleting/inserting rows
No explicit T-SQL examples despite being in the title
Pace of instruction might be too quick for some users