Description

Overview

Microsoft SQL Server is a powerful and widely-used database management system used by organizations of all sizes to store and retrieve data. This course teaches you how to use Microsoft SQL Server to design, implement, and maintain a database. You will learn key concepts such as database design, query writing, and stored procedure creation. You will have the opportunity to practice your skills through hands-on exercises and projects.

This is a zero-to-hero course on Microsoft SQL Database development and querying techniques. This course provides you with fundamental SQL Server training and is enough to get you started as a Database Developer or Database Administrator. There are no prerequisites for this course.

Course content

• Introduction
• Environment Setup
• Understanding The Toolset
• Creating And Manipulating Databases
• Managing Tables and Data
• Normalization, Relationships and Foreign Keys
• Group By and Aggregate Functions
• Advanced SQL Server Objects and Concepts
• SQL Server Security
• BONUS Lecture