OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053

Description: Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II exam with help from this exclusive Oracle Press guide. In each chapter, youAnd#39;ll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what youAnd#39;ve learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference.

MySQL 5.0 Certification Study Guide (MySQL Press)

Product Description

This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.

Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers

The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

Oracle 11g For Dummies (For Dummies (Computer/Tech)) (2009)

Product Description
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle.

This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers:

* The building blocks behind the database engine as well as Oracle’s physical and logical structures
* Hardware, software, system, and storage requirements for implementation
* How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
* Daily and intermittent tasks necessary to keep your database running properly
* How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures
* When to use online, offline, controlfile, and archivelog backups
* Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities
* Different ways to manage your database
* How to automate jobs with the Oracle Scheduler
* Using SQL in Oracle, and a great deal more

Oracle Application Express is an easy-to-use application development environment built on the Oracle technology stack. There are two aspects of that previous sentence that you may find jarring—that Oracle, a company widely known for its database technology, has an application development environment, and that Oracle, a company thought of as delivering high-end, enterprise-ready technology, has anything that is easy to use.

But, as this book will show, the introductory statement is completely accurate. Oracle Application Express, commonly known as Oracle APEX or simply APEX, does benefit from the long-established enterprise-class robustness that is the hallmark of Oracle technology. The applications you build will be able to support hundreds of users and many terabytes of data, scalability far beyond even the imagination of most other development environments.

And Oracle APEX, with its declarative, wizard-driven methodology, is truly easy to use. In the course of the few hundred pages of this book, you will not only learn about how to use APEX, you will create a usable order entry system. The fast learning curve presented in these pages is a consequence of many years of development and refinement of the APEX product, which began life almost a decade ago within Oracle.

By the end of this volume, you will know enough to create your own applications, as well as having the knowledge and understanding of Oracle APEX and the world of Oracle technology to explore further refinements on your own.

Best of all, you can use APEX with absolutely no cost—either in a hosted environment, as suggested in Chapter 1, or with a free version of the Oracle database.

Welcome to the world of Oracle Application Express!

This book is aimed at a particular group of users—those who are not familiar with Oracle Application Express. The book assumes that you have a basic knowledge of application development, the type you could get from playing around with a personal database such as Access. In fact, this book was written with an Access developer in mind—an Access developer looking to step up to a more scalable and reliable environment, with reduced maintenance overhead and greater integration between application systems.

This book covers the use of Oracle Application Express. Although the book is based on the 3.5 version, you can use the book with older versions as well. However, since the book will use a hosted version of Oracle Application Express, and since both the Oracle database that support the product and the product itself are available as free downloads from http://otn.oracle.com, you should be able to use the latest version easily.

PHP and MySQL Everyday Apps For Dummies is a one-stop reference providing all you need to build dynamic, real-world, ready-to-use apps with the popular PHP (a scripting language) and MySQL (a database system) software. The book is a hands-on, go-to-guide that
Walks you through installing the applications files from the CD-ROM and setting up your programming environment

Contains all the code needed to create seven applications:
User authentication with HTTP
User login
On-line catalog
Shopping cart
Content management system
Web forum
Building and managing a mailing list (on the CD-ROM)
Automates the programming process and walks you through building the application from start to finish

Explains how to write secure code

Features complete code—not just snippets, but neatly assembled packages with “instant” real-world functionality

Shows how to build the applications in two forms — procedural and object-oriented programming — providing programmers who want to switch to the object-oriented method of coding (which is new in PHP 5!) with the essential know-how

Includes a companion CD-ROM that contains every line of code in the applications from the book plus a bonus chapter that shows how to build a mailing list

Information on each application includes a discussion of issues, structure of the database, code listings, and an explanation of the code. You can use these applications as is, modify them for use on your Web site, or build your own application using techniques described. If you want real-world Web apps you can use right away, this is the book for you.

The smart way to learn Microsoft Windows SharePoint Services 3.0—one step at a time!

Experience learning made easy—and quickly teach yourself how to use Windows SharePoint Services to enable effective team collaboration. With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

•Build your own SharePoint site with easy-to-use templates
•Create lists and libraries to store information
•Add discussion boards, wikis, and blogs
•Set up Document and Meeting Workspaces for easy collaboration
•Share calendars, contacts, and data from Microsoft Office programs
•Customize your pages with Web Parts

Your all-in-one learning experience includes:
•Files for building skills and practicing the book’s lessons
•Fully searchable eBook
•Windows Vista Product Guide eReference—plus other resources on CD

Are you stymied by SharePoint? This plain-English guide offers simple instructions and focused coverage of this powerful tool, giving you practical solutions to real-world SharePoint challenges. You’ll install SharePoint, create sites and grant access, manage data and business processes, use sites to improve employee relations and marketing, put interactive reports and forms on a portal, and much more!

• Set up a SharePoint portal
• Manage portal content and Office documents
• Integrate Office 2007 with SharePoint
• Use SharePoint to collaborate
• Create personalized sites
• Monitor and back up your portal

Workflow is the glue that binds information worker processes, users, and artifacts. Without workflow, information workers are just islands of data and potential. Workflow in the 2007 Microsoft Office System details how to implement workflow in SharePoint 2007 and the rest of the 2007 Office System to help information workers share data, enforce processes and business rules, and work more efficiently together or solo.

This book covers anything you’re likely going to need to know — from what workflow is all about, to creating new Activities; from InfoPath forms to ASP.Net forms; from the Rules Engine to the object model. There’s even a section on integrating Office 2003 clients with SharePoint 2007 workflows. You’ll come away from reading this book with solid knowledge of how to implement workflow in the new world of Office and SharePoint

SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional.

SQL Server Distilled, Second Edition is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). For example, any DBA who implemented the security precautions detailed in the book would not have been affected by the infamous Slammer virus.

This second edition offers practical advice on how to implement good practices that will ward off future viruses before they are even created, and it contains new content that reflects all updates to SQL Server’s security mechanisms.