Database Administration

The Complete Guide to DBA Practices and Procedures

Author: Craig S. Mullins

Publisher: Addison-Wesley

ISBN: 0133012727

Category: Business & Economics

Page: 928

View: 9641

DOWNLOAD NOW »
Database Administration, Second Edition , is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have. Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more. This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.

Oracle Database 12c DBA Handbook

Author: Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 007179879X

Category: Computers

Page: 704

View: 5940

DOWNLOAD NOW »
The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online

Snappy Interviews

100 Questions to Ask Oracle Dbas

Author: Christopher Lawson

Publisher: CreateSpace

ISBN: 9781434826206

Category: Computers

Page: 118

View: 1435

DOWNLOAD NOW »
The questions in this guide have been selected using this framework: (1) Questions should reflect understanding of concepts (2) Questions should reflect actual hands-on experience (3) Questions should not be based on memorization of arcane names or syntax (4) Questions should reflect issues seen by the majority of DBAs of that skill level. The intent of the questions is that most DBAs, for a given skill level, can successfully answer most of the interview questions. Naturally, no one person could be expected to flawlessly answer all of the senior-level questions. Even the most adept DBAs have some areas of weakness. In order to test the fairness of the questions, I asked numerous DBAs, from different backgrounds and companies, to review the questions.

Vault.com Guide to the Case Interview

Author: Mark Asher,Marcy Lerner

Publisher: Vault.com

ISBN: 9781581310993

Category: Business consultants

Page: 151

View: 3435

DOWNLOAD NOW »
Anyone aiming for a prestigious position at a consulting firm will face the most daunting of barriers: the case interview. Packed with information, this guide offers answers on how to structure, analyze and solve case interview questions, solve mind-bending guesstimates and brainteasers, and keep current on behavioral interviewing trends.

Advanced SQL, 1999

Understanding Object-relational and Other Advanced Features

Author: Jim Melton

Publisher: Morgan Kaufmann

ISBN: 9781558606777

Category: Computers

Page: 563

View: 9093

DOWNLOAD NOW »
This guide documents SQL: 1999Us advanced features in the same practical, "programmercentric" way that the first volume documented the language's basic features. This is no mere representation of the standard, but rather authoritative guidance on making an application conform to it, both formally and effectively.

C & C++ Interview Questions You'll Most Likely Be Asked

Author: Vibrant Publishers

Publisher: Vibrant Publishers

ISBN: 1458188647

Category: Computers

Page: 92

View: 2117

DOWNLOAD NOW »
C & C++ Interview Questions You'll Most Likely Be Asked is a perfect companion to stand a head above the rest in today's competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build an IT career.

Programming Interviews Exposed

Secrets to Landing Your Next Job

Author: John Mongan,Noah Suojanen Kindler,Eric Giguère

Publisher: John Wiley & Sons

ISBN: 1118283406

Category: Computers

Page: 336

View: 1350

DOWNLOAD NOW »
Be prepared for your next job interview with this tried-and-true advice In today's tight job market, competition for programming jobs is hotter than ever. This third edition of a popular guide to programming interviews includes new code examples, information on the latest languages, new chapters on sorting and design patterns, tips on using LinkedIn, and a downloadable app to help prepare applicants for the interview. Like its earlier editions, this guide covers what software companies and IT departments want their programmers to know and includes plenty of helpful hints to boost your confidence. Looks at current job search and hiring processes, such as the rise of LinkedIn and other social networks as recruiting resources Addresses the most important languages for a programmer to know and features examples in multiple languages Includes new programming questions designed to sharpen your knowledge Features all-new chapters on design patterns and sorting, including how to deal with memory constraints and mobility issues Walk into your next job interview with confidence, knowing you have thoroughly studied this newest edition of Programming Interviews Exposed.

101 Great Answers to the Toughest Interview Questions

Author: Ron Fry

Publisher: Open Road Media

ISBN: 1504055187

Category: Business & Economics

Page: 208

View: 3899

DOWNLOAD NOW »
Updated for today’s job market, the classic interview prep guide helps you say the right words and get the job you want. No matter how good you look, how much research you’ve done, or how perfectly your qualifications match the job description, if you’re not prepared with great answers to the toughest interview questions, you won’t get the job. 101 Great Answers to the Toughest Interview Questions is a manual that will help you home in on exactly what the interviewer is trying to learn . . . with each and every question he or she asks. If you’ve never done well on interviews, never even been on a job interview, or just want to make sure a lousy interview doesn’t cost you a job you really want, Ron Fry will help you get that job—as he has helped millions of people nationwide and throughout the world. This twenty-fifth anniversary edition of 101 Great Answers to the Toughest Interview Questions is thoroughly updated to reflect the realities of today’s job market. Whatever your age and experience, whether you are seeking your very first job or finally breaking into the executive office, this is the one book you need to get that job.

Expert Oracle Database Architecture

Author: Thomas Kyte,Darl Kuhn

Publisher: Apress

ISBN: 1430262990

Category: Computers

Page: 824

View: 5743

DOWNLOAD NOW »
Now in its third edition, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career. Revised to cover Oracle Database 12c Proof-by-example approach: Let the evidence be your guide Dives deeply into Oracle Database’s most powerful features

Ace the Programming Interview

160 Questions and Answers for Success

Author: Edward Guiness

Publisher: John Wiley & Sons

ISBN: 1118757963

Category: Computers

Page: 448

View: 4060

DOWNLOAD NOW »
Be prepared to answer the most relevant interview questions and land the job Programmers are in demand, but to land the job, you must demonstrate knowledge of those things expected by today's employers. This guide sets you up for success. Not only does it provide 160 of the most commonly asked interview questions and model answers, but it also offers insight into the context and motivation of hiring managers in today's marketplace. Written by a veteran hiring manager, this book is a comprehensive guide for experienced and first-time programmers alike. Provides insight into what drives the recruitment process and how hiring managers think Covers both practical knowledge and recommendations for handling the interview process Features 160 actual interview questions, including some related to code samples that are available for download on a companion website Includes information on landing an interview, preparing a cheat-sheet for a phone interview, how to demonstrate your programming wisdom, and more Ace the Programming Interview, like the earlier Wiley bestseller Programming Interviews Exposed, helps you approach the job interview with the confidence that comes from being prepared.

Expert One-on-One Oracle

Author: Thomas Kyte

Publisher: Apress

ISBN: 9781430212799

Category: Computers

Page: 1328

View: 3724

DOWNLOAD NOW »
* A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.

Security + Study Guide and DVD Training System

Author: Syngress

Publisher: Elsevier

ISBN: 9780080480817

Category: Computers

Page: 784

View: 9325

DOWNLOAD NOW »
Why has CompTIA (the high-profile Computer Technology Industry Association behind the wildly popular A+ and Network+ certifications) targeted security for its latest credential? Thanks to soaring e-business initiatives and worldwide Internet connectivity, recent survey stats from the Computer Security Institute (CSI) show we need more network security specialists-fast! Boasting a one-of-a-kind integration of text, DVD-quality instructor-led training, and Web-based exam simulation and remediation, Security+ Study Guide & DVD Training System gives students 100% coverage of official CompTIA Security+ exam objectives plus realistic test prep. Security+ is sure to become an instant industry standard. Leading cert industry publications and Web portals forecast the rapid rise of security certifications in 2003, and CompTIA's growth curve of A+ and Network+ technicians suggests that Security+ certified engineers could easily number 100,000 by the end of next year The first Security+ study resource to market, Security+ Study Guide & DVD Training System bundles all 3 of these teaching technologies to give Security+ candidates the edge they need to pass this career-boosting new exam-and achieve certification-on their very first try. Syngress has become a leader in IT certification-blending innovative teaching methodologies with such groundbreaking tools as exam simulators, instructor-led DVDs, and integrated Web-based support.

Oracle PL/SQL by Example

Author: Benjamin Rosenzweig,Elena Rakhimov

Publisher: Pearson Education

ISBN: 0137151705

Category: Computers

Page: 768

View: 8923

DOWNLOAD NOW »
This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example , Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers. One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice. This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes • Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL’s role in PL/SQL • Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements • Efficiently handling errors and exceptions • Working with cursors and triggers, including Oracle 11g’s powerful new compound triggers • Using stored procedures, functions, and packages to write modular code that other programs can execute • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced PL/SQL capabilities • Handy reference appendices: PL/SQL formatting guide, sample database schema, ANSI SQL standards reference, and more

Vault Guide to Finance Interviews

Author: D. Bhatawedekhar,Dan Jacobson,Hussam Hamadeh,Vault (Firm)

Publisher: Vault Reports Incorporated

ISBN: 9781581313048

Category: Business & Economics

Page: 157

View: 6727

DOWNLOAD NOW »
If you're looking for a job with an investment bank, mutual fund, hedge fund or commercial bank, this is the guide for you. The Vault Guide to Finance Interviews is a must for your finance job search.

Oracle Dba Interview Questions, Answers, and Explanations

Oracle Database Administrator Certification Review

Author: Oracookbook

Publisher: N.A

ISBN: 9781933804262

Category: Computers

Page: 120

View: 2510

DOWNLOAD NOW »
The Ultimate Reference & Learning Guide for Oracle Database Administrators! 100 Certification Questions, Answers, and Explanations Oracle has long been setting the standard in database technology, and to stay competitive administrators need to have a current understanding of Oracle's newest improvements. With Oracle Ultimate DBA Interview Questions even 10g issues are covered, so you will be current and competitive. Using this guide to prepare for a job interview or to brush up on the newest trends in Oracle will aid any DBA in acquiring new skills. This guide will explain many common Oracle errors, standard database maintenance, performance tuning, and new features. More than just Oracle documentation and sales pitches, this guide explains Oracle from the perspective of the DBA so that you can evaluate a DBA candidate or land that DBA position with ease. Key certification and interview topics include: . Oracle 10g and 9i Database Administration . Database interactions with Windows . Database design, performance tuning, audit and security . Database monitoring and maintenance . OEM and OMS troubleshooting

Hadoop: The Definitive Guide

Author: Tom White

Publisher: "O'Reilly Media, Inc."

ISBN: 1449338771

Category: Computers

Page: 688

View: 5813

DOWNLOAD NOW »
Ready to unlock the power of your data? With this comprehensive guide, you’ll learn how to build and maintain reliable, scalable, distributed systems with Apache Hadoop. This book is ideal for programmers looking to analyze datasets of any size, and for administrators who want to set up and run Hadoop clusters. You’ll find illuminating case studies that demonstrate how Hadoop is used to solve specific problems. This third edition covers recent changes to Hadoop, including material on the new MapReduce API, as well as MapReduce 2 and its more flexible execution model (YARN). Store large datasets with the Hadoop Distributed File System (HDFS) Run distributed computations with MapReduce Use Hadoop’s data and I/O building blocks for compression, data integrity, serialization (including Avro), and persistence Discover common pitfalls and advanced features for writing real-world MapReduce programs Design, build, and administer a dedicated Hadoop cluster—or run Hadoop in the cloud Load data from relational databases into HDFS, using Sqoop Perform large-scale data processing with the Pig query language Analyze datasets with Hive, Hadoop’s data warehousing system Take advantage of HBase for structured and semi-structured data, and ZooKeeper for building distributed systems