Introduction

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

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: Learn the ins and outs of SQL syntax
Generate reports using sales and user data
Analyze data using Aggregate Functions
Run complex queries using MySQL logical operators and string functions
Write all the common SQL joins
Work with large datasets containing thousands of entries
Build a web app using MySQL and NodeJS
Design and implement complex database schemas
Learn to navigate the treacherous world of storing dates and times

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