Microsoft SQL Server 2019 Essentials - Hurbad

38 Cashir

5 Saacadood

iTus iyo iiSheeg

Course Certificate

Course Content

Expand All

INSTALL MICROSOFT SQL SERVER 2019 7 Cashir

Expand

Cutub Content

0% Complete 0/7 Steps

SQL Server 2019 editions

Install SQL Server Developer Edition

Install Management Studio

Enable features with Configuration Manager

Log Into SQL Server Using Management Studio

Authentication and user permissions

Create a new user account

CREATE DATABASE 8 Cashir

Expand

Cutub Content

0% Complete 0/8 Steps

Create database using Command Line

Create Database using GUI

Create a Simple Table

Edit a table’s structure

Enter data into a table using the GUI

Import data from CSV files

Create tables from flat files

Install a sample database

DATABASE TABLE DESIGN 7 Cashir

Expand

Cutub Content

0% Complete 0/7 Steps

Table column properties

Primary key fields

Establish a default value

Check constraints

Unique constraints

Create a foreign key column

Create relationships between tables

STRUCTURED QUERY LANGUAGE (SQL) 10 Cashir

Expand

Cutub Content

0% Complete 0/10 Steps

Use the T-SQL editor

Create a table with T-SQL

Add data to a table

Retrieve, Filter records with SELECT and WHERE

Delete records from a table

Update records in a table

Remove a table from the database

Create a view of the data

Use built-in functions

BACKUP, RESTORED, AND SECURITY 6 Cashir

Expand

Cutub Content

0% Complete 0/6 Steps

Create a full backup of the database

Create a differential backup

Restore a backup

Automate backups

User roles and permissions

Always On data encryption