Introduction to SQL PDF ePub eBook

Books Info:

Introduction to SQL free pdf 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 does-and 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

About Rick F. van der Lans

Rick F. van der Lans is an independent consultant, author, and lecturer specializing in database technology, SQL, and data warehousing. He is managing director of R20/Consultancy. He has been a member of the Dutch ISO committee responsible for developing the SQL standard. For the past 20 years, he has taught SQL classes to thousands of attendees. His popular books, including Introduction to SQL and The SQL Guide to Oracle, have been translated into various languages and have sold more than 100,000 copies. Rick is an internationally acclaimed lecturer. Throughout has career, he has lectured in many European countries, South America, USA, and Australia. You can contact Rick via email at sql@r20.nl.

Details Book

Author : Rick F. van der Lans
Publisher : Addison-Wesley Educational Publishers Inc
Data Published : 26 September 2006
ISBN : 0321305965
EAN : 9780321305961
Format Book : PDF, Epub, DOCx, TXT
Number of Pages : 1056 pages
Age + : 18 years
Language : English
Rating :

Reviews Introduction to SQL



17 Comments Add a comment




Related eBooks Download


  • SQL Queries for Mere Mortals free pdfSQL Queries for Mere Mortals

    The #1 Easy. Common-Sense Guide to SQL Queries-Updated for Today's Databases. Standards. and Challenges SQL Queries for Mere Mortals(R) has earned worldwide praise as the clearest. simplest tutorial on writing effective SQL queries..


  • Pro LINQ Object Relational Mapping in C# 2008 free pdfPro LINQ Object Relational Mapping in C# 2008

    It is nearly impossible today to write enterprise software without the use of one or more relational databases. Granted. there are cases when the data is transient and not stored in a database..


  • Beginning T-SQL: 2014 free pdfBeginning T-SQL: 2014

    Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database..


  • PHP  free pdfPHP

    PHP and MySQL in easy steps will teach the user to write PHP server-side scripts and how to make MySQL database queries. It has an easy-to-follow style that will appeal to: anyone who wants to begin producing data-driven web pages..


  • Gigabit LANs free pdfGigabit LANs

    An end-to-end guide to the technologies that will enable high-speed networks of the future Increasingly. end users are demanding that the enterprise network--including LANs. WANs. intranet. VPNs..


  • Introduction to SQL free pdfIntroduction to SQL

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