Certification in
Database Programming with SQL
Course Overview
- Certification in Database Programming with SQL
- NIBM internal students only.
- This comprehensive course provides foundational knowledge in SQL programming, database queries, data manipulation, and database management. Students will learn essential SQL programming skills including queries, functions, joins, DML, DDL, constraints, and database administration. The course is designed for individuals seeking to develop their SQL programming capabilities and prepare for database development roles.
Department
SCHOOL OF COMPUTING
Campus
Colombo Campus
Level
Certification Hub
Method
-
Delivery Format
-
Practical Labs
-
Duration
-
Medium
-
Ready to Start Your SQL Programming Journey?
Join our comprehensive Database Programming with SQL course and develop essential SQL programming skills. Learn queries, functions, joins, DML, DDL, and constraints for database development careers.
Course Structure and Modules
1. Introduction
2. SELECT and WHERE
3. WHERE, ORDER BY and Intro to Functions
4. Single Row Functions Part 1
5. Single Row Functions Part 2
6. JOINs Part 1
7. JOINs Part 2
8. Group Functions Part 1
9. Group Functions Part 2
10. Subqueries
11. Ensuring Quality Queries Part 1
12. DML
13. DDL
14. Constraints
15. Views
16. Sequences and Synonyms
17. Privileges and Regular Expressions
18. TCL
19. Final Project and Exam Review
20. Ensuring Quality Queries Part 2
Entry Requirements
NIBM internal students only.
Commencement
Lecture Schedule
- Schedule: -
- Delivery Format: -
- Practical Labs and Hands-on Experience: -
- Program Fees: -
- Hours: -
- Course Director: Contact for details