Learn the fundamentals of database systems, how data is organized, managed, and accessed using relational models, and how to write efficient queries with SQL. Perfect for students, developers, and IT professionals starting with databases.
Features
- Improve MySQL Knowledge
- Learn about normalization
Target audiences
- Diploma Holders
- After A/L Students
Requirements
- Basic knowledge of MySQL
- Basic PHP is an added advantage
Curriculum
- 5 Sections
- 2 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Lesson 1: Introduction to DatabasesTopics Covered: මාතෘකාව 1. What is a database? 2. Database vs. Spreadsheet 3. Types of Databases (Relational, NoSQL, Hierarchical, etc.) 4. Importance of DBMS in modern applications3
- Lesson 2: DBMS Architecture & Models0
- Lesson 3: Relational Model & Keys0
- Lesson 4: SQL Basics (SELECT, INSERT, UPDATE, DELETE)0
- Final Assignment1
FAQs
No. The basic knowledge is enough.
Yes. We provide practical questions and discuss in video sessions.
Instructor
