Intro To Databases With SQL | Codemy.com

Intro To Databases With SQL


 

Course: 32 Videos
Length: 2 Hours
Price: $49

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!

Sign Up Today!

Just $49



 

Course Content…

Module 1 Intro To Databases With SQL
Unit 1 Introduction | Video 1
Unit 2 Database Concepts | Video 2
Unit 3 Data Types | Video 3
Unit 4 Download and Install SQL Server | Video 4
Unit 5 Download and Install SSMS | Video 5
Unit 6 Connect To Server | Video 6
Unit 7 System Databases | Video 7
Unit 8 Creating a Database and Table | Video 8
Unit 9 Adding Data To A Table | Video 9
Unit 10 Intro To SQL | Video 10
Unit 11 Select Statements | Video 11
Unit 12 Where Clause | Video 12
Unit 13 And or Not | Video 13
Unit 14 Order By | Video 14
Unit 15 Group By | Video 15
Unit 16 The Having Clause | Video 16
Unit 17 The Top Clause | Video 17
Unit 18 Select Distinct | Video 18
Unit 19 Union | Video 19
Unit 20 Functions | Video 20
Unit 21 Insert Statement | Video 21
Unit 22 Update Statement | Video 22
Unit 23 Delete Statement | Video 23
Unit 24 Alter Table | Video 24
Unit 25 Null | Video 25
Unit 26 Creating a Table | Video 26
Unit 27 Drop Table | Video 27
Unit 28 Primary Key | Video 28
Unit 29 Intro To Joining Tables | Video 29
Unit 30 Inner Join | Video 30
Unit 31 Left, Right, and Outer Join | Video 31
Unit 32 Indexing | Video 32


 

Just $49