About This Course
This course I’ll teach you Structured Query Language – SQL for short – the fast and easy way.
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
– And Functions
Then we’ll jump into more advanced concepts like:
– Insert and Update Statements
– Deleting and Altering Tables
– Joining Tables
– Primary Keys
– And more!
When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.
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
Our Promise to You
By the end of this course, you will have learned about using SQL on databases.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the using SQL on databases.
|Section 1 - Introduction|
|Download And Install SQL Server||00:00:00|
|Download And Install SSMS||00:00:00|
|Connect To Server||00:00:00|
|Creating A Database And Table||00:00:00|
|Adding Data To A Table||00:00:00|
|Intro To SQL||00:00:00|
|And Or Not||00:00:00|
|The Having Clause||00:00:00|
|The Top Clause||00:00:00|
|Creating A Table||00:00:00|
|Intro To Joining Tables||00:00:00|
|Left, Right, And Outer Join||00:00:00|