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.

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.

In this course, you will be introduced to foundational programming skills with basic Python Syntax. You’ll learn how to use code to solve problems. You’ll dive deep into the Python ecosystem and learn popular modules, libraries and tools for Python. 

You’ll also get hands-on with objects, classes and methods in Python, and utilize variables, data types, control flow and loops, functions and data structures. You’ll learn how to recognize and handle errors and you’ll write unit tests for your Python code and practice test-driven development.

By the end of this course, you will be able to:
•	Prepare your computer system for Python programming
•	Show understanding of Python syntax and how to control the flow of code
•	Demonstrate knowledge of how to handle errors and exceptions
•	Explain object-oriented programming and the major concepts associated with it
•	Explain the importance of testing in Python, and when to apply particular methods

This is a beginner course for learners who would like to prepare themselves for a career in back-end development or database engineering. To succeed in this course, you do not need prior web development experience, only basic internet navigation skills and an eagerness to get started with coding.

Programming in Python

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.

Database Clients

Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration.  

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

The Professional Certificates create opportunities so that anyone regardless of education, background or experience can learn high-quality skills to land a high-growth career—no degree or experience required to get started. 
 
By the end of this course, you’ll be able to:  
 
- Deploy basic data modeling skills and navigate modern storage options for a data warehouse 
- Apply planning and execution of ETL style database engineering by building upon existing MySQL skills 
- Develop a working knowledge of the different aspects of managing a database including administration of database operations and concerns, alongside processes and solutions for monitoring, reporting and debugging  
- Demonstrate data modeling skills within a real-world project environment 
 
You’ll gain experience with the following tools and software: 
 
- Workbench data modeling software 
- Syntaxes used to interact with a data warehouse 
- Extract, transform and loading (ETL) techniques and methods 
- MySQL data warehouse administration 
- Data warehouse monitoring and reporting tools 
- Database debugging and testing tools 
- Data modeling tools

Advanced Data Modeling

Learn how modern software developers collaborate across the world without messing up each other's code. You will look at the different version control systems and how to create an effective software development workflow. You will be introduced to some of the most commonly used Linux commands that you can use to work with files on your hard drive and create powerful workflows that will automate your work, saving you time and effort. 

Finally, you will see how Git can be used in software development projects to manage team files. And you will create a repository that can manage code revisions.

Version Control

Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. 
 
By the end of this course, you’ll be able to: 
 
- Utilize the MySQL DBMS to build and modify relational databases with SQL 
- Add records to a MySQL database 
- Perform intricate queries on database records with filters and groupings 
- Create simple joins and unions within a database 
- Create relationships between tables using primary and foreign keys 
- Demonstrate the ability to complete a database normalization project

You’ll gain experience with the following tools and software: 
 
- MySQL DBMS 
- Joins and Unions 
- SQL statements, clauses and data types 
- Primary and foreign keys 
- Database normalization

Database Structures and Management with MySQL

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.

Database Engineer Capstone

The final course in this program will help prepare you for the unique aspects of a coding job interview, with approaches to problem-solving and computer science foundations needed to land the job. Ultimately you’ll gain strategic insights and tips for successful interviewing. 

By the end of this course, you'll have knowledge of:
•  Appropriate communication during a coding interview
•  Successful interviewing strategies
• Using pseudocode
•  The fundamentals of computer science
• The capabilities of data structures and how to implement them
• How to review data structures in the context of coding interviews
•  The concept of algorithms and common approaches to working with them
•  How to visualize an algorithm
•  Combining new and previously learned coding patterns to solve problems

Ideally, you should have completed all the courses in this professional certificate.

Coding Interview Preparation

In this course, you will be introduced to databases and explore the modern ways in which they are used. Learn to distinguish between different types of database management systems then practice basic creation and data selection with the use of Structured Query Language (SQL) commands. 
 
By the end of this course, you’ll be able to: 

- Demonstrate a working knowledge of the concepts and principles that underpin how databases work
- Identify and explain the different types of core technology and management systems used in
   databases
- Identify and interpret basic SQL statements and commands
- Manipulate records in a database with the use of SQL statements and commands
- Outline alternatives to SQL
- and plan and design a simple relational database system

You’ll also gain experience with the following:

• Fundamental concepts in database 
• Basic MySQL syntax and commands
• Database management systems
• MySQL software
• Relational databases

Introduction to Databases

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering.

By the end of this course, you'll be able to:

- Use control statements and variables in different contexts in MySQL
- Develop user defined functions and procedures
- Optimize MySQL database queries
- Demonstrate a working knowledge of common table expressions and the JSON data type
- Understand how and when to use triggers and events
- Utilize subqueries, JOINS, views and transactions to perform data analysis
- and use database optimization techniques such as MySQL transactions

You'll gain experience with the following advanced MySQL database skills:

- MySQL user defined functions
- Advanced MySQL stored procedures
- MySQL optimization techniques including Indexes, Transactions, CTE and JSON
- MySQL triggers and events
- Database analytics in MySQL
- Advanced SQL queries for data analysis with JOINS, views and subqueries

Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects.

To be successful in this course, you should have already completed the previous course, “Database Structures and Management with MySQL,” or have prior experience with the skills taught in that course.

Meta Database Engineer

About the Program

Description

Deliverables

0 Credits

Academic Excellence

Akamai Network Engineering$399

IBM Data Warehouse Engineer$399

Google IT Automation with Python$399

Google IT Support$399

IBM Data Engineering$399

IBM Full Stack Software Developer$399

IBM Cybersecurity Analyst$399

Akamai Consulting and Support$399

IBM IT Support$399

Information Technology Specialist: Networking$251.37