Data Warehousing Advanced

COURSE FEATURES

Duration

2 Days

Skill level

Advanced

Language

RO/EN

Type

In-class / Online-live

Assessments

Yes

Custom Training

1750 Eur / Day

Open Class

750 Eur / Participant

Download PDF

The Data Warehousing course covers concepts and definitions, as well as concrete examples that clearly illustrate the following terms: from data modeling and processing to performance, optimization techniques and tuning, security, and hardware.

This course is taught in Romanian, with course materials available in either English, or Romanian. The course can be customized - on request.

DAY

TOPICS

DW QUERY. PERFORMANCE OPTIMIZATION

Data loading

Data compression

Indexes. Bitmap. Index-Organized Table

Materialized views. Refresh. Query rewrite

Partitioning

Integrity constraints

Parallel processing

'In-memory' processing

SQL tuning, optimizer, joins, execution plan, statistics, hints

Optimizing star query (star query, star transformation)

Analytical functions. Data aggregation

SECURITY, USERS

Data upload, user access, network, encryption.

Audit: login, data access, data modification.

DW/ETL/BI roles and responsabilities.

DAY

TOPICS

BEST PRACTICES

General principles, standards, modeling/design/programming rules: metadata, configurations, names, auditing, default values, partitioning, indexes, security

HISTORICAL DATA STORAGE. BACKUP. RECOVERY. HARDWARE

Life cycle, rolling windows, read-only tablespaces, magnetic tape.

Backup techniques

High availability, disaster recovery.

Recommended hardware architecture (technical configuration). CPU, memory, storage.

Work environments, sizing, growth rate

Contact Us

Feel free to leave us your thoughts so we can discover the solution together!

academy@esolutions.ro

Get in touch

0753.029.187

Our address

20 Constantin Budisteanu Street , 1 st. District, Bucharest

academy@esolutions.ro

Get in touch

0753.029.187

Our address

20 Constantin Budisteanu Street , 1 st. District, Bucharest

Related Courses

+ View all courses

Database

Data Warehousing Fundamentals

From data modeling and processing to performance and optimization, this course covers fundamental data warehousing concepts.

DURATION

3 Days

Database

Introduction to NoSQL

This introductory course provides basic knowledge of the distributed data storage layer in big data architectures and NoSQL concepts.

DURATION

3 Days

Database

MongoDB

This introductory course provides the foundational skills needed to work with MongoDB and other important concepts, such as aggregation, indexing, data modeling, and transactions.

DURATION

5 Days

Database

Neo4j

This course introduces attendants to graph databases, focusing on using Neo4j and query languages aimed at making data analysis intuitive and effortless.

DURATION

2 Days

+ View all courses

Do you want to become a trainer?

Ask not what your company can do for you, ask what you can do for your company. Apply for a training position.

Apply Now