200,000 تومان

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

نظر خود را در مورد این محصول با دیگران به اشتراک بگذارید