From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Join today to access over 24,700 courses taught by industry experts.
The data you're given: Now what? - SQL Tutorial
From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
The data you're given: Now what?
- [Narrator] Before we explore the database tool, we're sketching out the type of data that'll eventually populate this database and imagine what good sample data criteria is. This will help build our confidence in our data model. With our need for data, we simply go to the internet. We search, we find, we download, we use. Well, not so fast. Be cautious of using existing datasets. There are three crucial questions to ask. Number one, where did it come from and for what original purpose? What are the data gathering procedures being used and how much harm is introduced? And number three, do you own the rights to do what you want with the data? Each question helps you pinpoint where that procured dataset matches your needs and where there are gaps. Let's say that I decide to use my social media data as a representative sample to help imagine the Brainery's database. Since the dataset is my social media content, I can answer questions one to three with ease. For question one, this data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.