Overview and Objectives: This course will teach you everything you need to know in order to confidently discuss database, data warehouse and business Intelligence technologies with candidates and clients alike. As well as clarifying the jargon and terminology seen on database CVs, you will obtain a clear understanding of some of the newer associated technologies such as MOLAP, cloud-based databases and all the associated roles in these areas. Pre-requisites: A basic understanding of IT equivalent to Holistica's IT Fundamentals course for recruiters is preferable before attending this event. Free Post-course Support Service: All attendees will automatically receive a free email support facility for a period of three months after the course to support any queries which may arise in their work place. Conditions apply. Format: This is a highly interactive one day course with quizzes and recruitment based discussion throughout the day. This is currently only delivered as an on-site event at your premises. Delivery: All of our presenters have had hands-on experience of technology recruitment. As well as this they are also IT trainers who have been accredited by the Institute of IT Trainers (IITT) as being able to deliver in accordance with their TAP (Training Assessment Programme) methodology, and as such are acknowledged as being able to deliver technical training of the highest calibre. Courseware A folder containing extensive courseware and an IT glossary for ongoing reference are provided. Course overview: Defining the Technology - DBMS and RDBMS strengths and weaknesses
- The nature of data in its various forms
- From schema to data systems
Database Models - Hierarchical
- Relational
- Object Oriented Database systems
Data Design Techniques - Data modelling tools
- ERP
- STD
- Case tools
Data Types
- Numerics
- Binary Boolean
- Boolean
- Others
SQL and all its Variants
- Origins of SQL
- Declarative and Procedural languages
- PSQL, SQL PL, and PL/SQL
- T SQL
- SQL/PSM
- pgSQL
- How DBAs use the SQL paradigm
- A world with 'NoSQL'
A Comparison of widely Used Database Systems today - A run through the key systems
- The legacy systems which are still around
- The new kids on the block
- Oracle
- IBM
- Microsoft
- MySQL
- Ingress
- Teradata
- Xeround Cloud
Data Warehousing - The key principals defined
- Top down and bottom up design
- The role of Middleware and ETL
- Data mining tools
- Data marts
- OLAP and MOLAP
- From raw data to information
- EIS and SAS
- Cognos, Business Objects, Oracle and other key players
Business Intelligence - From information to intelligence
- Seeing the bigger picture
- The role of Middleware and ETL
- BI tools and companies
- Reporting
- ETL, Netweaver and SAP in the BI space
The Specialists and Where the fit in:- Business Analyst
- Database developer
- Database administrator (DBA)
- Technical Architect
- Support
Exercises and discussion throughout the day.
Content and sequence may vary slightly at the trainer's discretion. |
