SQL Server Data Integration and Database Management Training Course
1Summary
Every organisation today runs on data that lives in more than one place — sales figures in one system, customer records in another, and operational logs scattered across files and spreadsheets. Moving that data reliably, keeping it accurate, and turning raw tables into something a business can act on is one of the most common technical challenges IT teams face, and Microsoft SQL Server sits at the centre of how most enterprises solve it.
This course, offered by the Arab British Fellowship Training Academy, gives participants hands-on grounding in relational database concepts alongside practical, tool-based experience in SQL Server Integration Services (SSIS) — the platform used to import, transform, move and load data between systems. Rather than only explaining theory, the programme walks trainees through the actual screens, wizards and components they will use on the job to build and manage real data workflows.
2Objectives and target group
Who should attend?
- IT staff and system administrators handling day-to-day server and database tasks
- Owners and managers of small, medium and large organisations who rely on data-driven decisions
- Heads of administrative and communications-technology departments within companies
- Professionals moving into a database-focused role, or picking up database responsibilities for the first time
How will attendees benefit?
By the end of the training course, participants will be able to:
- Explain the core concepts and terminology used in SQL Server, including the database languages it relies on
- Apply data modelling principles, including normalisation and de-normalisation, when designing tables
- Recognise how relationship types and design choices affect a database's performance
- Identify and work with the database objects most commonly used in day-to-day administration
3Course Content
Module 1: Getting Started — Installing SQL Server and Setting Up Your Workspace
- Introduction to the training programme and its practical approach
- Installing SQL Server
- Installing SQL Server Data Tools (SSDT)
- Setting up a sample database to work with throughout the course
Module 2: Moving Data In and Out of SQL Server
- Overview of SQL Server Integration Services (SSIS) and where it fits in a data workflow
- Working with the Import and Export Wizard
- Invoking the wizard from SQL Server Management Studio (SSMS)
- Invoking the wizard from SSDT
- Exporting data from SQL Server to a CSV file
Module 3: Transforming Data Inside an SSIS Package
- Working with Character Map Transformation
- Working with Copy Column Transformation
- Working with Derived Column Transformation
- Working with Percentage Sampling and Row Sampling Transformations
- Working with Sort Transformation
- Working with Union All Transformation
- Working with Multicast Transformation
- Working with Conditional Split Transformation
- Working with Aggregate Transformation
Module 4: Control Flow Tasks and Package Configuration
- Working with Bulk Insert Task
- Working with Sequence Container Task
- Working with Execute Process Task and Execute Package Task
- Passing parameters between packages
- Working with configuration types and building dynamic packages
Module 5: Event Handling, Logging and Maintenance
- Event handling techniques in SSIS
- Working with log providers
- Working with WMI tasks
- Using message queuing techniques
- Working with maintenance planning tasks and implementing checkpoints
Module 6: Advanced Loading Strategies and Deployment
- Working with various sources and destinations in SSIS
- Incremental data loading techniques
- Working with Change Data Capture (CDC) components
- Deploying SSIS packages