This course 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..
Course Objectives
By the end of the course, participants will be able to:
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 Outline
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 CharacterMap Transformation
Working with CopyColumn Transformation
Working with DerivedColumn Transformation
Working with PercentageSampling Transformation
Working with RowSampling Transformation
Working with Sort Transformation
Working with UnionAll Transformation
Working with Multicast Transformation
Working with ConditionalSplit Transformation
Working with Aggregate Transformation
Working with BulkInsert Task
Working with SequenceContainer Task
Working with ExecuteProcess Task
Working with ExecutePackage 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 CheckPoints
Working with Various Sources and Destinations of SSIS