Arich Infotech
Facebook
Instagram
Pinterest
X-twitter
Linkedin
Youtube
Menu
Home
About
Services
Careers
Courses
Mainframe
Infra
Data Science
Cloud
Open System
Blog
Events
Gallery
Contact
Home
About
Services
Careers
Courses
Blog
Events
Gallery
Contact
01
01
01
Menu
Home
About
Services
Careers
Courses
Mainframe
Infra
Data Science
Cloud
Open System
Blog
Events
Gallery
Contact
Core Database, Storage and Backup Concepts
Home
Courses
Infra
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
Understanding Core Database Concepts
What is Data and How data is stored in Table
Introduction to Databases – Relational, NoSQL, New SQL Model
Database Popularity by Model and Market Trends
Relational Database Concepts and DML – DDL – DCL – TCL
Understand how SQL can be used to create database objects, such as tables and views
Creating Database Objects
Choose data types
Understand tables and how to create them
How to create views (overview)?
How to create stored procedures and functions (overview)?
Manipulating Data
Select data
Insert data
Update data
Delete data vs Truncate
Understanding Data Storage
Understand normalization
Understand primary, foreign, and composite keys
Understand indexes
Administering a Database
Understand database security concepts
Understand database backups and restore
Understanding Proprietary RDBMS & Open-Source Databases
Basic understanding about Proprietary RDBMS – SQL Server, Oracle, IBM DB2 etc…
Basic understanding about Open-Source DBs – PostgreSQL, MariaDB, MySQL etc..
Understanding Database deployment options available on Public Cloud
Basic understanding about Database services on Azure
Basic understanding about Database services on AWS
Basic understanding about Database services on GCP
Storage Fundamentals
Storage Basics
Storage Fundamentals (SAN/NAS/DAS/Object)
Storage technology (HDD, SSD, SATA, NVME)
Stroage File system and protocols
SAN Fundamentals.
RAID concepts.
EMC Storage
Dell Technologies Overview
Unity storage architecture
Managing Unity storage
Brocade SAN
Brocade/Cisco WebTools
Brocade/cisco Switch Commands.
Windows/Unix disk/filesystem Commands ( Diskmgmt,diskpart, Lvinfo,Pvinfo).
Cloud Storage
Cloud storage overview
Cloud storage vendors and storage options
Demo of VNX/Unity/Object storage provisioning
Backup Fundamentals
Backup Basics
Backup overview
Backup Architecture and types
Backup subsystem (PTL,VTL, Disk, Purpose Built storage, Object storage, Cloud storage)
Backup tool types (Software based, Converged)
Deduplication technology, Snapshots
Netbackup Overview
Netbackup Overview
Netbackup architecture
Netbackup backup console and management
Rubrik Overview
Rubrik Overview
Rubrik architecture
Rubrik backup console and management
Demo
Configure Backup (Disk/Cloud storage)
Check backups
Restore backups
Need Help? Call Here
+91 88699 88399
COURSE ENQUIRY |
WhatsApp us