Adastra Academy presents to you a free open course designed to enhance your technical skills in the field of Data Analytics.

Adastra Academy, part of Adastra Bulgaria’s brand, binds together all internal and external training and knowledge sharing initiatives, with а strong training base and dedicated competency leads! This course will give you practical knowledge and hands-on experience in the areas of SQL, Data Warehousing, Data Quality, Data Profiling, Data Integration, Business Intelligence and Big Data.

THE COURSE WILL TAKE PLACE ON THE FOLLOWING SATURDAYS: APRIL 13, APRIL 20, MAY 11, MAY 18, JUNE 1

Time Slots: 09:00 – 14:00

Key Topics:

  • Introduction to Information Management (13.04.2019)
  • Main principles and organizational aspects
  • Strategic Objectives of Business Information Management
  • Relational Modeling (13.04.2019)
  • ER Diagrams. Attributes. Keys. Constraints
  • Types of notations. Modeling Approaches
  • Data Warehousing (13.04.2019)
  • Dimensional Data Modeling. EDW Architectures
  • Fact, dimensions and cubes. Slowly changing dimensions
  • Structured Query Language (13.04.2019)
  • Data Definition Language (DDL). CREATE, ALTER and DROP statements
  • Data Modification Language (DML). SELECT, INSERT, UPDATE, DELETE statements
  • Practical examples
  • Data Profiling (20.04.2019)
  • Objectives, Tools and Scenarios
  • Outlier Detection
  • Data Quality (20.04.2019)
  • Data and Information Quality. Dimensions and source of Data Quality
  • Data cleaning and Data Quality tools
  • Data Integration (11.05.2019)
  • Approaches, Processes and Architecture
  • ETL Data Structures and Operators. Data Integration Tools
  • Business Intelligence (11.05.2019)
  • Objectives of Business Intelligence. Business Intelligence Tools
  • Business Intelligence Best Practices
  • Big Data (18.05.2019)
  • Comparison with DWH. Hadoop Components. Storage
  • MapReduce and YARN Engines
  • Final Exam (01.06.2019)

Join our course and understand the scope, process and tools of Data Analytics!

The event is free but subject to mandatory pre-registration: HTTPS://WWW.SURVEYMONKEY.COM/R/ABGV2019