Categories

Summary

The British Academy for Training and Development provides a training course on relational database management systems and Structured Query Language (SQL) to anyone who wishes to develop their practical abilities to learn and apply all relational databases. 

Database management systems are a set of computer programs that control data organization, storage, management and recall from the database. Database management system manages many databases and many users can access these data and bases at the same time. Whereas regarding databases: When creating a database where data is stored in tables. Tables can be created by creating a new database, by inserting a table into the database, or by importing or linking to the table from another data source such as an EXEL file, a WORD text document, a text file or another database. Then a database is established which enables the entrance of data to start the identification of the table. Databases must be protected from persons unauthorized to access them.. 

Objectives and target group

Who should attend? 

  • IT professionals across a broad range of disciplines who need to perform essential server administration tasks. 
  • Managers and owners of large and medium enterprises. 
  • Managers of administrative departments in companies. 
  • Corporate Communications Technology Managers. 
  • people who are moving into a database role, or whose role has expanded to include database technologies. 

 

How attendees will benefit? 

After completion of the Training Programme, delegates will be learned to: 

  • Describe key database concepts in the context of SQL Server  
  • Describe database languages used in SQL Server  
  • Describe data modelling techniques 
  • Describe normalization and de-normalization techniques 
  • Describe relationship types and effects in database design 
  • Describe the effects of database design on performance 
  • Describe commonly used database objects 

Course Content

  • Introduction 
  • Installing SQL Serever  
  • Installing SSDT 
  • Setting Up Sample Database 
  • Overview of SQL Server Integration Services (SSIS) 
  • Working with Import Export Wizard 
  • Invoking Wizard From SSMS 
  • Invoking Wizard From SSDT 
  • Exporting Data From SQL Server To CSV File 
  • Working with Character Map Transformation 
  • Working with Copy Column Transformation 
  • Working with Derived Column Transformation 
  • Working with Percentage Sampling Transformation 
  • Working with Row Sampling Transformation 
  • Working with Sort Transformation 
  • Working with UnionAll Transformation 
  • Working with Multicast Transformation 
  • Working with Conditional Split Transformation 
  • Working with Aggregate Transformation 
  • Working with Bulk Insert Task 
  • Working with Sequence Container Task 
  • Working with Execute Process Task 
  • Working with Execute Package Task 
  • Passing Parameters between Packages 
  • Working with Configuration Types 
  • Creating Dynamic Packages 
  • Event Handling Techniques 
  • Working with Log Providers 
  • Working with WMI Tasks 
  • Using Message Queuing Techniques 
  • 1 lecture 
  • Working with Maintenance Planning Tasks 
  • Implementing Check Points 
  • Working with Various Sources and Destinations of SSIS 
  • Incremental Data Loading Techniques 
  • Working with CDC Components 
  • Deployment 

Course Date

2024-11-25

2025-02-24

2025-05-26

2025-08-25

Course Cost

Note / Price varies according to the selected city

Members NO. : 1
£4600 / Member

Members NO. : 2 - 3
£3680 / Member

Members NO. : + 3
£2852 / Member

Related Course

Featured

Excel Business Intelligence: Power Query Training Programme

2024-11-11

2025-02-10

2025-05-12

2025-08-11

£4600 £4600

$data['course']