From the course: From Excel to SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Viewing data in SQL
- Imagine someone sends you a spreadsheet, maybe it's a finance report or search analytics for your website. One of the first things you might do is just have a look around. You want to get a sense of what kind of data you're looking at? What are the different column headings? How many rows are there? How do they relate to each other? And what kind of data formats are used within the individual cells? Essentially, what you're doing is just exploring. When you first start working with an SQL database you can do the same thing. One place you can start is by inspecting the database structure and the data it contains. So let's open up DB Browser and take a look around the sample database. And if you're following along, you can access this database from the exercise files. Now, as you may recall the first tab here is called database structure. And we can see here the tables that make up our database. And if we click…
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.