Gavin Powell eBooks

An all-in-one study guide prepares you for the updated Oracle Certified Associate certificationIt's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting dataWalks you through using conversion functions and conditional expressionsAddresses displaying data from multiple tables, manipulating data, database mai...

The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficientlyShows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and OracleCovers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performanceProvides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements...

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, ...

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside inde...