Call Admissions Today: 1-888-482-6877

Microsoft Database Administrator Exam Preparation


In this program, students learn how to derive physical database designs.
by admin
Free
297 clock hours
0 Lessons

LaSalle Microsoft Database Administrator

Course Description

LaSalle Microsoft Database Administrator Exam Preparation

This diploma program focuses on Microsoft Database technologies using Microsoft SQL Server. This program focuses on administration, development and business intelligence skills using Microsoft SQL Server. In this 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. In this program students are qualified to sit various Microsoft MCTS certifications.

Contact Hours: 192

Courses: 5

 

Course

Number

Course Title Clock

Hours

COM03 Networking Fundamentals 40
MCS01 Windows Desktop Operating System 32
MCS07 SQL Server Database Fundamentals 40
MCS08 SQL Server Database Development 40
MCS09 SQL Server Database Business Intelligence 40
  TOTAL: 192

Areas Covered

Networking Fundamentals – 40 Hours

This Networking Fundamentals course covers entry level networking topics such as layers of the OSI model, features and functions of network components and the skills needed to install, configure, and troubleshoot basic networking hardware peripherals and protocols. This hands-on course covers a variety of network vendor products including Microsoft, Linux, Unix, Mac, and more

Windows Desktop Operating System – 32 hours

The purpose of this 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 Fundamentals - 40 hours

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

SQL Server Database Development - 40 hours

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

- SQL Server Business Intelligence - 40 hours

In this course, students will learn the core requirements to being able to successfully Business Intelligence strategies using SQL Server 2008. 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.