This course is aimed at database professionals who fulfill a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.
The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking.
This course provides an in-depth review of SQL Server 2014 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2014, and how to implement high availability using those technologies.
This three-day MTA Training course helps you prepare for Microsoft Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.
The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images and gauges.
This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
Students will reveal the underlying architecture of the Oracle database environment. This course is also intended to be of help to information technology (IT) managers and executives who require an understanding of the technology.