Learn SQL with Microsoft SQL Server

Understanding Databases and SQL

4.40 (674 reviews)
Udemy
platform
English
language
Databases
category
instructor
Learn SQL with Microsoft SQL Server
4,798
students
2 hours
content
Nov 2023
last update
$64.99
regular price

What you will learn

Understand and Use Databases

Understand and Use SQL with Databases

Know How To Install and Use Microsoft SQL Server

Why take this course?

In this course I'll teach you Structured Query Language - SQL for short - the fast and easy way.


We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it like a pro.


Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're actually pretty easy to use if you know just a few things...and I'll teach you those things in this course. 


We'll start out by learning fundamental database concepts, like... what is a database, what is a table, what are rows and columns, and what are data types.


After that I'll show you how to set up and use Microsoft SQL Server. 


Then we'll dive right in to SQL itself.  I'll teach you basic concepts like 

- Select Statements
- Where, And or Not 
- How to Order and Group By
- And cool things like that.


Then we'll move into slightly more difficult concepts like 

- Having and Top Clauses
- Select Distinct
- Union
- And Functions


Then we'll jump into more advanced concepts like 

- Insert and Update Statements
- Deleting and Altering Tables
- Joining Tables 
- Primary Keys
- Indexing 
- And more!


When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.


Join me today and I'll see you inside!


Screenshots

Learn SQL with Microsoft SQL Server - Screenshot_01Learn SQL with Microsoft SQL Server - Screenshot_02Learn SQL with Microsoft SQL Server - Screenshot_03Learn SQL with Microsoft SQL Server - Screenshot_04

Reviews

Peter
December 29, 2023
Good strait forward introduction but could use more time spent on the structure of the course. For example to create an index and then just saying you don't know how to verify if it is there is just sloppy work on the instructors part.
Simon
September 5, 2023
amazing, and seems like a very cool guy. dont waste time spending 20 plus hours learning from another course, this has everything you need to get employed.
Laura
September 27, 2022
I've really appreciated this course; I only think that Joining and Indexin chapters should be more elaborated.
Jeff
June 6, 2022
This was a good, concise course to introduce the basics of SQL. John did a good job communicating the main concepts quickly.
Adrian
May 4, 2022
Great course with sense of humour, step-by-step, easy to understand. The only missing point for me is that I do not know the next step, what is the next course?
Cornelius
March 28, 2022
Very simple. The installation was a NIGHTMARE had to settle for 2016 version. But I can't blame this or any course for that at all. 100% Microsoft related.
Jason
January 10, 2022
It is a good course, I just wished he would pause at moments so we can also replicate what he is doing on our own screens.
Savvas
December 31, 2021
The instructor seems to be educating on the fly rather than being prepared. Doing a google search and not knowing what to click into is not very professional.
Ethan
July 19, 2021
I’m watching this as a refresher and it seems like he has made 1 or 2 mistakes when describing data types, and he seems like he is just a little causal saying things like I don’t know for sure or It’s pretty much the same. Otherwise good.
Be213-It.Suppliers@Msc.Com
June 21, 2021
Pretty good as a refresher on SQL, but I'm not sure how much real beginners will get out of this. Still, it's certainly worth the time.
Marelize
May 10, 2021
So far John has been very simple and easy to understand in his explanations, even to someone like me with English as a second language.
Николай
April 9, 2021
структура разбита неудобно и нелогично, 3 минутные ролики из которых полезной информации от силы 10%, в процессе роликов куратор совершает ошибки и не разбирая их просто переделывает.
David
January 2, 2018
enjoyable, engaging presentation, I like the explanations and the energy of the course. Quite informative and good pacing
Alex
December 19, 2017
It was good as a brief introduction. I think it would have been helpful if there had been some more exercises to go with it, but it did provide a very general basic overview.
Juan
December 18, 2017
Perfect, we are on the right track. This is exactly the reinforcing material I am looking for. Great job!

Charts

Price

Learn SQL with Microsoft SQL Server - Price chart

Rating

Learn SQL with Microsoft SQL Server - Ratings chart

Enrollment distribution

Learn SQL with Microsoft SQL Server - Distribution chart
1423234
udemy ID
11/6/2017
course created date
11/21/2019
course indexed date
Bot
course submited by