Database Management

Learn how to properly manage and analyze complex databases using SQL

What you'll learn

Understand the Importance of Information & Data Management in Business
Translate business requirements into database diagrams
How to Install, configure and deploy different databases
elaborate on data storage and indexing options, and perform query optimization
understanding the life cycle of the relational database
Build your own Business Critical Database
Write SQL code based on Queries standards to build and maintain database structures and data
discuss the physical database design process of producing an efficient and tuned database transform an E-R diagram into a relational model, and use normalization to create a database relational schema

Introduction

Databases are used in applications or devices with software that stores and retrieves information. Applications like Facebook, Twitter,Instagram,Pinterest,Snapchat,Google Hotmail Mobile phones and other portable devices all have the ability to store and retrieve data. They all are able to achieve this using a database. Places like Banks,Hospitals,Airlines Supermarkets all use databases to store and retrieve data or information. Things like your Social security number ,Hospital Records number or Bank account number are all stored in a database .

Requirements

  • Basic Computer Knowledge
  • Some familiarity with computers and programming will be great but not required
  • Personal Laptop or Flashdrive if you don't have Laptop
  • Desire to learn
  • About This Course

    In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle or MySQL to execute SQL statements and a database diagramming tool such as the ER Assistant to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle or MySQL.

    Course Outline

  • Introduction to Database Systems
  • Data Modeling: The Entity-Relationship Diagram
  • The Relational Model and Normalization
  • Physical Database Design
  • SQL - A Standard Navigation Language for Relational Databases
  • Introduction to Data Warehousing
  • Data Quality and Database Administration
  • Overview of Object-Oriented Databases
  • Lab Project
  • Job Outlook

  • Career prospects for people with similar training include Web Developer, IT Officer, Application Developer, Software developer, Software tester, Data Analyst, Sales Analyst, DB Administrator.
  • The median salary for entry level for Database jobs in Cameroon is 300,000 FCFA per Month.
  • Course Benefits

  • Lab Project
  • Take Home Exercises
  • Lunch
  • Internship Opportunity
  • Certificate of Completion
  • Who is the target audience?

  • Anyone who works and want to work with data and information industries!
  • Those who work in organizations where the company typically uses database, software and apps.
  • Primary, Secondary School Students
  • Those who want to booast their CV or Advance their Career.
  • Graduate Trainee

  • Apply Now
    TOP