Administering in Microsoft SQL Server

Knowledge of computer and Windows operating system

The course is designed for administrators, developers and database developers.

The objectives of the training:

• acquire and strengthen the skills to create and manage databases
• knowledge of the syntax and use SQL to retrieve and modify data
• apply safety rules in the database
• the use of advanced elements (replication, automation, BI)
• the use of Microsoft SQL Server capabilities to create complex reports and solutions for developers

Basic information about databases

• Database files, Database Client / Server
• Relational database management systems (RDBMS)

SQL Server versions and the differences between them

• Express, Standard, Enterprise
• Workgroup, Mobile , Developer

SQL Server Tools

• SQL Server Management Studio
• SQL Server Agent

Services in SQL Server

• Database Services
• Analysis Services
• Reporting Services
• Integration Services

Base system

• Master
• Model
• Msdb
• Tempdb
• Distribution
• Resource      

Create a database

• The database files and their location
• File size and its growth
• Partitioning tables

Data Modification Language (DML)

• INSERT
• UPDATE
• DELETE

Data Definition Language (DDL)

Designing Tables

• Columns and Attributes
• Determine the type of data
• Indexes and Keys

Indexes

• Clustered Indexes
• Non-Clustered Indexes
• REBUILD vs. REORGANIZE 

Creating a database application

Server-side programming

• Procedures
• Views
• Functions
• Triggers

Models play

• Simple
• Full
• Bulk logged

Backup

• Full
• Differential
• Transaction Log

Backup Strategies

• Strategy full copy of the database
• Strategy of full backups and transaction log
• The strategy of incremental database backup
• Strategy copy of the database files

Basic security and administration of SQL Server

Automation

• Maintenance Plan
• Jobs

Basic security and administration of SQL Server

• Server Roles
• Database Roles
• SA Account
• Creating Accounts
• Schemes

High Availability

• Log Shipping
• Database Mirroring
• Server Clustering

Replication

• Snapshot Replication
• Transactional Replication
• Merge Replication

Activity Monitor SQL Server

• SQL Server Profiler

Upgrade

• In-Place vs. Side-By-Side
• Service-Pack
• Cluster

Best Practices