SQL Server 2019 is a powerful relational database. In the SQL Server 2019 training software, we review the following:
Chapter One: SQL Server 2019 Installation Method (Free)
Introduction
How to install SQL Server 2019
Remove SQL Server 2019
Chapter 2: Getting to Know and Working with SQL Server Management Studio 2019 (Free)
Familiarity with SQL Server Management Studio
Determining the server
Record a sample of SQL Server
Chapter 3: Creating a Database and Table in SQL Server 2019 (Free)
The concept of database, table and record in SQL Server 2019
How to create a database
Create a table in the database
Change table fields
Main and external keys
Determine the relationship between tables
Chapter 4: Data Comprehension Using SQL Server Management
What is data comprehensiveness?
Database relationship chart
Chapter Five: Create a Questionnaire
How to create a query
Familiarity with the Select command
Temporary table
Questionnaire design editor
Other tips in the Select command
Error detection and management in T-SQL
Chapter Six: DML Commands
Variable definition method
Insert command
Create Table command
Update command
Delete and Truncate command
Drop command
If conditional structure
The structure of the While loop
Use ready-made codes
Chapter Seven: Stored Procedures
The concept of stored routine
System stored procedures
Create a routine saved by T-SQL
Remove the procedure saved by T-SQL
Determine the parameter for the saved procedure
SQL Injection attack
Create routines saved by CLR
Chapter 8: How to Backup and Job
Backup method
Set backup time
Familiarity with SQL Server Agent
How to create a Job
Set Job Execution Time
View Job results
View Job execution errors
Send error to users
Work with SQL Server Profiler
Chapter 9: Security in SQL Server 2019 (Part 1)
The concept of security in SQL Server
Determine the encryption policy in Windows
Define the user in Windows
Ability to define user in SQL Server
Define Windows User in SQL Server
User Definition in SQL Server
Chapter 10: Security in SQL Server 2019 (Part 2)
T-SQL commands define the user
Change user profile
View database user
Database Schema
Connect to SQL Server engine by new user
Schema review
Check user access
Chapter Eleven: Comprehensive Data in SQL Server 2019
Defining data comprehensiveness
Definition of constraint using T-SQL
See the constraints created in the table
Create a Trigger DDL type
Create Trigger DML type
Chapter Twelve: Working with Vision in SQL Server 2019
Types of vision
Create a view by Management Studio
View by T-SQL
Edit viewing records
Eliminate, change and define vision
How to use vision
Determine a user's access to vision
Check a user's access
To download the version under Windows, refer to the following link
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-sql-server-2019.php
Chapter One: SQL Server 2019 Installation Method (Free)
Introduction
How to install SQL Server 2019
Remove SQL Server 2019
Chapter 2: Getting to Know and Working with SQL Server Management Studio 2019 (Free)
Familiarity with SQL Server Management Studio
Determining the server
Record a sample of SQL Server
Chapter 3: Creating a Database and Table in SQL Server 2019 (Free)
The concept of database, table and record in SQL Server 2019
How to create a database
Create a table in the database
Change table fields
Main and external keys
Determine the relationship between tables
Chapter 4: Data Comprehension Using SQL Server Management
What is data comprehensiveness?
Database relationship chart
Chapter Five: Create a Questionnaire
How to create a query
Familiarity with the Select command
Temporary table
Questionnaire design editor
Other tips in the Select command
Error detection and management in T-SQL
Chapter Six: DML Commands
Variable definition method
Insert command
Create Table command
Update command
Delete and Truncate command
Drop command
If conditional structure
The structure of the While loop
Use ready-made codes
Chapter Seven: Stored Procedures
The concept of stored routine
System stored procedures
Create a routine saved by T-SQL
Remove the procedure saved by T-SQL
Determine the parameter for the saved procedure
SQL Injection attack
Create routines saved by CLR
Chapter 8: How to Backup and Job
Backup method
Set backup time
Familiarity with SQL Server Agent
How to create a Job
Set Job Execution Time
View Job results
View Job execution errors
Send error to users
Work with SQL Server Profiler
Chapter 9: Security in SQL Server 2019 (Part 1)
The concept of security in SQL Server
Determine the encryption policy in Windows
Define the user in Windows
Ability to define user in SQL Server
Define Windows User in SQL Server
User Definition in SQL Server
Chapter 10: Security in SQL Server 2019 (Part 2)
T-SQL commands define the user
Change user profile
View database user
Database Schema
Connect to SQL Server engine by new user
Schema review
Check user access
Chapter Eleven: Comprehensive Data in SQL Server 2019
Defining data comprehensiveness
Definition of constraint using T-SQL
See the constraints created in the table
Create a Trigger DDL type
Create Trigger DML type
Chapter Twelve: Working with Vision in SQL Server 2019
Types of vision
Create a view by Management Studio
View by T-SQL
Edit viewing records
Eliminate, change and define vision
How to use vision
Determine a user's access to vision
Check a user's access
To download the version under Windows, refer to the following link
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-sql-server-2019.php
Show More
