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.56 (31166 reviews)
Udemy
platform
English
language
Programming Languages
category
Microsoft SQL for Beginners
119 390
students
4 hours
content
Dec 2020
last update
$149.99
regular price

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 1Microsoft SQL for Beginners
Microsoft SQL for Beginners – Screenshot 2
Screenshot 2Microsoft SQL for Beginners
Microsoft SQL for Beginners – Screenshot 3
Screenshot 3Microsoft SQL for Beginners
Microsoft SQL for Beginners – Screenshot 4
Screenshot 4Microsoft SQL for Beginners

Charts

Students
Price
Rating & Reviews
Enrollment Distribution

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
Related Topics
459948
udemy ID
26/03/2015
course created date
01/08/2019
course indexed date
Bot
course submited by