Select with string patterns, ranges, and sets | 13/25 | UPV

Description:
Título: Select with string patterns, ranges, and sets


Descripción automática: In this video, the presenter explains how to enhance SQL SELECT statements using string patterns, ranges, and value sets. The lesson utilizes a database from a food distributor, focusing on how patterns can be used in the situation where one wants to filter search results based on specific criteria, with practical examples using the 'LIKE' clause and various wildcard characters.

The video demonstrates the use of the percent sign (%) to represent any number of characters in a string pattern, enabling users to find records that begin with a certain character regardless of case sensitivity. It points out that the behavior regarding case sensitivity may differ between databases, and users should verify this aspect or use conversion commands as necessary.

Wildcards like the underscore (_) and brackets ([]) are introduced for matching a single character or a set range of characters, respectively. The tutorial shows how one can use these wildcards in SQL queries to refine search results effectively. Usage examples include finding records with 'A' as the second character or starting with certain letters.

Lastly, the presenter covers the use of the 'BETWEEN' keyword to filter numeric ranges in a more readable way compared to using multiple conditional operators, and the 'IN' keyword for filtering against a list of values to avoid numerous 'OR' conditions. Reference to a web SQL simulator, specific to wildcards, is provided for viewers to practice the concepts discussed. The video concludes with a review of the key points, including the importance of understanding database-specific implementations of SQL wildcards and commands.

Autor/a: Despujol Zabala Ignacio

Curso: Este vídeo es el 13/25 del curso MOOC Introduction to SQL and relational databases. https://www.youtube.com/playlist?list=PL6kQim6ljTJsZXkEMwa3NC8tB-KRJWSY_
Inscríbete en: https://upvx.es/courses/course-v1:edxorg+introduction-to-sql-and-relational-databases+v2/about


+ Universitat Politècnica de València UPV: https://www.upv.es
+ Más vídeos en: https://www.youtube.com/valenciaupv
+ Accede a nuestros MOOC: https://upvx.es

#SQL #Between #In #Like