4.01
551 reviews
Hands-On SQL Server,ManagementStudio,SQL Queries,AzureStudio
Detailed Course with Hands-On Practical Lab Sessions-SQL Server,Writing SQL Queries,Management Studio& Azure Data Studio
- Description
- Curriculum
- FAQ
- Reviews
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.
Hands-On Practical SQL Server Installation with Detailed SQL Server
SQL Server Management Tools & New Features & Components
-
7What is SQL Server ?Video lesson
-
8History of SQL ServerVideo lesson
-
9SQL Server VersionsVideo lesson
-
10SQL Server EditionsVideo lesson
-
11Wrap-Up 1Video lesson
-
12SQL Server InstallationVideo lesson
-
13Hardware Requirements for SQL Server InstallationVideo lesson
-
14Software Requirements for SQL Server InstallationVideo lesson
-
15Detailed Step-by Step Procedure of How to Install SQL ServerVideo lesson
-
16Hands-on Practical Lab Session on How to Install SQL serverVideo lesson
-
17Wrap-Up 2Video lesson
Hands-On Practical Database Creation, Management Studio & Azure Data Studio
Hands-On Practical Lab on SQL Programming & How to Write SQL Queries
-
22What is SQL Server Management Studio (SSMS)?Video lesson
-
23SQL Server Management Studio componentsVideo lesson
-
24When to Use SQL Server Management Studio ?Video lesson
-
25How SQL Server Management Studio Looks like ?Video lesson
-
26Wrap-Up 4Video lesson
-
27What is Azure Data Studio?Video lesson
-
28How to Install Management Studio & Azure Data Studio ?Video lesson
-
29Hands-on Practical Lab Session How to Install ManagementStudio & AzureDataStudioVideo lesson
-
30Wrap Up 5Video lesson
-
31How to Create a Database?Video lesson
-
32How to Create a Table?Video lesson
-
33Hands-on Practical Lab Sessions on How to Create Database & How to Create TableVideo lesson
Hands-On Practical Lab on How to Connect and Use Azure Data Studio
-
34How to Write SQL Queries to Insert Data into a Table?Video lesson
-
35Hands-on Practical Lab Session How to write SQLQueries to Insert Data into TableVideo lesson
-
36How to Write SQL Queries to Fetch Data from a Table?Video lesson
-
37Hands-on Practical Lab Session How to write SQL Queries to Fetch Data from TableVideo lesson
-
38Wrap Up 6Video lesson
Quiz - Test Your Understanding
PRACTICE ASSIGNMENT ACTIVITIES
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Share
Course details
Video
2 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV
Popular courses
External Links May Contain Affiliate Links read more