SQL Server Integration Services - DeepNeuron

+91 9840762315 support@deepneuron.in

Not a member yet? Register Now

Login to your account

Lost your password?

Register to start learning

Teacher sasken rams
Categories
Students 3 (Registered)
Review

(0 Review)

Course Content

Total learning: 44 lessons Time: 10 weeks

Introduction 0/4
- Lecture1.1
  
  Integrate your data with SQL Server Integration Services (SSIS)
- Lecture1.2
  
  What you should know
- Lecture1.3
  
  Set up the example database
- Lecture1.4
  
  How to install Microsoft SQL Server on Windows 10
Get Started with Integration Services 0/4
- Lecture2.1
  
  What is SSIS?
- Lecture2.2
  
  Add SSIS to a SQL Server instance
- Lecture2.3
  
  Connect to the SSIS catalog database
- Lecture2.4
  
  Explore SSIS packages
SSIS Designer 0/6
- Lecture3.1
  
  Install SQL Server Data Tools (SSDT)
- Lecture3.2
  
  View SSIS solutions and projects
- Lecture3.3
  
  Define control flow tasks
- Lecture3.4
  
  Create a precedence constraint
- Lecture3.5
  
  Create a sequence container
- Lecture3.6
  
  Run a package
Control Flow Tasks 0/8
- Lecture4.1
  
  Understanding tasks in control flow
- Lecture4.2
  
  The Data Flow task
- Lecture4.3
  
  The File System tasks
- Lecture4.4
  
  Modify file attributes
- Lecture4.5
  
  The Execute Package task
- Lecture4.6
  
  The Send Mail task
- Lecture4.7
  
  SQL Server tasks
- Lecture4.8
  
  Maintenance tasks
Data Sources and Connections 0/5
- Lecture5.1
  
  Project level connections
- Lecture5.2
  
  Convert package connections
- Lecture5.3
  
  The Excel connection manager
- Lecture5.4
  
  Connect to flat file data sources
- Lecture5.5
  
  Additional connection managers
The Data Flow Task and Transformations 0/8
- Lecture6.1
  
  Data flow components
- Lecture6.2
  
  Extracting data from a source
- Lecture6.3
  
  Understand transformations
- Lecture6.4
  
  Character Map row transformation
- Lecture6.5
  
  Conditional Split transformation
- Lecture6.6
  
  Rowset transformations
- Lecture6.7
  
  Loading data to a destination
- Lecture6.8
  
  Prevent duplicate records
Controlling Package Execution 0/6
- Lecture7.1
  
  Work with variables and scope
- Lecture7.2
  
  Add execution parameters
- Lecture7.3
  
  Change a variable’s value
- Lecture7.4
  
  Group tasks in looping containers
- Lecture7.5
  
  Event handlers
- Lecture7.6
  
  Error handling in data flows
Deploy and Run SSIS Projects 0/3
- Lecture8.1
  
  Deploy projects to SQL Server
- Lecture8.2
  
  Run packages with T-SQL
- Lecture8.3
  
  Schedule packages with SQL Server Agent

Instructor

0.0

0 rating

5 stars

0%

4 stars

0%

3 stars

0%

2 stars

0%

1 star

0%

₹14,999

Leave a Reply Cancel reply