Josh Innovations

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

Copyright © Josh Innovations 2021.All right reserved.Created by Starsite