| Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.
- Understand the definition and characteristics of relational databases and SQL’s role within RDBMS
- Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server
- Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL)
- Comprehend Data Manipulation Language (DML) from different vendors’ perspectives
- Master single-table select statements and multitable queries from the ground up
- Explore in-depth SQL functions, operators, and data types for major RDBMS implementations
- Discover new SQL developments including XML, OLAP, Web services, and object-oriented features
|
|
|
IoT as a Service: 4th EAI International Conference, IoTaaS 2018, Xi’an, China, November 17–18, 2018, Proceedings (Lecture Notes of the Institute for ... and Telecommunications Engineering)
This book constitutes the refereed post-conference proceedings of the Fourth International Conference on IoT as a Service, IoTaaS 2018, which took place in Xi’an, China, in November 2018. The 50 revised full papers were carefully reviewed and selected from 83 submissions. The technical track present IoT-based services in... | | 209 Fast Spare-Time Ways to Build Zero Cash into 7 Figures a Year in Real EstateMore fortunes are built in real estate on borrowed money than in any other business. And you can build your fortune in real estate using borrowed money too–if you follow the advice and tips in this book.
Whether you’re making your first foray into real estate investing or have invested for a number of years, 209 Fast Spare-Time Ways... | | Photoshop CC: The Missing Manual
Photoshop CC is truly amazing, but it can also be overwhelming if you’re just getting started. This book makes learning Photoshop as easy as possible by explaining things in a friendly, conversational style—without technical jargon. After a thorough introduction to the program, you’ll delve deep into... |
|