SQL Server Integration Services - Course Syllabus



DescriptionThis course teaches how to build simple as well as complex data integration solutions using Microsoft SQL Server Integration Services. The course covers all aspects of development, deployment and administration of SSIS packages.The course is based on SQL Server 2012, but it is relevant also for SQL Server 2005/2008/R2.Target AudienceThe course is intended for SQL Server developers, administrators and analysts who need to migrate and transform data amongst diverse platforms. Students should be familiar with the following topics:Transact-SQLSQL Server AgentSQL Server SecurityObjectivesBe familiar with SSIS architecture and componentsLearn how to implement SSIS packagesLearn how to implement logging in an SSIS packageBe able to debug and implement error handling in an SSIS packageLearn how to implement checkpoints and transactions in an SSIS packageLearn how to configure and deploy an SSIS packageUnderstand how to manage and secure an SSIS packageSchedule8 days & 4 hour each32 academic hoursMaterialsDisk-on-key including all the course materials:PresentationsDemonstrationsClass exercises & solutionsQuestion Banks fro interview PreperationAdditional resourcesBITeS Assessment SetCourse book: Introduction (0.5 hour) – Demonstration CLASSAbout the InstructorAbout the StudentsCourse ObjectivesCourse ScheduleCourse MaterialsCourse OutlineIntroduction to SQL Server Integration Services (2 hours)SSIS Historical OverviewSSIS ArchitectureTools of the TradeCreating a Simple PackagePracticeSSIS Tools (3 hours)Import and Export WizardSQL Server Data ToolsSQL Server Management StudioCommand-Line UtilitiesPracticeSSIS Tasks (4.5 hours)Looping and Sequence TasksData Flow TaskData Preparation TasksWorkflow TasksAdministration TasksExecute Package TaskScript Task (.NET)PracticeWorking with Containers (2.5 hours)Sequence ContainersGroupsFor Loop ContainerForeach Loop ContainerPracticeThe Data Flow (4 hours)Understanding the Data FlowSources & DestinationsCommon TransformationsPracticeUsing Variables, Parameters and Expressions (3 hours)Dynamic Package ObjectsUnderstanding Data TypesUsing Variables and ParametersWorking with ExpressionsPracticeLoading a Data Warehouse (3.5 hours)Data ProfilingData Extraction and CleansingDimension Table LoadingFact Table LoadingSSAS ProcessingPracticeAccessing Heterogeneous Data (2.5 hours)The Connection ManagersExcel and AccessOracleUsing XML and Web ServicesFlat FilesOther Heterogeneous SourcesPracticeError and Event Handling (3 hours)Package TransactionsUsing Precedence ConstraintsEvent HandlingBreakpointsError RowsLoggingPracticeSSIS Administration (3 hours)Deployment ModelsPackage ConfigurationSecurityScheduling PackagesMonitoring Package ExecutionsPracticeSummary (0.5 hour)Course SummaryAdditional ResourcesFeedback ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download