Catalogue
/
Databases
/
Selecting the Right Data Storage: A Comprehensive Guide from Flat Files to Distributed Systems

Selecting the Right Data Storage: A Comprehensive Guide from Flat Files to Distributed Systems

Acquire the proficiency to determine the optimal data storage solutions tailored for your business needs.

Dive deep into various modern storage techniques, from basic flat files to advanced distributed systems, and gain a holistic perspective

What will you learn?

Acquire the proficiency to determine the optimal data storage solutions tailored for your business needs. Dive deep into various modern storage techniques, from basic flat files to advanced distributed systems, and gain a holistic perspective. By the end, attendees will possess a comprehensive understanding, enabling them to select the best storage solution based on specific requirements and be prepared for future trends in data storage.

This course covers:

  • An exploration of File Document and Cloud Storage.
  • A study of Flat File, Relational, and NoSQL databases.
  • Dive into Search Engines and Traditional Data Warehouses.
  • Deepen your understanding with MapReduce & Distributed Parallel Processing.
  • Explore In-Memory Databases and other cutting-edge systems.

Requirements:

While no technical background is mandatory, familiarity with basic database theory, such as SQL, would be beneficial to better grasp the content.

Course Outline*:

*We know each team has their own needs and specifications. That is why we can modify the training outline per need.

1. File Document & Cloud Storage:
  • Key Features: OCR, Scalability, and Search Functionalities.
  • Open-source Spotlight: Next Cloud.
  • Leading Commercial Solutions.
2. Flat File Storage:
  • Delving into XML & CSV Databases.
3. Relational Databases:
  • Basics: Normalization, Dependencies, and Constraints.
  • Scalability Methods: Replications and Clustering.
  • Software Insights: MySQL, PostgreSQL, DM7, Oracle, and more.
4. NoSQL Storage:
  • Document-Oriented: MongoDB, CouchDB.
  • Column-Oriented: Cassandra, Scylla.
  • Search-Oriented: An Elasticsearch focus.
  • An introduction to NewSQL.
  • Deep Dive into CAP Theorem.
  • Open-source Spotlight: SequoiaDB.
5.  Search Engines:
  • Features: Text Processing, Relevancy, etc.
  • Open-source Showcase.
  • Scalability, High Availability, and Load Balancing.
6. Traditional Data Warehouses:
  • BI, OLTP, and Data Warehousing: Spotting the Differences.
  • A tour of open-source and commercial platforms.
7. MapReduce & Distributed Parallel Processing:
  • A journey through the Hadoop Ecosystem: Hive, HFS, Impala.
  • Distributed File Systems Overview.
  • Open-source Spotlight: Ceph.
8. In-Memory Databases:
  • Feature focus on open-source solutions like Apache Ignite.
9. Other Key Systems:
  • An overview of Hypertable, Google's Bigtable, BigQuery, and AWS offerings like S3.
10. The Future of Data Storage:
  • A look at upcoming trends and innovations.

Hands-on learning with expert instructors at your location for organizations.

0
Graph Icon - Education X Webflow Template
Level: 
Intermediate
Clock Icon - Education X Webflow Template
Duration: 
7
Hours (days:
1
) 
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.
Get Quote

Master new skills guided by experienced instructors from anywhere.

0
Graph Icon - Education X Webflow Template
Level: 
Intermediate
Clock Icon - Education X Webflow Template
Duration: 
7
Hours (days:
1
) 
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.
Get Quote

You can participate in a Public Course with people from other organisations.

0

/per trainee

Number of Participants

1 Participant

Thanks for the numbers, they could be going to your emails. But they're going to mine... Thanks ;D
Oops! Something went wrong while submitting the form.
Graph Icon - Education X Webflow Template
Level: 
Intermediate
Clock Icon - Education X Webflow Template
Duration: 
7
Hours (days:
1
) 
Camera Icon - Education X Webflow Template
Fits ideally for individuals and small groups
Star Icon - Education X Webflow Template
Networking opportunities with fellow participants.
*Price can range depending on number of participants, change of outline, location etc.
Get Quote