Practical Database Design: Implementing Responsible Data Solutions with SQL Querying

Focused View

2:15:57

0 View

01 - Introduction

01 - Designing and implementing a data model.mp4

01:03

02 - What you should know.mp4

01:29

02 - 1. Business Rule Development

01 - How databases help businesses.mp4

04:29

02 - The DIKW Model.mp4

05:08

03 - Whats a business rule.mp4

04:10

04 - A business rule vs. a business operation.mp4

03:05

05 - A business rule vs. a business practice.mp4

03:20

06 - A business rule vs. a business policy.mp4

03:02

07 - Example business rules.mp4

01:55

03 - 2. Database Design

01 - Entities and relationships.mp4

03:11

02 - Cardinalities.mp4

03:52

03 - Scoping the database requirements.mp4

03:08

04 - Analyzing the overall data requirements.mp4

04:00

05 - Connecting entities, relationships, and business rules.mp4

04:57

06 - Identifying data integrity requirements.mp4

04:16

04 - 3. Data Generation and Datasets

01 - The data youre given Now what.mp4

03:53

02 - Asking questions of the data.mp4

03:52

03 - The data youre creating Pros and cons.mp4

03:47

04 - Asking questions of your made-up data.mp4

03:22

05 - 4. Database Implementation

01 - Overview of MySQL Workbench.mp4

04:09

02 - Creating entities in MySQL Workbench.mp4

05:25

03 - Creating relationships in MySQL Workbench.mp4

11:08

04 - Confirming identifying and non-identifying relationships.mp4

05:03

05 - Creating the database schema.mp4

03:55

06 - 5. SQL Querying

01 - Overview of the SELECT statement.mp4

04:20

02 - Another toy dataset.mp4

09:04

03 - SELECT-FROM clauses.mp4

08:46

04 - SELECT-FROM-WHERE clauses.mp4

08:29

05 - GROUP BY and ORDER BY clauses.mp4

06:10

07 - 6. Final Project

01 - Bringing it all together.mp4

01:29

02 - Final project The Brainery.mp4

01:07

08 - Conclusion

01 - Next steps.mp4

00:53

Description

In this hands-on course, learn the fundamental concepts underlying database system design, including not only the design of applications using databases, but also covering the fundamental implementation techniques used in database systems. Instructor Brandeis Marshall takes you through a practical application of database design, database implementation, and data querying to determine when SQL querying is more appropriate. Learn how to develop effective SQL queries and leverage SQL as part of your responsible/ethical data practices. Brandeis takes you through the full arc of a database project, and finishes the course with a project that lets you apply all you’ve learned.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.