Database Administrator

Course IDCourse NameInstructorRoom NumberTime
010DATABASE ADMINISTRATOR---

DATABASE ADMINISTRATOR

OBJECTIVE:

Most modern businesses today, including those in the fields of engineering, science, medicine and government use some form of shared data to serve the needs of their enterprise. Many database management system (DBMS) products have been developed to meet these needs on workstations or mid-range and mainframe computers. The need for professionals to interact with these systems in one way or another has grown rapidly. This program will teach you how to design, build, analyze and maintain your Data Warehouse. You may pursue a Microsoft Certified Database Administrator (MCDBA) certificate.

CAREERS:

Upon completing the program, you may work as a Database Entry, Database Administrator, Database Specialist, IT Specialist, MIS, Database Support.

COURSE LENGTH:

40 hours/week: 19 Weeks

20 hours/week: 38 Weeks

Units: 77 /  Clock Hours: 770 hours

Prerequisite: Basic PC fundamentals

COURSE NO. COURSE DESCRIPTION UNITS HOURS
B104 Electronic Spreadsheet (Excel) 10 100
B107 Access Database 10 100
C217 Configuring Windows Server Application Structure  10 100
DBA Database Administration 47 470

BUS104 – ELECTRONIC SPREADSHEET (EXCEL)

Goals:

Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.

BUS107 – ACCESS DATABASE

Goals:

Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office Documents; creating data-entry forms, using filters and queries, designing reports, using unconditional formatting; preventing data corruption and unauthorized access; and other core topics.

C217 – Configuring Windows Server Application Structure (70-643)

Goals:

This course focuses mastering the skills and experience measured by these objectives: deploying servers, configuring remote desktop services, configuring a web services infrastructure, configuring network application services

Learning objectives:

Upon finishing, you will learn

  1. Implementing and configuring a Windows deployment infrastructure
  2. Configuring server storage and clusters
  3. Installing and configuring remote desktop services
  4. Configuring and managing a remote desktop infrastructure
  5. Installing and configuring web applications
  6. Managing web server security
  7. Configuring FTP and SMTP services
  8. Configuring Windows media services
  9. Configuring Microsoft Sharepoint foundation

DBA – DATABASE ADMINISTRATION

Goals:

The course presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more.