Learn how it is much easier to compare strings when their case is folded to either all uppercase or all lowercase.
- There are circumstances where it can be very useful…to force a string to all uppercase or all lowercase.…SQL provides the upper and lower functions for this.…We're gonna use the world database,…and type in a select statement with a string here.…And you notice, there's our result.…Now, if I want to compare that with a string…that's all lowercase, using the comparison operator equals,…and when I run Go, you notice the result is zero, or false.…
However, if I put both of these in lower functions,…and I compare them, now, I get true,…because if they're both converted to lowercase,…then they are the same string.…Of course, the same is true with upper,…and when I run that, I also get true.…If I use this in a query from a database,…upper of the name column from city,…and order by name,…you'll notice something interesting about this.…
The accented characters, like this Spanish ene,…or this accented A,…these accented characters are not converted.…The SQL database engine only converts ASCII characters,…and depending on the colation algorithms on your system,…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.