Certification In

Certification in Database Programming with SQL

Database

80,000.00 (LKR)

Department

School Of Computing

Campus

Colombo Campus

Level

Certification Hub

Duration

60 hours

(Including Theory, Hands On Practical, Exam Prep)

Course Overview

  • Certification in Database Programming with SQL.
  • 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.

Course Structure and Modules

  • Introduction
  • SELECT and WHERE
  • WHERE, ORDER BY and Intro to Functions
  • Single Row Functions Part 1
  • Single Row Functions Part 2
  • JOINs Part 1
  • JOINs Part 2
  • Group Functions Part 1
  • Group Functions Part 2
  • Subqueries
  • Ensuring Quality Queries Part 1
  • DML
  • DDL
  • Constraints
  • Views
  • Sequences and Synonyms
  • Privileges and Regular Expressions
  • TCL
  • Final Project and Exam Review
  • Ensuring Quality Queries Part 2

NIBM internal students only.

  • Schedule:
  • Delivery Format:
  • Practical Labs and Hands-on Experience:
  • Program Fees:
  • Hours:
  • Course Director: Contact for details