| Lesson 5 | How do SQL dialects differ? |
| Objective | Understand the variations in dialects. |
Versions of SQL differ somewhat from platform to platform to support specific features offered by a given database engine.
For example, in one database environment, you might reference a column value by adding a colon before the name of the column. In another, you might not need the colon.
In addition, different database capabilities can help you determine the best approach to submitting your query.
Although you won't learn about many of the advanced features in this course, it's important to understand that you will need to do some basic research as you start working with your selected database engine.
You will need to determine SQL Capitalization
For example, in one database environment, you might reference a column value by adding a colon before the name of the column. In another, you might not need the colon.
In addition, different database capabilities can help you determine the best approach to submitting your query.
Although you won't learn about many of the advanced features in this course, it's important to understand that you will need to do some basic research as you start working with your selected database engine.
SQL typically does not care about the capitalization in your queries. Capitalization has been provided throughout this course to help make the
content more readable. If you find that you've spelled everything in your query correctly but it still returns no results or an error message
indicating it can't find what you're looking for, check with your database administrator and see if the database is set up to be
case-sensitive.
SQL Approaches - Quiz
Take this quick quiz to determine how well you understand the basics of SQL before moving on.
SQL Approaches - Quiz
In the next lesson, the database will be implemented.
SQL Approaches - Quiz
In the next lesson, the database will be implemented.
