آموزش SQL Server 2016 - رایگان - فصل یک تا سه APK

آموزش SQL Server 2016 تعاملی و شبیه سازی شده با صدا و متن فارسی چند بخش اول رایگان

Dear user, the application is only the first of three parts and is free of charge
To see the rest of the http://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-sql-server.php.

This course is taught following:

Chapter One: How to install SQL Server 2016 (free)
Introduction
How to install SQL Server 2016
Remove SQL Server 2016

Chapter II: Introduction to SQL Server 2016 (free)
Familiarity with SQL Server Management Studio
Determine server
Register an instance of SQL Server


Chapter Three: Create database and tables in SQL Server 2016 (free)
The concept of the database, and record table in SQL Server 2016
How to create a database
Create a table in the database
Change fields table
Primary and foreign keys
The relationship between tables
Data integrity rules
Relationship graph database

Chapter Four: Create inquiry
How to create query
Select familiar with the command
Temporary table
Editor's Query Designer
Select another point on the agenda
Identifying and handling errors in T-SQL

Chapter Five: DML commands
Variable Definition
Insert command
Create Table command
Update command
Delete and Truncate command
Drop command
If the conditional structure
While the ring structure
Using snippets

Chapter VI: stored procedures,
The concept of a stored procedure
System stored procedures
Created by T-SQL stored procedure
Delete stored procedure by T-SQL
Determine the parameters for the stored procedure
SQL Injection Attacks
Created by the CLR stored procedure

Chapter VII: how to create a backup Job
Backup Method
Designated backup time
Introduction to SQL Server Agent
How to create a Job
Job execution time set
View the result of the Job
Find Job execution errors
Send errors to the user
Working with SQL Server Profiler


Chapter VIII: Security in SQL Server 2016 (Part I)
The concept of security in SQL Server
Set encryption policy in Windows
User defined in Windows
Defining user in SQL Server
Define the Windows user in SQL Server
User defined in SQL Server

Chapter Nine: Security in SQL Server 2016 (Part II)
T-SQL commands, user-defined
Change User Profile
View user database
Schema database
Connect to the SQL Server engine by a new user
Check Schema
Check user access

Chapter Ten: data integrity in SQL Server 2016
The definition of data integrity
Defined mostly using T-SQL
Find indicating Created on table
Create Trigger type DDL
Create Trigger Type DML

Chapter XI: Working with SQL Server 2016 vision
Of sight
Create visibility by Management Studio
Create visibility by T-SQL
Edit records in sight
Remove, Change and defined vision
The use of sight
Determine the availability of a user to see
Access a user review