Databases for Data Scientists Specialization

About Course

Looking to master the essential skills of a data scientist? Our **Databases for Data Scientists Specialization** course, brought to you by the University of Colorado, offers a comprehensive guide to relational databases. Learn the fundamentals of database design, SQL query language, and explore the intricacies of database software.

This specialization is perfect for aspiring data scientists, seasoned professionals seeking a deeper understanding of databases, or software developers interested in the database layer. You’ll delve into the world of relational databases, the dominant force in database software for decades, and gain hands-on experience with SQL.

Dive into practical exercises, learn from expert instructors, and explore the latest trends in database technologies, including non-relational databases (NoSQL) and big data. **This course is completely free!** Learn from top-rated instructors on platforms like **Udemy, Coursera, Udacity, MasterClass, NearPeer, and more.**

By the end of this specialization, you’ll be confident in designing and implementing effective relational databases, populating them with data, and harnessing the power of SQL for data manipulation and analysis.

Course Content

01. Advanced Topics and Future Trends in Database Technologies

A Message from the Professor
002 02_course-support_instructions.html

00:00
005 03_module-1-welcome-and-introduction.mp4

00:00
001 01_earn-academic-credit-for-your-work_instructions.html

00:00
013 02_transaction-logs-part-2.mp4

00:00
014 03_transaction-logs_exam.html

00:00
018 01_database-backup-and-recovery.mp4

00:00
019 02_database-backup-and-recovery_exam.html

00:00
023 01_database-concurrency.mp4

00:00
024 02_database-concurrency_exam.html

00:00
028 01_careers-in-database-technologies.mp4

00:00
029 02_exploring-careers-in-database-technologies_peer_assignment_instructions.html

00:00
033 01_a-different-perspective-of-organizing-data.mp4

00:00
075 02_the-relational-problem-part-2.mp4

00:00
076 03_the-relational-problem_exam.html

00:00
080 01_nosql-systems-part-1.mp4

00:00
084 02_nosql-systems-part-2.mp4

00:00
085 03_nosql-systems_exam.html

00:00
089 01_mongodb-overview-and-demo.mp4

00:00
093 02_cassandra-overview-and-demo.mp4

00:00
094 03_solving-the-relational-problem_peer_assignment_instructions.html

00:00
099 01__resources.html

00:00
Section Quiz

02. Relational Database Design

002 02_assessment-strategy_instructions.html

00:00
006 01_course-overview.mp4

00:00
007 02_assessment-strategy_instructions.html

00:00
011 03_data-information-knowledge-and-intelligence.mp4

00:00
015 04_solutions-for-data-management.mp4

00:00
019 05_data-stored-in-dbms.mp4

00:00
020 06_dbms_exam.html

00:00
024 01_what-are-entities-and-attributes-identifiers.mp4

00:00
028 02_what-are-relationships-degree-cardinality-and-participation-of-relationships.mp4

00:00
029 03_lab-1-entity-relationship-models_instructions.html

00:00
030 04_unlock-lab-1-solutions_exam.html

00:00
031 05_entities-and-relationships_exam.html

00:00
035 01_entity-relationship-model-representation.mp4

00:00
039 02_crows-foot-notation.mp4

00:00
043 03_in-class-exercise.mp4

00:00
044 04_lab-2-entity-relationship-diagrams_instructions.html

00:00
045 05_unlock-lab-2-solutions_exam.html

00:00
046 06_erd_exam.html

00:00
047 01_entity-relationship-models_instructions.html

00:00
048 02_unlock-entity-relationship-models-solutions_exam.html

00:00
052 01_what-are-relations.mp4

00:00
056 02_what-are-keys.mp4

00:00
057 03_lab-1-relations_instructions.html

00:00
058 04_unlock-lab-1-solutions_exam.html

00:00
059 05_relation-and-keys_exam.html

00:00
063 01_what-are-relational-schemas.mp4

00:00
064 02_lab-2-relational-schema_instructions.html

00:00
065 03_unlock-lab-2-solutions_exam.html

00:00
066 04_relational-schema_exam.html

00:00
070 01_how-to-convert-erds-to-relational-models.mp4

00:00
074 02_practice.mp4

00:00
075 03_lab-3-convert-erds-to-relational-models_instructions.html

00:00
076 04_unlock-lab-3-solutions_exam.html

00:00
077 05_converting-erd-to-rm_exam.html

00:00
078 01_relational-models_instructions.html

00:00
079 02_unlock-relational-models-solutions_exam.html

00:00
083 01_data-redundancy-and-normalization.mp4

00:00
087 02_functional-dependencies.mp4

00:00
088 03_lab-1-functional-dependencies_instructions.html

00:00
089 04_unlock-lab-1-solutions_exam.html

00:00
090 05_data-redundancy_exam.html

00:00
094 01_full-partial-and-transitive-functional-dependencies.mp4

00:00
095 02_lab-2-identify-special-fds_instructions.html

00:00
096 03_unlock-lab-2-solutions_exam.html

00:00
097 04_functional-dependency_exam.html

00:00
101 01_normal-forms-and-normalization-process.mp4

00:00
102 02_lab-3-normalization-process_instructions.html

00:00
103 03_unlock-lab-3-solutions_exam.html

00:00
104 04_normalization-process_exam.html

00:00
105 01_normalization_instructions.html

00:00
106 02_unlock-normalization-solutions_exam.html

00:00
107 01_background_instructions.html

00:00
108 02_unlock-step-1-solutions_exam.html

00:00
109 01_build-the-entity-relationship-model_instructions.html

00:00
110 02_unlock-step-2-solutions_exam.html

00:00
111 01_create-the-entity-relationship-diagram_instructions.html

00:00
112 02_unlock-step-3-solutions_exam.html

00:00
113 01_convert-the-erd-to-the-relational-model_instructions.html

00:00
114 02_unlock-step-4-solutions_exam.html

00:00
115 01_normalize-the-relational-model-to-3nf_instructions.html

00:00
116 02_unlock-step-5-solutions_exam.html

00:00
117 01_final-output-for-implementation_instructions.html

00:00
118 02_unlock-step-6-solutions_exam.html

00:00
120 01__resources.html

00:00
Section Quiz

03. The Structured Query Language (SQL)

002 02_course-support_instructions.html

00:00
005 03_overview-of-course-intro-to-instructor.mp4

00:00
008 01_the-origins-of-sql.mp4

00:00
009 02_old-but-widely-used_quiz.html

00:00
012 01_the-relational-algebra.mp4

00:00
013 02_understanding-relational-algebra-terms_quiz.html

00:00
016 01_the-sql-standard.mp4

00:00
020 02_sql-query-execution-terms_quiz.html

00:00
023 01_our-coursera-lab-environment.mp4

00:00
027 02_lab-1-coding-your-first-select-statements_instructions.html

00:00
028 03_unlock-lab-1-solutions_exam.html

00:00
031 01_the-where-clause-and-conditions.mp4

00:00
032 02_lab-2-adding-conditions-using-the-where-clause_instructions.html

00:00
033 03_unlock-lab-2-solutions_exam.html

00:00
036 01_the-order-by-and-distinct.mp4

00:00
037 02_adjusting-your-output_quiz.html

00:00
040 01_how-does-sql-handle-dates-and-nulls.mp4

00:00
041 02_lab-3-date-functions-and-nulls_instructions.html

00:00
042 03_unlock-lab-3-solutions_exam.html

00:00
046 01_the-five-group-functions.mp4

00:00
047 02_using-the-group-functions_quiz.html

00:00
050 01_creating-totals-and-subtotals.mp4

00:00
051 02_understanding-the-rules_quiz.html

00:00
052 03_lab-4-using-the-group-by_instructions.html

00:00
053 04_unlock-lab-4-solutions_exam.html

00:00
056 01_subqueries-three-different-forms.mp4

00:00
057 02_differentiating-types-of-subqueries_quiz.html

00:00
058 03_lab-5-practice-using-subqueries_instructions.html

00:00
059 04_unlock-lab-5-solutions_exam.html

00:00
063 01_join-syntax.mp4

00:00
064 02_understanding-joins_quiz.html

00:00
065 03_lab-6-inner-joins_instructions.html

00:00
066 04_unlock-lab-6-solutions_exam.html

00:00
069 01_three-way-join.mp4

00:00
073 02_join-conditions_quiz.html

00:00
076 01_when-an-outer-join-is-needed.mp4

00:00
077 02_lab-7-outer-joins_instructions.html

00:00
078 03_unlock-lab-7-solutions_exam.html

00:00
082 01_create-statement-data-types.mp4

00:00
083 02_understanding-data-types_quiz.html

00:00
084 03_lab-8-creating-tables_instructions.html

00:00
085 04_unlock-lab-8-solutions_exam.html

00:00
088 01_database-constraints.mp4

00:00
092 02_lab-9-modifying-tables-and-columns-with-alter_instructions.html

00:00
093 03_unlock-lab-9-solutions_exam.html

00:00
096 01_adding-changing-deleting-data.mp4

00:00
097 02_lab-10-practicing-dml_instructions.html

00:00
098 03_unlock-lab-10-solutions_exam.html

00:00
102 01_creating-and-using-views.mp4

00:00
103 02_lab-11-using-a-view_instructions.html

00:00
104 03_unlock-lab-11-solutions_exam.html

00:00
107 01_the-case-statement.mp4

00:00
108 02_lab-12-conditionals-with-the-case-operator_instructions.html

00:00
109 03_unlock-lab-12-solutions_exam.html

00:00
112 01_joining-answer-sets-with-the-union.mp4

00:00
117 02_final-lab_instructions.html

00:00
118 03_unlock-final-lab-solutions_exam.html

00:00
001 01_earn-academic-credit-for-your-work_instructions.html

00:00
119 04_final-comprehensive-sql-reflection_peer_assignment_instructions.html

00:00
122 01_wrap-up.mp4

00:00
123 02_links-from-wrap-up-video_instructions.html

00:00
124 01__resources.html

00:00
Section Quiz

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

01. Advanced Topics and Future Trends in Database Technologies

A Message from the Professor

002 02_course-support_instructions.html

005 03_module-1-welcome-and-introduction.mp4

001 01_earn-academic-credit-for-your-work_instructions.html

013 02_transaction-logs-part-2.mp4

014 03_transaction-logs_exam.html

018 01_database-backup-and-recovery.mp4

019 02_database-backup-and-recovery_exam.html

023 01_database-concurrency.mp4

024 02_database-concurrency_exam.html

028 01_careers-in-database-technologies.mp4

029 02_exploring-careers-in-database-technologies_peer_assignment_instructions.html

033 01_a-different-perspective-of-organizing-data.mp4

075 02_the-relational-problem-part-2.mp4

076 03_the-relational-problem_exam.html

080 01_nosql-systems-part-1.mp4

084 02_nosql-systems-part-2.mp4

085 03_nosql-systems_exam.html

089 01_mongodb-overview-and-demo.mp4

093 02_cassandra-overview-and-demo.mp4

094 03_solving-the-relational-problem_peer_assignment_instructions.html

099 01__resources.html

Section Quiz

02. Relational Database Design

002 02_assessment-strategy_instructions.html

006 01_course-overview.mp4

007 02_assessment-strategy_instructions.html

011 03_data-information-knowledge-and-intelligence.mp4

015 04_solutions-for-data-management.mp4

019 05_data-stored-in-dbms.mp4

020 06_dbms_exam.html

024 01_what-are-entities-and-attributes-identifiers.mp4

028 02_what-are-relationships-degree-cardinality-and-participation-of-relationships.mp4

029 03_lab-1-entity-relationship-models_instructions.html

030 04_unlock-lab-1-solutions_exam.html

031 05_entities-and-relationships_exam.html

035 01_entity-relationship-model-representation.mp4

039 02_crows-foot-notation.mp4

043 03_in-class-exercise.mp4

044 04_lab-2-entity-relationship-diagrams_instructions.html

045 05_unlock-lab-2-solutions_exam.html

046 06_erd_exam.html

047 01_entity-relationship-models_instructions.html

048 02_unlock-entity-relationship-models-solutions_exam.html

052 01_what-are-relations.mp4

056 02_what-are-keys.mp4

057 03_lab-1-relations_instructions.html

058 04_unlock-lab-1-solutions_exam.html

059 05_relation-and-keys_exam.html

063 01_what-are-relational-schemas.mp4

064 02_lab-2-relational-schema_instructions.html

065 03_unlock-lab-2-solutions_exam.html

066 04_relational-schema_exam.html

070 01_how-to-convert-erds-to-relational-models.mp4

074 02_practice.mp4

075 03_lab-3-convert-erds-to-relational-models_instructions.html

076 04_unlock-lab-3-solutions_exam.html

077 05_converting-erd-to-rm_exam.html

078 01_relational-models_instructions.html

079 02_unlock-relational-models-solutions_exam.html

083 01_data-redundancy-and-normalization.mp4

087 02_functional-dependencies.mp4

088 03_lab-1-functional-dependencies_instructions.html

089 04_unlock-lab-1-solutions_exam.html

090 05_data-redundancy_exam.html

094 01_full-partial-and-transitive-functional-dependencies.mp4

095 02_lab-2-identify-special-fds_instructions.html

096 03_unlock-lab-2-solutions_exam.html

097 04_functional-dependency_exam.html

101 01_normal-forms-and-normalization-process.mp4

102 02_lab-3-normalization-process_instructions.html

103 03_unlock-lab-3-solutions_exam.html

104 04_normalization-process_exam.html

105 01_normalization_instructions.html

106 02_unlock-normalization-solutions_exam.html

107 01_background_instructions.html