SQL Server DBA
0 STUDENTS ENROLLED
SQL Server DBA Course Content :
1.Introduction to Microsoft SQL Server
- What is a Database?
- Why to use database?
- What is RDBMS?
- Types of RDBMS
- Advantages of SQL Server
- Requirements and scope of SQL Server
2.Roles and Responsibilities of DBA
- What is Administration?
- Roles of DBA
- Licensing and Pricing of SQL Server
3.System Design and Architecture
- RAID Configuration
- Capacity Planning
- Installation
- Upgrades and Backward Compatibility
4.SQL Server Database Design
- Logical and Physical architecture of database
- Creating Database
- Modifying structure of Database
- Files and File Groups
- Data Placement and Audit Placement
5.SQL Server Objects
- Data Types
- Tables
- Constraints
- Views
- Indexes and performance Considerations
- Triggers
- Stored Procedures
- User Defined Functions
- Cursors
- Synonyms
6.Transactions
- ACID Properties
- Commit Modes and Rollbacks
- Savepoints
- Transaction Locks and Locking Mechanism
- Isolation Levels
- Blocking and Deadlocks
7.Database Snapshots
- What is a DB Snapshot
- Why we use Snapshots
- How to design Snapshots
- Advantages and disadvantages
- Precautions when designing Snapshots
8.SQL Server Partitions
- Partitioning Fundamentals
- Designing Partitions
- Creating Partitions
- Viewing Partition Information
- Maintaining Partitions
9.Backup Fundamentals
- System Failures and need of Backups
- Use of Transaction Log
- Microsoft SQL Server Automatic Recovery
- Recovery Models
- Simple Recovery Model
- Full Recovery Model
- Bulk Logged Recovery Model
- Types of Backups
- Data (Full) Backups
- Differential Backups
- Log Backups
- Copy-Only Backups
- Full-Text Catalog Backups
- Media Devices and Media Sets
- Overview of Backup History Tables
- Real world Backup Strategy
10.Restoring Data
- Restore and Recovery Concepts
- Restoring Data from Backups
- Complete, Differential and Log Restores
- Point-In-Time Restores
- File and File Group Restores
- Page Restores
- Piecemeal and Online Restores
- Reverting to Database Snapshots
11.Replication
- Replication Fundamental
- Use of Replication
- Data Warehousing
- Distributing and Consolidating Data
- Offloading Report Processing
- Replication Components
- Types of Replication
- Snapshot Replication
- Transactional Replication
- Merge Replication
- Configuring Replication
- Configure Distributor
Course Reviews
No Reviews found for this course.
Write a Review