Specialization PostgreSQL for Everybody
This specialization is for you if you are a beginning programmer with an interest in Data Science, a data scientist working closely with content experts, or a software developer looking to learn about the database layer of the stack. They concentrate on relational databases, which are the most common type of database. Relational databases have dominated the database software market for nearly four decades and are an essential, foundational component of software development.
This specialization will teach you about database architecture, database software principles, and how to work with databases using the Structured Query Language (SQL). The specialization will culminate with a look at future database trends, such as non-relational databases (NoSQL) and Big Data. After completing this specialization, you will be well prepared to design and build efficient and effective relational databases, populate them with data, and interact with them using SQL.
In Relational Database Design and The Structured Query Language (SQL), you will code, reflect on what you learned, and describe the difficulties you encountered. Then, in Advanced Topics and Future Trends in Database Technologies, you will plan a big data project and investigate the advantages and disadvantages of non-relational databases.
What you will 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
- Create Entity Relationship Models and Entity Relationship Diagrams
Coursera rating: 4.7/5.0
Enroll here: coursera.org/specializations/databases-for-data-scientists
