Taking the values from rows and turning them into columns is a common request for Oracle DBA. Or the reverse – take values from columns and turn them into rows. These are easy in Oracle Database with the PIVOT and UNPIVOT operators. This video will show the ins and outs …
You wanted to use those fancy Postgres features so you wrote raw SQL. Some time and a few more features go by and now your app is littered with SQL strings. Keep the power and lose the mess by building composable query objects that leverage Arel, the query builder under …
In the past decade, RDBMS related traction has moved away completely in the Java world from SQL towards JPA / JPQL, or even further, towards NoSQL. Evangelists have widely agreed that RDBMS are not “web scale”, even if the race is far from being decided.
Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis. Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database …
This screencast will take you thought the in’s and out’s of the SQL SELECT statement, including using the FROM, WHERE and ORDER BY clauses. Additional topics such as the TOP and DISTINCT keywords, column aliasing with AS and date/time functions are also covered.
This video demonstrates the basics of table creation and inserting data into database tables using the SQL language. You will learn how to create table(s), set primary key(s), add constraints, add foreign keys, insert data and read data from the table.
