Learn SQL with Microsoft SQL Server

• Introduction to Microsoft SQL Server
• Understanding conditions
• Playing around with tables.
• Working with functions

We’ll start out by learning fundamental database concepts, such as: 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 into SQL itself. I’ll teach you basic concepts such as:

• 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 such as:

• Having and Top Clauses
• Select Distinct
• Union
• And functions

Then we’ll jump into more advanced concepts such as:

• 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!

Style and ApproachThis course will show you how to build databases with Microsoft SQL Server from scratch. It covers the theory and implementation with real-life examples.

• Install and use Microsoft SQL Server
• Gain a basic Understanding about databases and their use
• Understand and use SQL with databases