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 VersionsSQL Server EditionsSQL Server Installation Hardware Requirements for SQL Server InstallationSoftware Requirements for SQL Server InstallationDetailed Step-by Step Procedure of InstallationHands-on Practical Lab Session on How to Install SQL server New Features of SQL Server SQL Server ComponentsSQL Server Management ToolsWhat is SQL Server Management Studio (SSMS)?SQL Server Management Studio componentsWhen 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 StudioHow to Create a Database?How to Create a Table?Hands-on Practical Lab Session on How to Create a Database & How to Create a TableHow 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 tableHow 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 tableWhen to Use Azure Data Studio?How Azure Data Studio Looks like ?Hands-on Practical Lab Session on How to Connect and Use Azure Data StudioPractical assignment activities for students to practice lab activities.
