To use other SQL Server training and training files under Windows
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-sql-server.php
See.
The following courses are taught in this course
Chapter One: How to install SQL Server 2016 (Free)
Introduction
How to install SQL Server 2016
Delete SQL Server 2016
Chapter Two: Understanding SQL Server 2016 (Free)
Familiar with SQL Server Management Studio
Identify the server
Submit an instance of SQL Server
Chapter Three: Create a Database and Table in SQL Server 2016 (Free)
The concept of a database, table and record in SQL Server 2016
Database creation method
Create table in database
Change table fields
Main and external keys
Determine the relationship between tables
Data integrity rules
The database relationship diagram
Chapter Four: Creating a Query
The method of creating a query
Familiar with the Select command
Temporary table
Query design editor
Other Tips in the Select command
Identify and manage the error in T-SQL
Chapter 5: DML Commands
Variable definition method
Insert command
Create Table command
Update command
The Delete and Truncate command
Drop command
Conditional structure if
Loop structure While
Use Ready Codes
Chapter Six: Stored Procedures
The concept of the stored procedure
System stored procedures
Create a stored procedure by T-SQL
Delete the stored procedure by T-SQL
Determine the parameter for the stored procedure
SQL Injection attack
Create a stored procedure by CLR
Chapter Seven: Backup and Job
Backup method
Determine backup time
Introduction to SQL Server Agent
Job creation method
Set Job Runtime
View the result of the Job run
See Job Errors
Send errors to users
Work with SQL Server Profiler
Chapter VIII: Security in SQL Server 2016 (Part I)
The concept of security in SQL Server
Determine the encryption policy in Windows
User Definition on Windows
Ability to define user in SQL Server
Windows User Definition in SQL Server
User Definition in SQL Server
Chapter 9: Security in SQL Server 2016 (Part 2)
T-SQL commands are user defined
Change user profile
View user database
Database schema
Connect to the SQL Server engine by a new user
Schema review
Check user access
Chapter 10: Data Comprehension in SQL Server 2016
Definition of data integrity
Define Constraint Using T-SQL
See the terms created in the table
Create a DDL Type Trigger
Create DML Type Trigger
Chapter 11: Working with Visibility in SQL Server 2016
Kinds of sights
Create a View by Management Studio
Create T-SQL View
Edit View Records
Deleting, modifying and defining views
Way of using vision
Determine the visibility of a user
Check a user's access
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-sql-server.php
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-sql-server-2016.php
