Meta Database Engineer Professional Certificate

Coursera – Advanced Data Modeling 2023-5

Week 1

Course Introduction
1 Introduction to Advanced Data Modeling
2 How is data modeling used at Meta
3 Course syllabus for Advanced Data Modeling
4 How to be successful in this course
5 Course requirements
6 Additional resources

Database modeling
7 Overview of data modeling
8 Types of data models
9 Data model example
10 Recap Normalization of relational database models
11 Exercise Design a database model for this scenario
12 Solution Design a database model for this scenario
13 Additional resources

MySQL Workbench WB
14 Introduction to MySQL Workbench
15 Installing MySQL Workbench
16 Data management in MySQL Workbench
17 Database modeling in MySQL Workbench
18 MySQL Workbench for data modeling and data management
19 Exercise Design a database model in MySQL Workbench
20 Solution Design a database model in MySQL Workbench
21 Module summary Data modeling and management
22 Additional resources

Week 2

What is a data warehouse
23 Overview of data warehousing
24 Data warehouse architecture
25 The data warehouse Extract Transform and Load ETL process
26 Case Study Real world data project
27 ETL testing
28 Additional resources

Dimensional data modeling
29 Fundamentals of dimensional data modeling
30 OLAP cubes
31 Dimensional data modeling in practice
32 Exercise Create a dimensional data model
33 Solution Create a dimensional data model
34 Module summary Data warehousing
35 Additional resources

Week 3

Introduction to data analytics
36 Overview of data analytics
37 Data mining versus machine learning
38 The value of data insights in business
39 Overview of data visualization
40 Additional resources

Advanced data analytics in practice
41 Using advanced analytic tools for data analysis
42 Getting started with Tableau
43 Data import and data preparation in Tableau
44 Data filtering and visualization in Tableau
45 Create an interactive dashboard
46 Exercise Data analysis in Tableau
47 Solution Data analysis in Tableau
48 Module summary Advanced data analytics
49 Additional resources

Week 4

Final project assessment
50 Course recap for Advanced Data Modeling
51 About the final project assessment
52 Exercise Data modeling project
53 Solution Data modeling project

Course wrapup
54 Congratulations you have completed Advanced Data Modeling
55 Next steps after completing Advanced Data Modeling

Coursera – Advanced MySQL Topics 2023-5

Week 1

Course Introduction
56 Introduction to advanced MySQL topics
57 Course syllabus Advanced MySQL
58 How to be successful in this course
59 How to access the MySQL environment

Advanced MySQL functions and stored procedures
60 Functions and stored procedures in MySQL
61 Variables and parameters
62 Developing userdefined functions
63 Create complex stored procedures
64 Differences between functions and stored procedures
65 Solution Developing functions in MySQL
66 Additional resources

MySQL triggers and events
67 What are MySQL triggers
68 Types of MySQL triggers
69 Create and drop triggers in MySQL
70 Working with MySQL Scheduled Events
71 Overview of MySQL triggers
72 Solution Working with triggers
73 Module summary Functions and triggers
74 Additional resources

Week 2

Optimizing database queries
75 Overview of database optimization
76 Optimizing database SELECT statements
77 Optimizing database SELECT statements in practice
78 Database optimization in practice with SELECT statements
79 Indexes in MySQL
80 Database optimization in practice with indexes
81 Solution SELECT statement optimization in MySQL
82 Additional resources

Further optimization techniques
83 MySQL Transaction
84 MySQL Common table expression CTE
85 MySQL Prepared Statement
86 MySQL JSON
87 Further optimization techniques
88 Solution MySQL optimization techniques exercise
89 Module summary Database optimization
90 Additional resources

Week 3

Evaluating MySQL for data analysis
91 Overview of database analytics
92 Using MySQL for data analysis
93 How MySQL is used with advanced data analytics tools
94 Additional resources

Performing data analysis in MySQL
95 Data analysis in MySQL using SQL queries
96 Emulating the Full Outer JOIN in MySQL
97 Extracting data from multiple tables with JOINS
98 Solution Data analysis in MySQL
99 Module summary MySQL for data analytics
100 Additional resources

Week 4

Graded assessment
101 Course Recap Advanced MySQL
102 About the final graded assessment
103 Solution Conduct a data analysis for a client persona

Course wrap up
104 Course wrap up
105 Next steps

Coursera – Database Clients 2023-5

Week 1

Course Introduction
106 Introduction to the course Database clients
107 Database clients
108 How databases are used in programming
109 Database engineering at Meta
110 Course syllabus
111 How to be successful in this course
112 Course requirements
113 Working with labs in this course
114 Additional resources

Establishing a MySQLPython connection and creating tables
115 MySQLPython connection
116 Overview of pip
117 Installation and setup
118 OS specific instructions
119 Connecting to a MySQL database using a Python client
120 Python and MySQL connections
121 Creating a database and tables in a MySQL database using Python
122 Additional resources

Working with cursors
123 Cursors and MySQL
124 Cursor subclasses
125 Module summary Interacting with MySQL using Python
126 Additional resources

Week 2

Performing Create Read Update and Delete CRUD operations
127 Creating and reading data in a MySQL database using Python
128 Updating and deleting records in a MySQL database using python
129 Additional resources

Advanced Queries in MySQL database using Python
130 Filtering and sorting data in MySQL using Python
131 Joining data from different tables in MySQL database using python
132 Module summary Performing advanced queries on a MySQL database using Python
133 Additional resources

Week 3

Implementing MySQL functions using Python
134 A quick review of MySQL Functions
135 Accessing MySQL functions using Python
136 Accessing functions
137 Working with datetime functions in Python
138 Additional resources

Accessing MySQL stored procedures using Python
139 A quick review of stored procedures
140 Accessing stored procedures using Python
141 Additional resources

Working with connection pools
142 Database connection pooling
143 Python MySQL connection pool
144 Module summary Advanced Database Clients
145 Additional resources

Week 4

Final project
146 Course Recap Database Clients
147 About the final project assessment
148 Set up the database
149 Implement and query stored procedures
150 Little Lemon analysis and sales report
151 Exemplar Little Lemon analysis and sales report

Course wrap up
152 Course wrap up
153 Next steps

Coursera – Database Engineer Capstone 2023-5

Week 1

Course introduction
154 Introduction to the course
155 Introduction to the technical recruitment process
156 Course syllabus
157 How to be successful in this course
158 Additional resources

Project info
159 Introduction to the course
160 Course syllabus
161 How to be successful in this course
162 Checking your project environment
163 Additional resources

Setting up the Project
164 Project overview and set up
165 Recap Version control
166 Exercise Setting up the repository
167 Recap Database setup in MySQL Workbench and SQL basics
168 Exercise Set up the MySQL instance server in MySQL Workbench
169 Recap Creating an Entity Relationship Model in MySQL Workbench
170 Exercise Create an ER diagram data model and implement it in MySQL
171 Exercise Committing the project
172 Module summary
173 Additional resources

The coding interview
174 What is a coding interview
175 What type of interviews might you expect
176 Communication
177 What to expect from a technical interview
178 Pseudocode step by step
179 Interview tips
180 Testing your solution
181 Additional resources

Introduction to Computer Science
182 Binary
183 Working in binary
184 Memory
185 Defining solutions
186 Time complexity
187 Working with time complexity
188 Space complexity
189 Module summary Introduction to the coding interview
190 Additional resources

Week 2

Adding sales reports
191 Creating report queries for Little Lemon sales data
192 Recap MySQL virtual tables and JOINS
193 Exercise Create a virtual table to summarize data
194 Recap MySQL query optimization with stored procedures and Prepared Statements
195 Exercise Create optimized queries to manage and analyze data
196 Additional resources

Basic Data Structures
197 Basic data structures
198 Strings
199 Integers
200 Booleans
201 Arrays
202 Objects
203 Additional resources

Collection Data Structures
204 Lists and sets
205 Lists and sets in different programming languages
206 Stacks and queues
207 Stacks and queues in different programming languages
208 Trees
209 Trees in different programming languages
210 Additional resources

Table booking system
211 Develop a table booking system
212 Recap SQL queries and transactions
213 Exercise Create SQL queries to check available bookings based on user input
214 Exercise Create SQL queries to add and update bookings
215 Module summary
216 Additional resources

Advanced Data Structures
217 Hash tables
218 Hash tables in different programming languages
219 Heaps
220 Graphs
221 Heaps and graphs in different programming languages
222 Module summary Introduction to data structures
223 Additional resources

Week 3

Data visualization
224 Data analytics and visualization
225 Recap Working with Tableau
226 Exercise Set up the Tableau Workspace for data analysis
227 Exercise Create interactive dashboard for sales and profits
228 Additional resources

Sorting and Searching
229 Sorting Algorithms
230 Time and space complexity in sorting algorithms
231 Searching Algorithms
232 Time and space complexity in search algorithms
233 Additional resources

Database client
234 Creating a database client
235 Recap Python and database clients
236 Exercise Set up the client project
237 Exercise Add query functions
238 Module summary
239 Additional resources

Working with Algorithms
240 Divide and conquer
241 Recursion
242 Dynamic programming
243 Greedy algorithms
244 Module summary Introduction to algorithms
245 Additional resources

Week 4

Final graded assessment
246 Course recap
247 About the final graded assessment

Final project assessment
248 Course recap for Capstone project
249 About the final project assessment
250 Exemplar Little Lemon database

Course wrap up
251 Course wrap up
252 Next steps

Course wrapup
253 Congratulations you have completed the Capstone project
254 Next steps

Coursera – Database Structures and Management with MySQL 2023-5

Week 1

Course Introduction
255 Introduction to the program
256 Introduction to the course
257 How Meta uses MySQL
258 Course syllabus Database structures and management with MySQL
259 How to be successful in this course
260 Recap of Course 1 concepts
261 How to access MySQL Environment
262 Additional resources

Filtering data
263 Filtering data using AND OR and NOT logical operators
264 Filtering data using IN BETWEEN and LIKE logical operators
265 Filtering data Exercise solution
266 Additional resources
267 Reading exercise Filtering data examples Optional
268 Reading exercise Filtering data examples Exercise solution
269 Reference sheet Using operators and the WHERE clause

Joining Tables
270 MySQL aliases
271 Joining tables
272 JOINS
273 INNER JOIN
274 LEFT and RIGHT JOIN
275 SELFJOIN
276 MySQL UNION operator
277 Practice using JOINS Exercise solution
278 Additional resources

Grouping Data
279 MySQL GROUP BY
280 MySQL HAVING
281 Grouping data Exercise solution
282 Module summary Intro to MySQL
283 Additional resources
284 Reading exercise Operators and clauses Optional
285 Reading exercise Operators and clauses Exercise solution
286 Reference sheet Operators and clauses

Week 2

Updating and inserting data
287 MySQL REPLACE statement
288 MySQL REPLACE statement in depth
289 MySQL REPLACE statement Exercise solution
290 Additional resources
291 Reading exercise REPLACE INTO statement Optional
292 Reading exercise REPLACE INTO statement Exercise solution

Constraints
293 Constraints in MySQL
294 Constraints in practice
295 Types of MySQL constraints
296 Working with constraints Exercise solution
297 Additional resources
298 Reading exercise MySQL constraints Optional
299 Reading exercise MySQL constraints Exercise solution

Changing table structure
300 MySQL ALTER TABLE
301 MySQL COPY TABLE
302 Changing table structure Exercise solution
303 Additional resources
304 Reading exercise ALTER TABLE statement Optional
305 Reading exercise ALTER TABLE statement Exercise solution
306 Reference sheet ALTER TABLE statement and its uses

Subqueries
307 Subqueries in MySQL
308 Subqueries and complex comparison operators
309 Working with subqueries Exercise solution
310 Additional resources
311 Reading exercise Practicing subqueries Optional
312 Reading exercise Practicing subqueries Exercise solution
313 Reference sheet Subqueries

Virtual Tables
314 MySQL CREATE VIEW
315 Virtual tables in depth
316 Working with views in MySQL Exercise solution
317 Module summary Updating databases and working with views
318 Additional resources
319 Reference sheet Creating virtual tables in MySQL

Week 3

Functions in MySQL
320 Numeric functions
321 String functions
322 Date functions
323 Comparison functions
324 Control flow functions
325 Working with MySQL functions Exercise solution
326 Additional resources
327 Reading exercise Practicing with functions Optional
328 Reading exercise Practicing with functions Exercise solution
329 Reference sheet Functions in MySQL

Procedures
330 Stored procedures in MySQL
331 MySQL stored procedures in depth
332 Working with procedures Exercise solution
333 Module summary Functions and MySQL stored procedures
334 Additional resources

Week 4

Graded Assessment Final project
335 Course Recap
336 About the final graded assessment
337 MySQL database project Exercise solution

Course wrap up
338 Course wrap up
339 Next steps

Coursera – Introduction to Databases 2023-5

Week 1

Course Introduction
340 Introduction to the program
341 Introduction to databases
342 A day in the Life of a Database Engineer
343 Course syllabus Introduction to databases
344 How to be successful in this course

Databases and data
345 What is a database
346 How is data related
347 Relational data example charts
348 Alternative types of databases
349 Database Evolution
350 Additional resources

Intro to SQL
351 What is Structured Query Language
352 SQL usage
353 Advantages of SQL
354 SQL syntax introduction
355 Common SQL Commands
356 Additional resources

Basic database structure
357 What are tables in databases
358 Tables overview
359 Database structure overview
360 Types of keys in a database table
361 Module summary Introduction to Databases
362 Additional resources

Week 2

SQL data types
363 Numeric data types
364 String data types
365 Default values
366 Additional resources

Create and read
367 CREATE and DROP database
368 CREATE TABLE statement
369 ALTER TABLE statement
370 INSERT statement
371 Creating tables
372 SELECT statement
373 INSERT INTO SELECT statement
374 Additional resources

Update and delete
375 Updating data
376 Deleting data
377 Module summary Create Read Update and Delete CRUD Operations
378 Additional resources

Week 3

SQL operators
379 SQL Arithmetic Operators
380 SQL Arithmetic Operator Examples
381 Operators in use
382 SQL Comparison operators
383 SQL Comparison operator examples
384 Additional resources

Sorting and filtering data
385 ORDER BY clause
386 Types of ordering sorting
387 WHERE clause
388 WHERE Clause uses
389 SELECT DISTINCT clause
390 SELECT DISTINCT clause in use
391 Module summary SQL operators and sorting and filtering data
392 Additional resources

Week 4

Designing database schema
393 Database schema
394 Exploring database schema
395 Schema in use
396 Types of database schema
397 Building a schema
398 Additional resources

Relational database design
399 Table relationships
400 Relational model
401 Primary key
402 Foreign key
403 Keys in depth
404 Finding entitites
405 Entity relationship diagrams ERD
406 Additional resources

Database normalization
407 What is database normalization
408 Data normalization
409 First normal form 1NF
410 Second normal form 2NF
411 Third normal form 3NF
412 Module summary Database design
413 Additional resources

Week 5

Graded Assessment
414 Course Recap Introduction to databases

Course wrapup
415 Congratulations you have completed Introduction to databases
416 Next steps after Introduction to Databases

Coursera – Programming in Python 2023-5

Week 1

Course Introduction
417 Introduction to the Course
418 How is Python used in the real world
419 Course syllabus
420 How to be successful in this course

Welcome to Python Programming
421 Introduction to Programming
422 Why Python
423 Visual Studio Code
424 Installing Python paths Optional for Windows Users
425 Installing Python paths Optional for Mac users
426 Required dependencies
427 Environment check for Windows
428 Environment check for Mac
429 Running code Command line VS IDE
430 Python syntax spaces matter
431 Python syntax cheat sheet
432 Commenting code
433 Variables
434 Basic data types
435 Strings
436 Basic Data type and Function Cheatsheet
437 Type casting
438 User input console output
439 Type casting a deeper look
440 Additional resources

Control flow and conditionals
441 Math and logical operators
442 Control flow If else else if
443 Conditional statements
444 Switch statement
445 Looping constructs
446 Looping Constructs Practical Examples
447 Practicing control flow and loops
448 Nested loops and the effect on algorithmic complexity
449 Exercise Use control flow and loops to solve a problem
450 Use control flow and loops to solve a problem solution
451 Module summary Getting started with Python
452 Additional resources

Week 2

Functions and Data Structures
453 Functions
454 Variable scope
455 Function and variable scope
456 What are data structures
457 Lists
458 Tuples
459 Sets
460 Dictionaries
461 kwargs
462 Choosing and using data structures
463 Visual Studio Code on Coursera
464 Additional resources

Errors exceptions and file handling
465 What are exceptions
466 Exception handling
467 Exercise Exceptions in Python
468 Exceptions in Python solution
469 File handling in Python
470 Creating Files
471 Reading Files
472 Storing file contents in data structures
473 Module summary Basic Programming with Python
474 Additional resources

Week 3

Procedural programming
475 What is procedural programming
476 Algorithms
477 Writing Algorithms
478 Exercise Make a cup of coffee
479 Make a cup of coffee solution
480 Algorithmic complexity
481 Intro to BigO notation
482 Additional resources

Functional programming
483 What is functional programming
484 Pure functions
485 Recursion
486 Recursion example Tower of Hanoi
487 Reversing a string on Python
488 Map filter
489 Comprehensions
490 Additional resources

Object Oriented Programming
491 Introduction to Object Oriented Programming
492 OOP Principles
493 Python classes and instances
494 Exercise Define a Class
495 Define a Class solution
496 Instantiate a custom Object
497 Exercise Instantiate a custom Object
498 Instantiate a custom Object solution
499 Instance methods
500 Parent classes vs. child classes
501 Inheritance and Multiple Inheritance
502 Exercise Classes and object exploration
503 Abstract classes and methods
504 Method Resolution Order
505 Working with Methods Examples
506 Exercise Working with Methods
507 Working with Methods solution
508 Module summary Programming paradigms
509 Additional resources

Week 4

Modules
510 What is a module in Python
511 Accessing modules
512 The import statement
513 Writing import statements
514 Namespacing and scoping
515 reload function
516 Module Usecases
517 Additional resources

Popular Packages Libraries and Frameworks
518 Popular packages NumPy pandas Matplotlib etc
519 Popular Packages Examples
520 Data analysis packages
521 Machine learning deep learning and AI PyTorch TensorFlow
522 Big Data and Analysis with Python
523 Python web frameworks
524 Additional Resources

Testing tools
525 What is testing
526 Types of testing
527 Test automation packages
528 Writing tests with PyTest
529 PyTest cheat sheet
530 Testdriven development TDD
531 Applying TDD
532 Module summary Modules packages libraries and tools
533 Additional resources

Week 5

Graded Assessment
534 Course Recap Programming in Python
535 About the EndofCourse Graded Assessment

Course wrap up
536 Congratulations you have completed Programming in Python
537 Next steps after Programming in Python

Coursera – Version Control 2023-5

Week 1

Course Introduction
538 Introduction to the course
539 How do developers collaborate in the real world
540 Course syllabus
541 How to be successful in this course

Introduction to Version Control
542 What is version control
543 Case study how Meta engineers collaborate
544 Version Control Git terminology
545 Systems of version control and tools
546 A history of version control
547 Version control in professional software development
548 A history of revisions
549 Staging vs. Production
550 Module Summary Software collaboration
551 Additional Resources

Week 2

Unix Commands
552 The Command line
553 What are Unix commands
554 Using Bash on Mac Terminal
555 Using Bash on Windows
556 Change directories and list contents
557 Creating and moving directories and files
558 Pipes
559 Redirection
560 Grep
561 Module Summary Command Line
562 Additional Resources

Week 3

Git and Github
563 What is Git and GitHub
564 Installing Git on Windows
565 Installing Git on Mac
566 Create your GitHub account
567 Connecting to GitHub via HTTPS
568 Connecting to GitHub via SSH
569 Creating and cloning a repository
570 How Git works
571 Add and commit
572 Branches
573 Remote vs. local
574 Push and pull
575 Resolving conflicts
576 Example workflow
577 HEAD
578 Diff commands
579 Blame
580 Forking
581 Additional Resources

Create a repository with forking
582 Module Summary Working with Git

Week 4

Graded Assessment
583 Course recap Version Control
584 About this graded assessment
585 Solution Managing a project in GitHub

Course wrap up
586 Congratulations you have completed Version Control
587 Next steps after completing Version Control