Udemy – Complete Microsoft SQL Server Database Design Masterclass 2022-10

Published on: 2024-08-19 09:49:40

Categories: 28

Description

Complete Microsoft SQL Server Database Design Masterclass course. This course teaches you how to use this powerful and widely used database management system to store and retrieve data. This course is suitable for people of all experience levels, from beginner to advanced. In this course, you will learn key concepts such as database design, writing queries, and creating stored procedures. You will also have the opportunity to practice your skills through practical exercises and projects.

What you will learn in the Complete Microsoft SQL Server Database Design Masterclass course

Introductory database design: tables, columns, data types, primary keys and normalization
Using Microsoft SQL Management Studio
SELECT statements: queries on unit tables (filtering, sorting, grouping)
DELETE: How to delete data from the database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Filter data groups using the HAVING clause
General best practices for database development
Create relationships and foreign keys
How to query related data from multiple tables
Using aggregate functions in SQL
How to export query results to Excel
How to create SQL statements based on real scenarios
Creating complex database objects (stored procedures, functions, views, triggers)
Backup and restore databases
Create database scripts for automation
How to manage users and database security