SQL Server 2012
Microsoft SQL Server is a client server database management system (DBMS) designed to offer a scalable solution from the hand held device through to the largest corporate or governmental enterprise level data platform. The current version is SQL Server 2012 which in its 64bit implementation offers the ability to run the largest mission critical transaction processing (OLTP), data warehousing (DW) and business intelligence (BI) applications using features such as Reporting Services (SSRS), Analysis Services (SSAS) / (OLAP) and Integration Services (SSIS) / (ETL).
- Learn the SQL Server TSQL language . This training course will introduce DDL, DCL and DML, variables, conditional and loop structures, exception handling, XML handling and parsing.
Design and Build a SQL 2012 Database This training course covers table design, indexing and query plans, planning for High Concurrency, working with XML.
- Learn how to create Analysis and Reporting Solutions . This course covers Business Intelligence, Reporting Services, Data Mining, Power Pivot and Data Cubes
- Learn how to Implement a Data WarehouseThis course covers design and implementation of a Data Warehouse, SSIS packages, ETL Process, SQL Azure