Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
A brief discussion on the differences between databases.
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
Up to now,
most of the SQL we've been using will
0:00
work in most relational database systems.
0:05
Mysql, SQL Server, Postgres,
and SQLite for example.
0:10
However, each database system has
different ways of working with dates.
0:15
Make sure you check out the teacher's
notes below each video for
0:20
more information on how major
databases handle dates.
0:23
The key ways in which databases
treat dates differently
0:26
are how you write dates in SQL queries.
0:30
Some databases prefer you
write one way over another.
0:34
Then there are different functions
used in different database systems to
0:38
calculate dates.
0:42
Like getting today's date or
calculating dates in the past or future.
0:43
There are different functions to
handle how dates are formatted
0:49
in a human readable format.
0:52
In SQL playgrounds we're
using a version of SQLite.
0:54
A popular database used in beta
devices like your smartphone and
0:58
in development environments.
1:02
While some of the information you'll learn
here will work in other database systems,
1:04
a lot of it may not.
1:08
Just concentrate on
the principles you learn here and
1:09
then you'll be able to look
up in the documentation for
1:12
the specific SQL environment you're
using in your career or project.
1:15
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up