The Complete SQL Server For Beginners
4.0 (355 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,761 students enrolled

The Complete SQL Server For Beginners

The ultimate practical guide to master SQL Server as a developer (Downloadable SQL Scripts Included).
4.0 (355 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,761 students enrolled
Created by Ahmad Mohey
Last updated 8/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9 hours on-demand video
  • 8 articles
  • 80 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Install SQL Server and Management Studio.
  • Understand basics of cloud databases.
  • Create SQL Server instances on Microsoft Azure.
  • Create SQL Server instances on AWS (Amazon Web Services).
  • Connect Management Studio to your cloud databases.
  • Create SQL databases and schemas.
  • Create and manage users in database.
  • Install AdventureWorks database.
  • Create tables using SQL script.
  • Create tables using Management Studio.
  • Learn about different data types available in SQL Server.
  • Applying different constraints.
  • Create primary keys, foreign keys and composite keys.
  • Design relational databases and create relationships between tables.
  • Generate Entity Relationship Diagram (ERD).
  • Import and Export Data using Management Studio.
  • Create tables using Import Wizard.
  • Work with select statement.
  • Filter data using where clause.
  • Work with and, or, not operators.
  • Use like operator and wildcards.
  • Enhance your data selection using (In and between)
  • How to select distinct column only.
  • How to work with union and intersect, except operators.
  • Work with case statement.
  • Enhancing your data selection with subqueries.
  • Applying aggregate functions (Min, Max, Avg, Sum, Count)
  • Group table records using group by keyword.
  • Filter grouped records using having keyword.
  • Integrating aggregate functions with group by and having keywords.
  • Understand what is DML and DDL.
  • Add new records using insert statement.
  • Delete records using delete statement.
  • Update records using update statement.
  • Generate SQL scripts using Management Studio.
  • Create inner joins, left outer joins and right outer joins.
  • How to create multiple joins in one SQL query.
  • Create views using SQL Script.
  • Create views using Management.
  • Create a small human resources databases.
  • Perform different SQL statements on the human resources database.
  • Understand what is T-SQL.
  • Working with Stored procedures.
  • How to create a stored procedures with parameters.
  • Setting default value for stored procedure parameters.
  • How to use built-in string functions (CharIndex, Replace, Substring, Concat, Upper, Lower and Reverse).
  • How to use built-in date functions (GetDate, DateAdd, DateDiff and DateName).
  • How to use built-in numeric functions (Round, Ceiling, Floor, Abs, Rand and Sign).
Course content
Expand all 139 lectures 09:11:16
+ Introduction to SQL Server and Cloud Databases
12 lectures 50:43

Introduction to the course, to show you what we are going to discuss in the next section.

Preview 04:15

In this lecture you will understand what is relational databases and what is SQL Server 

Preview 03:04
Relational Databases (Article)
01:28

Now we are going to install the download and install SQL Server database engine.

Install SQL Server
06:14
SQL Server (Article)
01:38

To complete the installation we need to download and install the Management Studio, which will enable us to perform different tasks on the SQL server database engine.

Management Studio
04:14

Understand the basic concepts of a cloud database and what are the advantages cloud databases give us.

Cloud Databases
04:10

In this lecture we are going to create SQL Server instances on Microsoft Azure.

SQL Server Database on Microsoft Azure
13:19
Microsoft Azure (Article)
01:46

Now we are going to create SQL Server instances on Amazon Web Services (AWS).

Preview 08:14
Amazon Web Services - AWS RDS (Article)
01:42

Summary of the section to remind you of the points we discussed in brief.

Summary
00:37
+ Databases, Users and Authentications In SQL Server
7 lectures 30:42

Introduction to section two.

Introduction
00:31

In this lecture you are going to create your first SQL Server database and see where the physical files are stored and how to work with them directly.

Preview 08:44

Now you will learn how to create users in SQL server and give them certain permissions.

Create and Manage Users
09:25

Learn what is a database schema and why people use schema and how to create them.

Database Schema
07:05

Exercise on creating users .

Exercise : Create User
01:51

Let's download and install AdventureWorks database.

AdventureWorks Database
02:35

Summary of the section to remind you of the points we discussed in brief.

Summary
00:31
+ Database Tables, Primary and Foreign Keys In SQL Server
16 lectures 01:42:38

Introduction to section three.

Introduction to The Chapter
01:12

In this lecture you are going to work with the most important database object which is the tables, think of tables as the heart of relational databases.

Preview 16:12

Explore more SQL Server datatypes and see some of the differences between the similar ones.

Data Types
11:49

Let's dive deeper in creating tables with applying constraints to the columns.

Constraints
09:52

We are going to see how to delete tables and delete data in the tables.

Drop and Truncate Tables
02:08

In this exercise you are going to build some of the tables for the human resources database.

Exercise : Create Tables Employees and Jobs
09:18

We can use a feature called column properties in management studio to add more properties and features to the columns visually.

Column Properties
04:56

Now it's time to discuses one of the most important concepts in relational database which is primary keys, you are going to learn how to create them in different ways.

Primary Keys
07:34

In this lecture we are going to see how to create foreign keys and make relationships between tables.

Foreign Keys
09:14

In this exercise you will be modifying the country column in the employees table.

Exercise : Edit Country Column in Employees Table
01:53

In this exercise you will be asked to create a new called contains the previous experience of employees in case some employees had experience in the past.

Exercise : Create Table Previous Experience
05:57

This is an interesting lecture we are going to fill our tables with data using Import wizard feature in management studio.

Import and Export Data
11:53

We can use the Import wizard to create tables from scratch and fill with data without typing any SQL script.

Create Table Using Import Wizard
02:49

In this exercise you will be asked to create both primary and foreign keys for statues table.

Exercise : Primary and Foreign Keys for Status Table
02:04

We have an interesting lecture, we are going to see how to generate ERD and visually view database objects and track relationships.

Entity Relationship Diagram (ERD)
04:49

Summary of the section to remind you of the points we discussed in brief.

Summary
00:58
+ Select Statements In SQL Server
17 lectures 01:15:21

Introduction to section four.

Introduction to The Chapter
00:42

Select statement is the most common used statement in SQL, it's used to retrieve data from database, let's figure out how to use it efficiently.

Preview 05:47

Small exercise to practice what you have learned about the select statement.

Exercise : Select data from AdventureWorks
02:37

Where clause is usually used with select statement to filter data based on conditions as we are going to see.

Where Clause
15:00

In this exercise you are going to select some data from AdventureWorks database based on specific conditions.

Exercise : Select data from AdventureWorks based on conditions
01:55

Order by statement is used to order the records based on one or multiple columns.

Order by
04:00

In this lecture we are going to create a table from an already existing table.

Create Table From Existing Table
05:48

Exercise on how to create table from another table.

Exercise : Create Table From Another Table
02:12

Let's see how to work with operators like and, or , not and is null and how can you combine them in one where clause.

And, Or, Not, Is Null Operators
09:43

Let's practice the conditions operators that we have just learned in the previous lecture.

Exercise : And, Or, Not, Is Null
03:13

Like is very powerful keyword in SQL it enable you to search for text patterns in your data as we are going to see.

Like and Wildcards
05:15

In this exercise you will be asked to create a pattern to display set of records in database.

Exercise : Like and Wildcards
03:48

There is more advanced wildcards that we can use to define our patterns, let's go a check them.

Advanced Like and Wildcards
03:44

In is a small word but it a save effort saver when typing queries as we are going to see in this lecture.

In
03:45

Between also is a very powerful keyword it is used to perform a range condition between two values, let's see how to use it.

Between
03:17

Time for an exercise about in and between and keywords.

Exercise : Between
03:44

Summary of the section to remind you of the points we discussed in brief.

Summary
00:51
+ Advanced Select Statements In SQL Server
13 lectures 49:13

Introduction to section five.

Introduction to The Chapter
00:27

Distinct is another powerful keyword used to select only the distinct values only in a table, let's see how to use it.

Distinct
03:27

Time with another keyword in can help you when selecting data from a huge table and you would like to get only a percentage of the data.

Percent
01:46

We can change how many rows Management Studio returns by default, in this lecture we are going to see how.

Change The Rule of 1000
02:41

Union is used to combine two different queries into one, sounds interesting...let's see how to use it.

Union Operator
06:21

Exercise to test your knowledge of the union operators.

Exercise : Union Operator
04:48

In this lecture we are going to learn about two keywords in SQL they are the Intersect and Except.

Intersect and Except
03:37

Another powerful statement we are going to learn in this lecture which is ....case statement.

CASE Statement
09:46

Exercise testing your case statement skills.

Exercise : CASE Statement
03:59

Another exercise to fill table with data.

Exercise : Fill PreviousExpereince Table with Data
01:41

Subquery, one of the very powerful features of SQL, learn how to make dynamic conditions using subquery.

Subqueries
05:44

Time for an exercise about the subquery

Exercise : Subquery
03:48

Summary of the section to remind you of the points we discussed in brief.

Summary
01:08
+ Aggregate Functions In SQL Server
9 lectures 42:19

Introduction to section six.

Introduction to The Chapter
00:42

In this lecture we are going to see the powerful aggregate functions, starting withe minimum and maximum functions, let's see how to use them.

Aggregate Functions - Min and Max
06:20

Continue our lectures about the aggregate functions, this lecture we will learn how to use a new function...count.

Aggregate Functions - Count
05:40

Exercise to help you practice aggregate functions.

Exercise : Create Table Budget with Some Queries
07:05

Yet with another aggregate functions, we have two more, average and summation.

Aggregate Functions - Avg and Sum
05:18

Group by is a statement used with aggregate functions, which will take your querying skills to another level.

Group By
08:40

having also is used with group by and aggregate functions, it's used like the where clause, but there is a difference, let's see what is the difference.

Having
03:45

In this exercise you will need to use different techniques that we have learned through the course.

Exercise : All in one
04:02

Summary of the section to remind you of the points we discussed in brief.

Summary
00:47
+ Data Manipulation In SQL Server
11 lectures 36:10

Introduction to section seven.

Introduction to The Chapter
00:20

In this lecture we are going to learn what is meant by DML and DDL.

DML and DDL
01:30

Finally let's see how to write the insert statement in SQL Server.

Insert Into Statement
06:01

Exercise about the Insert Statement.

Exercise : Insert Into Statement
03:39

We have another insertion related lecture, we are going to discuss insert into select.

Insert Into Select Statement
06:00

Delete statement used to delete one or more records from a tables but with some rules, let's see how to do it.

Delete Statement
02:46

Update statement also is used to update one or multiple columns based on conditions, let's see how to write it.

Update Statement
05:18

Exercise about the update statement.

Exercise : Update Statement
03:28

Another exercise about the update statement to make sure you understand it correctly.

Exercise : Update Status of Employees
03:51

One of the tricks of Management Studio is we can generate scripts.

Generate Scripts
02:29

Summary of the section to remind you of the points we discussed in brief.

Summary
00:48
+ String Functions in SQL Server
14 lectures 44:41

Introduction to section eight.

Introduction to The Chapter
00:30

In this lecture we are going to start exploring some basic built-in string functions.

Upper, Lower and Reverse
04:31

Moving on to a more advanced string functions we are going to discuess replace, substring and concat.

Replace, Substring and Concat
13:45

Exercise on the string functions in SQL Server

Exercise : Gender
01:19

Another exercise testing your knowledge of the string functions.

Exercise : Country Name
01:19

Len is a simple function used to get the length of the records.

Len
00:57

In this lecture we are going to discuss a very powerful string function CharIndex.

CharIndex
04:25

We have an interesting exercise I want you to extract the email username from the email field.

Exercise : Extract Email Username
02:48

In this lecture I want you to extract the email service provider from email field.

Exercise : Extract Email Service Provider
03:05

In this lecture we are going to discuss one of very powerful SQL server functions it is coalesce.

Coalesce
02:30

Replicate simply repeats a string value a specified number of times. let's see how to use it.

Replicate
02:06

Right Extract a substring from a string starting from right and Left extract a substring from a string starting from left.

Right and Left
01:54

We can use a function called trim to removes the space character.

Trim
02:46

Summary of the section to remind you of the points we discuss in brief.

Summary
02:46
+ Numeric and Date Functions in SQL Server
9 lectures 22:03

Introduction to section nine.

Introduction to The Chapter
00:32

Let's explore the date functions we are going to start with two functions, GetDate and DateAdd.

GetDate and DateAdd
02:25

An exercise about the dates.

Exercise : Add Two Years to birth date
03:00

Returns the count of the specified date part boundaries crossed between the specified startdate and enddate.

DateDiff
04:25

Returns a character string that represents the specified date part of the specified date.

DateName
03:15

In this exercise I need you to calculate the age of each employee based on the DOB column in Employees table.

Exercise : Get Age of Each Employee
01:17

Now let's see how the math functions work.

Round, Ceiling and Floor
03:33

Another math functions we are going to discuss in this lecture they are the abs, rand and sign.

Abs, Rand and Sign
02:35

Summary of the section to remind you of the points we discussed in brief.

Summary
01:01
+ Joins and Views in SQL Server
13 lectures 46:27

Introduction to section ten.

Introduction to The Chapter
00:35

By using joins, you can retrieve data from two or more tables based on logical relationships between the tables. The most important and frequently used of the joins is the INNER JOIN. 

Inner Joins
10:18

Still discussing about the inner joins so that you can fully understand it.

More Inner Joins
02:14

Let's see how to add multiple inner joins in one query.

Multiple Inner Joins
05:52

Exercise on joins, to create join between Cities and Countries tables in HumanResources Database.

Exercise : Joining Cities and Countries
03:07

More advanced exercise we have here, getting the number of cities in each country.

Exercise : No of Cities in Each Country
03:04

Right outer join performs a join starting with the second (right-most) table and then any matching first (left-most) table records.

Right Outer Join
04:05

The left outer join returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

Left Outer Join
02:52

A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data. 

Create a View using SQL Script
03:59

In this lecture we are going to see how to modify the structure of a view after we have already created it.

Modifying The Structure of a View
02:03

Another easier alternative way to create views, is to create views using Management Studio.

Create a View using Management Studio
05:47

Now it's time for an exercise about the views.

Exercise : Create View For Status of Each Employee
01:49

Summary of the section to remind you of the points we discussed in brief.

Summary
00:42
Requirements
  • SQL Server Developer Edition (Free)
  • Management Studio (Free)
Description

    Welcome to the Complete SQL Server For Beginners Course, The ultimate practical guide to master SQL Server for developers.

This course will start with you from zero level experience in SQL databases, starting to level up as we are going through the course. explaining all the questions you maybe asking yourself such as 

What is a relational database?  what is SQL Server?  what is a cloud database?

This course will guide you how to install SQL Server on a local machine step by step and even how to create your own cloud databases on the most required cloud services providers in the market...AWS (Amazon Web Services) and Microsoft Azure.

You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)

After you learn the basic concepts of the SQL and relational databases and how to install it on a machine and on the cloud, now it will be about time to dive deeper into the world of SQL databases and learn :

  • How create databases and schemas.

  • How create tables and views.

  • Understand all the big concepts like DML, DDL, T-SQL and DBaaS.

  • You will learn how to create users to access your database based on specific permissions you gave them.

  • How to create different constraints.

  • Create primary keys, foreign keys and composite keys.

  • How to export and import a bulk of data in and out of your database.

  • How to retrieve data from your database using select statement.

  •  How to filter data using where clause.

  • How to use aggregate functions (Sum, Min, Max..etc).

  • Learn how to use group by and having with aggregate functions.

  • How to use case statement.

  • How to use the keywords like between, in, distinct and percent.

  • Understand how to create subqueries.

  • How to manipulate data using Insert, update, delete statements.

  • How to use joins to link two tables or more together.

  • How to design complex database relations.

  • How to create different stored procedures to perform different jobs.

  • You will learn how to use string functions such as replace, substring, CharIndex and more.

  • How to use the powerful date functions in sql server such as DateAdd, DateDiff and more.

  • You will learn how to use the numeric functions such as round, ceiling, floor and more.

You will be designing a small human resources database from scratch, and we will also work with the  AdventureWorks database. AdventureWorks Database is a Microsoft product sample. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles. You will learn how to install AdventureWorks database onto your database server and we are going to perform different sql queries and statements on both HumanResources and AdventureWorks.

You will learn how to increase your productivity with relational databases using joins and views, you will be creating inner joins, left outer joins and right outer joins.

You will have the chances to create joins in two different ways, first using SQL script and you will learn how to do this step by step, and visually using the management studio features which allows you to create joins much faster and easier.

With over 30 real world exercises to help you practice and learn more about almost each major topic in the course, I am going to solve all of the exercises with you while giving you some time to try to solve it on your own.

All the SQL scripts I will be using in this course are available for you to download anytime.

Give your CV a huge boost by mastering the SQL server with the Complete SQL Server for Beginners course, do not hesitate enrolling.

Who this course is for:
  • Complete beginners, no prior experience is required.
  • Anyone looking for a course to refresh and incredibly increase their SQL knowledge.
  • People who are looking for a career change.
  • Anyone want to learn relational databases and SQL Server and be familiar with SQL syntax.
  • Developers looking for a huge boost in CV.