Description
What will you learn in the course?
- Demonstrate mastery of SQL syntax and explain how it is used to interact with a database.
- Create databases from scratch and learn how to add, manage, and optimize databases.
- Write database-based applications in Python to connect clients to MySQL databases.
- Develop practical knowledge of advanced data modeling concepts.
Preparing for a Career in Data Engineering
- Get high-level professional training from Meta
- Demonstrate your skills in portfolio-ready projects
- Earn an employer-recognized professional certificate from Meta
- Be eligible for in-demand positions such as: Database Engineer, Data Engineer, Junior Data Engineer
Professional Certificate – 9 Course Series
Want to get started in the world of database engineering? This program is delivered by industry-recognized experts from Meta. You'll learn the key skills needed to create, manage, and manipulate databases, along with industry-standard programming languages and software like SQL, Python, and Django, which are used to support top websites and apps like Facebook, Instagram, and more.
In this program, you will learn:
- Core techniques and methods for building and managing databases.
- Advanced techniques for writing database-based applications and advanced data modeling concepts.
- MySQL Database Management System (DBMS) and data creation, queries, and manipulations.
- How to program and use Python syntax.
- How to prepare for technical interviews for database engineer roles.
Hands-on Learning Project
You will complete a series of 5 projects in which you will demonstrate your mastery of various aspects of database engineering.
You'll demonstrate your skills in database normalization by building your own relational database, defining relationships between entities, and developing a relational schema.
Next, in the Stored Procedure project, you'll demonstrate your ability in SQL automation by writing a stored procedure to solve real-world problems. After developing your Python skills, you'll create a Python application to manage a MySQL database and program its interaction with clients.
In the next project, you'll apply data modeling to a realistic project by using advanced data modeling concepts like automation, storage, and optimization.
Finally, you'll be asked to create a MySQL database solution for an app using the knowledge and skills you've acquired during the program.
Course List
Introduction to Databases
Course 1
• 27 hours
• Rating: 4.7 (1,123 ratings)
What you'll learn
- Concepts and principles that form the basis of database operation.
- Planning and execution of a simple database development project.
Skills you will acquire
- Version control
- GitHub
- Bash (Unix shell)
- Web Development
- Linux
Version control
Course 2
• 13 hours
• Rating: 4.6 (3,247 ratings)
What you'll learn
- Implementation of version control systems.
- Navigation and settings at the command prompt.
- Using a GitHub repository and creating a GitHub repository.
- Code versioning.
Skills you will acquire
- Database Design (DB)
- Database Management System (DBMS)
- MySQL
Database Structures and Management with MySQL
Course 3
• 32 hours
• Rating: 4.8 (424 ratings)
What you'll learn
- Using MySQL DBMS to build and modify relational databases using SQL.
- Establishing connections between tables using Primary and Foreign Keys.
Skills you will acquire
- Database Management System (DBMS)
- Database Management
- MySQL
Advanced topics in MySQL
Course 4
• 18 hours
• Rating: 4.6 (208 ratings)
What you'll learn
- Add decision structures and functions to databases in MySQL using SQL functions and operators for numbers and strings.
- SQL automation by writing a stored procedure to solve real-world problems.
Skills you will acquire
- data structure
- computer science
- Algorithms
- communication
- Pseudocode
Programming in Python
Course 5
• 44 hours
• Rating: 4.6 (1,439 ratings)
What you'll learn
- Basic programming skills with Python syntax.
- Use of objects, classes, and methods.
Skills you will acquire
- Data Modeling
- Data Generation, Transformation, and Loading (ETL)
- Data Warehouses
Database Clients
Course 6
• 40 hours
• Rating: 4.4 (82 ratings)
What you'll learn
- Use Python code to create, populate, and manipulate MySQL databases and tables.
- Creating a useful Python application that enables MySQL database management.
Skills you will acquire
- Django (Web Framework)
- Python Programming
- Database Management System (DBMS)
- Data Management
- MySQL
Advanced Data Modeling
Course 7
• 18 hours
• Rating: 4.3 (85 ratings)
What you'll learn
- Deploy basic data modeling skills and navigate modern storage options for data warehouses.
- Demonstrate data modeling skills in a real-world project.
Skills you will acquire
- project management
- Django (Web Framework)
- Database Management System (DBMS)
- Application Development
- MySQL
Final Project for Database Engineers
Course 8
• 18 hours
• Rating: 4.0 (61 ratings)
What you'll learn
- Build a MySQL database solution.
- Deploy advanced ideas to improve the scope of a database project.
Skills you will acquire
- Database Management System (DBMS)
- Database Management
- Relative Databases
- Data Management
- MySQL
Preparing for Programming Interviews
Course 9
• 11 hours
• Rating: 4.6 (527 ratings)
What you'll learn
- Preparation for a programming interview.
- Preparing for an interview on Meta.
- Troubleshooting with code.
Skills you will acquire
- Computer Programming
- Django (Web Framework)
- Python Programming
- Application Programming Interfaces (APIs)
- Cloud Hosting
Reviews
There are no reviews yet.