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.