• Duration 60 minutes
  • Lectures 0
  • Skill level Beginner
  • Quizzes 0
  • Pass parcentages 80
  • Certificate No
  • User Avatar

    Willy Kamau

  • Category:

    Science & Technology

KSh2,000.00
  • 0 enrolled students
  • English

In this guided project, you will get hands-on experience working with a relational database using MySQL Workbench from Oracle. The […]

Introduction to Relational Database and SQL

In this guided project, you will get hands-on experience working with a relational database using MySQL Workbench from Oracle. The basic knowledge you learn will allow you to work with any other relational database. At the end of this project, you will be able to create a billing report and a club member roster.

In this Guided Project, you will:

  • Understand tables, the fundamental units in a relational database
  • Write basic SQL statements to query and maintain relational database

60 minutes

Beginner

No download needed

Split-screen video

English

Desktop only

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Know what tables are and write basic SELECT statements
  2. Use wildcard characters for pattern matching, and sort query results
  3. Add data to a database with INSERT statements
  4. Delete data from a database with DELETE statements
  5. Join tables together to produce meaningful reports

 

Note: This is part of the larger overall course Digital Marketer. To complete it fully, you will need to complete all of the following courses:

Main Content