How to write SQL queries: Databases for Developers #4
You query a database table with a select statement. But unless you provide a where clause, this will return you all the rows!
That's a lot for you to sift through if your table has millions, billions or trillions of rows. In this episode Chris discusses common conditions for filtering rows so the database only returns what you need.
Further reading:
Oracle Database 12.2 select syntax: http://docs.oracle.com/database/122/SQLRF/SELECT.htm#SQLRF01702
Oracle Database Concepts Guide on Select: http://docs.oracle.com/database/122/CNCPT/sql.htm#GUID-702909E1-B214-4D30-A0F9-5A4335C2BA4A
Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html
Daily SQL tips on Twitter: https://twitter.com/SQLDaily
Chris on Twitter: https://twitter.com/ChrisRSaxon
All Things SQL Blog: https://blogs.oracle.com/sql
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Видео How to write SQL queries: Databases for Developers #4 канала The Magic of SQL
That's a lot for you to sift through if your table has millions, billions or trillions of rows. In this episode Chris discusses common conditions for filtering rows so the database only returns what you need.
Further reading:
Oracle Database 12.2 select syntax: http://docs.oracle.com/database/122/SQLRF/SELECT.htm#SQLRF01702
Oracle Database Concepts Guide on Select: http://docs.oracle.com/database/122/CNCPT/sql.htm#GUID-702909E1-B214-4D30-A0F9-5A4335C2BA4A
Take the Databases for Developers FREE SQL course at https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html
Daily SQL tips on Twitter: https://twitter.com/SQLDaily
Chris on Twitter: https://twitter.com/ChrisRSaxon
All Things SQL Blog: https://blogs.oracle.com/sql
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Видео How to write SQL queries: Databases for Developers #4 канала The Magic of SQL
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
The Vanishing One Second WaitsThe Magic of SQL: The Cups and Balls TrickQuery Tuning 101 What to Look for in Autotrace OutputThe Magic of SQL: The Magical Changing RowCross joins - SQL in 60 seconds #shortsWindow functions ORDER BY PRECEDING & FOLLOWING - SQL in 60 seconds #shortsSchema Wars Episode 3: The SQL RedemptionAnalytic Functions: Databases for Developers #13What Are Foriegn Keys? A Video QuizQuery Tuning 101: Access vs. Filter Predicates In Execution PlansWhat Are Not Null Constraints? A Video QuizWhat are Primary Keys - A Video QuizSchema Wars Episode 2: Master DBA Strikes BackThe Magic of SQL: Magical Changing Row - Behind the CurtainWindow functions ORDER BY - SQL in 60 seconds #shortsSolve It with SQL: Removing Points from a Linked ListThe Magic of SQL: The 4 JacksON vs USING for joins - SQL in 60 seconds #shortsFree guess the SQL statement quizzesHow to Create Database Indexes: Databases for Developers: Performance #4The Magic of SQL: Cups and Balls Behind the Curtain