Master the art of building reliable, scalable, and secure database systems. This training equips learners with essential skills in data modeling, SQL programming, performance tuning, and core database administration practices used in professional environments.
Who Should Enroll:
- Software engineers & developers
- Aspiring database administrators (DBAs)
- IT undergraduates or recent graduates in computing
- Data professionals transitioning into backend systems
Prerequisites:
Basic knowledge of IT
Trainer:
Rasan Samarasinghe (Profile)
Training Fee:
Rs. 18,000.00 per participant (Method of payment)
Delivery:
Online with live sessions or self-paced
Duration:
18 hours
Medium:
English
Certification:
Digital certification with the transcript upon completion
Course Modules & Structure:
1: Introduction to Databases
- Purpose of databases in modern applications
- Types of databases: Relational, NoSQL, In-memory
- DBMS vs. RDBMS fundamentals
- Tools overview: MySQL, PostgreSQL, SQLite
- Hands-on: Explore a sample database using GUI tools (phpMyAdmin or DBeaver)
2: Data Modeling & ER Diagrams
- Concepts: Entities, attributes, and relationships
- Keys: Primary, foreign, and composite
- Drawing ER diagrams
- Mapping ER diagrams to relational schemas
- Hands-on: Model a real-world use case (e.g., Library or Inventory)
3: Relational Theory & Normalization
- Tables, records, constraints
- Data anomalies & normalization (1NF to 3NF)
- Denormalization: when and why
- Hands-on: Refactor an unstructured database into a normalized schema
4: SQL for Data Retrieval
- Basic SELECT queries and filtering
- Aggregate functions: COUNT, SUM, AVG
- GROUP BY, HAVING, sorting
- Hands-on: Write meaningful queries on sample datasets
5: SQL for Data Modification
- INSERT, UPDATE, DELETE syntax
- Transactions, ACID properties
- COMMIT and ROLLBACK concepts
- Hands-on: Manage transactional workflows
6: Joins & Subqueries
- INNER, LEFT, RIGHT, FULL JOIN
- Scalar, correlated, and nested subqueries
- Introduction to Common Table Expressions (CTEs)
- Hands-on: Multi-table queries with joins and subqueries
7: Database Design & Implementation
- Translating business requirements into schemas
- Table creation, data types, and constraints
- Indexing strategies
- Enforcing relationships with keys
- Hands-on: End-to-end schema implementation from requirements
8: Views, Stored Procedures & Triggers
- Use cases for views
- Writing reusable stored procedures
- Automating tasks with triggers
- Hands-on: Create a trigger to log data changes
9: Administration, Users & Security
- User roles and privilege management
- Granting/revoking permissions
- SQL injection: prevention and mitigation
- Hands-on: Secure a database environment using best practices
10: Final Project – Full Database Lifecycle
- Analyze a real-world scenario
- Create ER models and normalize schema
- Implement, test, and query the database
- Present a working solution with documentation
Request this Training
We schedule our trainings based on the requests we receive. Whether you’re an individual or a team, fill out the form below to request this course. We’ll get back to you with available dates or a custom session – group or one-on-one. Learn more.