Learn SQL with Microsoft SQL Server (Udemy.com)
Understanding Databases and SQL
Created by: John Elder
Last updated November 2023
What you will learn
- Understand and Use Databases
- Understand and Use SQL with Databases
- Know How To Install and Use Microsoft SQL Server
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.6 out of 5higher than 69% of them
- Reviews703#181 of 389 by number of reviews
- Length2 hoursshorter than 85% of them
- Last updatedNovember 2023more recently than 50% of them
Course Description
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!
Who this course is for:
- This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server
- Anyone Who Wants To Learn SQL
- Anyone Who Wants To Learn Databases
Instructor Details
- 4.6 Rating
703 Reviews
John Elder
John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.
Today he teaches Web Development courses at Codemy the online code school he founded.
John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar.
More courses by John Elder
Intro To PostgreSQL Databases With PgAdmin For Beginners (2023)
4.5 (7,751 Reviews)
Provider: Udemy
Time: 2h
$54.99
Build An API With The Django Rest Framework Using Python (2023)
4.5 (1,229 Reviews)
Provider: Udemy
Time: 1.4h
$54.99
Top Node and Javascript Bundle: Learn Node and JS (2023)
4.3 (1,126 Reviews)
Provider: Udemy
Time: 8.2h
$11.99
Reviews
By Raju G Rakshasmare on 11/8/2020
good
By Birmania Garcia on 11/8/2020
I love that he divides the videos into small parts and so it easy to go back and rewatch if you feel like you missed something
By Andrew Carlson on 10/14/2020
This course was very informative and I was able to learn a lot from it. Definitely makes me feel a lot more comfortable about reading and interacting with SQL Database.
By Nisha S on 10/13/2020
Perfect for absolute beginners!
By Samuel Lopez on 10/11/2020
Very well put together, explains it very through and speaks very clear...
By Eddy Coopmans on 8/12/2020
A nice, quick rundown of common sql statements without getting "into the thick of it". Exactly what I was looking for. I will recommend this course for someone who want to get an idea of what SQL can do.
By Carlos Angel Perez on 8/3/2020
Good information from the get go
By Vivica Shade on 7/23/2020
John was awesome and thorough in explaining everything SQL. I am getting back into writing SQL statements and needed a quick refresher on how to execute the code. I will be referring back to this course whenever I get stuck on how to execute or write a query. Thanks!
By Valintina Lim on 7/8/2020
Trainer speaks too fast and not really for beginner lesson.
By Valton Moreira Pael Neto on 6/27/2020
amazing
By Simeon Akala on 6/23/2020
Learnt a lot in 2hours
By PraveenKumar on 6/21/2020
Its just really awesome
Quality Score
Overall Score : 92 / 100









