Data Engineering

You’ll study in detail all the stages of data processing and disassemble the necessary tools to work with them, learn

Continue readingData Engineering

Ok, Data!

Working with data is no longer the domain of giants, but a necessity for any successful business. Any manager must know how to get value out of data. After the course you will be able to write simple SQL queries, compile reports in Power BI, or make a prototype DS project and then join a large team.

Hakka IT School

New Features for Administrators course introduces administrators to new or enhanced features and options. The course consists of two parts. The second part of the course presents five modules : security, data availability, sectioning, data information lifecycle, database operations execution monitoring, performance management.

The program :

  • Unified Auditing – Universal Unified Auditing
  • New privileges to control data access
  • Privilege analysis
  • Data Redaction – masking/hiding data
  • New features to ensure high availability of data
  • Online moving of data files
  • Improvement and development of Flashback Data Archive option
  • Enhancements in Recovery Manager to provide high availability of data
  • Improvements in sectioning
  • Heat Map and Automatic Data Optimization – automatic optimization of data lifecycle maintenance
  • Real-Time Database Operation – monitoring of operations execution
  • New options to increase SQL command performance: Database In-Memory, Full Database In-Memory Caching, Automatic Big Table Caching.
  • New options of optimizer: Adaptive Execution Plans, SQL Plan Directives, new types of histograms, extended statistics, Adaptive SQL Plan Management
  • Real-Time ADDM
  • Compare Period ADDM
  • Improvement of Real Application Testing option
  • Other improvements in database performance tuning

News