Language: English
Created by: Lalitha Audikesavan
Rate: 3.8 / 278 ratings
Enroll: 38,745 students
What you’ll learn
- Detailed Step-by Step Procedure of SQL Server Installation
- Hands-on Practical Lab Session on How to Install SQL server
- Hands-on Practical Lab Session on How to Create a Database & How to Create a Table
- Hands-on Practical Lab Session on How to write SQL Queries to Insert Data into a table
- Hands-on Practical Lab Session on How to write SQL Queries to Fetch Data from a table
- Practical Assignment Activities are included for students to practice lab activities
- Hands-on Practical Lab Session on How to Install Azure Data Studio
- Hands-on Practical Lab Session on How to Connect and Use Azure Data Studio
- Hands-on Practical Lab Session on How to Install SQL Server Management Studio
- Hands-on Practical Lab Session on How to Connect and Use SQL Server Management Studio
- New Features of SQL Server
Requirements
- PC or laptop with internet connection
- Willingness to Learn Installation of SQL Server and learn how to write SQL Queries
- Eagerness to learn how to connect and use SQL Server Management Studio & Azure Data Studio
- Prior knowledge of SQL Server is not needed because this is detailed course with Hands-on practical sessions for beginner & intermediate levels
Description
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.
Who this course is for:
- Beginners who are willing to learn SQL Server with Hands-on Practical Demo Sessions
- Interested in learning how to Install SQL Server
- Those wanted to learn how to use SQL Server Management Studio and Azure Data Studio
- Those who want to learn how to store data in database and retrieve data from SQL Server
- Those who wanted to start career in SQL Server as there is high demand for SQL SERVER DBAs(Database Administrators) & Developers.
