Learn the concepts, commands, and table operations in Microsoft SQL Server, and how to secure your database.
Read more.Instructor
I am a Post Graduate Masters Degree holder in Computer Science and Engineering with experience in Android/iOS Mobile and PHP/Python Web Developer Apps
Only want this course? Buy this course for $199 $29 and keep lifetime access.
Click here
About This Course
Who this course is for:
- IT professionals
What you’ll learn:Â
- SQL database operation
- SQL commands
- The basic clauses of SQL
- SQL server data-types
- SQL Joins
- Sub-query inside SQL server
- How to secure a database
Requirements:Â
- No prior knowledge is required to take this course
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 these information is stored in tables. There are two types of database. A structured database and also there is an unstructured or no-SQL kind of database.Â
We will look into the SQL or the Structured Query kind of database. And the most popular one among the SQL databases is the Microsoft SQL Server.Â
Happy Learning!
Our Promise to You
By the end of this course, you will have learned the concepts and commands in Microsoft SQL Server.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today!
Course Curriculum
Section 1 - Course Introduction And Table Of Contents | |||
Course Introduction And Table Of Contents | 00:00:00 | ||
Section 2 - Introduction To Database And Database Management Systems | |||
Introduction To Database And Database Management Systems | 00:00:00 | ||
Section 3 - Introduction To RDBMS And NonRDBMS | |||
Introduction To RDBMS And NonRDBMS | 00:00:00 | ||
Section 4 - Types Of SQL Commands | |||
Types Of SQL Commands | 00:00:00 | ||
Section 5 - Installing MSSQL | |||
Installing MSSQL | 00:00:00 | ||
Section 6 - Basic DB Operations | |||
Basic DB Operations – Part 1 | 00:00:00 | ||
Basic DB Operations – Part 2 | 00:00:00 | ||
Section 7 - Basic Table Operations | |||
Basic Table Operations – Part 1 | 00:00:00 | ||
Basic Table Operations – Part 2 | 00:00:00 | ||
Basic Table Operations – Part 3 | 00:00:00 | ||
Basic Table Operations – Part 4 | 00:00:00 | ||
Section 8 - Sample Databases Import | |||
Sample Databases Import | 00:00:00 | ||
Section 9 - Aggregate Functions In MSSQL | |||
Aggregate Functions In MSSQL – Part 1 | 00:00:00 | ||
Aggregate Functions In MSSQL – Part 2 | 00:00:00 | ||
Section 10 - Clauses In MSSQL | |||
Clauses In MSSQL – Part 1 | 00:00:00 | ||
Clauses In MSSQL – Part 2 | 00:00:00 | ||
Clauses In MSSQL – Part 3 | 00:00:00 | ||
Section 11 - Grouping Sets Clause | |||
Grouping Sets Clause – Part 1 | 00:00:00 | ||
Grouping Sets Clause – Part 2 | 00:00:00 | ||
Section 12 - SQL Basic Operators | |||
SQL Basic Operators – Part 1 | 00:00:00 | ||
SQL Basic Operators – Part 2 | 00:00:00 | ||
Section 13 - Union And Intersect Operators | |||
Union And Intersect operators | 00:00:00 | ||
Section 14 - Popular Datatypes Introduction | |||
Popular Datatypes Introduction – Part 1 | 00:00:00 | ||
Popular Datatypes Introduction – Part 2 | 00:00:00 | ||
Section 15 - Popular Datatypes Example | |||
Popular Datatypes Example | 00:00:00 | ||
Section 16 - Constraints - Primary Key | |||
Constraints – Primary Key – Part 1 | 00:00:00 | ||
Constraints – Primary Key – Part 2 | 00:00:00 | ||
Section 17 - Constraints - Foreign Key | |||
Constraints – Foreign Key – Part 1 | 00:00:00 | ||
Constraints – Foreign Key – Part 2 | 00:00:00 | ||
Section 18 - NOT NULL And UNIQUE Constraints | |||
NOT NULL And UNIQUE Constraints – Part 1 | 00:00:00 | ||
NOT NULL And UNIQUE Constraints – Part 2 | 00:00:00 | ||
Section 19 - CHECK And DEFAULT Constraints | |||
CHECK And DEFAULT Constraints – Part 1 | 00:00:00 | ||
CHECK And DEFAULT Constraints – Part 2 | 00:00:00 | ||
Section 20 - ER Diagram Overview | |||
ER Diagram Overview | 00:00:00 | ||
Section 21 - SQL Popular String Functions | |||
SQL Popular String Functions – Part 1 | 00:00:00 | ||
SQL Popular String Functions – Part 2 | 00:00:00 | ||
Section 22 - SQL Popular Date Functions | |||
SQL Popular Date Functions – Part 1 | 00:00:00 | ||
SQL Popular Date Functions – Part 2 | 00:00:00 | ||
Section 23 - SQL Popular Mathematical Functions | |||
SQL Popular Mathematical Functions | 00:00:00 | ||
Section 24 - SQL Popular Convert Functions | |||
SQL Popular Convert Functions | 00:00:00 | ||
Section 25 - Joins - Introduction And Table Preparation | |||
Joins – Introduction And Table Preparation – Part 1 | 00:00:00 | ||
Joins – Introduction And Table Preparation – Part 2 | 00:00:00 | ||
Joins – Introduction And Table Preparation – Part 3 | 00:00:00 | ||
Section 26 - Inner Join | |||
Inner Join | 00:00:00 | ||
Section 27 - Outer Join | |||
Outer Join | 00:00:00 | ||
Section 28 - Self Join | |||
Self Join | 00:00:00 | ||
Section 29 - Cross Join | |||
Cross Join | 00:00:00 | ||
Section 30 - Stored Procedure Basics | |||
Stored Procedure Basics – Part 1 | 00:00:00 | ||
Stored Procedure Basics – Part 2 | 00:00:00 | ||
Section 31 - Stored Procedure Passing Parameters And Return | |||
Stored Procedure Passing Params And Return | 00:00:00 | ||
Section 32 - SQL SubQueries | |||
SQL SubQueries | 00:00:00 | ||
Section 33 - SQL Views | |||
SQL Views | 00:00:00 | ||
Section 34 - SQL Triggers - DDL Triggers | |||
SQL Triggers – DDL Triggers | 00:00:00 | ||
Section 35 - SQL Triggers - DML Trigger | |||
SQL Triggers DML Trigger – Part 1 | 00:00:00 | ||
SQL Triggers DML Trigger – Part 2 | 00:00:00 | ||
Section 36 - SQL Transactions | |||
SQL Transactions – Part 1 | 00:00:00 | ||
SQL Transactions – Part 2 | 00:00:00 | ||
Section 37 - Normalization | |||
Normalization | 00:00:00 | ||
Section 38 - DB Backup And Restore | |||
DB Backup And Restore | 00:00:00 | ||
Section 39 - Securing The Database | |||
Securing The Database | 00:00:00 | ||
Query Source | 00:00:00 |