Inserting Data with Foreign Key Relationships and the DELETE statement
LAB - Inserting Data with Foreign Key Relationships and the DELETE statement
LAB - Inserting Data with FK Relationships and the DELETE statement (Solution)
Selecting Data from Multiple Tables using JOIN and WHERE.
LAB - Selecting Data from Multiple Tables using JOIN and WHERE.
LAB - Selecting Data from Multiple Tables using JOIN and WHERE. (Solution)
The Update Statement
LAB - Update Statement
LAB - Update Statement (Solution)
Computer running Windows that SQL Server Express 2014 can be installed on.
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
What a Foreign Key is and how to create one.
SELECT statement with multiple tables. JOIN statement.
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.
I have been creating and teaching SQL Server and C# applications for over 20 years. My passion is to pass on what I have learned in my career to others who are looking to advance their skill set. I believe the best way to learn is by doing and all my courses are designed to provide you with hands on experience.