Donald K. Burleson eBooks

Advanced SQL Database Programmer Handbook: Written by the world's top SQL programmers, this eBook utilizes their substantial knowledge in SQL database programming. With combined experience of over a century, these experts share their secrets for programming with SQL. This is an advanced eBook that explores topics such as using advanced SQL constructs and writing programs that utilize complex SQL queries. Not for the beginner, this eBook explores complex time-based SQL queries, managing set operations in SQL, and relational algebra with SQL. This is an indispensable handbook for any developer who is challenged with writing complex SQL inside applications....

Written by the world's top Oracle experts, this eBook is a super-advanced guide to hypercharging Oracle SQL performance. Not for the beginner, this is a guru-level overview of Oracle SQL internals tuning and may be beyond the ability of the average Oracle DBA. Explained are the internal mechanisms for Oracle indexing and how Oracle indexes can be used to fine-tune any Oracle database. Advanced Oracle SQL internals are also explored, including bitmap join indexes, STAR transformations, and SQL diagnostics and SQL tracing. This eBook is indispensable for anyone who must ensure that their Oracle SQL is optimally tuned....

Oracle Space Management Handbook: Written by some of the world's top authors, this exciting eBook provides you with everything that you need to know to manage Oracle storage. Explained are how to monitor and reduce disk I/O, how to set up tablespaces for maximum efficiency, and how to define Oracle tables and indexes to make the most efficient use of disk storage. Not for the beginner, this is a guru-level advanced Oracle handbook with highly detailed explanations of Oracle storage internals. This eBook is laden with useful scripts that will allow you to quickly see inside your data files and tablespaces and tune them for optimal performance. ...

Oracle Index Management Secrets: Written by the world's top Oracle authors, this eBook utilizes their substantial knowledge of Oracle indexing. With combined experience of over a century, the world's best authors share their secrets for using Oracle indexes to turbocharge Oracle SQL execution speed. Not for beginners, this is an advanced guide for the senior Oracle DBA and dives far into the internal mechanisms of Oracle indexing. Explained are how to monitor and optimize Oracle index structures, how to automate index rebuilding, and the internal structures of Oracle indexes....

The Unix for Oracle DBAs Pocket Reference puts within easy reach the commands that Oracle database administrators need most when operating in a Unix environment. If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that these commands are far different from those covered in most beginning Unix books. To jump start your learning process, Don Burleson has gathered together in this succinct book the Unix commands he most often uses when managing Oracle databases. You'll be able to reach into your pocket for the answer when you need to know how to: Display all Unix components related to Oracle, identify the top CPU consumers on your server, and even kill processes when necessary Stack Un...