Overview
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
Requirements
Knowledge of computer and Windows operating system
Course Outline
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