718-762-1900
info@compu21.com
3907 Prince St Ste 2C, Flushing NY 11354
718-762-1900
info@compu21.com
3907 Prince St Ste 2C,
Flushing NY 11354

Mircosoft SQL Server DBA

Course Description

Administration of your organization’s SQL Server databases is improved by effectively maximizing the scalability, availability and security features of SQL Server 2005/2008. This course offers extensive experience using SQL Server 2005/2008 tools to install SQL Server, create and modify storage structures, back up and recover databases, and manage security. Hands-on exercises provide you with practical experience administering SQL Server 2005/2008. The students may spend additional time in the lab beyond the 45 hours included in the course. Upon successful completion of this course, students should be prepared to sit for certification exam. This course cost included the Certification Exam Fee up to $300.

You will learn

  • Knowledge of database queries
  • Knowledge of database theory
  • Knowledge of database design
  • Knowledge about the RDBMS itself, e.g. Microsoft SQL Server or MySQL
  • Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL
  • General understanding of distributed computing architectures, e.g. Client–server model
  • General understanding of operating system, e.g. Windows or Linux
  • General understanding of storage technologies and networking
  • General understanding of routine maintenance, recovery, and handling failover of a database

Course Outline

Unit 1. Overview of SQL Server
Unit 2. Installing SQL Server
Unit 3. Preparing to Use SQL Server
Unit 4. Upgrading to SQL Server 2012
Unit 5. Understanding System and User Databases
Unit 6. Creating and Configuring User Databases
Unit 7. Populating a Database
Unit 8. Developing a Data Restoration Strategy
Unit 9. Backing Up and Restoring SQL Server
Unit 10. Managing Access to SQL Server
Unit 11. Managing SQL Server Permissions
Unit 12. Performing Administrative Tasks
Unit 13. Automating Administrative Tasks
Unit 14. Monitoring SQL Server Performance and Activity
Unit 15. SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS)
Unit 16. Maintaining High Availability

Schedule

7/27/2019 - 10/5/2019 (Every Saturday) 10AM - 1PM