Coursera – Databases for Data Scientists Specialization [FCO]
All about Databases for Data Scientists. Learn to design and create efficient and effective relational databases, fill them with data, and work with them using SQL.
What you’ll learn
– Design effective, efficient databases through normalization and data modeling
– Develop expertise in programming with the Structured Query Language (“SQL”)
– Knowledge about database operations, data warehouse, big data, and NoSQL
Specialization – 3 course series
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.
In this specialization you will learn about database design, database software fundamentals, and how to use the Structured Query Language (SQL) to work with databases. The specialization, will conclude with an overview of future trends in databases, including non-relational databases (NoSQL) and Big Data. Upon completion of this specialization you will be well prepared to design and create efficient and effective relational databases, fill them with data, and work with them using SQL.
Applied Learning Project
In Relational Database Design and The Structured Query Language (SQL), you will perform coding exercises, reflect on what you learned, and describe the challenges you experienced. Then, in Advanced Topics and Future Trends in Database Technologies, you will map out a plan for a big data project and investigate the benefits and drawbacks of non-relational databases.
1. Relational Database Design
2. The Structured Query Language (SQL)
3. Advanced Topics and Future Trends in Database Technologies
Skills you will gain
– Database (DB) Design
– Data Warehousing
– Database administration
Dr. Wu’s primary interests are in temporal databases, the semantic web, and data science. Most of his research has been in extending the Resource Description Framework (RDF) for temporal dimensions. Before joining CU, he taught algorithms and data structures, programming languages, and database management courses.
Alan accumulated over 36 years experience as an Information Technology professional with strengths in IT Leadership, Project Management, Database Administration, Systems Analysis and Design, IT Infrastructure Management, and Technical Architecture Direction. His experience spans multiple industries including Corporate Finance, Manufacturing, Health Care and Marketing. Most recently, Alan was Director, Database Administration, at Wiland Inc., a small, privately held high-tech leader in Marketing Intelligence located near Boulder, CO. Alan left industry and joined the faculty at the University of Colorado in Boulder in August, 2017, as a Teaching Professor in the Computer Science Department within the College of Engineering and Applied Science. In addition to his industrial experience, Alan has an impressive track record in academia…
Offered by University of Colorado Boulder
Author(s): Di Wu, Alan Paradise
Videos Duration: 76h
Course Source: https://www.coursera.org/specializations/databases-for-data-scientists