SQL The Complete Reference, 3rd Edition

Nonfiction, Computers, Database Management, General Computing, Skills, Networking & Communications
Cover of the book SQL The Complete Reference, 3rd Edition by Andy Oppel, James R Groff, Paul N. Weinberg, McGraw-Hill Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Andy Oppel, James R Groff, Paul N. Weinberg ISBN: 9780071592567
Publisher: McGraw-Hill Education Publication: October 1, 2008
Imprint: McGraw-Hill Education Language: English
Author: Andy Oppel, James R Groff, Paul N. Weinberg
ISBN: 9780071592567
Publisher: McGraw-Hill Education
Publication: October 1, 2008
Imprint: McGraw-Hill Education
Language: English

The Definitive Guide to SQL

Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume.

  • Build SQL-based relational databases and applications
  • Create, load, and modify database objects using SQL
  • Construct and execute simple, multitable, and summary queries
  • Implement security measures with authentication, privileges, roles, and views
  • Handle database optimization, backup, recovery, and replication
  • Work with stored procedures, functions, extensions, triggers, and objects
  • Extend functionality using APIs, dynamic SQL, and embedded SQL
  • Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol
  • Understand the latest market trends and the future of SQL
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

The Definitive Guide to SQL

Get comprehensive coverage of every aspect of SQL from three leading industry experts. Revised with coverage of the latest RDBMS software versions, this one-stop guide explains how to build, populate, and administer high-performance databases and develop robust SQL-based applications.

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume.

More books from McGraw-Hill Education

Cover of the book Complete Wireless Design, Second Edition by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Living Aboard Your RV by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Diagnostic Abdominal Imaging by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Changing Play: Play, Media And Commercial Culture From The 1950s To The Present Day by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book LANGE Q&A Physician Assistant Examination, Seventh Edition by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Biomedical Engineering and Design Handbook, Volume 2 by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Repeat the Remarkable: How Strong Leaders Overcome Business Challenges to Take Their Performance to the Next Level by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book The VAR Implementation Handbook, Chapter 19 - Structural Credit Modeling and Its Relationship To Market Value at Risk by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Schaum's Outline of Quantum Mechanics, Second Edition by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Practice Makes Perfect: Advanced French Grammar, Second Edition by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Tools and Tactics for the Master DayTrader: Battle-Tested Techniques for Day, Swing, and Position Traders by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Pump Handbook by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Design for Six Sigma for Service, Chapter 9 - Theory of Inventive Problem Solving (TRIZ) by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book Fundamentals of Mobile and Pervasive Computing by Andy Oppel, James R Groff, Paul N. Weinberg
Cover of the book The Four Pillars of Profit-Driven Marketing: How to Maximize Creativity, Accountability, and ROI by Andy Oppel, James R Groff, Paul N. Weinberg
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy