02633nam a2200265 a 4500 1/45302 140822s2003 ne 001 0 eng 9781558608764 1558608761 48262 OPELS eng OPELS OKU OCLCQ OPELS OCLCQ OCLCF GR-PeUP Harrington, Jan L. SQL [electronic resource] : clearly explained / Jan L. Harrington. 2nd ed. Amsterdam ; New York : Morgan kaufmann Publishers, c2003. 1 online resource (xvi, 352 p.) Includes index. Installing and running MySQL -- Creating and loading databases -- Introduction to SQL -- Simple SQL retrieval -- Retrieving data from more than one table : joins -- Advanced retrieval operations -- Calculations and grouping queries -- Data modification -- Schemas and tables -- Views, temporary tables, and indexes -- Users, sessions, and transaction control -- Embedded SQL -- Dynamic SQL -- Unimplemented SQL-92 features -- Object-oriented features of the SQL: 1999 standard. This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including formulating SQL queries, understanding how queries are processed by the DBMS, maximizing performance, using SQL to enter, modify, or delete data, creating and maintaining database structural elements, and embedding SQL in applications. Features Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92. Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based. Web enhanced with extra features available online at www.mkp.com. * Second edition of classic SQL handbook * Updated to cover changes in the SQL language standard (SQL:1999) * Includes CD with MySQL software. SQL (Computer program language). Electronic books. INST UNIPILB EBOOKS 20140917 00b48262 00b48262 ONLINE 0 ScienceDirect http://www.sciencedirect.com/science/book/9781558608764 /webopac/covers/03/48262_9781558608764.jpg /webopac/covers/03/48262_1558608761.jpg