SQL Server DBA Online Training

SQL Server DBA Online Training By IT Professionals

Prime Online Training offers SQL Server DBA Online Training. Our SQL Server DBA trainers are Highly talented and have Excellent Teaching skills. They are well experienced trainers in their relative field. Our online training is one of the Best online training in India For any technology. All our students were happy With our online training and able to find Jobs quickly in USA, UK, Singapore, Japan, Europe. online training is your one stop & Best solution to learn SQL Server DBA at your home with flexible Timings.

Prime Online Training offers the SQL Server DBA Online Training Course in a true global setting.

SQL Server DBA Training Course Content Outline

1. SQL Server Architecture
2. SQL Server Version’s and Editions
3. SQL server Installation and Configuration
4. System databases
5. Pages and extents
6. Sql server services
7. Sql server protocols
8. ACID properties
9. Recovery models
10. Security-Login and User,Principals,Securables,Managing Permissions
11. Authentication Modes
12. Server roles
13. Database roles
14. Isolation Levels and Concurrency
15. Locking and Blocking-Types of locks and Types of reads
16. Service accounts for SQL server
17. GUI Templates-object explorer,solution explorer,template explorer,registered servers
18. Command line tools-BCP,SQLCMD
19. Creating and Configuring Database
20. Altering Databases and Their Options-Using ALTER command,Controlling Access,Controling DB state.
21. Linked servers
22. DAC-Dedicated Adminstrator Connection
23. CMS-Central Management Server
24. Data Compression and Backup Compression
25. Using ALTER Authorization Command
26. Schemas-Creating and working with schemas
27. Databasesnapshots
28. DBCC-And their parameters
29. Indexes-Types of Indexes,working and Maintaining indexes,resolving indexfragmentation,fill factor
30. Update statistics
31. SQL Server 2008 Top New Features
32. DMV’s-Types of Dynamic Management Views and working with them.
33. PBM-Policy Based Management
34. Resource governer
35. Performance data collector
36. SQL Server profiler
37. Maintainence Plans
38. Databasemail
39. Types of Sql Server Backups and their important options.
40. Types of Restores and its related options
41. Orphan Users-Fixing orphan users
42. Log shipping
43. Database Mirroring
44. Replication-Types Replication
45. Basics of Windows Clustering
46. Overview of real time Third party Monitoring tools-Ex:-Idera DM,Lite speed.
47. Overview of real time Ticketing tool-Ex:-Altiris,Remedey.

Our SQL Server DBA Online Training batches start every week and we accommodate your flexible timings.

Prime Trainings provides online training for various courses like  .Net, ASP.Net, VB.Net, Sharepoint,  C#, …

Comments are closed.