Hands on SQL Server Devlopment for Beginners!
4.3 (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.
144 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Hands on SQL Server Devlopment for Beginners! to your Wishlist.

Add to Wishlist

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.3 (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.
144 students enrolled
Created by Greg Mills
Last updated 10/2015
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 22 Lectures Collapse All 22 Lectures 01:49:26
+
Getting Started
4 Lectures 15:37

General knowledge of what a Database is.

What DBMS and RDBMS stand for.

Preview 05:05

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


Preview 01:55

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

Preview 06:32
+
Creating Databases, Tables and Relationships
6 Lectures 20:48

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.


Creating a Database.
07:01

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.
LAB - Creating a Database
2 pages

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.
LAB - Creating a Database (Solution)
02:29

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
Creating Tables.
06:22

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
LAB - Creating Tables
4 pages

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
LAB - Creating Tables (Solution)
04:56
+
Inserting, Selecting and Deleting data. Setting Foreign Key Relationships.
6 Lectures 28:26

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
Inserting and Selecting Data
05:43

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
LAB: Inserting and Selecting Data
3 pages

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
LAB - Inserting and Selecting Data (Solution)
03:51

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.
Inserting Data with Foreign Key Relationships and the DELETE statement
09:26

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.
LAB - Inserting Data with Foreign Key Relationships and the DELETE statement
3 pages

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.
LAB - Inserting Data with FK Relationships and the DELETE statement (Solution)
09:26
+
Working With Data
6 Lectures 26:35

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.
Selecting Data from Multiple Tables using JOIN and WHERE.
08:14

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.
LAB - Selecting Data from Multiple Tables using JOIN and WHERE.
3 pages

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.
LAB - Selecting Data from Multiple Tables using JOIN and WHERE. (Solution)
05:36

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.
The Update Statement
07:56

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.
LAB - Update Statement
3 pages

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.
LAB - Update Statement (Solution)
04:49
About the Instructor
Greg Mills
4.3 Average rating
8 Reviews
144 Students
1 Course
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.