Mastering VB.Net Database Programming (with source code)

Are you building Visual Basic .NET applications that interact with a database? If so, this book is an essential guide to understanding how to program and use databases for real world applications. It covers a vast array of topics, useful for both beginners and experts. Don't let this book leave your side.

This book goes beyond telling you "how" to program using Microsoft Visual Basic .NET, but explains the "why" behind the code, The authors provide real-world examples, such as a shopping cart system, that you can use as a foundation for your own systems. By understanding why you should design applications in a certain way, you can design more efficient and scalable systems. Throughout the book, Asli and Evangelos point out tips and tricks for your application design to improve performance, reusability and scalability.

Part I of the book begins with a whirlwind tour of database concepts starting with a brief discussion of what a database is and an overview of various Microsoft data access technologies. The book then provides an overview of basic concepts in relational databases, such as common database objects and normalization. Part I then continues with discussions of visual tools you can use to aid in the database planning and development process and a final chapter on Structure Query Language (SQL), the language used to communicate with a database.

In Part II the authors introduce programming concepts building upon the foundation established in part I. The first chapter is dedicated to programming on the data tier using Microsoft SQL Server's Transaction SQL (T-SQL). You will learn how to program stored procedures, functions, triggers, and transactions in T-SQL, and how these features can improve application performance and scalability. For example, Asli and Evangelos go into detail discussing why you should use stored procedures in your application.

Part III begins the more advanced topics, covering threading issues, XML integration, programming the middle tier, as well as discussing some of advanced Microsoft SQL Server 2000 topics.

The book concludes with Part IV, a practical set of chapter that discuss how to manage and work with data aware web applications built with ASP.NET. Asli and Evangelos discuss the use of ASP.NET Web Services to connect and share data via XML interfaces using SOAP, and also discuss aspects of ASP.NET Page and application design, covering topics such as the caching functionality built into ASP.NET.

TABLE OF CONTENT:
Chapter 01 - Database Access: Architectures and Technologies
Chapter 02 - Basic Concepts of Relational Databases
Chapter 03 - The Visual Database Tools
Chapter 04 - Structured Query Language
Chapter 05 - Transact-SQL
Chapter 06 - A First Look at ADO.NET
Chapter 07 - ADO.NET Programming
Chapter 08 - Data-Aware Controls
Chapter 09 - Working with DataSets
Chapter 10 - The Role of XML
Chapter 11 - More ADO.NET Programming
Chapter 12 - Integration with XML
Chapter 13 - The Middle Tier
Chapter 14 - Advanced SQL Server 2000 Features
Chapter 15 - Introducing ASP.NET
Chapter 16 - The Web Data Controls
Chapter 17 - Working with WebServices
Chapter 18 - VS .NET Deployment Considerations

Download Here

Password:ganelon