Course

Credit Type:
Course
ACE ID:
FBOK-0004
Version:
1
Organization:
Coursera Inc.
Location:
Online
Length:
24 weeks (144 hours)
Minimum Passing Score:
80
ACE Credit Recommendation Period:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 Data Visualization with Tableau
Lower-Division Baccalaureate 3 Introduction to Databases
Lower-Division Baccalaureate 3 Introduction to Programming with Python
Lower-Division Baccalaureate 1 Computer Science Seminar
Description

Objective:

This course is offered through Coursera, which is an ACE Authorized Instructional Platform.

The course objective is to 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; and how to prepare for technical interviews for database engineer roles.

Learning Outcomes:

  • Demonstrate proficiency of SQL syntax and explain how it is used to interact with a database
  • Write database driven applications in Python to connect clients to MySQL databases
  • Create databases from scratch and learn how to add, manage and optimize your database
  • Develop a working knowledge of advanced data modeling concepts

General Topics:

  • Introduction to databases
  • Create, Read, Update and Delete (CRUD) Operations
  • Database design
  • Introduction to Databases
  • SQL operators and sorting and filtering data
  • Command Line
  • Software collaboration
  • Working with Git
  • Functions and MySQL stored procedures
  • Introduction to MySQL
  • Updating databases and working with views
  • Advanced MySQL
  • Database optimization
  • Functions and triggers
  • MySQL for data analytics
  • Abstract Classes and Methods
  • Using Python
  • Functions, loops and data structures
  • Import and Scope
  • Mapping key-values to Dictionary data structures
  • Basic Programming with Python
  • Getting started with Python
  • Modules, packages, libraries and tools
  • Programming Paradigms
  • Read in data, store, manipulate and output new data to a file
  • Type casting input
  • Database Clients
  • Advanced Database Clients
  • Interacting with MySQL Using Python
  • Performing Advanced Queries in MySQL Using Python
  • Data modeling project
  • Advanced Data Modeling
  • Advanced data analytics
  • Data modeling and management
  • Data warehousing
  • Database engineer Capstone
  • Little Lemon database
  • Clients and visualization
  • Database queries, procedures and prepared statements
  • Introduction to algorithms
  • Introduction to data structures
  • Introduction to the coding interview
Instruction & Assessment

Instructional Strategies:

  • Audio Visual Materials
  • Discussion
  • Lectures
  • Practical Exercises
  • Project-based Instruction
  • Work-based Learning

Methods of Assessment:

  • Quizzes
Supplemental Materials
Equivalencies

Other offerings from Coursera Inc.

View All Courses
College Credit Opportunities