Call Admissions Today: 1-888-482-6877

LaSalle Microsoft Database Administrator Exam Preparation

In this program, students learn how to derive physical database designs.
by admin
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 Title Clock


COM03Networking Fundamentals40
MCS01Windows Desktop Operating System32
MCS07SQL Server Database Fundamentals40
MCS08SQL Server Database Development40
MCS09SQL Server Database Business Intelligence40

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

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.