Alex Kriegel eBooks

Teaching the SQL skills that businesses demand when hiring programmersIf you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL. Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL codeUses a hands-on style and...

Gives programmers two-in-one coverage, with both a "how-to" on SQL functions and a complete SQL functions referenceSQL is the standard language for database queries; this book's advanced coverage helps programmers write their own SQL functionsCovers both the internationally standardized SQL 99 functions and the hundreds of additional functions introduced by vendors, including the subtle variations required to successfully migrate or interoperate between vendor productsCovers the latest versions of the major relational database management system (RDMS) applications: Microsoft SQL Server, Oracle, IBM DB2, and MySQL...

Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2Knowledge of this ubiquitous database programming language is becoming more critical as IT departments move toward more integrated heterogeneous platformsCovers growing use of SQL with Web services and XMLCD-ROM includes a complete sample database and trial versions of major relational database management software...