Wow! eBook – Blog

Book Description

Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. You’ll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.

• Step through the basic SQL syntax
• Learn how to use best practices in database design
• Master advanced syntax like inner joins, groups, and subqueries
• Understand the SQL datatypes
• And much more…

About the Author
Rudy Limeback is a semi-retired SQL Consultant living in Toronto, Canada. His SQL experience spans more than 20 years, and includes working with DB2, SQL Server, Access, Oracle, and MySQL.

He is an avid participant in discussion forums, primarily at SitePoint (http://sitepoint.com/forums/). His two Web sites are http://r937.com/ for SQL and http://rudy.ca/ for personal stuff. When not glued to his computer, Rudy enjoys playing touch football and frisbee golf. Download Now »

Book Description

Extract, Transform, and Load data to build a dynamic, operational data warehouse

• Build a working data warehouse from scratch with Oracle Warehouse Builder.
• Cover techniques in Extracting, Transforming, and Loading data into your data warehouse.
• Learn about the design of a data warehouse by using a multi-dimensional design with an underlying relational star schema.
• Written in an accessible and informative style, this book helps you achieve your warehousing goals, and is loaded with screenshots, numerous tips, and strategies not found in the official user guide.

In today’s economy, businesses and IT professionals cannot afford to lag behind the latest technologies. Data warehousing is a critical area to the success of many enterprises, and Oracle Warehouse Builder is a powerful tool for building data warehouses. It comes free with the latest version of the Oracle database.

Written in an accessible, informative, and focused manner, this book will teach you to use Oracle Warehouse Builder to build your data warehouse. Covering warehouse design, the import of source data, the ETL cycle and more, this book will have you up and running in next to no time.

This book will walk you through the complete process of planning, building, and deploying a data warehouse using Oracle Warehouse Builder. By the book’s end, you will have built your own data warehouse from scratch.

Starting with the installation of the Oracle Database and Warehouse Builder software, this book then covers the analysis of source data, designing a data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. You’ll follow the whole process with detailed screenshots of key steps along the way, alongside numerous tips and hints not covered by the official documentation. Download Now »

Book Description

Convert your Oracle Forms applications to Oracle APEX successfully

• Convert your Oracle Forms Applications to Oracle APEX
• Master the different stages of a successful Oracle Forms to APEX conversion project
• Packed with screenshots and clear explanations to facilitate learning
• A step-by-step tutorial providing a proper understanding of Oracle conversion concepts

Although Oracle Forms remains popular, many developers now see Oracle APEX as a preferred technology. Oracle Forms to Oracle APEX conversion projects follow a well-defined procedure, but sub-procedures and complexities can arise that make such conversion projects a challenging job.
This book will take you through a real Oracle Forms to APEX conversion project. It explains all the elements of the conversion, from generating XML files to the deployment of a working APEX application. By the end of this book, you will have mastered the process of Forms conversion.

The book starts with the details of the Forms project, and prepares you for the conversion process. You will use the rwconverter and Reports Builder in Oracle Developer Suite to generate XML and other useful files. You will plan and define the business logic for your conversion project. You will use the Forms Converter in Oracle APEX to convert and customize your Oracle Forms applications. Finally, you will deploy your application.

With this book you will understand what a Forms Conversion project in Oracle APEX means, what needs to be done, and what steps are necessary in order to create a fully functional and meaningful conversion project. This book shows the best way to convert applications from Forms to APEX. Download Now »

Book Description

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions is the definitive book if you’re a developer or DBA who works with Oracle-driven database applications. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.

One of the world’s foremost Oracle experts, Thomas Kyte covers every important feature and function of the database: the importance, inner workings, proper usage, and pitfalls if handled incorrectly. This book will show you how to program correctly with the Oracle database and exploit its feature-set effectively. As a result, you will be able to build fast, effective, scalable, and secure Oracle applications.

About the Author
Thomas Kyte is the vice president of the Core Technologies Group at Oracle Corporation and has been with the company since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c.

At Oracle, Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database, and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large-scale, heterogeneous databases and applications for military and government clients. Download Now »

Book Description

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he’s gathered on PL/SQL usage over those years and applies the 80/20 rule &emdash; cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

• Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
• Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
• Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory. Download Now »

Book Description

Today, interpreting data is a critical decision-making factor for businesses and organizations. If your job requires you to manage and analyze all kinds of data, turn to Head First Data Analysis, where you’ll quickly learn how to collect and organize data, sort the distractions from the truth, find meaningful patterns, draw conclusions, predict the future, and present your findings to others.

Whether you’re a product developer researching the market viability of a new product or service, a marketing manager gauging or predicting the effectiveness of a campaign, a salesperson who needs data to support product presentations, or a lone entrepreneur responsible for all of these data-intensive functions and more, the unique approach in Head First Data Analysis is by far the most efficient way to learn what you need to know to convert raw data into a vital business tool.

You’ll learn how to:

• Determine which data sources to use for collecting information
• Assess data quality and distinguish signal from noise
• Build basic data models to illuminate patterns, and assimilate new information into the models
• Cope with ambiguous information
• Design experiments to test hypotheses and draw conclusions Download Now »