Generative AI for Business Leaders
Advertising with Meta
How Google does Machine Learning
Our Courses
Using Databases with Python
This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3.js library to do basic data visualization. This course will cover Chapters 14-15 of the book “Python for Everybody”.
-
Course by
-
Self Paced
-
15 hours
-
English
Introduction to Structured Query Language (SQL)
In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.
-
Course by
-
Self Paced
-
16 hours
-
English
Data Warehousing and Business Intelligence
This course builds on “The Nature of Data and Relational Database Design” to extend the process of capturing and manipulating data through data warehousing and data mining. Once the transactional data is processed through ETL (Extract, Transform, Load), it is then stored in a data warehouse for use in managerial decision making. Data mining is one of the key enablers in the process of converting data stored in a data warehouse into actionable insight for better and faster decision making.
-
Course by
-
Self Paced
-
7 hours
-
English
AWS DynamoDB Fundamentals
Amazon DynamoDB Fundamentals is a skill enhancement course designed for candidates aiming to enhance their knowledge as Database professionals. This course will help learners understand working with NoSQL databases. Furthermore, fluency in basic concepts of AWS DynamoDB brings long-term opportunities with a specialization in database designing on the cloud. This course provides 7+ hours of training videos which are segmented into modules. The course concepts are easy to understand through lab demonstrations.
-
Course by
-
Self Paced
-
19 hours
-
English
Manage Data for an Online Grocer Using MySQL Workbench
In this project, you’ll help Greenspot Grocer, an online grocery store, prepare for rapid growth and planned expansion.
-
Course by
-
Self Paced
-
1 hour
-
English
Relational Database Design
Have you ever wanted to build a database but don't know where to start? This course will provide you a step-by-step guidance. We are going to start from a raw idea to an implementable relational database. Getting on the path, practicing the real-life mini cases, you will be confident and comfortable with Relational Database Design. Let's get started! Relational Database Design can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform.
-
Course by
-
Self Paced
-
71 hours
-
English
The Nature of Data and Relational Database Design
This course provides a comprehensive overview of data, various data types, design of databases for storage of data, and creation and manipulation of data in databases using SQL. By the end of this course, students will be able to describe what business intelligence is and how it’s different from business analytics and data science, conduct a basic descriptive statistical analysis and articulate the findings, and differentiate between types of statistics.
-
Course by
-
Self Paced
-
7 hours
-
English
Relational Modeling in Dia
In this course you will learn to interpret and draw a relational model through hands-on exercises using a diagramming tool called “Dia”. You will complete the final step in the database design process as you convert the logical design documented in an Entity Relationship Diagram into a Relational Model. During the conversion, you will investigate relational modeling rules and practice modeling techniques as you learn to resolve one-to-many and many-to-many relationships using foreign keys and bridge tables.
-
Course by
-
Self Paced
-
2 hours
-
English
Creating Database Tables with SQL
In this course you will experience the process of defining, creating, and managing relational database tables using the SQL language. Tables are used as the containers for the data in a database. As such, the structure, or makeup, of each table in a relational database is critical, since it must be designed and created specifically to meet the needs of the data it will contain. The table’s structure indicates which pieces of data are stored in a table, as well as the type and size of each piece of data.
-
Course by
-
Self Paced
-
2 hours
-
English
Build a Database from a Relational Model
In this course you will interpret the components of a relational data model, convert that model into a relational database, and then test the database design.
-
Course by
-
Self Paced
-
2 hours
-
English
Retrieve Data using Single-Table SQL Queries
In this course you’ll learn how to effectively retrieve data from a relational database table using the SQL language. We all know that most computer systems rely on at least one database to store data. Your tax information is stored in the database used by the Internal Revenue Service. Your phone stores your contacts’ names, addresses, email addresses, and phone numbers in a database. If you shop online, you’re viewing photos, descriptions, and prices of products that are stored in a database.
-
Course by
-
Self Paced
-
2 hours
-
English
Database Design and Operational Business Intelligence
Welcome to the course on Database Design and Operational Business Intelligence. This course is strategically crafted to empower you with the skills needed to design a robust database and efficiently manage intricate datasets. Throughout this course, you will acquire the expertise to develop well-formatted databases that are seamlessly designed to integrate with Power BI. Throughout this course, you'll delve into how Power BI and MS SQL Server are applied within specific industries. By the end of this course, you will be able to: 1.
-
Course by
-
Self Paced
-
English
Secure Software Design
Information security is an extremely important topic in our world today. As individuals, we seek to protect our personal information while the corporations we work for have to protect suppliers, customers, and company assets.
-
Course by
-
Self Paced
-
English
PostgreSQL for Everybody
Across these four courses, you’ll learn how to use the PostgreSQL database and explore topics ranging from database design to database architecture and deployment. You’ll also compare and contrast SQL and NoSQL approaches to database design. The skills in this course will be useful to learners doing data mining or application development.
-
Course by
-
Self Paced
-
English
Create a Database with the Modeling Tool in MySQL Workbench
In this project you will use the Modeling and Design Tool in MySQL Workbench to design and create a multiple-table relational database. As a DBMS (database management system), MySQL is used by many organizations for managing a variety of types and sizes of databases. MySQL Workbench acts as an integrated development environment allowing users to work with relational databases using a visual user interface rather than the command line.
-
Course by
-
Self Paced
-
3 hours
-
English
Databases for Data Scientists
Whether you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer seeking to learn about the database layer of the stack this specialization is for you! We focus on the relational database which is the most widely used type of database. Relational databases have dominated the database software marketplace for nearly four decades and form a core, foundational part of software development.
-
Course by
-
Self Paced
-
English
Web Applications for Everybody
This Specialization is an introduction to building web applications for anybody who already has a basic understanding of responsive web design with JavaScript, HTML, and CSS. Web Applications for Everybody is your introduction to web application development. You will develop web and database applications in PHP, using SQL for database creation, as well as functionality in JavaScript, jQuery, and JSON. Over the course of this Specialization, you will create several web apps to add to your developer portfolio.
-
Course by
-
Self Paced
-
English