The Complete SQL Server For Beginners

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

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

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

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.

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

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

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

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

Introduction to section two.

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.

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

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

Exercise on creating users .

Let's download and install AdventureWorks database.

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

Introduction to section three.

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.

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

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

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

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

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

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.

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

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

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.

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

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

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

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

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

Introduction to section four.

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.

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

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

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

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

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

Exercise on how to create table from another table.

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.

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

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

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

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

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

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.

Time for an exercise about in and between and keywords.

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

Introduction to section five.

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

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.

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

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

Exercise to test your knowledge of the union operators.

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

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

Exercise testing your case statement skills.

Another exercise to fill table with data.

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

Time for an exercise about the subquery

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

Introduction to section six.

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.

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

Exercise to help you practice aggregate functions.

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

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

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.

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

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

Introduction to section seven.

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

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

Exercise about the Insert Statement.

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

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

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

Exercise about the update statement.

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

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

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