SQL

Wrangle Your SQL With Arel

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 the hood of ActiveRecord.

SQL, the Underestimated Big Data Technology

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.

Using SQL for Pattern Matching in Oracle Database

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 12c Release 1 (12.1), you …

Using SQL for Pattern Matching in Oracle Database Read More »

Learning the SQL SELECT Statement

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.

SQL Basics: Table Creation and Data Insert

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.