SQL Server DBA 2012
Course contents:
- Understand SQL Server DB Design capacity planning
- Table Design with Schemas, Constraints, and Views
- Implement and Troubleshoot Disaster Recovery and Availability
- Resolve TempDB, Log Space, Memory and Network Issues
- Configure, Monitor and Manage SQL Clusters in AD over SAN (RAID 5)
- Know the roles and responsibilities of SQL Server DBA
- Understand the various SQL Server tools that are available
- Learn about Query Designing and Query Performance Tuning
- Learn the importance of Backups and Restorations
1) Differentiate Files and Databases
2) DBMS
3) RDBMS
4) Normalizations
5) SQL Server
- Versions and Editions
- Features of SQL Server
- Differentiate the SQL Server and Oracle
- Services of SQL Server
- Tools of SQL server
6) SQL Server components over view
7) Pages & extents
- Pages and Extents
- Type of Extents
8) Files and File groups
- Type of Files
- Type of File groups
9) Backup, Restore and Recovery models
- Full backup
- Deferential backup
- Transaction log backup
- Tail log backup
10) Maintenance and Troubleshooting of System Databases
- Moving system databases
- Rebuilding system databases
11) Troubleshooting, maintenance and Starting the SQL Server instances with following methods
- Single user mode
- Minimal Configuration Mode
- Command Prompt
- Net Command
12) Login the SQL Server using by DAC
13) Installation and Up gradation of SQL Server
14) Migrating SQL server Databases
- Backup and Restore
- Attach and Detach
- Import and Export
- Copy Database
- Migrating of Orphaned users
15) Security
- i) Authentication modes
- ii) Logins and Server roles
- iii) Database users and Database roles
- iv) User mapping
16) Automation and SQL server agent
- Creating jobs
- Creating Job Scheduling
- Creating Alerts and Operators
- Database mail Configuration
17) Monitoring SQL Server
- Job Activity Monitor
- Activity monitor
- Log File Viewer
- Performance Monitor
- Windows Event viewer
- Monitoring by SQL Server Alerts
- SQL Server Profiler
18) Mirroring
- Types of Mirroring
- High performance mode
- High availability
- High Protection
- Types of Data Transfer methods
- Failover of Mirroring
19) Log shipping
20) Replication
- Snapshot replications
- Transactional Replication
- Transactional With Updatable
- Merge Replications
- Types of Replication agents
21) Clustering
- Connection Setup of Clusters
- Nodes
- Quorum
- Automatic failover
- Moving to another Node
- Monitoring Clusters
22) Performance tuning
- i) Types of Isolation levels
- ii) Locks
- iii) Deadlocks
- iv) Blockings
23) Query Optimizer and Query Execution Plan
24) Indexing
- Types of Indexes
- Differences of Indexes
- Index Structure
- Rebuild and Reorganizing
- Fill Factor
25) T-Log structure
26) Overview of anyone Third-party monitoring tool
27) FAQ’s, PDF documents and Software’s
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.