SQL - core concepts - SELECT - functions - date&time - JOINS

SQL - Structured query language is declarative way to select data, update, delete or insert data from the Database. In this video we use example of Oracle HR schema and two tables Employees and Departments to demonstrate code concepts of SQL - query clauses, joins, conversion and aggregate functions. We'll go through 4 assignments to demonstrate how to query database using SQL and what are basic building blocks of select. We'll also show how to use conversion function - to_date and how to work with dates and intervals, by also taking into account vendor differences between Oracle and Postgres databases. 00:00 intro 00:52 fundamental sql clauses 01:13 where clause 02:19 select - projection 02:32 order by clause 02:45 employees with salary over 14000 03:08 second question - employees hired this and past year 03:39 conversion functions 05:57 dates and intervals 07:34 vendor differences 09:06 referential integrity 10:09 join 13:57 aggregate functions 14:55 group by clause 15:13 having clause 16:14 outro