|
|
|
SQL
Server
DBA Course Details |
|
Subcribe and Access : 3000+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: July
4th @ 10:00AM
Faculty: Mr. Suresh (15 yrs of EXP)
Duration: 45 Days
Fee:
3000/- INR + Reg fee 100/- INR
Location
: Maitrivanam, Hyderabad.
Venue
:
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202,
IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.
Ph.No : 09246212143
Syllabus:
- DBMS
- RDBMS
- Introduction to SQL SERVER
- Software And Hardware Requirements
- Client-Server Architecture
- SQLSERVER Installation
- Requirements
- 2008 Installation Steps
- Services & Checks after installation
- Features of SQLSERVER 2008 & 2012
- Server startup process
- Tools in SQL SERVER 2012
- Management Studio(SSMS)
- BI Tools(BIDS)
- Configuration Tools
- Performance Tools(Profiler)
- ARCHITECTURE
- SQLSERVER ARCHITECTURE
- PROTOCOLS
- STORAGE STRUCTURE
- DATABASE ARCHITECTURE
- Configuration Settings
- Memory Settings
- Processor
- Connections
- Database Settings
- Transactions in SQL SERVER
- Commit
- Rollback
- Buffer
- Checkpoint
- Databases
- System Databases
- User Databases
- Creating Database
- Altering Database
- Data Files
- Log Files
- File Groups
- Security
- Windows Authentications
- SQL Server Authentications
- Logins and Users
- Roles
- Schema
- Orphaned Users
- Recovery Models
- Full
- Bulk Logged
- Simple
- Non Logged Operations
- Backups and Plann
- Full
- Differential
- Transaction Log
- Files and File Groups
- Compressed backups
- Mirrored Backups
- Split Backup
- Jobs and Schedules
- Back up Device
- Append and Over write
- Permissions and Settings
- Enhancements
- Restore
- Complete restoration
- Point in Time restoration
- Restore Modes
- Recover Process
- Migrations
- Steps in Migration
- Migrating System databases
- Migration to other RDBMS
- SSIS , Package creation & Issues
- Database Upgrade
- Types
- Planning for Upgrade
- Upgrade Advisor
- Replication
- Publisher
- Publication
- Subscriber
- Subscription
- Distributor
- Agents
- Snap Shot Publication
- Transactional Publication
- Merge Publication
- Replication monitor
- Jobs
- Latency Issues
- Log Shipping
- Configuring Log shipping
- Monitoring logshipping
- Failover Process
- Issues
- Mirroring
- Principle Serve
- Mirror Server
- Witness Server
- Quorum
- High Availability
- High Protection
- High performance
- Synchronization
- Disaster Recovery
- Monitoring & Issues
- ALWAYS ON
- CLUSTERING
- Types
- Configuring Clustering
- Monitoring Clustering
- Issues
- SQL SERVER AGENT
- Jobs
- Schedules
- Alerts
- Operators
- Error Logs
- Database Mail Configuration
- Maintenance Plan
- Through SSMS
- Through SSIS
- PERFORMANCE TUNING
- Isolation levels
- ACID Properties
- Normalization
- Blocking
- Dead Locks
- Indexes
- DBCC and DMV
- Stored procedures
- Performance Monitor
- Profiler & Counters
- Tuning Adviser
- TROUBLE SHOOTING
- Tempdb Full Issues
- Log file Full Issues
- Suspect Mode Issues
- Page Corruption Issues
- Tail Log Backup
- Moving system databases
- Moving User databases
- Rebuild Matser Database
- Orphaned Users
- Connection Issues
- SQLSERVER Service Issues
- LONG Running Slow Queries
- Index Fragmentation Issues
- SP_RECOMPILE SP’S
- Tickets, SLA
- SSRS Configuration & Issues
- Sql Browser
- REGULAR, WEEKLY AND MONTHLY ACTIVITIES
- INTERVIEW STUFF
|
|
|
|
|
|