Hands on SQL Server Devlopment for Beginners!

Hands on SQL Server Devlopment for Beginners! , available at $19.99, has an average rating of 4.55, with 22 lectures, based on 16 reviews, and has 175 subscribers.

You will learn about 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. This course is ideal for individuals who are Anyone wanting to learn the basics of SQL Server. or Anyone preparing for Job interview that requires SQL Server or Anyone looking to add SQL Server to their skill set. It is particularly useful for Anyone wanting to learn the basics of SQL Server. or Anyone preparing for Job interview that requires SQL Server or Anyone looking to add SQL Server to their skill set.

Enroll now: Hands on SQL Server Devlopment for Beginners!

Summary

Title: Hands on SQL Server Devlopment for Beginners!

Price: $19.99

Average Rating: 4.55

Number of Lectures: 22

Number of Published Lectures: 22

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Introduction

Lecture 2: What is a Database?

Lecture 3: Different Versions of SQL Server 2014.

Lecture 4: Installing SQl Server 2014 Express Edition

Chapter 2: Creating Databases, Tables and Relationships

Lecture 1: Creating a Database.

Lecture 2: LAB – Creating a Database

Lecture 3: LAB – Creating a Database (Solution)

Lecture 4: Creating Tables.

Lecture 5: LAB – Creating Tables

Lecture 6: LAB – Creating Tables (Solution)

Chapter 3: Inserting, Selecting and Deleting data. Setting Foreign Key Relationships.

Lecture 1: Inserting and Selecting Data

Lecture 2: LAB: Inserting and Selecting Data

Lecture 3: LAB – Inserting and Selecting Data (Solution)

Lecture 4: Inserting Data with Foreign Key Relationships and the DELETE statement

Lecture 5: LAB – Inserting Data with Foreign Key Relationships and the DELETE statement

Lecture 6: LAB – Inserting Data with FK Relationships and the DELETE statement (Solution)

Chapter 4: Working With Data

Lecture 1: Selecting Data from Multiple Tables using JOIN and WHERE.

Lecture 2: LAB – Selecting Data from Multiple Tables using JOIN and WHERE.

Lecture 3: LAB – Selecting Data from Multiple Tables using JOIN and WHERE. (Solution)

Lecture 4: The Update Statement

Lecture 5: LAB – Update Statement

Lecture 6: LAB – Update Statement (Solution)

Instructors

Greg Mills
Professional SQL Server and C# Developer

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 9 votes

5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!