Database Design and Programming with SQL

This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information.

Home  /  Programmes Offered  /  ICT  /  Database Design and Programming with SQL

Introduction


This course engages students to analyze complex business scenarios and create a data model—a conceptual representation of an organization’s information. Participants implement their database design by creating a physical database using SQL. Basic SQL syntax and the rules for constructing valid SQL statements are reviewed. This course culminates with a project that challenges students to design, implement, and demonstrate a database solution for a business or organization.

Sound good? Change your life.

Apply Now

Overview

Topics to be treated include  – Introduction, SELECT and WHERE, WHERE, ORDER BY, and Intro to Functions, Single Row Functions Part I, Single Row Functions Part II, JOINs Part I, JOINs Part II, Group Functions Part I, Group Functions Part II, Subqueries, Ensuring Quality Queries Part I, DML, DDL, Constraints, Views, Sequences and Synonyms, Privileges and Regular Expressions, TCL, Final Project, and Exam Review, Ensuring Quality Queries Part II 

Apply Now

BLUECREST COLLEGE ACCRA CAMPUS:

Cola Street, Near ATTC, 

Adjacent Societe Generale 

Head Office, Kokomlemle, 

P.O. Box AN18392, Accra

BlueCrest Ghana 

Cola Street, Near ATTC, Adjacent Societe. Generale Head Office, Kokomlemle,    

P.O. Box AN 18392, Accra   Email: contactus@bluecrest.edu.gh   

Tel: +233 (0)30-2250649 / (0)30-2251150 / (0)30-2251151, (0)28-9116315, (0)28-9116316