MY SQL COURSE

Course Overview: MS SQL

1 Introduction to Database Management
• What is database?
• What is RDBMS?

Introduction to SQL Server
• Advantages of SQL Server
• Installing SQL Server 2017
• Installing SQL Server Management Studio
• Connecting to Server from SSMS
1. Server Type (Data Engine, Reporting, Analysis, Integration)
2. Server Name
3. Authentication Modes
a). SQL Server Authentication Mode
b). Windows Authentication Mode
c). Login and Password
4. Object Explorer
5. Object Explorer details
6. Query editor

3 Database
• Creating Database
• Deleting Database
• Backup Database
• Restore sample Database- Adventure Works

4 TSQL (Transact-Structured Query Language)
• Introduction to TSQL
• Types of TSQL Commands
1. Data Definition Language (DDL)
2. Data Manipulation Language (DML)
3. Data Query Language (DQL)
4. Data Control Language (DCL)
5. Transaction Control Language (TCL)
• Differences between each language

5 Table
• Creating Table
• Creating a table from another table
• Using Computed Columns
• Altering Table
• Adding Identity column
• Drop Table

6 Constraints
• Primary Key and Foreign key constraints
• Not Null, Unique, Default and Check constraints

7 Data Types In TSQL
• Binary
• Numeric
• Text or String
• Date & Date Time

8 Data Manipulation Language (DML)
• Insert
• Inserting Rows from one table to another
• Update
• Delete
• Truncate
• Differences Between Delete and Truncate

9 Data Query Language (DQL)
• Select
• Where Clause
1. Between. And
2. In
3. Like
4. Is Null
• Order by Clause
• Group By
• Distinct Keyword
• Isnull () function
• Column aliases
• Table Aliases
• Formatting a SQL Statement with each Clause in a new Line

10 Built in Functions
• Aggregate functions
• String functions
• Date functions
• Mathematical functions
• Ranking functions
• Conversion functions
• Logical functions

11 Joins
• Inner Join
• Natural Join
• Self-Join
• Outer Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Cross Join

12 Set Operators
• Union
• Intersect
• Except

13 Sub Queries
• Single Row Sub Queries
• Multi Row Sub Queries
• Nested Sub Queries

14 Views
• Purpose of Views
• Creating, Altering and Dropping Views
• Simple and Complex Views

15 Security
• Login Creation
• SQL Server Authenticated Login
• Windows Authenticated Login
• User Creation
• Granting Permissions
• Revoking Permissions
• Roles

16 Transaction Management
• Introduction
• Begin Transaction
• Commit Transaction
• Rollback Transaction