SQL Server Essentials in an hour: The SELECT statement

Learn how to use SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER in SQL Server. Helps with DP-600

4.51 (2665 reviews)

Udemy

platform

English

language

Databases

What you will learn

Build your own SQL Server SELECT statements.

Use the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses.

Encapsulate (save) your statements as views or procedures.

Dynamically connect the results of your SELECT statements into Excel.

Loading charts...

Comidoc Review

Our Verdict

SQL Server Essentials in an Hour: The SELECT Statement is a great course for anyone looking to learn or refresh their knowledge on SQL Server's SELECT statement. With clear explanations, relevant examples, and regular quizzes, this course makes learning SQL enjoyable. However, lacking exercises for writing SQL queries and some confusing slip-ups in material presentation might deter absolute beginners. As the course primarily focuses on writing queries and not SQL server administration, it's best to approach it with correct expectations.

What We Liked

Covers all the essentials of SELECT statement in SQL Server
Well-structured and easy to follow with relevant examples
Logical order of presentation helps build understanding
Regular quizzes make learning fun and engaging

Potential Drawbacks

Some exercises for writing SQL would be beneficial
A few slip-ups in material presentation might confuse beginners
Instructions could specify newer Microsoft Office versions
Could provide real-time data tables instead of system tables