Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Learn SQL with Microsoft SQL Server

via Udemy

Overview

Understanding Databases and SQL

What you'll learn:
  • Understand and Use Databases
  • Understand and Use SQL with Databases
  • Know How To Install and Use Microsoft SQL Server

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


We'll download anduse the free trial version ofMicrosoft SQLServer 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 SQLServer.


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

- Select Statements
- Where, And or Not
- How to Order and Group By
- And coolthings 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
- PrimaryKeys
- Indexing
- And more!


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


Join me today and I'll see you inside!


Taught by

John Elder

Reviews

Start your review of Learn SQL with Microsoft SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.