SQL Server 2008
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 2008 R2 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.
-
Learn about SQL Server maintenance for the DBA. This course will help you understand server installation and configuration, database creation and configuration, backup and restore, trouble shooting, data transformation, performance analysis, log shipping, database mirroring and a range of replication options.
-
Learn developer skills for the database programmer . This course teaches advanced SQL programming, views, stored procedures, functions, triggers, common language runtime integration (CLR) and Service Broker implementation.
-
Learn how to design an ETL solution using SSIS to create a data warehouse , an OLAP analysis solution using SSAS and an enterprise reporting solution using RS. Understand how Reports and KPI’s can be implemented in conjunction with Microsoft Sharepoint services or standalone using the RS Web service.