Microsoft SQL Server 2017 Database Basic (พื้นฐาน)

Module 1: Introduction To Microsoft SQL Server

• Introduction
• Introduction To Database
• Microsoft SQL Server 2017 Installation
• Overview Of SQL Server Management Studio

Module 2: Cloud DataBase

• Introduction
• Amazon AWS
• Microsoft Azure

Module 3: Introduction To Database

• Introduction
• Create, Alter, Drop Database Using SQL Syntax
• Drop Database Issue
• Create, Alter, Drop Database Using GUI

Module 4: Introduction To Tables

• Introduction
• Tables
• Create, Alter, Drop Table Using SQL Syntax
• Create, Alter, Drop Table Using GUI

Module 5: Data Manipulation Language (DML)

• Introduction
• Insert Command
• Update Command
• Delete Command

Module 6: Advance Table Concepts

• Advance Table Concepts

Module 7: SQL Comments

• SQL Comments

Module 8: Joins

• Introduction To Joins
• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Cross Join
• Self Join

Module 9: Stored Procedure

• Stored Procedure

Module 10: SQL Injection And Advantages of Stored Procedure

• SQL Injection And Advantages of Stored Procedure Part 1

Module 11: Functions

• Functions
• Built-in Functions
• User Defined Function

Module 12: Temp Tables

• Temp Tables

Module 13: Triggers

• Trigger

Module 14: Views

• Views

Module 14: Stored Procedure Extended

• Introduction
• Input Parameter
• Output Parameter
• Return Value
• Output Clause In Insert, Update and Delete
• Dynamic Output Parameter
• Parameter as optional and default value
• Retrieving identity column value

Module 15: Exception Handling

• Introduction
• Exception Handling 

Module 16: Import

• Introduction
• Import data from excel file
• Import data from flat file
• Import data from another SQL server database
• Filter data while importing
• Import data from MySQL

Module 17: Export

• Introduction
• Export data to excel file
• Export multiple table data to excel file
• Export data to flat File
• Export data to another SQL server database
• Filter data while exporting

Module 18: Bulk Insert

• Bulk Insert

Module 18: Cursors

• Cursors

Module 19: Table Variable

• Table Variable

Module 20: Derived tables and Except operator

• Derived tables
• Except operator