From the course: Database Foundations: Intro to Databases
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Querying data
- [Instructor] The entire point of building a database is so that information is available when you want it. The process of asking questions about your data is called querying and it all begins with the SELECT command. SELECT allows you to retrieve rows from your data tables, but the command goes way beyond simply showing you the data as it's currently stored. With a SELECT statement and its various clauses, you can slice and dice your data into any configuration imaginable in order to answer an unlimited number of questions. The trick is learning how to ask the right questions. Select queries can perform for different tasks in order to help you better understand your data. They're collect, filter, summarize and manipulate. Let's take these one at a time. Imagine that you have a table about customers. A basic select query will be able to collect rows of data in order to answer the question, what customers do…
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.