001 Welcome |
002 What you should know before watching this course |
003 Setting up the practice environment |
004 Using the exercise files |
005 Version changes of SSIS from 2008-2014 |
006 The SQL Server Integration Service |
007 Understanding packages |
008 Managing with control flow |
009 Moving data with data flow |
010 Understanding variables |
011 Understanding parameters |
012 Utilizing the Import and Export Wizards |
013 Working in the Explore window |
014 Creating SQL Server Integration Services packages |
015 Utilizing connection managers |
016 The Source and Destination Assistants |
017 Coding the Script task |
018 Looping and Sequence tasks |
019 Data Preparation tasks |
020 Data loading with the Execute SQL task |
021 Using the Workflow tasks |
022 Managing SQL with the SQL tasks |
023 Administration of SQL using the SQL Management Objects tasks |
024 Using destinations and understanding choices |
025 Examining the Row transformations |
026 Examining the Rowset transformations |
027 Examining Split and Join transformations |
028 SQL Server Integration Services data typing |
029 Defining and using variables and parameters |
030 Using expressions to make dynamic packages |
031 Performing joins with the Lookup transformation |
032 Performing joins with the Merge transformation |
033 Designing to troubleshoot - Using precedence constraints |
034 Using events |
035 Working with logging |
036 Handling errors |
037 Choosing the Script task or Script component |
038 Working with XML |
039 Deployment |
040 Best practices |
041 Where to go next |
Exercise Files |
آموزشی