Dotnetcat » .NET Books » Database books

Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.
This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:

• Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)


• Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)


• Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)


• Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider

The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types)
For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.
"Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases."
--Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

This unique book-and-video package introduces ASP.NET 4 to programmers

Microsoft ASP.NET allows you to build dynamically generated Web pages from database content. Written by a well-known authority on ASP.NET, this book-and-DVD package is an ideal place to start learning about the capabilities of ASP.NET 4. Each lesson covers both the ASP.NET Web Forms Framework and the ASP.NET MVC 2 Framework and is designed to teach you the fundamentals of the topic before progressing to a step-by-step tutorial. An instructional video for each of the 48 tutorials is provided on the DVD that accompanies the book.

Lessons include:

• Anatomy of an HTML Page
• Using Common HTML Tags
• Adding Style to an HTML Page
• State Management in ASP .NET 4
• Configuring Your Web Application
• Web Site Projects vs. Web Application Projects
• ASP.NET Web Forms Web Application
• ASP.NET MVC Web Application
• The Page Life Cycle in Web Forms
• The Request Life Cycle in MVC
• Server Controls in Web Forms
• HTML Helpers in MVC
• Master Pages
• Skins and Themes in Web Forms
• Partial Views in MVC
• Validation Controls in Web Forms
• Validation Helpers in MVC
• Dynamic Data in Web Forms
• Display Templates in MVC
• Dynamic Data Templates in Web Forms
• Using the AJAX Extensions in Web Forms
• Using jQuery for Ajax in Web Forms Authentication

ASP.NET 4 24-Hour Trainer is an exceptional book-and-video package ideal for everyone from beginners to more advanced developers.

The complete software developer's guide to working in .NET environments Praise for .NET Patterns: "Was both insightful and comprehensive. It's great to see these patterns presented within the context of many architectural dilemmas facing the vastly interconnected enterprise. Web service architects are sure to see enormous value in this text." --Ed Draper, Microsoft Patterns have proven to be practical tools for the programmer who knows how to use them. In .NET Patterns, distributed computing and .NET expert Christian Thilmany presents both an introduction to patterns for programmers working in the .NET environment and a library of patterns unique to the .NET platform. Part of John Vlissides' critically acclaimed Addison-Wesley Software Patterns Series, .NET Patterns extends the proven concept of design patterns into the arena of .NET design and development. Now, .NET developers can depend on patterns to provide solutions to recurring problems in software design.In addition to covering both lower and higher level programming with patterns, this book also includes helpful primers on XML and web services, as well as thorough coverage of debugging, exceptions, error handling, and architecture. Whether you're working in .NET environments or transitioning to .NET environments, you'll find .NET Patterns a comprehensive resource for software solutions.

This article is a sequel to "A Portable Database Diagram," which showed how to retrieve metadata from an RDBMS via ADO and present it in Scalable Vector Graphics (SVG) format.

In this article, Dave Beauchemin explains how to migrate the existing ASP application that used MSXML 4.0 to .NET, using the System.Xml classes, ASP.NET, and XML Web Services. Dave also explores some of the pitfalls encountered in migrating the application to the .NET Framework.

“Brian Noyes’ writing style easily captures your attention as he elaborates on all aspects of data binding in his book. He has a refreshingly clear and crisp delivery as he starts each chapter with a simple tour of each topic, and then leads you into practical concerns for sound practices and extensibility opportunities. Most importantly, as Brian explains approaches to data-binding architecture, patterns of usage, the value of data sets, binding controls and the rest, he always describes how he reaches his recommendations on the topic. This book is perfect for newcomers to .NET 2.0, but also for those that have some experience. Anyone who cares about data in their applications (okay, that should be almost everyone) is guaranteed to learn something new and useful by reading Brian’s book.”
—Michele Leroux Bustamante, IDesign chief architect, Microsoft regional director, and MVP“Brian has saved me a lot of time. I’m writing The Hitchhiker’s Guide to Visual Studio and SQL Server 2005 (7th Edition) and I’m not going to have to cover data binding nearly as deeply because Brian has done it for me. His book gets right to the meat of the subject and makes data binding look easy. I was also pleased to see that the book focuses on the misunderstood and under-applied Windows Forms architecture. It’s a must-read for anyone trying to make their application more interactive and to leverage the new Visual Studio 2005 technology. I’m planning to point my readers to this resource when they need an in-depth treatment of data binding.”
—William Vaughn, president, Beta V Corporation“Data binding has finally come of age in Windows applications. Back in the Visual Studio 6.0 days, I ignored data binding completely and wrote my own repetitive code to encapsulate my business logic. With Visual Studio 2005, we finally have a robust and compelling data-binding technology. To ignore it today would make you inefficient and put you behind the curve. Brian delivers a clear and concise discussion of a core topic of development for Windows today. A combination of an easy-to-follow conversational yet technical tone, excellent examples, and solid explanations make this a must-read for any developer writing for Windows or learning to write for Windows.”
—Stephen Forte, chief technical officer, Corzen Inc.“This book provides a clear, readable, and in-depth treatment of data binding, with detailed discussions of best practices in the presentation and use of data. Brian communicates his knowledge on the mechanics of data binding to give the low-level understanding that makes all the difference when building sophisticated applications and troubleshooting difficult problems. Effective data binding can enormously reduce the amount of code in your applications and will allow new levels of sophistication in your development. Read this book.”
—Jonathan Cogley, chief executive officer, Thycotic, ASPInsider, and C# MVP“The .NET Framework 2.0, Visual Studio .NET 2005, and Windows Forms 2.0 incorporate the most powerful data-binding platform yet, and absolutely need a book like this to expose it. Brian’s extensive data-binding knowledge and experience shine through as he comprehensively explores its many facets, starting with the fundamentals before tackling a wide variety of real-world scenarios. I’ve always thought a data-binding book was necessary, and I’m glad Brian found the time to write his.”
—Michael Weinhardt, freelance author and application developer“Data Binding with Windows Forms 2.0 earns a gold star and a prized place in my development book library. Brian is an exceptional teacher of technology, best practices, and technique. He continues to educate at every presentation I attend; his book carries that quality to paper. I found this book to be highly informative and full of all the important steps and examples necessary to learn this technology. In this book, Brian demonstrates a firm grasp on the concepts and I really enjoy his efforts to promote best practices at every chance. Definitively a cover-to-cover read.”
—Randy Hayes, president, Expert Network Solutions, Inc.“Brian’s direct and well-organized presentation makes this much misunderstood topic finally understandable.”
—Sahil Malik, author of Pro ADO.NET 2.0 and C# MVP

Data binding is the most important part of many business applications—and one of the most difficult things to understand. Data Binding with Windows Forms 2.0 is the first book to focus on this crucial area of development. It will quickly get you up to speed on binding data sources to Windows Forms components. The book contains clear examples in C# that work with SQL Server 2000 and SQL Server 2005. Visual Basic .NET examples are available on the book’s Web site.

Brian Noyes, leading consultant and speaker on .NET programming, teaches you both the theory and practice of data binding and provides numerous samples ready to run in Visual Studio 2005.

From his in-depth coverage, you’ll learn how to

• Use Visual Studio 2005 to generate a data-bound application from a database
• Use the new Visual Studio 2005 typed data set designer, and how and why to use typed data sets and typed data adapters
• Perform simple and complex binding of data to controls, and how to use the .NET 2.0 BindingSource
• Use the Binding object for simple binding with automatic formatting, and how to handle binding events
• Generate bound controls with the Visual Studio Designer, and how to use Data Sources
• Present data with the new DataGridView control, and how to implement advanced features of the DataGridView
• Implement custom data-bound controls in Windows Forms
• Create custom business objects and collections that are suitable for use in data binding
• Implement validation and error handling at the Windows Forms and data-binding levels
• Implement data binding with ASP.NET 2.0 and the upcoming Windows Presentation Foundation (Avalon) technologies

WebMatrix is the latest addition to the hugely popular Microsoft ASP.NET web platform. This exciting new technology aims to simplify the process of developing websites by combining the new and powerful Razor syntax with a fully extensible set of data and HTML helpers for performing common web tasks.
The WebMatrix installation includes all the tools the developer requires to quickly create fully-functional, data-driven, dynamic sites using ASP.NET web pages. The lightweight custom development tool works alongside SQL Server Compact Edition and Internet Information Services (IIS) Express to provide a seamless and easy-to-use environment which enables the web developer to concentrate on the rapid development of feature-rich websites, without the need to learn the complex concepts and highly structured programming models which many other frameworks require.

What you’ll learn

• How to combine HTML and server-side C# Razor code with the powerful .NET framework to easily develop websites using Microsoft WebMatrix
• How to create layouts which can be applied across multiple pages
• How to interact with SQL Server and other databases, using proven techniques and best practices
• How to add social networking features to your web site using WebMatrix Helpers
• How to create your own custom functions and helpers to provide reusable code and content
• How to secure your website using a role-based membership model
• How to deploy your website to a hosting provider

Who this book is for

This book is aimed at anyone with a basic knowledge of web technologies who wants to use this latest addition to the Microsoft ASP.NET web platform to easily and quickly build feature-rich, dynamic, data-driven websites.

Table of Contents

1. Introduction
2. Getting Started
3. C# Primer
4. Working with Razor and ASP.NET Web Pages
5. Forms and Validation
6. Working with Data
7. Security & Membership
8. Full Application Tutorial: Getting Started
9. Adding E-Commerce Features
10. Site Administration
11. Adding Social Networking with the Package Manager and WebMatrix Helpers
12. Advanced WebMatrix
13. Deployment

Prepare for MCPD Exam 70-519—and help demonstrate your real-world mastery of web application design and development—with this official Microsoft® Exam Ref. Written for experienced, MCTS-certified professionals ready to advance their status—this guide focuses on the critical-thinking and decision-making acumen needed for success at the MCPD level. With concise, objective-by-objective reviews, strategic case scenarios, and "Thought Experiments", you get professional-level preparation for the professional-level exam.

Optimize your exam-prep by focusing on the expertise needed to:

• Design the application architecture
• Choose the right server-side and client-side technologies
• Design the user experience
• Design data access and presentation
• Plan for security
• Choose a testing methodology
• Plan for scalability and reliability

You also get an exam discount voucher—making this book an exceptional value and a great career investment.

XML Web services are the next logical step in the evolution of the Internet. Teach yourself how to write and deploy XML Web services for Microsoft® .NET—one step at a time—with this modular, accessible tutorial. It delivers expert, task-based instruction plus a real-world XML service example to help you apply what you already know about Microsoft Visual C#™, Microsoft Visual Basic® .NET, and object-oriented programming so that you can learn XML Web services development at your own pace. Topics covered include:

UNDERSTANDING XML WEB SERVICES

• XML Web services architecture
• XML Web services protocols
• Web Service Description Language (WSDL)
• Discovering XML Web services

BUILDING XML WEB SERVICES

• Writing .NET XML Web services
• Testing XML Web services
• Debugging XML Web services

CONSUMING XML WEB SERVICES

• Discovering XML Web services
• Generating a proxy class
• Creating clients that consume XML Web services
• Consuming XML Web services asynchronously
• Consuming XML Web services with HTTP

ADVANCED XML WEB SERVICES

• Managing XML Web service state
• Securing XML Web services
• Using data sets with XML Web services
• Using SOAP headers

Most programming books are about as exciting as Bill Gates' left ear. But with this latest eye-opening release, technology author Karl Moore shows it doesn't have to be quite so dull and uninspiring. Split into eight dynamic parts, Karl Moore's Visual Basic .NET covers every key area of real-life computer developmentand promises to turn even newbie programmers into VB .NET wizards, quicker than anyone else. It's a perfect tutorial guide for those learning VB .NET from scratch or moving from VB6.

Karl Moore's Visual Basic .NET: The Tutorials consists of a number of key tutorials, each dealing with a specific, "real-life" area of programming. The tutorials are broken down into easily digestible 10-page installments, with an accompanying FAQ and review sheet at the close. Numerous "top tips" are also distributed throughout the texts to aid understanding.

Would you like to write Windows programs but don’t know where to start?

Visual Basic. NET, the latest distribution of Microsoft’s programming language was designed to let anybody—even people with no prior programming experience—create sophisticated programs with stunning user interfaces, quickly and easily. A true marvel of computing technology, Visual Basic .NET combines BASIC, the only programming language specifically designed to teach beginners how to program, with a completely intuitive drawing program that lets you create cool user interfaces without having to write a single line of code.

Written by computer book author and well-known stand-up comic Wallace Wang, Visual Basic .NET For Dummies offers you a fun and easy way to master VB .NET programming. Featuring crystal-clear explanations along with dozens of working examples, it gives you what you need to tap the power of Visual Basic .NET. In no time you’ll:

• Design a user interface
• Create pull-down menus
• Write programs on any scale—both large and small
• Debug your programs
• Write your own code
• Work with loops, subrouting, and decision commands
• Use object-oriented techniques in your programming

Visual Basic .NET For Dummies was designed to give you the confidence and skills you need to start building Windows programs right away—not turn you into a computer scientist. To that end, it features hands-on, jargon-free coverage of the full range of practical VB .NET topics, including:

• Getting started and using the Visual Basic .NET interface
• Creating full-featured user interfaces
• Making menus--including pull-downs, submenus, growing menus, pop-up menus—and showing dialog boxes
• Writing BASIC code
• Making programs appear intelligent by using loops and decision commands
• Writing small subprograms and combining them to make large, robust programs
• Getting a handle on object-oriented programming

Visual Basic .NET For Dummies is the pain-free way to get up to speed on Visual Basic programming and all the new features in Visual Basic .NET.