SQL DBA Course

(1)

SQL Server DBA Online Training at ProLiveTech

Why is SQL

Server DBA course popular?

KEY FEATURES:



 SQL SQL Server Server DBA DBA training training material & material & preparation preparation guidanceguidance



 3 3 month month e-learning e-learning accessaccess



 Recorded Recorded videos videos and and training training material material for for future future referencereference



 Career Career guidance guidance and and job job placement placement assistanceassistance



 Flexi Flexi pay pay optionoption – – Pay full or in two installments Pay full or in two installments 

 Audio/Visual Audio/Visual PresentationsPresentations



 Online Online Doubt Doubt ClarificationClarification



 Certification Certification Oriented Oriented Material Material & & Preparation Preparation Guidance/Mock Guidance/Mock TestsTests



 24*7 24*7 Support Support to hto help yelp you ou with with technical technical queriesqueries



 Chapter-end Chapter-end QuizzesQuizzes



 Weekday Weekday and and weekend weekend batches batches based based on yon your our convenienceconvenience

TRY it, you’ll never regret your decision –

Call us at 203-463-9418

LEARN QTP ONLINE TRAINING AT

PROLIVETCH:

Data Base Administrator (DBA) is responsible for designing, installing, and maintaining the

database system. DBA products come from various companies like SQL

database system. DBA products come from various companies like SQL Server DBA from

Server DBA from

Microsoft, Oracle DBA from Oracle, Sybase DBA from Sybase. Among many of these SQL Server

DBA from Microsoft is one

DBA from Microsoft is one of the popular database administratio

of the popular database administration systems. Every

n systems. Every company

company

needs database administrators to install or upgrade a SQL server, patch up the SQL Servers,

needs database administrators to install or upgrade a SQL server, patch up the SQL Servers, to

to

monitor the health of the database server, to do performance tun

monitor the health of the database server, to do performance tun ing and optimization and to

ing and optimization and to

establish policies regarding the database management, security and maintenance. So there is

always a need for SQL

always a need for SQL Server database administra

Server database administrators. Our training program is designed both

tors. Our training program is designed both

for beginners and advanced users.

(2)

SQL Server DBA Course Content

SQL SERVER ADMINISTRATION

1. Introduction to Microsoft SQL Server



 What is a Database?What is a Database? 

 Why to use database?Why to use database? 

 What is RDBMS?What is RDBMS? 

 Types of RDBMSTypes of RDBMS 

 Advantages of SQL ServerAdvantages of SQL Server 

 Requirements and scope of SQL Requirements and scope of SQL ServerServer

2. Roles and Responsibilities of DBA



 What is Administration?What is Administration? 

 Roles of DBARoles of DBA 

 Licensing and Pricing of SQL Licensing and Pricing of SQL ServerServer

3. System Design and Architecture



 RAID RAID ConfigurationConfiguration 

 Capacity PlanningCapacity Planning 

 InstallationInstallation 

 Upgrades and Backward Upgrades and Backward CompatibilityCompatibility

4. SQL Server Database Design



 Logical and Physical architecture of databaseLogical and Physical architecture of database 

 Creating DatabaseCreating Database 

 Modifying structure of DatabaseModifying structure of Database 

 Files and File GroupsFiles and File Groups 

 Data Placement and Audit PlacementData Placement and Audit Placement

5. SQL Server Objects



 Data TypesData Types   TablesTables   ConstraintsConstraints   ViewsViews 

 Indexes and performance ConsiderationIndexes and performance Considerationss 

 TriggersTriggers 

 Stored ProceduresStored Procedures 

 User Defined FunctionsUser Defined Functions

Cursors & Synonyms Cursors & Synonyms

(3)

6. Transactions



 ACID PropertiesACID Properties 

 Commit Modes and RollbacksCommit Modes and Rollbacks 

 SavepointsSavepoints 

 Transaction Locks and Locking MechanismTransaction Locks and Locking Mechanism 

 Isolation LevelsIsolation Levels 

 Blocking and DeadlocksBlocking and Deadlocks

7. Database Snapshots



 What is a DB SnapshotWhat is a DB Snapshot 

 Why we use SnapshotsWhy we use Snapshots 

 How to design SnapshotsHow to design Snapshots 

 Advantages and disadvantagesAdvantages and disadvantages 

 Precautions when designing SnapshotsPrecautions when designing Snapshots

8. SQL Server Partitions



 Partitioning FundamentalsPartitioning Fundamentals 

 Designing PartitionsDesigning Partitions 

 Creating PartitionsCreating Partitions 

 Viewing Partition InformationViewing Partition Information 

 Maintaining PartitionsMaintaining Partitions

9. Backup Fundamentals



 System Failures and need of System Failures and need of BackupsBackups 

 Use of Transaction LogUse of Transaction Log 

 Microsoft SQL Server Automatic Microsoft SQL Server Automatic RecoveryRecovery 

 Recovery ModelsRecovery Models

i. Simple Recovery Model

ii. Full Recovery Model

iii. Bulk

_–

Logged Recovery Model



 Types of BackupsTypes of Backups

i. Data (Full) Backups

ii. Differential Backups

iii. Log Backups

(4)

iv. Copy-Only Backups

v. Full-Text Catalog Backups



 Media Devices and Media SetsMedia Devices and Media Sets 

 Overview of Backup History TablesOverview of Backup History Tables 

 Real world Backup StrategyReal world Backup Strategy

10. Restoring Data



 Restore and Recovery Restore and Recovery ConceptsConcepts 

 Restoring Data from BackupsRestoring Data from Backups

i. Complete, Differential and Log Restores

ii. Point-In-Time Restores

iii. File and File Group Restores

iv. Page Restores

v. Piecemeal and Online Restores

vi. Reverting to Database Snapshots

11. Replication



 Replication FundamentalsReplication Fundamentals 

 Use of ReplicationUse of Replication

i. Data Warehousing

ii. Distributing and Consolidating Data

iii. Offloading Report Processing



 Replication ComponentsReplication Components 

 Types of ReplicationTypes of Replication

i. Snapshot Replication

ii. Transactional Replication

iii. Merge Replication

(5)



 Configuring ReplicationConfiguring Replication 

 Configure DistributorConfigure Distributor