What you'll learn

General knowledge of what a Database is.
Differenet versions of SQL Server 2014
How to install SQL Server Express 2014
Create a database in SQL Server
Create tables in SQl Server
Add data into tables in SQL Server
Set foreign key relationships between tables
Delete data from tables
Update data in tables.

Course content

4 sections • 22 lectures • 1h 49m total length

Introduction2:05
What is a Database?5:05
General knowledge of what a Database is.

What DBMS and RDBMS stand for.
Different Versions of SQL Server 2014.1:55
What are the different versions SQL Server used for.

Where to download SQL Server 2014 Express from.
Installing SQl Server 2014 Express Edition6:32
Step-By-Step Instructions for Installing SQL Server Express 2014

Creating a Database.7:01
You will learn the following from this Lecture:

How to Start Microsoft SQL Server 2014 Management Studio

How to Browse for your SQL Server.

How to login into SQL Server.

Change default options.

How to a create Databases.
LAB - Creating a Database2:00
You will get the following hands on experience from this Lab:

How to Start Microsoft SQL Server 2014 Management Studio

How to login into SQL Server.

Change default options.

How to create a Databases.
LAB - Creating a Database (Solution)2:29
You will see the solution for the Creating a Database Lab:

How to Start Microsoft SQL Server 2014 Management Studio

How to login into SQL Server.

Change default options.

How to create a Databases.
Creating Tables.6:22
You will learn the following from this Lecture:

How to Create Tables.

How to set Primary Key.

How to set a Identity Column.

How set a column as Not Null or Null
LAB - Creating Tables4:00
You will get the following hands on experience from this Lab:

How to Create Tables.

How to set Primary Key.

How to set a Identity Column.

How set a column as Not Null or Null
LAB - Creating Tables (Solution)4:56
You will see the solution for the Creating Tables Lab:

How to Create Tables.

How to set Primary Key.

How to set a Identity Column.

How set a column as Not Null or Null

Inserting and Selecting Data5:43
You will learn the following from this Lecture:

How to use the INSERT Statement to add data to a table.

How to use the SELECT Statement to see all data from a table.

Demo show common Error messages and how to resolve them
LAB: Inserting and Selecting Data3:00
You will get the following hands on experience from this Lab:

How to use the INSERT Statement to add data to a table.

How to use the SELECT Statement to see all data from a table
LAB - Inserting and Selecting Data (Solution)3:51
You will see the solution for the Inserting and Selecting Data Lab:

How to use the INSERT Statement to add data to a table.

How to use the SELECT Statement to see all data from a table
Inserting Data with Foreign Key Relationships and the DELETE statement9:26
You will learn the following from this Lecture:

How to use the INSERT Statement to add data to a table with data that is a Foreign Key from another table.

How to set Foreign Key Relationships using Database Diagrams.

How to use the DELETE statement to remove a record from a table.
LAB - Inserting Data with Foreign Key Relationships and the DELETE statement3:00
You will get the following hands on experience from this Lab:

How to use the INSERT Statement to add data to a table with data that is a Foreign Key from another table.

How to set Foreign Key Relationships using Database Diagrams.

How to use the DELETE statement to remove a record from a table.
LAB - Inserting Data with FK Relationships and the DELETE statement (Solution)9:26
You will see the solution for the Inserting Data with FK Relationships and the DELETE Lab:

How to use the INSERT Statement to add data to a table with data that is a Foreign Key from another table.

How to set Foreign Key Relationships using Database Diagrams.

How to use the DELETE statement to remove a record from a table.

Selecting Data from Multiple Tables using JOIN and WHERE.8:14
You will learn the following from this Lecture:

How to Select data from multiple tables using the SELECT and JOIN statements.

How to use the WHERE clause to filter the records returned by the SELECT statement.

Hot to use the GETDATE() function in the WHERE clause.

Using DISTINCT to provide uniqueness to a result set.
LAB - Selecting Data from Multiple Tables using JOIN and WHERE.3:00
You will get the following hands on experience from this Lab:

How to Select data from multiple tables using the SELECT and JOIN statements.

How to use the WHERE clause to filter the records returned by the SELECT statement.

Hot to use the GETDATE() function in the WHERE clause.

4. Using DISTINCT to provide uniqueness to a result set.
LAB - Selecting Data from Multiple Tables using JOIN and WHERE. (Solution)5:36
You will see the solution for the Selecting Data from Multiple Tables using JOIN and WHERE Lab:

How to Select data from multiple tables using the SELECT and JOIN statements.

How to use the WHERE clause to filter the records returned by the SELECT statement.

Hot to use the GETDATE() function in the WHERE clause.

Using DISTINCT to provide uniqueness to a result set.
The Update Statement7:56
You will learn the following from this Lecture:

How to add a new column to an existing Table.

How to Update data.

How to Update data with data from another table.

How to Insert data using a SELECT statement.
LAB - Update Statement3:00
You will get the following hands on experience from this Lab:

How to add a new column to an existing Table.

How to Update data.

How to Update data with data from another table.

How to Insert data using a SELECT statement.
LAB - Update Statement (Solution)4:49
You will see the solution for the Update Statement Lab:

How to add a new column to an existing Table.

How to Update data.

How to Update data with data from another table.

How to Insert data using a SELECT statement.

Requirements

Computer running Windows that SQL Server Express 2014 can be installed on.

Description

Get hands on learning of SQL Server as I walk you through from installing to updating data.I use the lecture, lab and solution teaching process to provide hands on learning.

At the end of this course you will hands on experience doing the following:

Installing SQL Server 2014 Express
Using Microsoft SQL Server 2014 Management Studio
Creating database
Creating tables
Inserting data
Deleting data
What a Foreign Key is and how to create one.
SELECT statement with multiple tables. JOIN statement.
Updating data

You should take this course if you want to learn the basics of SQL Server. You will learn good skills if you are preparing for an interview or seeing if SQL Server is something you want to add to skill set.

You need no previous experience on SQL Server in order to be successful in this course. I start you out at the basics and take to where you are creating intermediate SQL statements.

Who this course is for:

Anyone wanting to learn the basics of SQL Server.
Anyone preparing for Job interview that requires SQL Server
Anyone looking to add SQL Server to their skill set.

What you'll learn

Explore related topics

Course content

Getting Started4 lectures • 16min

Creating Databases, Tables and Relationships6 lectures • 27min

Inserting, Selecting and Deleting data. Setting Foreign Key Relationships.6 lectures • 34min

Working With Data6 lectures • 33min

Requirements

Description

Who this course is for: