This course is part of the Meta Database Engineer Professional Certificate

4.4

stars

19 ratings

Taught by Meta Staff

2,556 already enrolled

Offered By

Meta Database Engineer Professional CertificateMeta

About this Course

46,348 recent views

Explore how to write database driven applications in Python by creating various types of clients that connect to MySQL databases using Python code and Python-related MySQL features and tools. 
By the end of this course, you’ll be able to:  
 
- Utilize Python code to create, populate and manipulate MySQL databases and tables 
- Access advanced functionality in MySQL using custom built Python clients 
- Develop working familiarity with advanced topics in MySQL 
- Apply the principles of advanced MySQL topics to problem solving using Python 
- Develop a working knowledge of the methods by which a MySQL database connects to the web via a Django API 
- Create a useful Python application capable of administration of a MySQL database 
 
You’ll gain experience with the following tools and software: 
 
- Python code 
- Python-related MySQL features and tools 
- Django REST framework 
- _meta API

To take this course, you must have completed the previous course Advanced MySQL topics. You must also be eager to continue your journey with coding.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 6 of 9 in the

Meta Database Engineer Professional Certificate

Intermediate Level

To take this course, you must have completed the previous course Advanced MySQL topics. You must also be eager to continue your journey with coding.

Approx. 37 hours to complete

English

What you will learn

Utilize Python code to create, populate and manipulate MySQL databases and tables.
Create a useful Python application capable of administration of a MySQL database.

Skills you will gain

Data Management
Database (DBMS)
Python Programming
MySQL
Django (Web Framework)

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 6 of 9 in the

Meta Database Engineer Professional Certificate

Intermediate Level

To take this course, you must have completed the previous course Advanced MySQL topics. You must also be eager to continue your journey with coding.

Approx. 37 hours to complete

English

Instructor

Instructor rating

4.8/5 (10 Ratings)

Taught by Meta Staff

295,880 Learners

67 Courses

Offered by

Syllabus - What you will learn from this course

Week1

Week 1

11 hours to complete

Interacting with a MySQL database using Python

11 hours to complete

9 videos (Total 41 min), 12 readings, 6 quizzes

9 videos

Introduction to the course: Database clients4mDatabase engineering at Meta5mMySQL/Python connection3mInstallation and setup5mConnecting to a MySQL database using a Python client3mCreating a database and tables in a MySQL database using Python4mCursors and MySQL4mCursor subclasses6mModule summary: Interacting with MySQL using Python4m

12 readings

Database clients10mHow databases are used in programming15mCourse syllabus15mHow to be successful in this course10mCourse requirements10mWorking with labs in this course10mAdditional resources5mOverview of pip30mOS specific instructions30mPython and MySQL connections30mAdditional resources5mAdditional resources5m

6 practice exercises

Self review: Making your MySQL/Python connection12mSelf review: Creating a table structure in a MySQL database using Python12mKnowledge check: Establishing a MySQL and Python connection and creating tables15mSelf review: Working with cursors12mKnowledge check: Cursors15mModule quiz: Interacting with MySQL using Python30m

Week2

Week 2

10 hours to complete

Performing queries in MySQL using Python

10 hours to complete

5 videos (Total 22 min), 2 readings, 7 quizzes

5 videos

Creating and reading data in a MySQL database using Python5mUpdating and deleting records in a MySQL database using python3mFiltering and sorting data in MySQL using Python4mJoining data from different tables in MySQL database using python3mModule summary: Performing advanced queries on a MySQL database using Python3m

2 readings

Additional resources5mAdditional resources5m

7 practice exercises

Self review: Creating and reading records in a MySQL database using Python12mSelf review: Updating and deleting records in a MySQL database using Python12mKnowledge check: Performing create, read, update and delete (CRUD) operations15mSelf review: Filtering and sorting data in a MySQL database using Python12mSelf review: Performing different JOIN operations in MySQL databases using Python12mKnowledge check: Performing advanced queries on a MySQL database using Python15mModule quiz: Performing advanced queries in MySQL using Python30m

Week3

Week 3

11 hours to complete

Advanced Database Clients

11 hours to complete

8 videos (Total 39 min), 4 readings, 8 quizzes

8 videos

A quick review of MySQL Functions5mAccessing MySQL functions using Python5mWorking with datetime functions in Python5mA quick review of stored procedures3mAccessing stored procedures using Python3mDatabase connection pooling3mPython / MySQL connection pool5mModule summary: Advanced Database Clients5m

4 readings

Accessing functions30mAdditional resources5mAdditional resources5mAdditional resources5m

8 practice exercises

Self review: Utilizing MySQL functions with Python12mSelf review: Working with date and time functions in Python9mKnowledge check: Working with MySQL functions in Python15mSelf review: Accessing stored procedures in a MySQL database using Python12mKnowledge Check: Accessing MySQL stored procedures using Python15mSelf review: Working with connection pools12mKnowledge check: Working with connection pools15mModule quiz: Advanced Database Clients30m

Week4

Week 4

4 hours to complete

Working with a Database Client

4 hours to complete

2 videos (Total 6 min), 6 readings, 4 quizzes

2 videos

Course Recap: Database Clients4mCourse wrap up2m

6 readings

About the final project assessment30mSet up the database30mImplement and query stored procedures30mLittle Lemon analysis and sales report30mExemplar: Little Lemon analysis and sales report10mNext steps5m

3 practice exercises

Readiness check: Have you completed the initial setup?3mReadiness check: Have you set up the stored procedures and run the queries?3mFinal graded quiz: Database clients30m

About the Meta Database Engineer Professional Certificate

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more.

Upon completion, you’ll get access to the Meta Career Programs Job Board—a job search platform that connects you with 200+ employers who have committed to sourcing talent through Meta’s certificate programs, as well as career support resources to help you with your job search. In this program, you’ll learn: Core techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts. MySQL database management system (DBMS) and data creation, querying and manipulation. How to code and use Python Syntax How to prepare for technical interviews for database engineer roles. Any third-party trademarks and other intellectual property (including logos and icons) referenced in the learning experience remain the property of their respective owners. Unless specifically identified as such, Coursera’s use of third-party intellectual property does not indicate any relationship, sponsorship, or endorsement between Coursera and the owners of these trademarks or other intellectual property.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

More questions? Visit the Learner Help Center.

Database Clients

About this Course

What you will learn

Skills you will gain