Psalm E. Obiri - Tech Expert, Web developer & Instructor

Course Overview

This comprehensive course is designed for developers and professionals worldwide looking to master database management skills. You'll learn through practical, real-world projects that are relevant to global market needs.

Global Perspective/Requirements

Anyone can take this course (no prior knowledge of database management is needed

Direct Support

Get personalized guidance from an experienced instructor

What You'll Learn

Database design and normalization

Advanced SQL queries and optimization

MySQL administration and security

PostgreSQL features and performance

Database backup and recovery

Stored procedures and triggers

Psalm Obiri

Full Stack Developer & Tech Instructor

1000+ Students

5+ Years Experience

4.8 Rating

Experienced developer and instructor with a passion for teaching technology skills to students worldwide. My courses focus on practical, market-relevant skills that you can apply immediately.

Course Curriculum

Database Fundamentals

Learn core database concepts, data types, and basic SQL operations

6 lectures 4 hours

Lecture 1: Database Fundamentals Part 1 0.7h

Lecture 2: Database Fundamentals Part 2 0.7h

Lecture 3: Database Fundamentals Part 3 0.7h

Lecture 4: Database Fundamentals Part 4 0.7h

Lecture 5: Database Fundamentals Part 5 0.7h

Lecture 6: Database Fundamentals Part 6 0.7h

SQL Mastery

Master advanced SQL queries, joins, subqueries, and data manipulation

8 lectures 6 hours

Lecture 1: SQL Mastery Part 1 0.8h

Lecture 2: SQL Mastery Part 2 0.8h

Lecture 3: SQL Mastery Part 3 0.8h

Lecture 4: SQL Mastery Part 4 0.8h

Lecture 5: SQL Mastery Part 5 0.8h

Lecture 6: SQL Mastery Part 6 0.8h

Lecture 7: SQL Mastery Part 7 0.8h

Lecture 8: SQL Mastery Part 8 0.8h

MySQL Administration

Learn MySQL installation, configuration, user management, and security

7 lectures 5 hours

Lecture 1: MySQL Administration Part 1 0.7h

Lecture 2: MySQL Administration Part 2 0.7h

Lecture 3: MySQL Administration Part 3 0.7h

Lecture 4: MySQL Administration Part 4 0.7h

Lecture 5: MySQL Administration Part 5 0.7h

Lecture 6: MySQL Administration Part 6 0.7h

Lecture 7: MySQL Administration Part 7 0.7h

PostgreSQL Features

Explore PostgreSQL advanced features, extensions, and performance

6 lectures 4 hours

Lecture 1: PostgreSQL Features Part 1 0.7h

Lecture 2: PostgreSQL Features Part 2 0.7h

Lecture 3: PostgreSQL Features Part 3 0.7h

Lecture 4: PostgreSQL Features Part 4 0.7h

Lecture 5: PostgreSQL Features Part 5 0.7h

Lecture 6: PostgreSQL Features Part 6 0.7h

Performance Optimization

Learn query optimization, indexing, and database tuning

4 lectures 3 hours

Lecture 1: Performance Optimization Part 1 0.8h

Lecture 2: Performance Optimization Part 2 0.8h

Lecture 3: Performance Optimization Part 3 0.8h

Lecture 4: Performance Optimization Part 4 0.8h

Advanced Database Concepts

Master stored procedures, triggers, transactions, and backup strategies

4 lectures 4 hours

Lecture 1: Advanced Database Concepts Part 1 1h

Lecture 2: Advanced Database Concepts Part 2 1h

Lecture 3: Advanced Database Concepts Part 3 1h

Lecture 4: Advanced Database Concepts Part 4 1h

Database Management with MySQL & PostgreSQL