Jan 19, 2012 |
4,526 views |
Book Description
- The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)
- Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever
- Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques
- New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations
From the Back Cover
Professional Microsoft SQL Server 2008 Integration Services
When SQL Server Integration Services (SSIS) was released to the market in SQL Server 2005, it took the Extract Transform Load (ETL) market by storm. Three years later, SQL Server 2008 has introduced an even more mature rendition of SSIS that is focused on improving the scalability and performance of SQL Server and also serves as a very powerful tool for performing ETL operations, which are central to data warehousing.
With this book, an assembled team of professionals has combined their years of experience and tried-and-true best practices to present you with the tools to take your SSIS Download Now »
Jan 08, 2012 |
6,179 views |
Book Description
Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less.
Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data.
Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.
- Provides proven content from a world-renowned performance and troubleshooting expert
- Emphasizes the significance of internals knowledge to rapid identification of database performance problems
- Covers the core essentials and does not waste your time with esoterica
What you’ll learn
Jan 05, 2012 |
5,146 views |
Book Description
Service Oriented Architecture (SOA) remains a buzzword in the business and IT community, largely because the ability to react quickly is of utmost importance. SOA can be the key solution to this. The challenge lies in the tricky task of integrating all the applications in a business through a Service Oriented Architecture, and “Do more with SOA Integration: Best of Packt” will help you do just that with content from a total of eight separate Packt books.
“Do more with SOA Integration: Best of Packt” will help you learn SOA integration from scratch. It will help you demystify the concept of SOA integration, understand basic integration technologies and best practices, and get started with SOA Governance. “Do more with SOA Integration: Best of Packt” draws from eight separate titles from Packt’s existing collection of excellent SOA books:
- BPEL cookbook
- SOA Approach to Integration
- Service Oriented Architecture: An Integration Blueprint
- Building SOA-Based Composite Applications Using NetBeans IDE 6
- Oracle SOA Suite Developer’s Guide
- WS-BPEL 2.0 for SOA Composite Applications with Oracle SOA Suite 11g
- Oracle Modernization Solutions
- SOA Governance
The chapters in “Do more with SOA Integration: Best of Packt” help you to learn Download Now »
Jan 03, 2012 |
5,567 views |
Book Description
The Oracle Database 11g: SQL Fundamentals I exam is the first stepping stone in getting the Oracle Certified Associate Certification for Oracle Database 11g. The SQL programming language is used in every major relational database today and understanding the real world application of it is the key to becoming a successful DBA.
This book gives you: the essential real world skills to master relational data manipulation with Oracle SQL and prepares you to become an Oracle Certified Associate. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.
We begin with the essentials of why databases are important in today’s information technology world and how they work.
We continue by explaining the concepts of querying and modifying data in Oracle using a range of techniques, including data projection, selection, creation, joins, sub-queries and functions. Finally, we learn to create and manipulate database objects and to use them in the same way as today’s expert SQL programmers.
This book prepares you to master the fundamentals of the SQL programming language using an example-driven method that is easy to understand
This definitive certification guide provides a disciplined approach to be adopted for successfully clearing the 1Z0-051 SQL Fundamentals I exam Download Now »
Dec 27, 2011 |
4,170 views |
Book Description
Introduce your students to the new generation of Microsoft Office with the new generation of Shelly Cashman Series books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Access 2010, we’re continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today’s students. In Microsoft Access 2010: Complete you’ll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of the Access 2010 software through experimentation, exploration, and planning ahead. Brand new end of chapter exercises prepare students to become more capable software users by requiring them to use critical thinking and problem-solving skills to create real-life documents.
- A step-by-step, screen-by-screen approach allows students to successfully learn and retain information to be used in their personal and professional lives
- Increases students’ retention with brand new end-of-chapter exercises, including Make It Right, Extend Your Knowledge, and Make It Personal, which emphasize problem-solving and experimentation.
Table of Contents
Access Common Elements.
1. Databases and Database Objects: An Introduction. Download Now »
Dec 24, 2011 |
10,126 views |
Book Description
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL.
This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you’ll learn how to deal with a host of common SQL dilemmas.
- Why is proper column naming so important?
- Nulls in your database are causing you to get wrong answers. Why? What can you do about it?
- Is it possible to write an SQL query to find employees who have never been in the same department for more than six months at a time?
- SQL supports “quantified comparisons,” but they’re better avoided. Why? How do you avoid them?
- Constraints are crucially important, but most SQL products don’t support them properly. What can you do to resolve this situation?
Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of SQL available. Download Now »
