Database Management

This course will first introduce you to the fundamental concepts of database. You will learn its importance in storage, management, and retrieval of information. The course will discuss Structured Query Language (SQL), Database Management System (DBMS), and Relational Database Management System (RDMS). You will study the SQL Server Management Studio (SSMS) and how Graphical User Interface (GUI) can be used to manage an SQL Server, its databases, and the content contained within the databases.

Course Overview

You will then look into the relational concepts of databases, study the process of organizing data in a database through Normalization, and see how the different normal forms impact the organization of data in a database. You will learn how referential integrity can ensure the consistency of data contained in the database. The course will also discuss constraints, datatype including categories, Unicode, implicit and explicit data types, database objects, and DDL statements. Every organization needs a database to store, manage, and retrieve important information. This course will give a solid introduction to the real-life uses of databases. This is a skill and knowledge set that will greatly enhance your résumé and your career path, and make you a highly valuable employee for a wider range of companies. So why wait? Start you next learning journey, today.

What you’ll learn
  • Describe a database and give an example of real life uses.
  • List common database terms and explain their part in a database.
  • Describe normalization and different forms.
  • Describe referential integrity.
  • Recognize how constraints are part of referential integrity.
  • Describe different data types.
  • Discuss how to create a basic database.
  • Describe Data Definition Language (DDL) statements for creating databases.
Requirements
  • Basic proficiency in the English language, numeracy and computer literacy.
  • Candidates must have access to either a computer or smartphone with internet connectivity.
  • Candidate must be equipped with quality webcam or headphones.
Duration & Fees
  • Regular – 4 Weeks – ₦150,000
  • Fast-Track – 3 Weeks – ₦225,000
Program Dates
  • August – October, 2024
  • October – December, 2024
  • February – April, 2025
  • May – July, 2025