آموزش کار با سرویس های اس کیو ال

Microsoft SQL Server Integration Services, or SSIS, is an enterprise-level ETL tool: a tool for extracting, transforming, and loading data. Whether you're looking for information in flat files, via FTP, or on the web, SSIS allows you to transform it all into a uniform format for databases. In this course, Ron Davis teaches this mission-critical skill for IT professionals, developers, and data analysts. Ron covers the architecture of SQL Server Integration Services, the platform's tools, basic task scripting, and the variables, parameters, and expressions you can use to customize your ETL packages. Plus, discover how to use containers to group and repeat tasks, how to merge datasets with joins, and how to debug packages, and learn about common design patterns that will increase your efficiency in SSIS. Topics include: Creating SSIS packages Coding and looping tasks Managing and administering SQL with SSIS tasks Optimizing data for extraction Making packages dynamic with variables and parameters Using sequences in a container Performing joins Handling errors Working with XML Introduction 21m 35s Welcome 1m 11s What you should know before watching this course 2m 2s Setting up the practice environment 1m 59s Using the exercise files 16m 23s 1. Architecture 42m 48s Version changes of SSIS from 2008-2014 7m 59s The SQL Server Integration Service 2m 36s Understanding packages 6m 50s Managing with control flow 6m 46s Moving data with data flow 4m 12s Understanding variables 7m 7s Understanding parameters 7m 18s 2. SQL Server Integration Services Tools 19m 3s Utilizing the Import and Export Wizards 6m 21s Working in the Explore window 3m 23s Creating SQL Server Integration Services packages 4m 54s Utilizing connection managers 2m 10s The Source and Destination Assistants 2m 15s 3. SQL Server Integration Services Tasks 44m 54s Coding the Script task 3m 10s Looping and Sequence tasks 5m 25s Data Preparation tasks 12m 49s Data loading with the Execute SQL task 5m 59s Using the Workflow tasks 7m 42s Managing SQL with the SQL tasks 1m 57s Administration of SQL using the SQL Management Objects tasks 7m 52s 4. Data Flow 38m 27s Using destinations and understanding choices 5m 7s Examining the Row transformations 7m 32s Examining the Rowset transformations 14m 35s Examining Split and Join transformations 11m 13s 5. Variables, Parameters, and Expressions 19m 32s SQL Server Integration Services data typing 9m 10s Defining and using variables and parameters 5m 29s Using expressions to make dynamic packages 4m 53s 6. Performing Joins 13m 34s Performing joins with the Lookup transformation 5m 8s Performing joins with the Merge transformation 8m 26s 7. Debugging SQL Server Integration Services Packages 25m 22s Designing to troubleshoot: Using precedence constraints 10m 39s Using events 3m 47s Working with logging 4m 36s Handling errors 6m 20s 8. Common Designs in SQL Server Integration Services 23m 8s Choosing the Script task or Script component 9m 35s Working with XML 7m 35s Deployment 2m 29s Best practices 3m 29s Conclusion 37s Where to go next 37s