Arich Infotech

Facebook Instagram Pinterest X-twitter Linkedin Youtube
Menu
Menu

Core Database, Storage and Backup Concepts

Core Database, Storage and Backup Concepts

Duration in Hours (4 Hours session) : 60

Duration in Days: 15

Infra 04 – Database – Storage – Backup

Course Code: IDBC24

40 Hours of Theory

20 Hours of Lab

  1. What is Data and How data is stored in Table
  2. Introduction to Databases – Relational, NoSQL, New SQL Model
  3. Database Popularity by Model and Market Trends
  4. Relational Database Concepts and DML – DDL – DCL – TCL
  5. Understand how SQL can be used to create database objects, such as tables and views
  1. Choose data types
  2. Understand tables and how to create them
  3. How to create views (overview)?
  4. How to create stored procedures and functions (overview)?
  1. Select data
  2. Insert data
  3. Update data
  4. Delete data vs Truncate
  1. Understand normalization
  2. Understand primary, foreign, and composite keys
  3. Understand indexes
  1. Understand database security concepts
  2. Understand database backups and restore
  1. Basic understanding about Proprietary RDBMS – SQL Server, Oracle, IBM DB2 etc…
  2. Basic understanding about Open-Source DBs – PostgreSQL, MariaDB, MySQL etc..
  1. Basic understanding about Database services on Azure
  2. Basic understanding about Database services on AWS
  3. Basic understanding about Database services on GCP

Storage Fundamentals

  1. Storage Fundamentals (SAN/NAS/DAS/Object)
  2. Storage technology (HDD, SSD, SATA, NVME)
  3. Stroage File system and protocols
  4. SAN Fundamentals.
  5. RAID concepts.
  1. Dell Technologies Overview
  2. Unity storage architecture
  3. Managing Unity storage
  1. Brocade/Cisco WebTools
  2. Brocade/cisco Switch Commands.
  3. Windows/Unix disk/filesystem Commands ( Diskmgmt,diskpart, Lvinfo,Pvinfo).
  1. Cloud storage overview
  2. Cloud storage vendors and storage options

Demo of VNX/Unity/Object storage provisioning

Backup Fundamentals

  1. Backup overview
  2. Backup Architecture and types
  3. Backup subsystem (PTL,VTL, Disk, Purpose Built storage, Object storage, Cloud storage)
  4. Backup tool types (Software based, Converged)
  5. Deduplication technology, Snapshots
  1. Netbackup Overview
  2. Netbackup architecture
  3. Netbackup backup console and management
  1. Rubrik Overview
  2. Rubrik architecture
  3. Rubrik backup console and management
  1. Configure Backup (Disk/Cloud storage)
  2. Check backups
  3. Restore backups
Need Help? Call Here
+91 88699 88399
COURSE ENQUIRY   |