You are previewing this course

Each course is broken down into short video tutorials taught by award-winning instructors. To access the entire course:

Login Redeem a voucher View pricing

Introduction to SQL



Lessons

We will discuss what a database is, the different types of databases and what they are used for

We will discuss what SQL(Structured Query Language) is, what it is used for and some of the different systems that use SQL
We will look at the core concepts and structure of a relational database such as tables, columns, rows, etc
We will discuss some of the important data types that may be used in a relational database, including Integer, varchar, text and much more

We will install and setup Microsoft SQL Server 2016

We will install and setup SQL Server Management Studio.

We will connect to a server and look at the Object Explorer

We will take a look at the master and model databases as well as the msdb and tempdb Databases

We will create a new database within MS SQL Server 2016, and create a new table

We will add data to our Table

You will learn how to backup a database and how to restore a backup

Here we will start to write SQL statements and queries, starting with basic SELECT statements
We can target specific columns using the WHERE clause along with a SELECT statement
We can select data based on multiple conditions using the AND & OR clause

We will look at how we can sort returned data using the ORDER BY clause

We will look at how we can sort returned data using the GROUP_BY clause

The HAVING clause is similar to a WHERE clause but can use aggregation
The TOP clause is used to limit the number of records that will be returned from a SELECT statement
We can use DISTINCT to only return distinct or different values in a SELECT statement
The UNION operator is used to combine the result-set of two or more SELECT statements
We will look at some built in functions for performing calculations on data
We will insert our own records into a database using INSERT INTO
The UPDATE statement can be used to change data that already exists in the SQL database
We can use DELETE FROM to remove data from the SQL database
With ALTER TABLE, we can add, remove or change columns, data types and just about anything else
Aliases can be used to temporary rename columns and tables
We will discuss and write inner joins to combine more than one table in a specific way
We will discuss and write outer joins to combine more than one table in a specific way
We will discuss and write left joins to combine more than one table in a specific way
We will discuss and write right joins to combine more than one table in a specific way
We will discuss combining queries together in a subquery
We will talk about what indexing is and how to do it within MS SQL Server

We will discuss the Primary Key and why it's so important

Sorry, it looks like there are no lessons that match your filter.