Learn SQL with Microsoft SQL Server

Description

Understanding databases and SQL

Databases are incredibly important in the modern world, and may seem quite complex to most people. But they're easy to use if you know the right techniques and concepts. With this course, you'll get up to speed with the Structured Query Language (SQL) in an interactive, quick, and easy way. You'll be able to download and use the free trial version of Microsoft SQL Server and understand how to use it confidently. You'll start by learning fundamental database concepts, gradually understanding what databases, tables, rows and columns, and data types are. Next, you'll explore how to set up and use Microsoft SQL Server. The course will then delve into SQL, focusing on basic concepts such as SELECT statements; Where, And, or Not; and How to Order and Group By. As you progress, you'll gain insights into comprehensive topics such as Having and Top Clauses; Select Distinct; Union; and Functions. Finally, you'll focus on advanced concepts including Insert and Update Statements; Deleting and Altering Tables; Joining Tables; Primary Keys; and Indexing. By the end of this course, you'll have the skills you need to effectively use databases with SQL.

Discover the fundamentals of Microsoft SQL Server
Explore conditions
Understand how to experiment with tables
Work with functions

This course is for beginners who want to learn SQL, or anyone who wants to understand how to build databases using Microsoft SQL Server.

This course will demonstrate how to build databases with Microsoft SQL Server from scratch. You'll cover the theory and implementation through real-world examples.

Install and use Microsoft SQL Server * Gain a basic understanding of databases and their use * Explore SQL and use it with databases

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. John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.

1. Introduction

2. Installation and Setup

3. Structured Query Language - SQL