Beginner to Advanced Guide to Learn SQL with Microsoft SQL Server. Covering All Basics to Advanced with Examples
This course includes:
- 8 hours of on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
0.0
(0 ratings)
258 students
Created by Abhilash Nelson
What you’ll learn
- Learn Microsoft SQL Server Database Management
- SQL commands and SQL Server Management Studio UI
- Start from the basic to advanced MSSQL database
- Combining both SQL commands and MSSQL UI
Course content
39 sections • 60 lectures • 7h 48m total lengthCollapse all sections
Course Introduction and Table of Contents1 lecture • 9min
- Course Introduction and Table of ContentsPreview08:59
Introduction to Database and Database Management Systems1 lecture • 7min
- Introduction to Database and Database Management Systems07:10
Introduction to RDBMS and NonRDBMS1 lecture • 6min
- Introduction to RDBMS and NonRDBMS05:52
Types of SQL Commands1 lecture • 3min
- Types of SQL Commands02:46
Installing MSSQL1 lecture • 12min
- Installing MSSQLPreview12:10
Basic DB Operations2 lectures • 20min
- Basic DB Operations – Part 108:32
- Basic DB Operations – Part 211:26
Basic Table Operations4 lectures • 29min
- Basic Table Operations – Part 107:03
- Basic Table Operations – Part 207:23
- Basic Table Operations – Part 304:09
- Basic Table Operations – Part 410:27
Sample Databases Import1 lecture • 8min
- Sample Databases Import07:43
Aggregate Functions in MSSQL2 lectures • 20min
- Aggregate Functions in MSSQL – Part 110:16
- Aggregate Functions in MSSQL – Part 209:31
Clauses in MSSQL3 lectures • 27min
- Clauses in MSSQL – Part 110:32
- Clauses in MSSQL – Part 206:48
- Clauses in MSSQL – Part 309:59
Grouping Sets Clause2 lectures • 16min
- Grouping Sets Clause – Part 109:54
- Grouping Sets Clause – Part 205:40
SQL Basic Operators2 lectures • 19min
- SQL Basic Operators – Part 109:00
- SQL Basic Operators – Part 210:25
Union and Intersect operators1 lecture • 13min
- Union and Intersect operators12:46
Popular Datatypes Introduction2 lectures • 17min
- Popular Datatypes Introduction – Part 108:26
- Popular Datatypes Introduction – Part 208:28
Popular Datatypes Example1 lecture • 15min
- Popular Datatypes Example15:15
Constraints – Primary Key2 lectures • 23min
- Constraints – Primary Key – part 112:09
- Constraints – Primary Key – part 211:11
Constraints – Foreign Key2 lectures • 21min
- Constraints – Foreign Key – Part 111:58
- Constraints – Foreign Key – Part 209:27
NOT NULL and UNIQUE constraints2 lectures • 13min
- NOT NULL and UNIQUE constraints – Part 107:08
- NOT NULL and UNIQUE constraints – Part 206:16
CHECK and DEFAULT constraints2 lectures • 12min
- CHECK and DEFAULT constraints – Part 106:30
- CHECK and DEFAULT constraints – Part 205:47
ER Diagram Overview1 lecture • 9min
- ER Diagram Overview09:08
SQL Popular String Functions2 lectures • 13min
- SQL Popular String Functions – Part 109:36
- SQL Popular String Functions – Part 203:16
SQL Popular Date Functions2 lectures • 11min
- SQL Popular Date Functions – Part 104:33
- SQL Popular Date Functions – Part 206:51
SQL Popular Mathematical Functions1 lecture • 4min
- SQL Popular Mathematical Functions03:54
SQL Popular Convert Functions1 lecture • 6min
- SQL Popular Convert Functions05:32
Joins – Introduction and Table Preparation3 lectures • 18min
- Joins – Introduction and Table Preparation – Part 104:21
- Joins – Introduction and Table Preparation – Part 206:43
- Joins – Introduction and Table Preparation – Part 306:47
Inner Join1 lecture • 7min
- Inner Join07:01
Outer Join1 lecture • 8min
- Outer Join07:32
Self Join1 lecture • 7min
- Self Join06:50
Cross Join1 lecture • 5min
- Cross Join04:39
Stored Procedure Basics2 lectures • 11min
- Stored Procedure Basics – Part 103:43
- Stored Procedure Basics – Part 207:31
Stored Procedure Passing Params and Return1 lecture • 8min
- Stored Procedure Passing Params and Return08:13
SQL SubQueries1 lecture • 3min
- SQL SubQueries03:21
SQL Views1 lecture • 4min
- SQL Views04:03
SQL Triggers – DDL Triggers1 lecture • 9min
- SQL Triggers – DDL Triggers08:52
SQL Triggers – DML Trigger2 lectures • 19min
- SQL Triggers DML Trigger – Part 108:13
- SQL Triggers DML Trigger – Part 210:36
SQL Transactions2 lectures • 13min
- SQL Transactions – Part 106:39
- SQL Transactions – Part 206:38
Normalization1 lecture • 6min
- Normalization05:37
DB Backup and Restore1 lecture • 8min
- DB Backup and Restore07:43
Securing the Database1 lecture • 10min
- Securing the Database09:54
Requirements
- The computer which can install MSSQL Server and MSSQL Studio. Your Laptop or PC will be fine.
Description
Hello, and welcome to my new course ‘The Complete Dummies Guide to Microsoft SQL Server’.
You already know that in this information technology age ‘data’ is everything. And a Database is the place where this information is stored in tables. There are two types of databases. A structured database and also there is an unstructured or no-SQL kind of database. We will see the SQL or the Structured Query kind of database. And the most popular one among the SQL databases is the Microsoft SQL Server.
Here is an overview of the sessions that are included in this course.
In the first session, we will have an introduction to databases. Then we will see the concepts of SQL or Structured Query Language which is used in RDBMS.
Then we will see different types of SQL commands. Then the database objects And in the next session, we will move on to the basics of the MSSQL server. We will see how we can install the free version or the express edition of Microsoft SQL server into your computer and then we will download the Microsoft SQL Server Management Studio, which is a tool and an interface. And later we will connect SQL Server Management Studio with our MSSQL Server process that is running in the background.
And then we will proceed with the basic SQL database operation. We will create a database, we will list the database in the server, then can select a database using the USE command, and finally will try demonstrating deleting a database using the DROP command. There is also an option to take a backup of the database.
And then we will move on with SQL basic table operations. We will have an overview of the data types of SQL. Then we will have an overview of different SQL constraints and the difference between a primary key and a foreign key. And finally, we will start creating a table in our database. We will create it, we will try to delete it. We will try to alter it. And then we will move on to describing the table schema and inserting data into the table. Deleting data from the table, modifying data, then.. fetching the data all these basic table operations will be dealt with in this session.
And then we will go ahead and import a sample database. It’s a free sample database called the Northwind Traders database from Microsoft. We will download it and we will import that into our SQL server. Later we will proceed with the basic aggregate functions of SQL. We will see what is an aggregate function and then we will proceed with each and every aggregate function.
And then we will proceed with the basic clauses of SQL. We will see what is a clause and different
clauses. The first is the Distinct clause, Group-by, Where clause, then Order-by, Having clause, Select, and Grouping sets. We will also have different examples for each and every clause that we learn. Then we will proceed with the basic operators of the SQL server. The basic operators include Comparison operators Union operators, Intersect, In operator, Not, Between, Is Null, and Not Null. Then we have the Like, Exists, operator. We will try different examples.
Then we will have an elaborate session with the SQL server data types. The popular ones. Then we will have a detailed session regarding the constraints in the SQL server. The constraints include the Primary key, then the Foreign key, Check then Unique then Default, and Not Null constraints. The relationship between these tables and their columns is defined using a standard notation called the ER or Entity Relationship diagram. We will see what is an Entity, then we will see what is an Attribute, and also what is the relationship in the ER diagram.
And then we will proceed with the popular string functions or string manipulation functions in the SQL server. These functions we can use to process a string inside our SQL server. We will also have an overview of the popular SQL Date and Time functions which are used to manipulate date and time data inside SQL servers. And then we will proceed with the popular SQL mathematical operations. And also examples to demonstrate all these functions and then we will proceed with the SQL conversion functions which are used to perform data conversion inside SQL. We will try examples for these functions.
And then we will move on to an important topic called SQL Joins. This join clause in SQL will enable us to connect between different tables which are linked by some common key. The popular ones are Inner join, Outer join, then Cross Join, and Self Join We will see detailed examples, and demonstrations for each of these joins, and then we will proceed with Stored Procedures in the SQL server. A block of re-usable SQL statements that are stored in the Server.
We will see an overview of the stored procedure. Then we will see how we can create a stored procedure. Then execute then how we modify, and delete the stored procedure, and also we will see how we can pass input parameters into. Return the processed parameters from the stored procedure.
And then we will see what is a sub-query inside SQL server. We will see an overview of the sub-query. We will try different examples of how we can create a sub-query. And then we will proceed with Views in the SQL server. We will see an overview of the views in SQL. Then, how we can create a view? We will try an example of how we can call the already-created view. And then we will move on with SQL server triggers. Different types of SQL triggers. DDL trigger, and the DML trigger, are the two types of DML triggers. We will try them with examples.
And then we will see what is a transaction in the SQL server. We will have two states of transactions. We will explain it with the help of a bank ATM scenario and we will try examples of committing a transaction. Rolling back the transaction, the SQL transaction in case of an error. And then we will proceed with the normalization of the table which is used to keep everything in order inside the database. We will see what normalization is in DBMS. We will see different types of normalization. Then we will be proceeding with the backup and restore of the database. We will see how we can back up a database. Save that into our computer and then later we can use that backup to restore that database.
And in the final session, we will be discussing how we can secure a database. We will use an inbuilt tool to access the different security risks and the preventive measures that we can take. The steps that we can follow to fix those security risks and finally about the SQL injection technique that hackers use. We will see a few demonstrations of how a hacker can include an SQL injection statement into our SQL server and get the data he wants.
And that’s all about the topics which are currently included in this quick course. The sample database and the materials have been uploaded and shared in a folder. I will include the link to download them in the last session or the resource section of this course. You are free to use that with no questions asked.
Also, after completing this course, you will be provided with a course completion certificate which will add value to your portfolio.
So that’s all for now. See you soon in my classroom.
Happy Learning !!
Who this course is for:
- A beginner who wants to learn the basics and advanced level of MSSQL Database
