Module 1: Introduction to Database Management Systems

• Fundamental database concepts: tables, records, fields, keys
• Database architecture: client-server, file-based
• Relational Database Management Systems (RDBMS) vs. NoSQL DBMS
• Overview of SQL, MySQL, PostgreSQL, and MongoDB
• Database management system functionalities
• Practical session: Exploring different database management systems interfaces.

Module 2: SQL Fundamentals - Data Definition Language (DDL)

• Creating databases and tables
• Defining data types and constraints
• Altering and dropping tables and databases
• Understanding primary and foreign keys
• Implementing relationships between tables
• Practical session: Creating a database schema with tables and relationships using SQL.

Module 3: SQL Fundamentals - Data Manipulation Language (DML)

• Inserting, updating, and deleting data
• Selecting data using the SELECT statement
• Filtering data with the WHERE clause
• Sorting data with ORDER BY
• Using aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• Practical session: Writing SQL queries to insert, update, delete, and retrieve data.

Module 4: SQL Fundamentals - Data Query Language (DQL) - Advanced Queries

• Joining tables (INNER, LEFT, RIGHT, FULL)
• Using subqueries and common table expressions (CTEs)
• Grouping and aggregating data with GROUP BY and HAVING
• Working with date and time functions
• Using string manipulation functions
• Practical session: Writing complex SQL queries involving joins, subqueries, and aggregate functions.

Module 5: MySQL Database Administration

• Installing and configuring MySQL
• Connecting to MySQL server and using the MySQL client
• Managing users and privileges in MySQL
• Backing up and restoring MySQL databases
• Basic MySQL server configuration
• Practical session: Creating users and granting permissions in MySQL.

Module 6: PostgreSQL Database Administration

• Installing and configuring PostgreSQL
• Connecting to PostgreSQL server and using psql
• Managing roles and privileges in PostgreSQL
• Backing up and restoring PostgreSQL databases
• Basic PostgreSQL server configuration
• Practical session: Performing a database backup and restore in PostgreSQL.

Module 7: Introduction to NoSQL Databases - MongoDB

• Understanding NoSQL database concepts
• Introduction to MongoDB: documents, collections, databases
• Installing and running MongoDB
• Basic MongoDB operations: insert, find, update, delete
• Querying MongoDB using the MongoDB Shell
• Practical session: Inserting and querying documents in MongoDB.

Module 8: MongoDB - Advanced Queries and Data Manipulation

• Advanced query operators in MongoDB
• Indexing in MongoDB for performance
• Aggregation framework in MongoDB
• Working with embedded and referenced documents
• Basic data modeling in MongoDB
• Practical session: Writing advanced queries and using the aggregation framework in MongoDB.

Module 9: Database Design and Data Modeling

• Principles of database design
• Entity-Relationship (ER) modeling
• Normalization (1NF, 2NF, 3NF)
• Choosing appropriate data types
• Indexing strategies for performance
• Practical session: Designing an ER diagram for a given business scenario.

Module 10: Database Security

• Understanding database security risks
• User authentication and authorization
• Implementing data encryption
• Preventing SQL injection attacks
• Database auditing and logging
• Practical session: Implementing basic user authentication in a database system.

Module 11: Database Performance Optimization

• Identifying performance bottlenecks
• Query optimization techniques
• Indexing strategies
• Database server tuning
• Monitoring database performance
• Practical session: Analyzing and optimizing a slow-performing SQL query.

Module 12: Relational vs. NoSQL Database Selection

• Comparing relational and NoSQL databases
• Use cases for MySQL and PostgreSQL
• Use cases for MongoDB
• Factors to consider when choosing a database system
• Hybrid database approaches
• Practical session: Analyzing a scenario and recommending the appropriate database system.

Module 13: Data Backup and Recovery Strategies

• Importance of data backup and recovery
• Different backup strategies (full, incremental, differential)
• Recovery procedures for MySQL, PostgreSQL, and MongoDB
• Testing backup and recovery processes
• Disaster recovery planning for databases
• Practical session: Performing a data backup and simulating a recovery scenario.

Module 14: Database Integration with Applications (Overview)

• Introduction to connecting applications to databases
• Overview of database connectors and drivers
• Basic concepts of ORM (Object-Relational Mapping)
• Security considerations for application-database interaction
• Introduction to database APIs
• Practical session: Exploring connection parameters for a database from a sample application.

Module 15: Database Transaction Management

• Understanding database transactions
• ACID properties (Atomicity, Consistency, Isolation, Durability)
• Transaction isolation levels
• Concurrency control and locking mechanisms
• Handling deadlocks
• Practical session: Demonstrating the concept of transactions in a database.

Module 16: Advanced SQL Features and Functions

• Window functions
• Stored procedures and functions
• Triggers
• Common table expressions (CTEs) - advanced usage
• Optimizing complex SQL queries
• Practical session: Writing a stored procedure or function in SQL.

Module 17: Database Scaling and High Availability (Overview)

• Concepts of database scaling (vertical and horizontal)
• Introduction to replication and clustering
• Load balancing for databases
• High availability architectures
• Overview of scaling and HA options for MySQL, PostgreSQL, and MongoDB
• Practical session: Discussing basic scaling strategies for different database systems.

Module 18: Data Warehousing and ETL (Introduction)

• Introduction to data warehousing concepts
• ETL (Extract, Transform, Load) processes
• Basic data modeling for data warehouses
• Overview of data warehousing tools
• The role of databases in data warehousing
• Practical session: Identifying potential data sources for a data warehouse.

Requirements:

·       Participants should be reasonably proficient in English.

·       Applicants must live up to Armstrong Global Institute admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@armstrongglobalinstitute.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254725012095 / +254724452588

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Armstrong Global Training & Development Center Limited should be paid in advance, 5 days to the training.

2. Invoice: We can send a bill directly to you or your company.

3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

2. Participants may cancel attendance 14 days or more prior to the training commencement date.

3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588