Category Review: Advanced SQL Functions in Oracle 10g (Wordware Applications Library) This book is a comprehensive guide to advanced SQL functions available in Oracle 10g. It covers various topics such as window functions, user-defined functions, and data types. The author provides clear explanations of each function with examples that help readers understand how they work. Additionally, the book includes practical exercises that allow readers to apply what they have learned. Overall, this is a great resource for anyone looking to improve their SQL skills in Oracle 10g. SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly)) This cookbook provides solutions to common database development problems using SQL queries. It covers topics such as data manipulation, aggregation, filtering, and sorting. The author uses real-world examples to illustrate how these techniques can be applied in practice. One of the strengths of this book is its focus on practical applications rather than theoretical concepts. This makes it a great resource for database developers who want to learn SQL quickly and efficiently. ORACLE PL/SQL 101 (Oracle Press) This book provides an introduction to Oracle PL/SQL, which is a programming language used to develop stored procedures and functions in Oracle databases. The author covers the basics of PL/SQL syntax, data types, control structures, and SQL integration. Additionally, the book includes examples that help readers understand how to use PL/SQL to solve common database problems. Overall, this is a great resource for anyone looking to learn PL/SQL programming. ORACLE PL/SQL Performance Tuning Tips & Techniques (Oracle Press) This book provides practical tips and techniques for optimizing Oracle PL/SQL code for performance. It covers topics such as query optimization, indexing, caching, and concurrency control. The author uses real-world examples to illustrate how these techniques can be applied in practice. One of the strengths of this book is its focus on hands-on experience rather than theoretical concepts. This makes it a great resource for database administrators who want to improve the performance of their PL/SQL applications. Oracle Business Intelligence Discoverer 11g Handbook (Oracle Press) This handbook provides an in-depth guide to using Oracle Business Intelligence Discoverer, which is a tool used to create interactive reports and dashboards for business intelligence purposes. The author covers topics such as data modeling, report design, and data visualization. Additionally, the book includes examples that help readers understand how to use Discoverer to solve common business intelligence problems. Overall, this is a great resource for anyone looking to learn how to use Oracle Business Intelligence tools effectively. OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) This exam guide provides a comprehensive review of the topics covered on the Oracle Certified Associate (OCA) and Oracle Certified Professional (OCP) database administration exams for Oracle Database 11g. The author covers topics such as data modeling, SQL programming, security, and performance tuning. Additionally, the book includes practice questions and a CD-ROM with additional resources. Overall, this is a great resource for anyone looking to prepare for these certification exams. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach (Wordware Applications Library) This book provides a collection of SQL practice problems that readers can use to improve their skills in various areas such as data manipulation, aggregation, filtering, and sorting. The author provides clear explanations of each problem and how it can be solved using SQL queries. Additionally, the book includes solutions to each problem for reference. Overall, this is a great resource for anyone looking to learn SQL through hands-on practice. MySQL Workbench: Data Modeling & Development (Oracle Press) This book provides an introduction to MySQL Workbench, which is a tool used for data modeling and development in MySQL databases. The author covers topics such as entity relationship diagrams, database design patterns, and SQL programming. Additionally, the book includes examples that help readers understand how to use Workbench to solve common database problems. Overall, this is a great resource for anyone looking to learn how to use MySQL Workbench effectively. SQL in 10 Minutes, Sams Teach Yourself (4th Edition) (Wordware Applications Library) This book provides an introduction to SQL programming in just 10 minutes. It covers topics such as data types, basic SQL statements, and query optimization. The author uses clear explanations and examples to illustrate how these concepts work. Additionally, the book includes practical exercises that allow readers to apply what they have learned. Overall, this is a great resource for anyone looking to learn SQL quickly and efficiently. Advanced Oracle PL/SQL Developer's Guide - Second Edition (Oracle Press) This guide provides an in-depth look at advanced topics in Oracle PL/SQL programming. It covers topics such as object-oriented programming, multithreading, and dynamic SQL. Additionally, the book includes examples that help readers understand how to use these techniques effectively. One of the strengths of this book is its focus on practical applications rather than theoretical concepts. This makes it a great resource for experienced PL/SQL developers who want to take their skills to the next level. In conclusion, the products reviewed in this category are all valuable resources for individuals looking to improve their database development and administration skills. Whether you are a beginner or an experienced professional, there is something here for everyone.