Hands-On IT Training
Advance your career through professional development training in Microsoft SQL Server 2008 *** The Most Comprehensive SQL Server training in the market *** This hands-on course provides a solid foundation on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security, replicating data over multiple servers and creating ETL packages using SQL Server Integration Services. Key Benefits • Create Complex Databases and Star Schema data-marts in SQL Server 2008 • Extract and update data using T-SQL • Install, Configure and maintain SQL Server Database Instances • Explore the raw power of SSIS ETL • Learn how to perform data analysis and build data models • Learn how to create Advanced reporting and dash-board solutions WHO SHOULD ATTEND Any individual who would simply like to increase their understanding of SQL Server 2008 or IT Professionals who want to learn SQL Server 2008 for career or professional development objectives. PRE-REQUISITES Before taking this course, participants should have at least 2-3 years of general business experience (any role) and/or sound understanding of computers. PROGRAM DETAILS Day 1: Introduction to RDBMS & SQL Server 2008 • Understanding Relational Databases • SQL Server Basics • Introduction to T-SQL • Installing and Configuring a SQL Server Instance • Data manipulation and extraction using T-SQL Day 2: Advanced SQL Server Concepts • Introduction to Database Administration • Manage Security, User roles and data backup • Introduction to SSIS and ETL • Advanced T-SQL transactions Day 3: Introduction to Business Intelligence & Reporting • Understanding Business Intelligence • All about Data warehousing • Introduction to Data Modeling • Getting started with Data Analytics • Introduction to Reporting and Dashboards • Understanding SSRS Day 4: Advanced BI Concepts • Introduction to MS Excel • Understanding PivotTables • Building your first Dashboard • Advanced MS Excel reporting Day 5: Class Project • Build an end to end data mart and dashboard solution in SQL Server employing all the concepts learnt in class
Greg Bhatia Greg is a Business analyst consultant with over 8 years of professional industry experience. He has led successful projects and has been applying business analysis techniques in many large organizations (TD Canada Trust, Microsoft, First Data, Sprint) in Canada and the USA. Greg has extensive experience in CRM, Business Intelligence, Data warehousing and enterprise reporting. |
Take a Free Class today to find out more.
