Microsoft Sql Server 2017 For Everyone

Learn the fundamentals of database design, development and querying using the latest Microsoft SQL Server

Last updated 2022-01-10 | 4.6

- Basic Database Design (Tables
- Columns
- Data Types
- Primary Keys
- Normalization)
- Using Microsoft SQL Management Studio
- SELECT Statements: Queries against single tables (Filtering
- Ordering
- Grouping)

What you'll learn

Basic Database Design (Tables

Columns

Data Types

Primary Keys

Normalization)

Using Microsoft SQL Management Studio

SELECT Statements: Queries against single tables (Filtering

Ordering

Grouping)

DELETE: How to remove data from a database

INSERT INTO: How to insert data into a table

UPDATE: How to update existing data

Filter groups of data using the HAVING clause

Overall Database Development Best Practices

Creating 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 craft SQL statements based on real scenarios

Create Complex Database Objects (Stored Procedures

Functions

Views

Triggers)

Backup and Restore Databases

Generate Database Scripts for Automation

* Requirements

* A Computer
* A desire to learn database development

Description

Basic Database Design (Tables, Columns, Data Types, Primary Keys, Normalization)
Using Microsoft SQL Management Studio
SELECT Statements: Queries against single tables (Filtering, Ordering, Grouping)
DELETE: How to remove data from a database
INSERT INTO: How to insert data into a table
UPDATE: How to update existing data
Filter groups of data using the HAVING clause
Overall Database Development Best Practices
Creating 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 craft SQL statements based on real scenarios
Create Complex Database Objects (Stored Procedures, Functions, Views, Triggers)
Backup and Restore Databases
Generate Database Scripts for Automation

Course content

6 sections • 33 lectures

Introduction 2 lectures

Introduction to SQL Server and Databases Preview 01:27

Download and Install SQL Server Express 2019 - Latest Preview 04:59

Download SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

Microsoft® SQL Server® 2019 Express

https://www.microsoft.com/en-us/download/details.aspx?id=55994

Microsoft® SQL Server® 2019 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.