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.)

Code Leader: Using People, Tools, and Processes to Build Successful Software (Programmer to Programmer)
Code Leader: Using People, Tools, and Processes to Build Successful Software (Programmer to Programmer)
Code Leader: Using People, Tools, and Processes to Build Successful Software

"Patrick is a pragmatist with a purist's knowledge. He has a deep understanding of what 'smells' right, and he knows when and how to find the right balance to get the job done. This philosophy of balanced 'pure pragmatism' pervades this book...

The Quick Python Book
The Quick Python Book

The Quick Python Book, Second Edition, is a clear, concise introduction to Python 3, aimed at programmers new to Python. This updated edition includes all the changes in Python 3, itself a significant shift from earlier versions of Python.

The book begins with basic but useful programs that teach the core features of syntax,...

Specification by Example: How Successful Teams Deliver the Right Software
Specification by Example: How Successful Teams Deliver the Right Software

The book you hold in your hands, or see on your screen, is the result of a series of studies of how teams all over the world specify, develop, and deliver the right software, without defects, in very short cycles. It presents the collective knowledge of about 50 projects, ranging from public websites to internal back-office systems....


Build Your Own Website: A Comic Guide to HTML, CSS, and WordPress
Build Your Own Website: A Comic Guide to HTML, CSS, and WordPress

Build Your Own Website is a fun, illustrated introduction to the basics of creating a website. Join Kim and her little dog Tofu as she learns HTML, the language of web pages, and CSS, the language used to style web pages, from the Web Guru and Glinda, the Good Witch of CSS.

Once she figures out the basics,
...

Advanced Programming in the UNIX Environment, 3rd Edition
Advanced Programming in the UNIX Environment, 3rd Edition

For more than twenty years, serious C programmers have relied on one book for practical, in-depth knowledge of the programming interfaces that drive the UNIX and Linux kernels: W. Richard Stevens’ Advanced Programming in the UNIX® Environment . Now, once again, Rich’s colleague Steve...

Learn Python Programming: The no-nonsense, beginner's guide to programming, data science, and web development with Python 3.7, 2nd Edition
Learn Python Programming: The no-nonsense, beginner's guide to programming, data science, and web development with Python 3.7, 2nd Edition

Learn the fundamentals of Python (3.7) and how to apply it to data science, programming, and web development. Fully updated to include hands-on tutorials and projects.

Key Features

  • Learn the fundamentals of Python programming with interactive projects
  • Apply Python to data...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy