From the course: Intermediate SQL for Data Scientists (2021)
Join today to access over 24,700 courses taught by industry experts.
SQL standards
From the course: Intermediate SQL for Data Scientists (2021)
SQL standards
- [Instructor] I briefly want to touch on SQL standards, and that's for two reasons. One, standards change over time and typically new features are added. And more importantly, for us, there's variations across databases. This is especially important if you're trying to follow along in this course, and you're using a database other than Postgres or PostgresSQL. Now, when we talk about SQL standards, we're talking generally about the ANSI standard SQL, and that's from the American National Standards Institute. Now, the first standard SQL was issued in 1986, but there have been 10 revisions or 10 versions since that time, and the versions add new features or make some changes. And so for example, some of the latest features are support for JSON structures and multi-dimensional arrays. Now, as a data scientist, this means you have to be careful about your SQL statements and porting code from one database to another. So…
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.