Microsoft SQL from A to Z
The Complete Guide to SQL Querying
4.51 (7816 reviews)
28,361
students
5.5 hours
content
Dec 2020
last update
$94.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
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
Why take this course?
This course is an extension of our previous course, "Microsoft SQL for Beginners". This course, "Microsoft SQL from A to Z" contains all the course material and content from the previous course plus the additional MANY new lectures on more intermediate and advanced-level SQL querying topics. Students who sign up for this course will also have access to our 150+ page "Complete T-SQL Querying Guide" as an added bonus to assist you in the learning process.
Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!
SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.
This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.
You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.
Screenshots
Reviews
Adam
March 21, 2024
I enjoyed it. I wish it would have been a little more in depth, like going over the UNION operator, etc..instead of saying look over the documentation on microsoft. However, i learned a good bit and enjoyed the content.
Sean
March 8, 2024
It's 2024 so I'm confused as to why you're telling me to install SQL 2012... After installing sql server express 2022, I couldn't attach the training DB because SSMS couldn't find it.
Syed
March 7, 2024
A best course for a beginner to start learning SQL, and also a brush up course to an advance/expert level person. I urge for those, who want to learn SQL and , make sure your basic is fine then this is the course to start.
Nimesh
February 27, 2024
This course is filled with knowledge and information of SQL Server. I am feeling glad that I took this course. The instructor is very good with providing knowledge with good examples, that's one thing that make this course interesting. Now I can confidently say that I've added one more skill to my skill set.
Thanks!
Srinivasan
February 11, 2024
That was Excellent Training by the Instructor, covered most out of it.
Highly Recommended for any one looking to learn from beginning or who wants to refresh the concepts.
Meital
February 11, 2024
I like the way this course is built in a structured way, explanations are coherent and examples start from the simplest to the more complex.
Toyin
February 6, 2024
I found the experience to be quite positive overall. The course content was well-structured and comprehensive, covering all the topics I was interested in learning about. The instructor's teaching style was engaging and easy to follow, which helped me stay motivated throughout the course. Additionally, the hands-on exercises and quizzes provided valuable opportunities for me to apply and reinforce what I had learned.
Overall, I would say that the course was a good match for me because it met my learning objectives and helped me acquire new knowledge and skills in the subject area. I feel more confident in my abilities now and I am excited to apply what I've learned.
Parya
January 29, 2024
My experience didn't start off well. The course provided limited guidance on installing SQL Server, which is crucial for the curriculum. I struggled to find SQL Server Express 2012 as instructed, and had to opt for the 2022 version. However, the installation process for this version was not covered in the course materials, leaving me without the necessary 'SQL Express' folder for data management. This lack of detailed installation instructions made it difficult for me to engage with the course content from the beginning.
It's disappointing to encounter such obstacles right at the start of a course. I believe the course could be significantly improved by updating the installation guide to reflect the latest versions of SQL Server and providing step-by-step instructions for beginners. This would make the course more accessible and less frustrating for new learners.
Forest
December 16, 2023
It has been very informative so far. Exactly what I need as a developer who works in a data-centric field.
sanjay
December 9, 2023
Sound is bit low need to keep the volume full high to get normal sound , i tried with mobile,lapton, and tab .explation is very good, video quality is good
Philippe
November 22, 2023
Good course. Loved the fact that there are exercices.
It's a bit old though. First few lessons should be updated for setting up newer versions of the material: AdventureWorks2022 and SSMS19.
Good to know: once the setup is passed, everything in these lessons was compatible with AdventureWorks2022 and SSMS19.
Tyler
October 25, 2023
A well presented and categorised course, with practice documents provided along the way encouraging students to test their knowledge first-hand. This has helped me gain a new perspective when writing queries using SQL Server as well which will certainly come in use for query writing in my future endeavours. Thank you Brewster! :)
Robert
October 24, 2023
Very well paced course, excellent presentation: clear, concise and explanatory about the materials. Highly recommended.
Abdulaziz
October 18, 2023
Really good course!
Two comments:
1. I would like to have more practice questions(We already have but more).
2.I would like to know next level courses, advanced.
Thanks.
Uddivs
March 28, 2023
It was a good course, although i have learnt SQL so many times from different sources, i was really surprised to learn few things that i still didn't know ! thank you for the content Knowlton :)
Charts
Price
Rating
Enrollment distribution
Related Topics
1005698
udemy ID
11/7/2016
course created date
11/22/2019
course indexed date
Bot
course submited by