From the course: Learning Data Analytics: 1 Foundations
Join today to access over 25,300 courses taught by industry experts.
Learning database datasets
From the course: Learning Data Analytics: 1 Foundations
Learning database datasets
- [Instructor] Sometimes it's not spreadsheets that we're tasked to learn, sometimes it's databases. So let's take a look at how I learn a new database. One of the very first things I'm going to do is look at the names of the tables. Do they seem to be meaningfully named? I see things like dates, login log, subscriptions, users, users subscriptions, video categories all the way through to video subscriptions. Super interesting. So now what I'll do is actually take a look at some of the data. Okay. I'll start with the login log. I'll double click that. I see a lot of IDs here. This means that I'm probably going to tie things together. Looks like I'll tie users, probably to users. I see company ID, I see login dates and times. Let me go check these data types. I'll go to the design view. So I see that login log for this database is an auto number. I see that user ID is a number. And thankfully I see the login date and time is actually a date and time. Fantastic. I'll go through each one…
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.