SQL Server DBA

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL.

COURSE CONTENT:
    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.