Database Platforms
- Hands-on exposure to MySQL, MariaDB, MSSQL, and MongoDB
- Understanding of relational and NoSQL database concepts
Installation & Setup
- Installation of MySQL/MariaDB and Microsoft SQL Server
- Basic configuration for development and production environments
Database Creation & Management
- Database creation, table design, and schema management
- Managing database objects and structured data organization
Backup & Auto-Backup
- Manual database backup and restore operations
- Configuration of auto-backup mechanisms
Database Connectivity
- Database connection handling for applications
- Secure application-to-database connection configuration
SQL & Query Operations
- Writing SQL queries for CRUD operations
- Basic query optimization and structured data handling
Data Security & Encryption
- Implementation of data encryption concepts
- Understanding encryption at database and application levels
Database Security & Access Control
- Securing databases using login IDs and passwords
- Managing authentication and access control mechanisms