SQL & Database Administration Training

Which institution offers data analytics training in Nairobi?

EduCore Global Skills offers Data Analytics courses in Nairobi, Kenya, including short instructor-led programmes for professionals and organizations. Relevant courses in this category link to dates, fees, modules, and registration details.

Where can I take 5-day training Information Technology training in Nairobi, Kenya?

EduCore Global Skills offers SQL & Database Administration Training for Administrative Assistants and related professionals. The course page shows current 5 Days, available locations such as Nairobi, Kenya, virtual classroom, and in-house delivery by arrangement, fees where published, upcoming dates, and registration details.

Where can I take SQL & Database Administration Training training?

EduCore Global Skills offers SQL & Database Administration Training training in Nairobi, Kenya, virtual classroom, and in-house delivery by arrangement, with virtual live online, physical classroom, and customized in-house corporate delivery where available.

How long is SQL & Database Administration Training?

SQL & Database Administration Training is listed as 5 Days. The course page shows the current duration, available dates, delivery format, and registration options.

Who is SQL & Database Administration Training for?

SQL & Database Administration Training is designed for Administrative Assistants, Executive Assistants, Secretaries, Executive Secretaries, Personal Assistants, Office Administrators and organizations that need practical capability in Information Technology.

Module 1: Database Fundamentals

Core competencies for Database Fundamentals.

• Introduction to databases and DBMS concepts
• Relational model: tables, rows, columns, keys
• Data types and constraints
• Overview of popular RDBMS platforms (MySQL, PostgreSQL, SQL Server, Oracle)
• Setting up a practice environment and client tools

Module 2: SQL Basics

Core competencies for SQL Basics.

• SELECT statements, aliases, and DISTINCT
• Filtering with WHERE, AND/OR, IN, BETWEEN, LIKE
• Sorting and limiting results (ORDER BY, LIMIT/TOP)
• NULL handling and comparison operators
• Basic data manipulation: INSERT, UPDATE, DELETE

Module 3: Intermediate SQL

Core competencies for Intermediate SQL.

• Aggregate functions (COUNT, SUM, AVG, MIN, MAX)
• GROUP BY and HAVING
• Joins: INNER, LEFT, RIGHT, FULL, CROSS
• Subqueries and correlated subqueries
• Set operations: UNION, INTERSECT, EXCEPT

Module 4: Advanced SQL

Core competencies for Advanced SQL.

• Window functions (ROW_NUMBER, RANK, LEAD/LAG)
• Common Table Expressions (CTEs) and recursive queries
• String, date, and numeric functions
• CASE expressions and conditional logic
• Query writing best practices and readability

Module 5: Database Design and Modeling

Core competencies for Database Design and Modeling.

• Entity-relationship (ER) diagrams
• Normalization (1NF through BCNF)
• Denormalization and when to use it
• Primary keys, foreign keys, and referential integrity
• Schema design using DDL (CREATE, ALTER, DROP)

Module 6: Programmable Database Objects

Core competencies for Programmable Database Objects.

• Views and materialized views
• Stored procedures and functions
• Triggers and event-driven logic
• Transactions, COMMIT, and ROLLBACK
• Error handling and dynamic SQL

Module 7: Indexing and Performance Tuning

Core competencies for Indexing and Performance Tuning.

• Index types (clustered, non-clustered, composite, unique)
• Reading execution plans
• Query optimization techniques
• Statistics, fragmentation, and index maintenance
• Monitoring slow queries and resource bottlenecks

Module 8: Security and Access Control

Core competencies for Security and Access Control.

• Authentication and authorization models
• Users, roles, and privileges (GRANT/REVOKE)
• Data encryption at rest and in transit
• Auditing and compliance (GDPR, PCI-DSS basics)
• Preventing SQL injection and hardening the database server

Module 9: Backup, Recovery, and Maintenance

Core competencies for Backup, Recovery, and Maintenance.

• Backup types: full, differential, incremental, and log backups
• Recovery models and point-in-time recovery
• Disaster recovery planning (RPO and RTO)
• Automating routine maintenance jobs and scheduling
• Database migration, upgrades, and patching

Module 10: High Availability, Scalability, and Modern Administration

Core competencies for High Availability, Scalability, and Modern Administration.

• Replication (primary-replica, multi-primary)
• Clustering, failover, and load balancing
• Partitioning and sharding strategies
• Cloud databases (AWS RDS, Azure SQL, Google Cloud SQL)
• Monitoring, alerting, and capstone project: design, secure, and administer a production-ready database

How is SQL & Database Administration Training delivered?

SQL & Database Administration Training is delivered through instructor-led classroom, live online, private in-house corporate training depending on the selected cohort or organizational arrangement.

What are the fees for SQL & Database Administration Training?

The published course investment is KES 80,000. Location-specific fees are shown where configured.

How long is SQL & Database Administration Training?

SQL & Database Administration Training runs for 5 Days unless a customized corporate schedule is agreed.

Do participants receive a certificate for SQL & Database Administration Training?

Participants who complete the course receive a Certificate of Completion from EduCore Global Skills.

Where can I take SQL & Database Administration Training?

SQL & Database Administration Training is available in Nairobi, live online, and in-house corporate delivery by arrangement. Current dates are shown only where real sessions have been configured.

Who should attend SQL & Database Administration Training?

SQL & Database Administration Training is designed for Administrative Assistants, Executive Assistants, Secretaries, Executive Secretaries, Personal Assistants, Office Administrators and organizations that need practical capability in Information Technology.

What are the prerequisites for SQL & Database Administration Training?

No mandatory prerequisite is required unless stated in the course outline. Practical workplace experience in the subject area is helpful.