Microsoft SQL from A to Z (Udemy.com)

The Complete Guide to SQL Querying

Created by: Brewster Knowlton

Produced in 2020

icon
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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

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.Who this course is for:
  • Anyone who works with data, tables, or databases!
  • Someone who wants to learn the foundational skill of big data and data analytics.
  • Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.
  • If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
  • Someone who wants to learn skills that give them the potential to earn near SIX figures!

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

icon
Instructor Details

Brewster Knowlton

Brewster Knowlton has worked in all facets of the business intelligence industry. With significant experience writing SQL code, developing ETL processes, and architecting and designing data warehouse systems, his greatest strength is the ability to communicate difficult concepts in an easily understood way. Having completed business intelligence projects across a variety of industries, Brewster understands what BI skills organizations need and employers are seeking. His goal is to help you learn SQL and business intelligence skills so that you might find your dream career in the business intelligence field.

icon
Students also recommend

$59.99

Free

Free

icon
Reviews

4.6

50 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

I am very glad that I chose this course, now I feel sure that I can cope with any SQL tasks at work. The course is very clear and easy if you already know Excel and VBA.

I'm from finance background. It's very clear and easy to follow course. Love the course being clustered in smaller part for easy learning. The missing full 5 star is because of the technical issue happen during installation, end up I install the 2016 service pack version 13 instead to solve the problem.

This was a great course for me. I use SQL quite frequently in my new role for querying purposes only and find the material incredibly valuable and relevant to my needs. The videos are digestible and easy to follow, and the Assignments posed a good challenge while following skills shown in the videos. I plan to go back through this course material again to better understand the more difficult concepts. I appreciated that it was done in SQL Server Management Studio as that is what I use as work.

I came over from the previous one Brewster made, so I hoped to find more exercises than the ones I made before, it wasn't the case but this course was much more complete, I already recommended it to my teammates who want to learn more about SQL on SQL server

Mr. Brewster teaching style, example and practice questions have been helpful for me to getting introduced to SQL concepts. I wish if I could download the entire lecture notes which are not available to download. I also wish if there could be a next level SQL course available by Mr. Brewster on Udemy.Thank you, Mr. Brewster!!

Very good course. This is the second Brewster Knowlton course that I have taken. I feel that his course construction is just right for me. Very clear. Very logical. If I see other SQL courses by this instructor, I will take them.

Good course. Concise and covers a lot of material for someone that has never used SQL before. I have been able to do some basic querying in my office thanks to this course. Hoping that with more experience some of these lessons will become internalized. The lessons on derived tables and CTE could have been explained a little bit more slowly but nothing that can not be learned by rewatching the videos and looking at other material. In summary, for the price I definitely recommend the course.

The course is very well structured, with good explanations and exercises. The pdf guideline is on its own worth the money of this course.One point worth to be improved is audio. The quality and volume of the recorded audio are just low, and at times it makes it difficult to follow the narrative. I wish audio was re-recorded properly.

this course is greatI started this course from zero knowledge and now I've cleared a interview for SQL Developer that to only in a week.

I am a self-taught beginner/intermediate level T-SQL user in my work as an Analyst, looking for courses which will help plug in the gaps in my learning. That being the case, the most useful information to me is the discussion on the HAVING clause (I never use it), the order of operations SSMS reads the query in (I never knew), the difference between CAST and CONVERT (I'd wondered), and matters related to performance (e.g. don't put the whole case statement in the group by if speed is an issue). I use CTEs in my work all the time, but lacked confidence in rewriting them/reading them as a derived tables, so the coverage of derived tables was useful, also. Some functions were also new to me (COALESCE, FLOOR).I would like to be able to do a follow-up course that focused on using a lot larger range of SQL functions, as Microsoft's online guides can be confusing to unpack, and there's a big difference between looking up the specifics of a function you already know exists (which Microsoft's online guides are very useful for), and knowing what is available and what the use cases are (Microsoft does not tend to be particularly helpful on that front - take, for example, how many useful Excel formulas you never know exist until one day you see someone else use it!).At this stage, I'm not interested in training as a DBA, but my queries are often sufficiently complex (and querying large tables), so understanding performance issues is a priority. Some sort of light coverage of the way in which SSMS and Servers work, as well as a vague overview of how ETL is developed, could also be useful. There must be many like myself who are in an Analyst position and not necessarily seeking MS DBA accreditation but just trying to understand and work with a system someone else has built, and who needs to understand the perspective of ETL Developers and the platform they provide.

Yes i enjoyed the course it so educational its help me bit more understanding the SQL

I enjoyed the course it taught me the basic of SQL. It was easy to follow along with the instructor.