Watch Practical Database Design: Implementing Responsible Data Solutions with SQL Querying Free Online - Full Video Classroom | MJ Accedemy

LinkedIn – Practical Database Design: Implementing Responsible Data Solutions with SQL Querying 2024-6

Download Course (Free)

Lecture 8/32

00:00/00:00

Lecture 8 of 32

A business rule vs. a business policy

Download Course (Free)

Course Content

0 / 32 completed

Section 1: Introduction2 videos

What you should know

Designing and implementing a data model

Section 2: Business Rule Development7 videos

How databases help businesses

The DIKW Model

What's a business rule

A business rule vs. a business operation

Example business rules

A business rule vs. a business policy

2mNow Playing

A business rule vs. a business practice

Section 3: Database Design6 videos

Entities and relationships

Cardinalities

Scoping the database requirements

Connecting entities, relationships, and business rules

Analyzing the overall data requirements

Identifying data integrity requirements

Section 4: Data Generation and Datasets4 videos

Asking questions of the data

The data you're creating Pros and cons

The data you're given Now what

Asking questions of your made-up data

Section 5: Database Implementation5 videos

Overview of MySQL Workbench

Creating entities in MySQL Workbench

Creating relationships in MySQL Workbench

14m

Creating the database schema

Confirming identifying and non-identifying relationships

Section 6: SQL Querying5 videos

Overview of the SELECT statement

SELECT-FROM-WHERE clauses

Another toy dataset

14m

SELECT-FROM clauses

10m

GROUP BY and ORDER BY clauses

Section 7: Final Project2 videos

Bringing it all together

Final project The Brainery

Section 8: Conclusion1 videos

Next steps

About this Lecture

Section: Business Rule Development • Size: 4.88 MB • Duration: 2m

Course Summary

Practical Database Design: Implementing Responsible Data Solutions with SQL Querying is a training course on implementing responsible data solutions with SQL Querying, published by LinkedIn Online Academy. In the age of big data, it is critical to implement responsible data solutions to ensure integrity, security, and compliance with ethical standards. SQL Querying (Structured Query Language) is an essential skill for managing and analyzing data stored in relational databases. This course or topic focuses on using SQL Querying to implement responsible data solutions that adhere to best practices in data management, privacy, and ethical considerations.Using SQL’s powerful capabilities, professionals can ensure data security, integrity, and quality, and strengthen trust and compliance in their data-driven efforts. In this course, you will learn the fundamental concepts underlying database system design, including not only designing applications using databases, but also covering the basic implementation techniques used in database systems. In this course you will learn how to create SQL Querying. During this training course, you will be exposed to a variety of exercises and exams that will help you gain a deep understanding of implementing data-responsive solutions with SQL Querying.

Course Content

0 / 32 completed

Section 1: Introduction2 videos

What you should know

Designing and implementing a data model

Section 2: Business Rule Development7 videos

How databases help businesses

The DIKW Model

What's a business rule

A business rule vs. a business operation

Example business rules

A business rule vs. a business policy

2mNow Playing

A business rule vs. a business practice

Section 3: Database Design6 videos

Entities and relationships

Cardinalities

Scoping the database requirements

Connecting entities, relationships, and business rules

Analyzing the overall data requirements

Identifying data integrity requirements

Section 4: Data Generation and Datasets4 videos

Asking questions of the data

The data you're creating Pros and cons

The data you're given Now what

Asking questions of your made-up data

Section 5: Database Implementation5 videos

Overview of MySQL Workbench

Creating entities in MySQL Workbench

Creating relationships in MySQL Workbench

14m

Creating the database schema

Confirming identifying and non-identifying relationships

Section 6: SQL Querying5 videos

Overview of the SELECT statement

SELECT-FROM-WHERE clauses

Another toy dataset

14m

SELECT-FROM clauses

10m

GROUP BY and ORDER BY clauses

Section 7: Final Project2 videos

Bringing it all together

Final project The Brainery

Section 8: Conclusion1 videos

Next steps