Microsoft SQL from A to Z

The Complete Guide to SQL Querying

4.48 (8751 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

Use built-in SQL Server functions

Understand SQL Server Data Types and Type Casting

Work with Table Expressions: Derived Tables and CTEs

Use CASE Statements

Use Subqueries

Course Gallery

Microsoft SQL from A to Z – Screenshot 1 — Screenshot 1 – Microsoft SQL from A to Z

Microsoft SQL from A to Z – Screenshot 2 — Screenshot 2 – Microsoft SQL from A to Z

Microsoft SQL from A to Z – Screenshot 3 — Screenshot 3 – Microsoft SQL from A to Z

Microsoft SQL from A to Z – Screenshot 4 — Screenshot 4 – Microsoft SQL from A to Z

Charts

Students

Price

Rating & Reviews

Enrollment Distribution

Comidoc Review

Our Verdict

Microsoft SQL from A to Z is a solid course for learning and mastering SQL, providing valuable knowledge and exercises backed by positive feedback. However, the course could be improved with updated installation instructions and clearer communication regarding prerequisites, addressing its shortcomings without affecting its strong points.

What We Liked

Comprehensive course content covering a wide range of SQL topics, including SELECT statements, database design, joins, aggregate functions, and more.
Engaging teaching style with hands-on exercises and quizzes that reinforce learning.
Well-structured curriculum that has helped learners acquire new knowledge and skills in SQL.
Valuable for both beginners looking to learn the basics of SQL and professionals seeking a refresher or to expand their skillset.

Potential Drawbacks

Lacking detailed installation instructions, causing frustration with setting up SQL Server Express 2012 and not covering the 2022 version.
Assumed basic knowledge of database architecture is required, leaving some learners at a disadvantage.
Occasional discrepancies between courses by the same instructor, causing confusion with nearly identical content.
Sections could benefit from more examples and practice problems to cement understanding.