Classic SQL Tutorial:? S Standard and Paid Today for Today? Updated s Top Databases For twenty years, van der Lans? By using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and reports. true SQL master. Writing queries and updating data: all you need to know about SELECT Working with joins, functions, and subqueries Creating database objects: tables, indexes, views, and more Define buttons and other integrity constraints using indexes to improve efficiency Enforcing security via passwords and rights Building special stored procedures and triggers Developing with embedded SQL and ODBC Working with transactions, including rollbacks, savepoints, isolation levels, and more Optimize performance by formulating an SQL statement using object-relational features: subtables, references, sets, and user-defined data types Reference sections: the definition of an SQL statement and a list of SQL functions