Database Management Essentials

External: Coursera Courses ↗ · Coursera

Open Course on External: Coursera

Free to audit · Opens on External: Coursera

Database Management Essentials

Coursera · Beginner ·📊 Data Analytics & Business Intelligence ·3mo ago

Key Takeaways

Creates relational databases and writes SQL statements for business reporting requests using database management essentials

Original Description

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle, MySQL, or PostgreSQL.
Watch on External: Coursera ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

📰
Stop Testing One Indicator at a Time. Loop Your Way to Better Trading
Learn to improve trading by testing multiple indicators using a champion loop, increasing efficiency and accuracy in trading strategies
Medium · Data Science
📰
Fact Tables, Star Schemas, Joins and Dashboards
Learn to design efficient data models using fact tables, star schemas, and joins to create informative dashboards
Dev.to · samwel
📰
The Ultimate Step-by-Step Guide: Connecting Power BI to Cloud-Based & Local PostgreSQL
Learn to connect Power BI to PostgreSQL databases, both cloud-based and local, to unlock powerful data analysis and visualization capabilities
Dev.to · michael imani
📰
Understanding Data Warehousing: The Complete Beginner’s Guide for Data Engineering
Learn the basics of data warehousing and its importance in data engineering
Medium · Data Science
Up next
How to Hire Top SEO Talent
Menerva Digital
Watch →