Hands on SQL Server Devlopment for Beginners!

Learn the Basics about SQL Server from Installing to Updating Data. Starting step to becoming a SQL Developer.
4.4 (8 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
142 students enrolled
Instructed by Greg Mills Development / Databases
$19
$25
24% off
Take This Course
  • Lectures 22
  • Length 2 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course 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.

What are the requirements?

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

What am I going to get from this course?

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

What is the target audience?

  • 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 get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
Introduction
Preview
02:05
05:05

General knowledge of what a Database is.

What DBMS and RDBMS stand for.

01:55
  1. What are the different versions SQL Server used for.
  2. Where to download SQL Server 2014 Express from.


06:32

Step-By-Step Instructions for Installing SQL Server Express 2014

Section 2: Creating Databases, Tables and Relationships
07:01

You will learn the following from this Lecture:

  1. How to Start Microsoft SQL Server 2014 Management Studio
  2. How to Browse for your SQL Server.
  3. How to login into SQL Server.
  4. Change default options.
  5. How to a create Databases.


2 pages

You will get the following hands on experience from this Lab:

  1. How to Start Microsoft SQL Server 2014 Management Studio
  2. How to login into SQL Server.
  3. Change default options.
  4. How to create a Databases.
02:29

You will see the solution for the Creating a Database Lab:

  1. How to Start Microsoft SQL Server 2014 Management Studio
  2. How to login into SQL Server.
  3. Change default options.
  4. How to create a Databases.
06:22

You will learn the following from this Lecture:

  1. How to Create Tables.
  2. How to set Primary Key.
  3. How to set a Identity Column.
  4. How set a column as Not Null or Null
4 pages

You will get the following hands on experience from this Lab:

  1. How to Create Tables.
  2. How to set Primary Key.
  3. How to set a Identity Column.
  4. How set a column as Not Null or Null
04:56

You will see the solution for the Creating Tables Lab:

  1. How to Create Tables.
  2. How to set Primary Key.
  3. How to set a Identity Column.
  4. How set a column as Not Null or Null
Section 3: Inserting, Selecting and Deleting data. Setting Foreign Key Relationships.
05:43

You will learn the following from this Lecture:

  1. How to use the INSERT Statement to add data to a table.
  2. How to use the SELECT Statement to see all data from a table.
  3. Demo show common Error messages and how to resolve them
3 pages

You will get the following hands on experience from this Lab:

  1. How to use the INSERT Statement to add data to a table.
  2. How to use the SELECT Statement to see all data from a table
03:51

You will see the solution for the Inserting and Selecting Data Lab:

  1. How to use the INSERT Statement to add data to a table.
  2. How to use the SELECT Statement to see all data from a table
09:26

You will learn the following from this Lecture:

  1. How to use the INSERT Statement to add data to a table with data that is a Foreign Key from another table.
  2. How to set Foreign Key Relationships using Database Diagrams.
  3. How to use the DELETE statement to remove a record from a table.
3 pages

You will get the following hands on experience from this Lab:

  1. How to use the INSERT Statement to add data to a table with data that is a Foreign Key from another table.
  2. How to set Foreign Key Relationships using Database Diagrams.
  3. How to use the DELETE statement to remove a record from a table.
09:26

You will see the solution for the Inserting Data with FK Relationships and the DELETE Lab:

  1. How to use the INSERT Statement to add data to a table with data that is a Foreign Key from another table.
  2. How to set Foreign Key Relationships using Database Diagrams.
  3. How to use the DELETE statement to remove a record from a table.
Section 4: Working With Data
08:14

You will learn the following from this Lecture:

  1. How to Select data from multiple tables using the SELECT and JOIN statements.
  2. How to use the WHERE clause to filter the records returned by the SELECT statement.
  3. Hot to use the GETDATE() function in the WHERE clause.
  4. Using DISTINCT to provide uniqueness to a result set.
3 pages

You will get the following hands on experience from this Lab:

  1. How to Select data from multiple tables using the SELECT and JOIN statements.
  2. How to use the WHERE clause to filter the records returned by the SELECT statement.
  3. Hot to use the GETDATE() function in the WHERE clause.
  4. 4. Using DISTINCT to provide uniqueness to a result set.
05:36

You will see the solution for the Selecting Data from Multiple Tables using JOIN and WHERE Lab:

  1. How to Select data from multiple tables using the SELECT and JOIN statements.
  2. How to use the WHERE clause to filter the records returned by the SELECT statement.
  3. Hot to use the GETDATE() function in the WHERE clause.
  4. Using DISTINCT to provide uniqueness to a result set.
07:56

You will learn the following from this Lecture:

  1. How to add a new column to an existing Table.
  2. How to Update data.
  3. How to Update data with data from another table.
  4. How to Insert data using a SELECT statement.
3 pages

You will get the following hands on experience from this Lab:

  1. How to add a new column to an existing Table.
  2. How to Update data.
  3. How to Update data with data from another table.
  4. How to Insert data using a SELECT statement.
04:49

You will see the solution for the Update Statement Lab:

  1. How to add a new column to an existing Table.
  2. How to Update data.
  3. How to Update data with data from another table.
  4. How to Insert data using a SELECT statement.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Greg Mills, Professional SQL Server and C# Developer

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.

Ready to start learning?
Take This Course