Course not currently available
Administering in Microsoft SQL Server Training Course
Course
Online
Description
-
Type
Course
-
Methodology
Online
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
About this course
Knowledge of computer and Windows operating system
Reviews
Subjects
- Server
- Database Management
- Database
- SQL
- Database training
- Syntax
- Shipping
- Systems
- Programming
- Play
Course programme
- Database files, Database Client / Server
- Relational database management systems (RDBMS)
- Express, Standard, Enterprise
- Workgroup, Mobile , Developer
- SQL Server Management Studio
- SQL Server Agent
- Database Services
- Analysis Services
- Reporting Services
- Integration Services
- Master
- Model
- Msdb
- Tempdb
- Distribution
- Resource
- The database files and their location
- File size and its growth
- Partitioning tables
- INSERT
- UPDATE
- DELETE
- Columns and Attributes
- Determine the type of data
- Indexes and Keys
- Clustered Indexes
- Non-Clustered Indexes
- REBUILD vs. REORGANIZE
- Procedures
- Views
- Functions
- Triggers
- Simple
- Full
- Bulk logged
- Full
- Differential
- Transaction Log
- 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
- Maintenance Plan
- Jobs
- Server Roles
- Database Roles
- SA Account
- Creating Accounts
- Schemes
- Log Shipping
- Database Mirroring
- Server Clustering
- Snapshot Replication
- Transactional Replication
- Merge Replication
- SQL Server Profiler
- In-Place vs. Side-By-Side
- Service-Pack
- Cluster
Additional information
Administering in Microsoft SQL Server Training Course