| Courses Software Training | Locality Anand park |
SQL Server DBA Online Training Course
SQL SERVER ADMINISTRATION
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.
contact India +91-9052666559
Usa : +1-678-693-3475.
visit www.sqldbaonlinetraining.com
please mail us all queries to [email protected]