SQL Server Essentials, from Scratch (Udemy.com)
Step-by-Step Beginner's Training Course in SQL Server. No prior database knowledge is needed.
Created by: Joey Blue
Last updated December 2022
What you will learn
- By the end of the course, you will have a foundation in SQL Server and the vocabulary and understanding to talk about and use SQL Server with confidence.
- You will know how to navigate SQL Server Management Studio (SSMS) to find database objects and business data.
- You will understand how to take advantage of Management Studio to make you work faster and more efficient.
- You will understand the different pieces in SQL Server. Including, Tables, Views, Stored Procedures, Security, Backups, Indexes and Schemas to help you talk to DBA's, Programmers, IT and to sound smart when you are speaking about databases.
- You will know how to write SQL statements to CREATE, Retrieve, Update, and Delete data.
- You will be able to create basic Views and Stored Procedures.
- You will be able to Filter, Join, Sort, and Group data.
- You will be able to create basic Views, Stored Procedures, and Functions.
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.6 out of 5higher than 69% of them
- Reviews1,991#100 of 389 by number of reviews
- Length13.7 hourslonger than 82% of them
- Last updatedDecember 2022earlier than 55% of them
Quality Score
Overall Score : 92 / 100
Course Description
You learned a little SQL, but you are ready to take the next step and really understand how databases work. Or maybe you are a complete beginner. Here’s a little secret. It’s not that complicated. That’s right. Databases are actually a very simple concept that starts with a simple Table just like a spreadsheet in Excel. Everything else in the database is built around this little concept of a table.
With a little SQL Server knowledge, you can retrieve data yourself. You can automate your reporting. You can help management find information and troubleshoot problems. You can even transfer this knowledge to Oracle and MySQL.
In this course, veteran consultant, Joey Blue, takes you through the essentials of SQL Server right through advanced topics such as backups, security, and indexes. This course is recommended for all business and IT professionals that want to advance their careers by understanding their corporate database.
Instructor Details
- 4.6 Rating
1,991 Reviews
Joey Blue
Joey has been working with Data for over 21 years. He works during the day as a consultant in the Business Intelligence space, which includes SQL Server and its BI Stack.
In the evenings, he creates videos on YouTube to document some of the problems he runs into working with customers. On Udemy, Joey has put together some excellent trainings.
Don’t forget to visit Joey’s website to find extra videos and discounts.
“Send me a message if you have any questions about my videos and training.”
More courses by Joey Blue
Learn SQL in 1 Hour - SQL Basics for Beginners (2017)
4.6 (12 Reviews)
Provider: YouTube
Time: 1h
Free
Reviews
By Mónica Avelãs Stanton Arau Ribeiro on 3/29/2023
this is the second SQL course I take and I would have liked to have available the definition of the SQL commands. So the theory would have been a nice addition. The exercises were good but they did not have a correction so i wouldn't know for sure if my answer was correct or if there was a different way to achieve the same answers. If I hadn't taken a introductory course prior to this one, it would have been pretty hard to follow.
By Ashley Ross on 11/20/2022
I had taken another SQL course but still found I was having difficulty with the concepts. I found a few videos from Joey on YouTube and stumbled on this course so I decided to go for it as I liked the videos I had watched on YouTube. I was not disappointed, this course really helped me to write and understand different types of queries. Thank you! Looking forward to the next one.
By Robert McCann on 11/22/2020
The set up and installation was relatively straightforward despite being quite complex and subject to software updates. I wasn't able to access the Pre Assessment resources but have raised a question about this.
By Shawnta Byrd on 10/21/2020
The step by step visual on how to install everything was exactly what I needed. I am so ready to learn!!!!! Wooohooo!!!!
By Trintin Caley Affleck on 10/17/2020
Very easy to follow along!
By Marie Renee Emery on 10/14/2020
Pretty straight forward. I had to download one or the other of these first. Step 1: Enable Microsoft .Net Framework 3.5 SP1. and Download and install Microsoft .Net Framework 4.0.
then Microsoft SQL Server 2012 Service Pack 3 (SP3) Express as of 10/01/2020
Hopefully this helps someone else.
By Emmanuel Ehuron on 10/11/2020
Not done yet
By Bui Khang on 10/6/2020
Good instructor. Use the simple English
By Rajesh on 9/27/2020
expalnation is very good and clear to understand. But not too depth into topics basics only. if there are practice questions on each it help to practice and gain knowledge.
By Barnabas Demeke on 9/10/2020
Lectures are very plane and not engaging. Lucks enthusiasm.
By Geo 3d on 8/26/2020
This course seems dated. Windows 7? The description of the course said that it had been recently updated. I hope so.
By Yusufu Heri Kihojo on 8/19/2020
Amazing, above expectation.




