SQL Server Database
By: Professor
Course Content
SQL Server Database
- Database Environment
- DBA Types
- DBA Responsibilities
- Versions & Features of SQL Server
- Installation Strategy
- Type of Installation
- System Requirements
- Pre-Installation Steps
- Instance Types
- SQL Server Services
- Installation Check List Documents
- Post Installation Steps
- System Databases
- User Databases
- Database Setup
- Database Architecture
- SQL Server Optimized Configuration
- SQL Power Shell Scripts
- Securing SQL Server Instances & Databases
- Types of Authentications
- Working with Permissions and Roles
- Application Roles
- Schemas
- Encryption & Decryptions
- Database Recovery Models
- Backup Strategies
- Recovery Planning
- Migrations of Databases & Servers
- Contained Database
- Maintaining Backup & Restore History
- Configuring Database mail
- Jobs
- Operators
- Alerts
- Monitoring of Automation Tasks
- Need of High Availability
- Log Shipping
- Database Mirroring
- Clustering
- Always On
- Introduction to Replication
- Configuring Replication (publisher, subscriber, distributor)
- Types of Replication (snapshot, transactional, peer-to-peer, Merge)
- Replication Topologies
- Monitoring Replication
- Windows and SQL Server Event Logs
- User Activity Tracking
- Performance base line
- CPU, RAM and I/O Utilization
- Performance Monitor
- SQL Server Profiler
- Database level Tuning
- Query / SP Tuning
- Resource Governor
- CDC (Change Data Capture)
- Data Collection
- DMVs and DMFs
- System Stored Procedures
- System Tables and Catalog Views
- Data Partitions
- Indexes fragmentation
- Statistics Updation
- Consistency & Data integrity Check [DBCC]
- Copying objects from One Server to another Server
- Script based Backup of Objects
- Upgradation Strategies
- Upgrade Advisor
- Installing BI Components
- Configuration of BI
- Security in Integration, Reporting & Analysis Services
- SQL Doctor, SQL Virtual database
- SQL admin toolset
- SQL Traffic Accelerator
- SQL Diagnostic Manager
Register
Josh Innovations is a leading software training institute providing Software Training, Project Guidance, IT Consulting and Technology Workshops.