Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Introduction to SQL: Mastering the Relational Database Language (4th Edition)

Buy

The Classic SQL Tutorial: Fully Updated for Today's Standards and Today's Top Databases

For twenty years, van der Lans' Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today's leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.

Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it doesand how to get the most out of it. You'll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you're a programmer or DBA, a student or veteran, this book will take you from "apprentice" to 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

  •   Specifying keys and other integrity constraints

  •   Using indexes to improve efficiency

  •   Enforcing security via passwords and privileges

  •   Building stored procedures and triggers

  •   Developing with embedded SQL and ODBC

  •   Working with transactions, including rollbacks, savepoints, isolation levels, and more

  •   Optimizing performance by reformulating SQL statements

  •   Using object-relational features: subtables, references, sets, and user-defined data types

  •   Reference section: SQL statement definitions and SQL function lists

(HTML tags aren't allowed.)

Professional Microsoft Windows Embedded CE 6.0 (Wrox Programmer to Programmer)
Professional Microsoft Windows Embedded CE 6.0 (Wrox Programmer to Programmer)
Windows Embedded CE is a 32 - bit, native, hard, real - time, small - footprint operating system developed by Microsoft to address the needs of handheld, mobile, and embedded devices. With support for multiple processor architectures, Windows Embedded CE can be adapted to a variety of devices like Smartphones, PocketPCs, set - top boxes, thin -...
Tools and Algorithms for the Construction and Analysis of Systems: 17th International Conference
Tools and Algorithms for the Construction and Analysis of Systems: 17th International Conference

This volume contains the proceedings of the 17th International Conference on Tools and Algorithms for the Construction and Analysis of Systems (TACAS 2011). TACAS 2011 took place in Saarbr¨ucken, Germany, March 28–31, 2011, as part of the 14th European Joint Conferences on Theory and Practice of Software (ETAPS 2011), whose...

Anorexia and Bulimia in the Family: One Parent's Practical Guide to Recovery
Anorexia and Bulimia in the Family: One Parent's Practical Guide to Recovery

"Nine years ago my daughter came home after an abusive marriage and developed Anorexia, yet did not recognise she was ill. It was the beginning of a living nightmare."

Anorexia and Bulimia in the Family: One Parent’s Guide to Recovery is the first supportive self-help guide written by a...


Ants, Bikes, and Clocks: Problem Solving for Undergraduates
Ants, Bikes, and Clocks: Problem Solving for Undergraduates
Mathematics educators agree that problem solving is one of the essential skills their students should possess, yet few mathematics courses or textbooks are devoted entirely to developing this skill. Supported by narrative, examples, and exercises, Ants, Bikes, and Clocks: Problem Solving for Undergraduates is a readable and enjoyable text designed...
Beginning Joomla! Web Site Development (Wrox Programmer to Programmer)
Beginning Joomla! Web Site Development (Wrox Programmer to Programmer)

By programmers for programmers-the essential beginner's guide to building websites with Joomla!

Want to build and maintain dynamic websites without having to learn HTML and CSS? Joomla! open-source web content management system and this beginner's guide are all you need. This book walks you step-by-step through the...

How to Write Successful Fundraising Letters, with CD
How to Write Successful Fundraising Letters, with CD

You'll learn all the essential components of writing for success from this go-to book for writing for fundraising! Mal Warwick, the nation's premier letter-writing tutor and direct mail expert, shows you the essential tools for making your direct marketing program a success. He gives you both general advice about the most effective...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy