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.
Overview of the SELECT statement - SQL Tutorial
From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Overview of the SELECT statement
- [Instructor] Knowing SQL has skyrocketed as a preferred skill for data analysts and engineers. Learning SQL has stayed relatively the same since the early 1970s. The emphasis is placed on learning the mechanics of structuring an SQL statement. However, we should also focus on understanding the decision-making implications of what an SQL query is retrieving. Let's discuss the mechanics first. The SQL select statement. The select clause is first, which contains the list of columns to be returned back to the user. Then comes the from clause. It holds the list of tables needed to perform the query. After from, we have options, depending on which database items we're trying to retrieve. Most times, we need a where clause. The where clause places conditions on which data elements will be selected and filtered out for each column. And sometimes, especially when we want to cluster or sort, we'll use the group by, having, and/or order by clauses. The group by clause does just that, groups…
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.