NP URI: www.nobleprog.com.eg/cc/datastorageoverview Undefined array key 0 /apps/hitra7/npfrontend/nptemplates/default.php:137 Array ( [0] => Array ( [file] => /apps/hitra7/npfrontend/nptemplates/default.php [line] => 137 [function] => {closure:/apps/hitra7/npfrontend/index.php:5} [args] => Array ( [0] => 2 [1] => Undefined array key 0 [2] => /apps/hitra7/npfrontend/nptemplates/default.php [3] => 137 ) ) [1] => Array ( [file] => /apps/hitra7/npfrontend/modules/course/course.php [line] => 141 [args] => Array ( [0] => /apps/hitra7/npfrontend/nptemplates/default.php ) [function] => require_once ) [2] => Array ( [file] => /apps/hitra7/npfrontend/core/routes.php [line] => 16 [function] => course_menu_callback [args] => Array ( [0] => /cc/datastorageoverview ) ) [3] => Array ( [file] => /apps/hitra7/npfrontend/__index.php [line] => 94 [args] => Array ( [0] => /apps/hitra7/npfrontend/core/routes.php ) [function] => require_once ) [4] => Array ( [file] => /apps/hitra7/npfrontend/index.php [line] => 17 [args] => Array ( [0] => /apps/hitra7/npfrontend/__index.php ) [function] => include_once ) [5] => Array ( [file] => /apps/hitra7/index.php [line] => 65 [args] => Array ( [0] => /apps/hitra7/npfrontend/index.php ) [function] => include_once ) ) NP URI: www.nobleprog.com.eg/cc/datastorageoverview Undefined array key 1 /apps/hitra7/npfrontend/nptemplates/default.php:137 Array ( [0] => Array ( [file] => /apps/hitra7/npfrontend/nptemplates/default.php [line] => 137 [function] => {closure:/apps/hitra7/npfrontend/index.php:5} [args] => Array ( [0] => 2 [1] => Undefined array key 1 [2] => /apps/hitra7/npfrontend/nptemplates/default.php [3] => 137 ) ) [1] => Array ( [file] => /apps/hitra7/npfrontend/modules/course/course.php [line] => 141 [args] => Array ( [0] => /apps/hitra7/npfrontend/nptemplates/default.php ) [function] => require_once ) [2] => Array ( [file] => /apps/hitra7/npfrontend/core/routes.php [line] => 16 [function] => course_menu_callback [args] => Array ( [0] => /cc/datastorageoverview ) ) [3] => Array ( [file] => /apps/hitra7/npfrontend/__index.php [line] => 94 [args] => Array ( [0] => /apps/hitra7/npfrontend/core/routes.php ) [function] => require_once ) [4] => Array ( [file] => /apps/hitra7/npfrontend/index.php [line] => 17 [args] => Array ( [0] => /apps/hitra7/npfrontend/__index.php ) [function] => include_once ) [5] => Array ( [file] => /apps/hitra7/index.php [line] => 65 [args] => Array ( [0] => /apps/hitra7/npfrontend/index.php ) [function] => include_once ) ) NP URI: www.nobleprog.com.eg/cc/datastorageoverview Undefined array key 2 /apps/hitra7/npfrontend/nptemplates/default.php:137 Array ( [0] => Array ( [file] => /apps/hitra7/npfrontend/nptemplates/default.php [line] => 137 [function] => {closure:/apps/hitra7/npfrontend/index.php:5} [args] => Array ( [0] => 2 [1] => Undefined array key 2 [2] => /apps/hitra7/npfrontend/nptemplates/default.php [3] => 137 ) ) [1] => Array ( [file] => /apps/hitra7/npfrontend/modules/course/course.php [line] => 141 [args] => Array ( [0] => /apps/hitra7/npfrontend/nptemplates/default.php ) [function] => require_once ) [2] => Array ( [file] => /apps/hitra7/npfrontend/core/routes.php [line] => 16 [function] => course_menu_callback [args] => Array ( [0] => /cc/datastorageoverview ) ) [3] => Array ( [file] => /apps/hitra7/npfrontend/__index.php [line] => 94 [args] => Array ( [0] => /apps/hitra7/npfrontend/core/routes.php ) [function] => require_once ) [4] => Array ( [file] => /apps/hitra7/npfrontend/index.php [line] => 17 [args] => Array ( [0] => /apps/hitra7/npfrontend/__index.php ) [function] => include_once ) [5] => Array ( [file] => /apps/hitra7/index.php [line] => 65 [args] => Array ( [0] => /apps/hitra7/npfrontend/index.php ) [function] => include_once ) )

Course Outline

  1. File Document Storage (Cloud Storage)
    1. Features (OCR, Scalaibility, Search, etc...)
    2. Open Source examples (e.g. Next Cloud)
    3. Some commercial examples
  2. Flat file storage
    1. XML databases
    2. CSV databases
  3. Relational databases
    1. Normalization
    2. Dependencies and Constrants
    3. Scalability - replications, clusters
    4. Open Source and commercial software (MySQL, PostrgreSQL, DM7, Oracle, etc.)
  4. NoSQL Storage
    1. Document Oriented Databases (MongoDB, CouchDB etc...)
    2. Column Orientation (Canadra, Scylla etc...)
    3. Search Orientation (Elasticsearch...
  5. NewSQL
    1. CAP Theorem
    2. Opensource software (SequoiaDB, etc...)
  6. Search Engines
    1. Features (text processing, relevancy, etc...)
    2. Open Source examples
    3. Scalability, High Availability, Load Balacing, etc....
  7. Traditional Datawherehouses
    1. Business Inteligence, OLTP and Datawherehouse
    2. Opensource and commercial solutions
  8. MapReduce and Distributed Parallel Processing
    1. Hadoop-like (Hive, HFS, Impala)
  9. Distributed filesystem
    1. Overview of opensource (Ceph etc...)
  10. In-memory Databases
    1. Opensource solution (e.g. ApacheIgnite)
  11. Others
    1. Hypertable (Google Bigtable)
    2. BigQuery
    3. AWS solutsion (S3, etc...)
  12. Beyond present - future trends

Requirements

Though no technical background is required, understanding the examples requires some level of database theory (e.g. SQL, etc...)

 7 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (2)

I liked that he had actual know how of when to use each technology, that's valuable.

Radu Mazilu - eMAG IT Research
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

The Trainer Subject Knowledge

Rares Serea - eMAG IT Research
Course - Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

Upcoming Courses

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

2025-11-24 09:30
7 hours
Cairo - Le Méridien Heliopolis
1,455 USD (Online)
1,955 USD (Classroom)

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

2025-12-08 09:30
7 hours
Alexandria, Stanley
1,455 USD (Online)
1,705 USD (Classroom)

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

2025-12-22 09:30
7 hours
Regus - Cairo Nile City Towers
1,455 USD (Online)
1,705 USD (Classroom)

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

2026-01-05 09:30
7 hours
Cairo - Four Seasons Hotel
1,455 USD (Online)
2,055 USD (Classroom)

Which data storage to choose - from flat files, through SQL, NoSQL to massive distributed systems

2026-01-19 09:30
7 hours
Cairo - Le Méridien Heliopolis
1,455 USD (Online)
1,955 USD (Classroom)

Related Courses

Microsoft Access – Downloading Data

 14 Hours

This instructor-led, live training in Egypt (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their skills in extracting, analyzing, and manipulating data within Microsoft Access using queries and SQL.

By the end of this training, participants will be able to:

  • Understand different types of queries in Microsoft Access.
  • Use query design tools to extract and analyze data effectively.
  • Write SQL queries to retrieve and manipulate data.
  • Perform data aggregation, filtering, and sorting using queries.
  • Apply advanced query techniques for troubleshooting and optimization.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Egypt (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

By the end of this training, participants will be able to:

  • Perform advanced querying techniques using unions, subqueries, and complex joins.
  • Add, update, and delete data, tables, views, and indexes with precision.
  • Ensure data integrity through transactions and manipulate database structures.
  • Create and manage databases efficiently for robust data storage and retrieval.
Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.
Read more...

MS 20764C:Administering a SQL Database Infrastructure

 35 Hours

Administering a SQL Database Infrastructure MOC 20764-C course imparts skills and knowledge to manage and maintain SQL Server databases while operating on a SQL database infrastructure.

Read more...

SQL Advanced level for Analysts

21 Hours

The aim of this course is to provide a clear understanding of the use of SQL for different
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.

Read more...

SQL Development Bootcamp

 35 Hours

This instructor-led, live training in Egypt (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.

Read more...

SQL Fundamentals

 14 Hours

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries

This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.

Read more...

SQL in Microsoft Access

 14 Hours

This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn:

  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between SQL dialects (Oracle, T-SQL, ANSI)
  • practical skills for writing queries

This SQL course deals with Microsoft Access dialect of SQL.

Read more...

SQL language in MSSQL

 14 Hours

The course answers questions

  • How to build a query?
  • What opportunities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

SQL in MySQL

 14 Hours
  • How to build a query?
  • What is a relational database?
  • What is the structure and SQL commands?
Read more...

SQL Advanced in MySQL

 7 Hours

This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.

Read more...

Data Analysis with SQL, Python and Spotfire

 14 Hours

In this instructor-led, live training in Egypt, participants will learn three different approaches for accessing, analyzing and visualizing data. We start with an introduction to RDMS databases; the focus will be on accessing and querying an Oracle database using the SQL language. Then we look at strategies for accessing an RDMS database programmatically using the Python language. Finally, we look at how to visualize and present data graphically using TIBCO Spotfire. 

Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.

Read more...

SQL in SQL Server

 14 Hours

This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:

  • how to write SQL queries
  • what relational databases are and how we can use them
  • what are relations and how to create them
  • the structure of data
  • differences between T-SQL and other dialects
  • practical skills for writing queries

This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.

Read more...

Transact SQL Advanced

 7 Hours

Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following:

  • Use queries to return complex result sets
  • Manage database objects to aid query performance
  • Tune queries to perform more efficiently

This course is for anyone who currently uses Transact SQL to extract data from a Microsoft SQL Server database and wishes to expand their knowledge particularly in the areas of data analysis and improving query speed.

Read more...

Transact SQL Basic

 14 Hours

Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following:

  • Construct queries to extract and filter data from an SQL Server database
  • Create summarised results
  • Change, derive and format data to suit the required output
  • Change data and maintain database components and definitions

This course is for anybody who needs information from a Microsoft SQL Server database. It is suitable for either system developers or people from other areas who need to use SQL to extract and analyse data.

Read more...

Related Categories

SQL
SQL