technifyed

Meta via Coursera

Database Engineer Capstone

3.967 ratings at Coursera

Overview

In this course you’ll complete a capstone project in which you’ll create a database and client for Little Lemon restaurant.

To complete this course, you will need database engineering experience.

The Capstone project enables you to demonstrate multiple skills from the Certificate by solving an authentic real-world problem. Each module includes a brief recap of, and links to, content that you have covered in previous courses in this program.

In this course, you will demonstrate your new skillset by designing and composing a database solution, combining all the skills and technologies you've learned throughout this program to solve the problem at hand.

By the end of this course, you’ll have proven your ability to:

-Set up a database project,

-Add sales reports,

-Create a table booking system,

-Work with data analytics and visualization,

-And create a database client.

You’ll also demonstrate your ability with the following tools and software:

-Git,

-MySQL Workbench,

-Tableau,

-And Python.

Syllabus 4

  1. Project info 4.5 hours

    This module provides practical hands on experience with using MySQL. Set up a MySQL instance server in MySQL Workbench, then create an ER Diagram data model and implement it in MySQL.

  2. Database queries procedures and prepared statements 4.5 hours

    Use SQL to create virtual tables, stored procedures and prepared statements for Little Lemon restaurant.

  3. Clients and visualization 4 hours

    Visualize the sales data of a restaurant and implement a database client in Python.

  4. Project Assessment 5 hours

    Complete a peer review of the Little Lemon database project and reflect on what you have learned.

Skills you'll practise

DatabasesMySQLMySQL WorkbenchPython ProgrammingTableau SoftwareComputer ProgrammingSQLDatabase DesignLeadership and Management

Advantages and disadvantages

Advantages

  • Structured courses with graded quizzes, assignments and deadlines you can reset.
  • A shareable certificate from the university or company when you pay.
  • Financial aid is often approved for students in India (apply 15 days before you need it).
  • From Meta, a well-regarded name.
  • Self-paced: start any time.
  • A clear syllabus (4 parts) you can see before you start.
  • Hands-on: you build or practise, not just watch.

Disadvantages

  • Paid after a 7-day free trial (Coursera Plus or per course).
  • Some courses can be audited for free, but graded work and certificates need payment.
  • Learners rate it 3.9 out of 5, lower than most.

Some points apply to every course of this kind; see how we rank.

This course is paid. Here is how to take it for free

  • Free trials: You can start a 7-day free trial for many individual courses, Specializations, or a Coursera Plus subscription to test full course features. Cancel before the seventh day if you do not want to be charged.
  • Financial aid: If you cannot afford the fee for a certificate, you can apply for financial aid through the link on the course home page by filling out an application about your background and goals.

Taught by

  • Taught by Meta Experts

Meta is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (84/100).

Similar courses

Compare these

Harvard University · YouTube

CS50's Web Programming with Python and JavaScript (CS50W) 2020

This is CS50W, CS50's Web Programming with Python and JavaScript. Register for free at https://cs50.edx.org/web. Slides and source code at https://cs50.harvard.edu/web. This course picks up where Harvard University’s CS50 leaves off, diving more deeply into the design and implementation of web apps…

Free video10 videos, 14 hours

Harvard University · YouTube

CS50's Web Programming with Python and JavaScript

Learning objectives This course picks up where Harvard University's CS50 leaves off, diving more deeply into the design and implementation of web apps with Python, JavaScript, and SQL using frameworks like Flask, Django, and Bootstrap. Topics include database design, scalability, security, and user…

Free video13 videos, 20 hours

Harvard University · edX

Fundamentals of TinyML

4.567 ratings

Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.

Free to audit5 weeks, 2 - 4 hours per week

Harvard University · edX

Introduction to Data Science with Python

4.3174 ratings

Learn the concepts and techniques that make up the foundation of data science and machine learning.

Free to audit8 weeks, 3 - 5 hours per week

Harvard University · edX

CS50's Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Free to audit12 weeks, 5 - 14 hours per week

Harvard University · edX

Data Science: Building Machine Learning Models

4.4133 ratings

Build a movie recommendation system and learn the science behind one of the most popular and successful data science techniques.

Free to audit8 weeks, 2 - 3 hours per week

Enter your email and the official page opens. Phone is optional.