Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Differences Between Databases1:20 with Andrew Chalkley
A brief discussion on the differences between databases.
[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 up