Call Admissions Today: 1-888-482-6877

LaSalle Microsoft Database Administrator Exam Preparation


In this CE exam prep program, students learn how to derive physical database designs.
by alan
297 clock hours
0 Lessons

LaSalle Microsoft Database Administrator

Course Description

LaSalle Microsoft Database Administrator Exam Preparation

This CE exam prep program focuses on administration, development and business intelligence skills using Microsoft SQL Server. In this CE exam prep program students learn how to derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

Contact Hours: 192

Courses: 5

 

Course

Number

Course Title Clock

Hours

COM01 A+ Repair Comprehensive 72
COM04 Networking Fundamentals 45
MCS11 Intro to Databases 45
SQL07 Select One Elective: SQL Server Database Administration 72
SQL08 One Elective: SQL Server Database Development 72
SQL09 One Elective: SQL Server Database Business Intelligence 72
  TOTAL: 234

Areas Covered

A+ Repair Comprehensive - 72 Hours

In this CE exam prep course, the student will examine basic computer hardware infrastructure and operating systems, gaining knowledge on the installation, configuration, customization, upgrade, repair, troubleshooting, diagnosis, and maintenance of a variety of devices, as well as safety procedures and soft skills. They will also review specific topics related to portable devices, networking, virtualization, and cloud computing as part of their preparation for the CompTIA A+ Exam. In addition, the student will practice key entry-level service technician skills.

Networking Fundamentals - 45 Hours

In this CE exam prep course, students will analyze entry-level networking topics such as layers of the OSI model, and features and functions of network components. They will develop the skills required to install, configure, manage, and troubleshoot basic network hardware protocols and peripherals. In addition, students will use a variety of products from network providers, including Microsoft, Linux, Unix, Mac, and more.

Intro to Databases - 45 Hours

The purpose of this CE exam prep course is to address the implementation and desktop support needs of customers that are planning to deploy and support Microsoft Windows client operating systems in a variety of stand-alone and network operating system environments. It provides in-depth, hands-on training for Information Technology (IT) professionals responsible for the planning, implementation, management, and support of Windows Client OS.

SQL Server Database Administration - 72 Hours

In this CE exam prep course, students will learn the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

SQL Server Database Development – 72 Hours

In this CE exam prep course, students will learn the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to maintaining a database.

SQL Server Business Intelligence - 72 Hours

In this CE exam prep course, students will learn the core requirements to being able to successfully Business Intelligence strategies using SQL Server. Through hands-on labs, lecture and interactive activities students will learn to maximize their ability using SQL Server to Install SSAS, Configure SSAS, Configure query logging, Configure error logging, Configure disk allocation, Configure server and database roles and permissions, Deploy an SSAS solution, Deploy solutions by using the Deployment Wizard, Deploy solutions by using XML for Analysis (XMLA) scripts, Deploy solutions by using BIDS, Monitor SSAS, Implement processing for SSAS objects, Implement processing options, Implement disaster recovery tasks, Backup and restore the SSAS database files by using SSMS, Re-create database objects by using XMLA scripts and reprocess and more.

Course Details

  • 7—33 Weeks
  • $8,000 Tuition
Request Information

Clicking the “Submit” button constitutes your express written consent for Florida Technical College to contact you by call, text, email and mail using the provided contact information, including a wireless number and you understand that these efforts may be generated using automated technology. Your consent is not required to obtain further information.