1) Detailed Course with Hands-On Practical Lab Sessions on SQL Server Installation,
Writing SQL Queries, Database Creation, Installation of SQL Server Management Studio & Azure Data Studio,
How to Connect and Use SQL Server Management Studio & Azure Data Studio.
2) Practical Course includes practical assignment activities for students to practice lab activities.
3) Students will learn the following topics in this detailed hands-on course.
- What is SQL Server ?
- History of SQL Server
- SQL Server Versions
- SQL Server Editions
- SQL Server Installation
- Hardware Requirements for SQL Server Installation
- Software Requirements for SQL Server Installation
- Detailed Step-by Step Procedure of Installation
- Hands-on Practical Lab Session on How to Install SQL server
- New Features of SQL Server
- SQL Server Components
- SQL Server Management Tools
- What is SQL Server Management Studio (SSMS)?
- SQL Server Management Studio components
- When to Use SQL Server Management Studio ?
- How SQL Server Management Studio Looks like ?
- What is Azure Data Studio?
- How to Install Management Studio & Azure Data Studio ?
- Hands-on Practical Lab Session on How to Install Management Studio
- Hands-on Practical Lab Session on How to Install Azure Data Studio
- How to Create a Database?
- How to Create a Table?
- Hands-on Practical Lab Session on How to Create a Database & How to Create a Table
- How to Write SQL Queries to Insert Data into a Table?
- Hands-on Practical Lab Session on How to write SQL Queries to Insert Data into a table
- How to Write SQL Queries to Fetch Data from a Table?
- Hands-on Practical Lab Session on How to write SQL Queries to Fetch Data from a table
- When to Use Azure Data Studio?
- How Azure Data Studio Looks like ?
- Hands-on Practical Lab Session on How to Connect and Use Azure Data Studio
- Practical assignment activities for students to practice lab activities.