eBooks-it.org Logo
eBooks-IT.org Inner Image

Introduction to SQL

Mastering the Relational Database Language

4th Edition
Introduction to SQL Image

Book Details:

Publisher:Addison-Wesley Professional
Series: Addison Wesley , Mastering
Author:Rick F. van der Lans
Edition:4
ISBN-10:0321305965
ISBN-13:9780321305961
Pages:1056
Published:Oct 06 2006
Posted:Nov 19 2014
Language:English
Book format:CHM
Book size:4.51 MB

Book Description:

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

Download Link:

Related Books:

Introducing PL/SQL to SQL Users

Enhance Your SQL With PL/SQL Procedural Logic
Introducing PL/SQL to SQL Users Image
Introducing PL/SQL to SQL Users is for SQL users who do not have PL/SQL skill. If you wish you can write some procedural logic in a SQL statement, such as controlling the process flow using IF THEN ELSE logic, you need to consider using PL/SQL. This book, which introduces PL/SQL basic features, is a perfect starting point....

An Introduction to Computer Simulation Methods

Applications to Physical Systems
An Introduction to Computer Simulation Methods Image
3rd Edition
KEY BENEFIT: Now inits third edition, this book teaches physical concepts using computer simulations. The text incorporates object-oriented programming techniques and encouragesreadersto develop good programming habits in the context of doing physics. Designed forreaders at all levels , An Introduction to Computer Simulation Methods uses Java, currently the most popular programming language. Introduction, Tools for Doing Simulations, Simulating Particle Motion, Oscillatory Systems, Few-Body Problems: The Motion of the Planets, The Chaotic Motion of Dynamical Systems, Random Processes, The Dynamics of Many Particle Systems, Normal Modes and Waves, El...

How to Design Programs

An Introduction to Programming and Computing
How to Design Programs Image
This introduction to programming places computer science in the core of a liberal arts education. Unlike other introductory books, it focuses on the program design process. This approach fosters a variety of skills--critical reading, analytical thinking, creative synthesis, and attention to detail--that are important for everyone, not just future computer programmers.The book exposes readers to two fundamentally new ideas. First, it presents program design guidelines that show the reader how to analyze a problem statement; how to formulate concise goals; how to make up examples; how to develop an outline of the solution, based on the analysis; how to finish the program; and how to test. Each step produces a well-defined intermediate product. Second, ...



2007 - 2021 © eBooks-IT.org