INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

May 11, 2017 at 10:33 am

will start on 14/5/2017
from 10:00 am to 4:00 pm
Days: Sunday / Monday / Thursday / Sunday


About this course
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience profile
This course is intended for database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:
Implementing a data warehouse.
Developing SSIS packages for data extraction, transformation, and loading.
Enforcing data integrity by using Master Data Services.
Cleansing data by using Data Quality Services.
At course completion
After completing this course, students will be able to:
Describe data warehouse concepts and architecture considerations.
Select an appropriate hardware platform for a data warehouse.
Design and implement a data warehouse.
Implement Data Flow in an SSIS Package.
Implement Control Flow in an SSIS Package.
Debug and Troubleshoot SSIS packages.
Implement an ETL solution that supports incremental data extraction.
Implement an ETL solution that supports incremental data loading.
Implement data cleansing by using Microsoft Data Quality Services.
Implement Master Data Services to enforce data integrity.
Extend SSIS with custom scripts and components.
Deploy and Configure SSIS packages.
Describe how BI solutions can consume data from the data warehouse.

Course Outline


Module 1: Introduction to Data Warehousing
This module provides an introduction to the key components of a data warehousing solution and the high-level considerations you must take into account when you embark on a data warehousing project.
Lessons
Overview of Data Warehousing
Considerations for a Data Warehouse Solution
Lab : Exploring a Data Warehousing Solution
After completing this module, you will be able to:

Describe the key elements of a data warehousing solution
Describe the key considerations for a data warehousing project
Module 2: Data Warehouse Hardware Considerations
This module discusses considerations for selecting hardware and distributing SQL Server facilities across servers.
Lessons
Considerations for building a Data Warehouse
Data Warehouse Reference Architectures and Appliances
Lab : Planning Data Warehouse Infrastructure
After completing this module, you will be able to:
Describe key considerations for BI infrastructure.
Plan data warehouse infrastructure.
Module 3: Designing and Implementing a Data Warehouse
This module describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation.
Lessons
Logical Design for a Data Warehouse
Physical design for a data warehouse
Lab : Implementing a Data Warehouse Schema
After completing this module, you will be able to:
Describe a process for designing a dimensional model for a data warehouse
Design dimension tables for a data warehouse
Design fact tables for a data warehouse
Design and implement effective physical data structures for a data warehouse





Module 4: Creating an ETL Solution with SSIS
This module discusses considerations for implementing an ETL process, and then focuses on Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions.
Lessons
Introduction to ETL with SSIS
Exploring Data Sources
Implementing Data Flow
Lab : Implementing Data Flow in an SSIS Package
After completing this module, you will be able to:
Describe the key features of SSIS.
Explore source data for an ETL solution.
Implement a data flow by using SSIS
Module 5: Implementing Control Flow in an SSIS Package
This module describes how to implement ETL solutions that combine multiple tasks and workflow logic.
Lessons
Introduction to Control Flow
Creating Dynamic Packages
Using Containers
Managing Consistency
Lab : Implementing Control Flow in an SSIS Package
Lab : Using Transactions and Checkpoints
After completing this module, you will be able to:
Implement control flow with tasks and precedence constraints
Create dynamic packages that include variables and parameters
Use containers in a package control flow
Enforce consistency with transactions and checkpoints
Module 6: Debugging and Troubleshooting SSIS Packages
This module describes how you can debug packages to find the cause of errors that occur during execution. It then discusses the logging functionality built into SSIS that you can use to log events for troubleshooting purposes. Finally, the module describes common approaches for handling errors in control flow and data flow.
Lessons
Debugging an SSIS Package
Logging SSIS Package Events
Handling Errors in an SSIS Package
Lab : Debugging and Troubleshooting an SSIS Package
After completing this module, you will be able to:
Debug an SSIS package
Implement logging for an SSIS package
Handle errors in an SSIS package
Module 7: Implementing an Incremental ETL Process
This module describes the techniques you can use to implement an incremental data warehouse refresh process.
Lessons
Introduction to Incremental ETL
Extracting Modified Data
Loading Modified data
Lab : Extracting Modified Data
Lab : Loading Incremental Changes
After completing this module, you will be able to:
Plan data extraction
Extract modified data
Module 8: Enforcing Data Quality
This module introduces Microsoft SQL Server Data Quality Services (DQS), and describes how you can use it to cleanse and deduplicate data.
Lessons
Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match data
Lab : Cleansing Data
Lab : De-duplicating data
After completing this module, you will be able to:
Describe how Data Quality Services can help you manage data quality
Use Data Quality Services to cleanse your data
Use Data Quality Services to match data
Module 9: Using Master Data Services
Master Data Services provides a way for organizations to standardize data and improve the quality, consistency, and reliability of the data that guides key business decisions. This module introduces Master Data Services and explains the benefits of using it.
Lessons
Master Data Services Concepts
Implementing a Master Data Services Model
Managing Master Data
Creating a Master Data Hub
Lab : Implementing Master Data Services
After completing this module, you will be able to:
Describe key Master Data Services concepts
Implement a Master Data Services model
Use Master Data Services tools to manage master data
Use Master Data Services tools to create a master data hub
Module 10: Extending SQL Server Integration Services
This module describes the techniques you can use to extend SSIS. The module is not designed to be a comprehensive guide to developing custom SSIS solutions, but to provide an awareness of the fundamental steps required to use custom components and scripts in an ETL process that is based on SSIS.
Lessons
Using Scripts in SSIS
Using Custom Components in SSIS
Lab : Using Custom Components and Scripts
After completing this module, you will be able to:
Include custom scripts in an SSIS package
Describe how custom components can be used to extend SSIS
Module 11: Deploying and Configuring SSIS Packages
In this module, students will learn how to deploy packages and their dependencies to a server, and how to manage and monitor the execution of deployed packages.
Lessons
Overview of SSIS Deployment
Deploying SSIS Projects
Planning SSIS Package Execution
Lab : Deploying and Configuring SSIS Packages
After completing this module, you will be able to:
Describe considerations for SSIS deployment.
Deploy SSIS projects.
Plan SSIS package execution.
Module 12: Consuming Data in a Data Warehouse
This module introduces business intelligence (BI) solutions and describes how you can use a data warehouse as the basis for enterprise and self-service BI.
Lessons
Introduction to Business Intelligence
Introduction to Reporting
An Introduction to Data Analysis
Lab : Using Business Intelligence Tools
After completing this module, you will be able to:
Describe BI and common BI scenarios
Describe how a data warehouse can be used in enterprise BI scenarios
Describe how a data warehouse can be used in self-service BI scenarios

For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

March 26, 2017 at 12:22 pm

Graphics Advertising Diploma
Will Start On 1.April.2017
sat & Mon & wed
The aim of the course is to show you how to make the most of the software tools available to you, and so make the production of finished artwork easier and faster.
Topic

Adobe Photoshop

Adobe Illustrator

Adobe InDesign
Audience

Explore featured stories, and learn more about your design tools. Learn printing best practices. Make sure your creative control doesn’t end when your files leave your computer. Optimize your designs so they work with the abilities of the printing process, rather than against them
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

March 19, 2017 at 9:55 am

Java EE & ADF Professional Track
Will Start On 3.April.2017
Mon & Fri
Time From 2:00 PM To 6:00 PM
Enterprise Java & ADF developers are in high demand in the IT marketplace today. IT professionals can differentiate themselves from their peers or competition and gain valuable job security by earning a Java EE certification.



Expand your knowledge of ADF and related technologies today with comprehensive, expert-led training from INFORM.

Simplify application development in your organization to increase productivity. Become more efficient at building Java EE applications using Oracle ADF (innovative yet mature Java EE development framework) and deploy an end-to-end web application.

Note that the following is the main topic for EE & ADF course.

Content

Web , Web Tiers & MVC Design Pattern Introduction .

HTML Tags.

Servlet & Servler Life Cycle .

JSP & custom tags .

Create custom MVC using Servlet & MVC full example (include Data Base).

JSF , JSF life cycle Introduction .

JSF Tags & Manged bean.

Create MVC example using JSF & manged Bean.

EJB Introduction .

Create Model project (EJB & JPA) , Entity Bean and Session Bean .

Create View Controller Project (JSF& ADF FACES ).

Create Data Control and communicate between Model & View controller project.

ADF Introduction .

Create ADF bussiness (Entity Object, View Object , Association & View) Link).

Create Application Model and Data Control and Communicate it to VC project (JSF & ADF FACES)

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

March 19, 2017 at 9:44 am

CCNA Routing And Switching Course :
Will start next month,
Days : Saturday & Friday
--------------------------------------
Cisco is the best option if you really want to have a successful career in the information technology industry.
Getting CCNA certification training is very ideal if you want to start a great career in this competitive industry.
------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cair

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

March 19, 2017 at 9:38 am

Office Fundamentals Diploma
Will Start On 23.March.2017
Sun & Tus & Thu
Time: From 10:00 AM To 3:00 PM
-ماهي متطلبات الدورة؟

لا توجد متطلبات مسبقة لهذه الدورة

على ماذا يمكنني الحصول من هذه الدورة؟

التعرف على فوائد استخدام برنامج Microsoft Office Word
التعرف على ميزات Backstage
زيادة الانتاجية باستخدام ميزة Quick Access Toolbar
احتراف المهارات الاساسية لبناء وتعديل الملفات النصية
جعل نصوص الملفات اسهل قراءةً واجمل شكلاً
افضل طرق حفظ وتحويل الوثائق من صيغة الى اخرى
المهارات الأساسية والمتقدمة لتعديل الوثائق وجميع ادواتها
كيفية تحويل المعلومات المكتوبة الى اشكال تمثلها بشكل افضل مثل SmartArt
افضل طريقة لمشاركة وتصدير الوثائق

-من يستفيد من هذه الدورة؟
موظفين يرغبون بزيادة انتاجيتهم
طلاب المعاهد والجامعات
------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

October 24, 2016 at 1:17 pm

CCNA Course
Will Start On Next Sat 29-October 2016
Sun-Tue&thu
Time: From 6:00 PM to 09:30 PM
-------------------
تعتبر شهادات سيسكو هي الأساس في احتراف عالم الشبكات حيث تقوم دورة السيسكو بإعطائك كل شيء عن عالم الشبكات ابتداً من الأساسيات حتى أدق التفاصيل حيث يتسنى لك بعد ذلك فهم كل شيء في الشبكات. وتنقسم شهادة السيسكو إلى ثلاث أقسام:
CCNA و CCNP و CCIE.

ماهي سيسكو Cisco ؟
سيسكو شركة أمريكية عملاقة متخصصة بعلم الشبكات بشكل عام.. الشركة توفر أجهزة الراوترات(الموجهات) والمقسمات الخاصة بالشبكات وأبدعت في هذا المجال. وتطورت الشركة لتنشئ برامج تدريبية لديها لكل طلاب الشبكات حول العالم وانشئت مايسمى بـ سيكسو نيتورك أكاديمي.. وهي الأكاديمية الأولى في العالم التي تقدم شهادات متخصصة بالشبكات، وأصبحت هذه الشهادات معتمدة حول العالم لذلك سميت بالشهادات العالمية.

------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

October 24, 2016 at 10:19 am

Office Fundamentals Diploma
Will Start On Next Tue 25-October 2016
Sun&Tue
Time: From 6:00 PM to 8:30 PM
------------------------
-ماهي متطلبات الدورة؟

لا توجد متطلبات مسبقة لهذه الدورة

على ماذا يمكنني الحصول من هذه الدورة؟

التعرف على فوائد استخدام برنامج Microsoft Office Word
التعرف على ميزات Backstage
زيادة الانتاجية باستخدام ميزة Quick Access Toolbar
احتراف المهارات الاساسية لبناء وتعديل الملفات النصية
جعل نصوص الملفات اسهل قراءةً واجمل شكلاً
افضل طرق حفظ وتحويل الوثائق من صيغة الى اخرى
المهارات الأساسية والمتقدمة لتعديل الوثائق وجميع ادواتها
كيفية تحويل المعلومات المكتوبة الى اشكال تمثلها بشكل افضل مثل SmartArt
افضل طريقة لمشاركة وتصدير الوثائق

-من يستفيد من هذه الدورة؟
موظفين يرغبون بزيادة انتاجيتهم
طلاب المعاهد والجامعات
------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

October 11, 2016 at 1:07 pm

Advanced Access Course
Will Start On 17-October 2016
Sun-Tue &The
Time: From 10:00 AM To 01:30 PM
------------------------
Microsoft Access is a highly worthwhile skill to have at your command as this very popular database application is widely used across many employment sectors.
Our Microsoft Access courses are split into manageable lessons, although these are not fixed-time Microsoft Access training classes. Our flexible study programme means you can work at your own pace at one of our handy town or city centre locations in Ireland.
In a detailed and varied training programme, you'll be guided through many aspects of Access including database terminology; planning and design; defining relationships and creating a table; editing data; using advanced tools; using the query wizard; adding a field; exporting html documents; adding charts to forms; and creating macros. After your training, your workbook is yours to keep as a handy reference guide - and you'll have all the advantages of having the renowned Pitman Training name on your CV.
------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

October 10, 2016 at 11:46 am

Advanced Office Diploma
Will Start On 17-October 2016
Sun-Tue &The
Time: From 10:00 AM To 01:30 PM
------------------------
This Office Skills Training Diploma will equip you perfectly for setting out on your career in an office environment. We'll help you to carefully select your Diploma modules, tailored to your current skills, so that you can tackle a multitude of tasks with confidence and efficiency. And once you've mastered these new skills, you will be perfectly prepared to pursue your career in your current employment or to seek out new horizons.
You will become highly-skilled according to your choice of the four modules, which among others, include the following: typing, typing speed development, communication at work, health & safety essentials, book-keeping, Word, Excel and Outlook.
Many of our students choose this Diploma as a step towards additional Pitman Training qualifications, such as our Legal Secretary, Medical Secretary, Advanced Accounts or other Secretarial Diplomas.
------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

September 27, 2016 at 10:17 am

SQL Server Track
Will Start On 2-October 2016
Sun-Tue &The
Time: From 05:00 PM To 08:30 PM
Ask About Offers
---------------------------------------------
The SQL server that is produced by both Microsoft and Sybase serves as a relational database management system. The primary function of a SQL server is to serve as a database that stores data that can be retrieved on demand through the usage of query languages or software applications. Microsoft's SQL server program is written in C and C++ and can be used on the Windows operating system.
هي لغة استعلام هيكلية وهي لغة التعامل مع قواعد البيانات، حيث تعتمد عليها كافة التطبيقات التي تتعامل مع قواعد البيانات العلائقية من استرجاع وادراة البيانات
------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 24, 2016 at 8:18 am

Technical Support Require
------------------------------------------
For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 17, 2016 at 1:33 pm

PMP- Project Management Professional Course:
Will Start On The 20th Of August
Days: Saturdays.
From 5:30 PM To 9:30 PM
-----------------------------------------------
The PMP recognizes demonstrated competence in leading and directing project teams. If you're an experienced project manager looking to solidify your skills, stand out to employers and maximize your earning potential, the PMP credential is the right choice for you.
-----------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 15, 2016 at 7:50 am

Microsoft Office 2010 Fundamental Diploma :
----------------------------------------
Will Start On 23-Aug
Days: Sun- Tue- Thu
From 5:30 PM To 8:30 PM
-----------------------------------------------------------
This certificate will provide students with the most common office skills demanded and used in the market today.
Students will learn and perform intermediate techniques in Microsoft Word and Excel and basic techniques in Access and PowerPoint.
Students will also learn how to integrate the Office Applications.
-----------------------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 14, 2016 at 2:11 pm


3Ds Max Diploma :
----------------------------
Will Start On 21-August
Sun- Tue- Thu
From 6:00 PM To 10:00 PM
--------------------------------------
3Ds Max
-----------
Participants learn how to:
Use the Interface
Use Selection and Transformation Tools
Create and Modify Mesh Objects
Create and Modify Poly Objects
Import AutoCAD 2D Files and Model in Max
Organize AutoCAD Files Using Layers and Plines
Import Plines from AutoCAD Files to Create 3D Objects in Max
Use Standard Lights
Create a Night View Using Photomatric Lights
Create Daylight Systems
Add and Modify Cameras
Create a Basic Animation
Create, Get, Modify, and Save Materials
Import a 3D Hut from AutoCAD to Assign Materials, Add Backgrounds, and Render
Import a 3D House from AutoCAD to Assign Materials, Add Trees, Insert Cars, and Create a Walkthrough

---------------------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 11, 2016 at 8:40 am

AutoCAD Interior Design Course:
Will Start Next Saturday 13/08/2016
From 6:00 pm to 10:00 pm
Sat- Mon- Wed
----------------------------------------------------
AutoCAD is a computer-aided drafting software program used to create blueprints for buildings, bridges, and computer chips, among other things.
Discover how AutoCAD is used by drafters and other professionals.
----------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 7, 2016 at 1:41 pm

3Ds Max Diploma:
Will Start On 14-August
Sun- Tue- Thu
From 6:00 PM To 10:00 PM
--------------------------------------
3Ds Max is a software, developed by Autodesk.
It is a modeling, animation and rendering package widely used by game developers, graphic designers, visual effects artists and architects.
It is also used to create awe-inspiring special effects in films.
----------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 3, 2016 at 1:04 pm


مركز انفورم في انتظاركم يوم السبت الموافق 13/08/2016 يوم تعريفي مجاني لكيفية ان تصبح مدير مشروع محترف في الساعه الرابعه عصرا .
What is Project Management Professional-PMP
--------------------------------------------------------------------
Someone asked me the other day about details on the PMP Exam Certifications. And How to Prepare for the PMP Exam
The Steps to get PMP certification
How to become a member of the PMI
Project Management Experience Hours vs. Contact Hours
Who Should Apply
----------------------------------------
Register : facebook.com/INFORM.Education.center/app/206429986046631/
We will confirm by sending confirmation mail Or call you back

For more information please contact us :
01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,From Gamal Nouh St., Almaza , Cairo

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

August 2, 2016 at 7:54 am

Microsoft Office 2010 Fundamental Diploma :
Will Start This Month
-----------------------------------------------
Microsoft Office is a set of desktop applications that offer flexible and powerful ways to organize, manage, and present information. Universally used in office settings, knowledge of Microsoft Office tools are a must for anyone in today's job market.
--------------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

July 30, 2016 at 3:12 pm

CCNA Routing And Switching Course :
Will start next month,
Days : Saturday & Friday
--------------------------------------
Cisco is the best option if you really want to have a successful career in the information technology industry.
Getting CCNA certification training is very ideal if you want to start a great career in this competitive industry.
------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

INFORM

INFORM

Cairo, EGYPT

Education / Training / Coaching

July 30, 2016 at 2:21 pm

Microsoft Office 2010 advanced Diploma :
Will Start Next Month
----------------------------------
Get Microsoft Office training and gain the skills needed to express your ideas, solve problems and connect with people.
Microsoft Office Diploma includes Access, Excel, Outlook, Power Point and Word.
------------------------------------------
For more information please contact us : 01227472664 - 24141567
Or visit us at :20 Mahmoud Fouad St.,Thawra St., Almaza Heliopolis, Cairo.

Like Share

Download Jobzella Mobile App

Jobzella mobile app for Android and iPhone