Introduction to SQL: Mastering the Relational Database Language (4th Edition)
Mega Sale! Save 24% on the Introduction to SQL: Mastering the Relational Database Language (4th Edition) by Addison-Wesley Professional at Translate This Website. MPN: Illustrations. Hurry! Limited time offer. Offer valid only while supplies last. The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases For twenty years, van der Lans’ Introduction 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 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
|Item Weight:||3.25 pounds|
|Item Size:||2.15 x 9.15 x 9.15 inches|
|Package Weight:||3.25 pounds|
|Package Size:||6.8 x 2.1 x 2.1 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product by Addison-Wesley Professional, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
Related Best Sellers
By Oxford University Press
mpn: numerous figures and tables, ean: 9780195304800, isbn: 0195304802,
Two thirds of global internet users are non-English speakers. Despite this, most scholarly literature on the internet and computer-mediated-communication (CMC) focuses exclusively on English. This is the first book devoted to analyzing internet relat...
mpn: 9781680501452, ean: 9781680501452, isbn: 1680501453,
Don't accept the compromise between fast and beautiful: you can have it all. Phoenix creator Chris McCord, Elixir creator Jose Valim, and award-winning author Bruce Tate walk you through building an application that's fast and reliable. At every step...
By Addison-Wesley Professional
ean: 9780321154934, isbn: 0321154932,
The Common Language Infrastructure Annotated Standard is the definitive guide to understanding the annotated specification for the Common Language Infrastructure (CLI) standard. With annotations and code samples from both the ECMA standards committee...
By Packt Publishing - ebooks Account
mpn: black & white illustrations, ean: 9781784391799, isbn: 9781784391799,
Explore various approaches to organize and extract useful text from unstructured data using Java About This BookIntegrate basic tasks to tackle more complex NLP problemsTrain NLP models to address domain-specific problem areasLearn to use a variety o...
By CreateSpace Independent Publishing Platform
ean: 9781979683821, isbn: 1979683824,
SQL Made Easy- The Ultimate Step by Step Guide To Success Do you want to learn SQL programming without the complicated explanations? Do you want to understand how to manage databases without all the confusion? Well than, this is your go to guid...
ean: 9783319537320, isbn: 3319537326,
This book constitutes the refereed proceedings of the 11th International Conference on Language and Automata Theory and Applications, LATA 2017, held in Umeå, Sweden, in March 2017. The 31 revised full papers presented together with 4 invited talks ...
By Mc Press
ean: 9781583473580, isbn: 1583473580,
Covering the basics of Control Language (CL) programming as well as the latest CL features—including new structured-programming capabilities, file-processing enhancements, and the Integrated Language Environment—this resource is geared towards st...
ean: 9783319607887, isbn: 331960788X,
The full source code for the examples provided in this book aims to encourage innovation and experimentation by a readership that will gain much from the first publication of its kind based on F#. It also covers design and other aspects of Java and C...
By Brand: Jones Bartlett Learning
ean: 9781449615529, isbn: 144961552X,
Written to address the fundamentals of formal languages, automata, and computability, An Introduction to Formal Languages and Automata provides an accessible, student-friendly presentation of all material essential to an introductory Theory of Comput...
By Multilingual Matters
ean: 9781783099276, isbn: 1783099275,
This volume shares the results of research conducted within and across the complex nexus of language, religion and the internet. It identifies the dynamic and mobile ways religious practice and language interact online to modify, confirm, transform a...