X
ODT

Administering Business Intelligence
On-Demand Training

Starting At: $395.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Unlimited Elite Pack
$995
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

Administration of SQL Server can often be as simple as query tuning a T-SQL statement or configuring a server properly. When a Business Intelligence developer gets a hold of other ‘cool’ features provided in Standard or Enterprise Edition of SQL Server, then the range of knowledge a DBA has needs to keep up with developers. The administrator does not need to know how to develop an integration service (SSIS) package or create a calculated measure in analysis services (SSAS), but it is good to understand what is needed to help debug and maintain the features used in their enterprise IT systems. Most shops do not use all these components, but most do use more than one.


Prerequisites:


Basic DBA skills that can be obtained by watching our DBA Fundamentals course.

System Requirements:


Your computer should meet the following minimum requirements: https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server

Curriculum For This Course

Image

Thomas LeBlanc

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, LA. Today, he designs Dimensional Models in the financial industry while using Integration (SSIS) and Analysis Services (SSAS) for development along with Reporting Services (SSRS) and Power BI for reporting.  Starting as a developer in COBOL while at LSU, he has been a developer, tester, project manager, and team lead, as well as a software trainer for writing documentation. His involvement in the SQL Server community includes speaking at SQLPASS.org Summits, SQLSaturday eventssince 2011, IT/Dev Connections and Live! 360. He is the past Chair of the PASS Data Architecture and Excel Business Intelligence Virtual Chapters and worked on the nomination committee for the PASS Board of Directors in 2016 and 2017.



Related Courses

Course Info
7 Comprehensive Modules
37 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
9h 35m
Download Syllabus
Enrollment Price:
$395/Year
Share this course with your friends