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:

• Google Digital Marketing & E-commerce
• Create a Landing Page using Mailchimp
• Create Digital Marketing Campaign Dashboards in Tableau
• Prepare, Clean, Transform, and Load Data using Power BI
• Get Started With Tableau
• Create a value proposition canvas in Miro
• Introduction to Relational Database and SQL
• Simple Linear Regression for the Absolute Beginner
• Create a website with MailChimp
• Getting started with Microsoft Excel