Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Database Access with Visual Basic

Database Access with Visual Basic
(Publisher: Macmillan Computer Publishing)
Author(s): Jeffrey Mcmanus
Page: 330
ISBN: 1562765671

It’s probably safe to say that the majority of Visual Basic developers will use VB to access databases sooner or later. So why aren’t there more books on databases and Visual Basic? Because database access is the equivalent of plumbing. Like plumbing, there are dozens of segments you must put together before the whole thing works, and when it doesn’t work, the part that’s causing the problem isn’t immediately obvious. Put bluntly, it’s a decidedly unsexy topic.
This book puts the plumbing in order. It won’t help you hike up your pants when you reach under the sink, but it will give you exposure to nearly all aspects of database access you’re likely to encounter in Visual Basic today. Through it all, the objective is to give you the information you need in a concise manner, using examples and step-by-step procedures rather than brief, acronym-laden blurbs.

Download:

Database Access with Visual Basic
Read More......

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005



Author: Jayaram Krishnaswamy
Publisher: Packt Publishing
First published: December 2007

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides you with the basic knowledge that you should have before you move onto more advanced ETL (Extraction, Transformation, and Loading). This step-by-step, hands-on guide will take you right into the Visual Studio 2005 Integrated Development Interface, making you appreciate and understand how Business Intelligence Projects and Packages are created using the Visual Studio designer. The book will also provide you with a comprehensive description of the many designer windows that you may encounter while working with the designer. This guide provides the building blocks, describing each block by way of an example, as well as describing the nuts and bolts that bind the blocks. You start building packages right from Chapter 2 and continue onto Chapter 20, gathering and building upon your knowledge in each step.

This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA's who are testing water with the Visual Studio IDE but without a wide programming experience; SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services; Microsoft programming professionals in Small Businesses who wear multiple hats (jack of all trades)—developer, programmer, and DBA with a little bit of experience in each of these.

It is expected that you know how to manipulate window objects, like clicking; dragging and dropping; using contextual help; tabbing, etc. It is also expected that you are exposed to SQL Server database basics and that you understand connecting to a database server; querying the database; reviewing objects; displaying and reviewing properties of objects, etc. Very little coding skill is assumed except that you can logically follow a fully commented code.

Download:

SQL Server Integration Services Using Visual Studio 2005 ON ZIDDU
OR
SQL Server Integration Services Using Visual Studio 2005 ON Rapidshare
Read More......

PHP & MySQL® For Dummies® 3rd Edition



PHP & MySQL® For Dummies® 3rd Edition
Author: Janet Valade
Publisher: Wiley Publishing
2007

Welcome to the exciting world of Web database applications. This book provides the basic techniques to build any Web database application, but I certainly recommend that you start with a simple one. In this book, I develop two sample applications, both chosen to represent two types of applications frequently encountered on the Web: product catalogs and customer- or member-only sites that require the user to register and log in with a password. The sample applications are complicated enough to require more than one program and to use a variety of data and data manipulation techniques, yet simple enough to be easily understood and adapted to a variety of Web sites. After you master the simple applications, you can expand the basic design to include all the functionality that you can think of.

Think of this book as your friendly guide to building a Web database application. This book is designed as a reference, not as a tutorial, so you don’t have to read it from cover to cover. You can start reading at any point — in Chapter 1, Chapter 9, wherever. I divide the task of building a Web database application into manageable chunks of information, so check out the table of contents and locate the topic that you’re interested in. If you need to know information from another chapter to understand the chapter you’re reading, I reference that chapter number.

Here’s a sample of the topics I discuss:
 Building and using a MySQL database
 Adding PHP to HTML files
 Using the features of the PHP language
 Using HTML forms to collect information from users
 Showing information from a database in a Web page
 Storing information in a database

Download: PHP & MySQL® For Dummies® 3rd Edition ON ZIDDU
OR PHP & MySQL® For Dummies® 3rd Edition ON RAPIDSHARE

Read More......

Oracle Essentials Oracle Database 11g



Oracle Essentials Oracle Database 11g - FOURTH EDITION
Author: Rick Greenwald, Robert Stackowiak, and Jonathan Stern
2008 O’Reilly Media


This book is divided into 15 chapters and 2 appendixes, as follows:
Chapter 1, Introducing Oracle, describes the range of Oracle products and features and provides a brief history of Oracle and relational databases.

Chapter 2, Oracle Architecture, describes the core concepts and structures (e.g., files, processes, and so on) that are the architectural basis of Oracle.

Chapter 3, Installing and Running Oracle, briefly describes how to install Oracle and how to configure, start up, and shut down the database and Oracle Net.

Chapter 4, Oracle Data Structures, summarizes the various datatypes supported by Oracle and introduces the Oracle objects (e.g., tables, views, indexes). This chapter also covers query optimization.

Chapter 5, Managing Oracle, provides an overview of managing an Oracle system, including the advisors available as part of Oracle Database 11g, using Oracle Enterprise Manager (EM), dealing with database fragmentation and reorganization using current database releases, information lifecycle management, and working with Oracle Support.

Chapter 6, Oracle Security, Auditing, and Compliance
Chapter 7, Oracle Performance
Chapter 8, Oracle Multiuser Concurrency
Chapter 9, Oracle and Transaction Processing
Chapter 10, Oracle Data Warehousing and Business Intelligence
Chapter 11, Oracle and HighAvailability
Chapter 12, Oracle and Hardware Architecture
Chapter 13, Oracle Distributed Databases and Distributed Data
Chapter 14, Oracle Extended Datatypes
Chapter 15, Beyond the Oracle Database
Appendix A, What’s New in This Book for Oracle Database 11g, lists the Oracle Database 11g changes described in this book.
Appendix B, Additional Resources, lists a variety of additional resources—both online and offline—so you can do more detailed reading

Download:

Oracle Essentials Oracle Database 11g ON ZIDDU
OR
Oracle Essentials Oracle Database 11g ON RAPIDSHARE
Read More......

Learning PHP and MySQL-A Step by Step Guide to Creating Dynamic Database Driven Websites



Learning PHP and MySQL, Second Edition
Author : Michele E. Davis and Jon A. Phillips
ISBN-13: 978-0-596-51401-3
2007

This book is for people who want to know how to create dynamic web sites. That could include graphic designers who are already working in an IT or advertising firm creating static web sites, and who may need to move forward with coding databasedriven web sites. It might also include people who already know, say, Flash development and HTML markup, but need to expand their repertoire of skills to databases and programming.

This book starts out with an overview of how all of the pieces you’ll be working with fit together. Because there are multiple languages and technologies that interact to formdynam ic web pages, it’s best to start with a solid understanding of how the pieces work together. The PHP that you’ll learn works as an integration package for dynamic web sites.

Next, we’ll walk through installing the core software packages on your local computer. This book focuses on PHP and MySQL, but making this work also usually requires the Apache web server. The PHP interpreter works with the web server when processing dynamic content. Finally, you’ll install the MySQL database. Installation is covered for PC, Mac, and Linux systems. You can also use a hosted Internet service provider (ISP) account to develop your pages, if you don’t want to install everything locally.

Download: Learning PHP and MySQL, Second Edition ON ZIDDU
OR
Learning PHP and MySQL, Second Edition ON RAPIDSHARE

Read More......

Rails for PHP Developers



Pragmatic bookshelf
Rails for PHP Developers
Author: Derek DeVries, Mike Naberezny
pub.date: February 2008

There is no doubt that by now you’ve heard all of the hype about Ruby on Rails. It has been generating a lot of buzz with the promise of making
web applications fast and simple to create, and you may be wondering what the big deal is. We know that PHP has been doing this for years
and has proven quite capable by its use in large companies such as Yahoo. You may be wondering whether it’s worth the time investment
to learn Rails and Ruby, when you already have PHP under your belt.

This book is meant for PHP developers who are interested in adding Rails to their toolsets. There are a lot of books on Rails now, but PHP
developers have a unique way of thinking about problems that are built around the PHP mind-set. This book aims to guide your learning in
Rails based on your existing knowledge of programming in PHP. An understanding of object-oriented programming in PHP will help but is
not entirely necessary. This should be something you start to pick up naturally while programming in Ruby.

More Review
Download:

Rails for PHP Developers Read More......

Beginning PHP and MySQL: From Novice to Professional, Third Edition



Beginning PHP and MySQL: From Novice to Professional, Third Edition
Author: W. Jason Gilmore
ISBN-13 (pbk): 978-1-59059-862-7
Pub. Date: March 2008.
Most great programming books sway far more toward the realm of the practical than of the academic. Although I have no illusions regarding my place among the
great technical authors of our time, it is always my goal to write with this point in mind, producing material that you can apply to your own situation. Given the size of this book, it’s probably apparent that I attempted to squeeze out every last drop of such practicality from the subject matter. That said, if you’re interested in gaining practical and comprehensive insight into the PHP programming language and MySQL database server, and how these prominent technologies can be used together to create dynamic, database-driven Web applications, this book is for you.

If you’re new to PHP, I recommend beginning with Chapter 1, because gaining the fundamental knowledge presented therein will be of considerable benefit to you when you’re reading later chapters. If you know PHP but are new to MySQL, consider beginning with Chapter 25. Intermediate and advanced readers are invited to jump around as necessary; after all, this isn’t a romance novel. Regardless of your reading strategy, I’ve attempted to compartmentalize the material found in each chapter so that you can quickly learn each topic without having to necessarily master other chapters beyond those that concentrate on the technology fundamentals.
Furthermore, novices and seasoned PHP and MySQL developers alike have something to gain from this book, as I’ve intentionally organized it in a hybrid format of both tutorial and reference. I appreciate the fact that you have traded hard-earned cash for this book, and therefore have strived to present the material in a fashion that will prove useful not only the first few times you peruse it, but far into the future.

More Review
Download:

Beginning PHP and MySQL: From Novice to Professional, Third Edition Read More......

PHP 6 and MySQL 5 for Dynamic Web Sites



VISUAL QUICKPRO GUIDE
PHP 6 and MySQL 5 for Dynamic Web Sites
Author: Larry Ullman
ISBN-13: 978-0-321-52599-4
Pub.date: December 2007

Today’s Web users expect exciting pages that are updated frequently and provide a customized experience. For them, Web sites are more like communities, to which
they’ll return time and again. At the same time, Web site administrators want sites that are easier to update and maintain, understanding that’s the only real way to
keep up with visitors’ expectations. For these reasons and more, PHP and MySQL have become the de facto standards for creating dynamic, database-driven Web sites.

This book represents the culmination of my many years of Web development experience coupled with the value of having written several previous books on the technologies
discussed herein. The focus of this book is on covering the most important knowledge in the most efficient manner. It will teach you how to begin developing dynamic Web
sites and give you plenty of example code to get you started. All you need to provide is an eagerness to learn.

More Review
Download:

PHP 6 and MySQL 5 for Dynamic Web Sites Read More......

PHP & MySQL® For Dummies® 3rd Edition



PHP & MySQL® For Dummies® 3rd Edition
Publisher: Wiley Publishing, Inc.
Author : Janet Valade
ISBN-13: 978-0-470-09600-0

Think of this book as your friendly guide to building a Web database application.
This book is designed as a reference, not as a tutorial, so you don’t have to read it from cover to cover. You can start reading at any point — in
Chapter 1, Chapter 9, wherever. I divide the task of building a Web database application into manageable chunks of information, so check out the table of
contents and locate the topic that you’re interested in. If you need to know information from another chapter to understand the chapter you’re reading,
I reference that chapter number.
Here’s a sample of the topics discuss:

  • Building and using a MySQL database
  • Adding PHP to HTML files
  • Using the features of the PHP language
  • Using HTML forms to collect information from users
  • Showing information from a database in a Web page
  • Storing information in a database

Download:
ebook PHP & MySql for Dummies 3rd Edition Read More......

Visual Basic® .NET Unleashed



Author: Paul Kimmel
Publisher : Sams Publishing
Pub Date : January 17, 2002
ISBN : 0-672-32234-X
Pages : 784

Book Description

Visual Basic .NET is more than simply Visual Basic 7. Microsoft has almost completely revamped a language that millions of developers know and love, Visual Basic 6. Perhaps the reasons for changing VB so dramatically require a book of their own, but that is a story best left for Microsoft to tell. Some things were clearly missing in past versions of VB. These missing things may not seem apparent to those completely content with Visual Basic as it used to be, but deficits existed.

When you and I are finished, you will see the new power and beauty of Visual Basic .NET and I hope you will agree that it was time for a VB overhaul.

Visual Basic .NET Unleashed is a complete book on the fundamentals of programming in a fully object-oriented language filled with new idioms and capabilities like true inheritance and polymorphism, event handlers, structured exception handling, and Web services. In addition to presenting you with fundamentals, it is the charter of this book to give you extra insight and advice based on real-world experience to help you become more productive with Visual Basic .NET than you ever were able to be with Visual Basic 6.

Visual Basic .NET has everything, including the kitchen sink. Visual Basic .NET presents the reader with more power and potential than any other implementation of Basic ever has.

Visual Basic.NET Unleashed is a complete book on the fundamentals of programming with a fully object-oriented language filled with new idioms and capabilities. In addition to the fundamentals, this book covers:

  • Free threading and multithreading
  • Inheritance
  • Virtual methods and shared methods
  • Structured exception handling
  • Event handling
  • Encapsulation at the namespace level
  • Web Services
  • .NET Framework compatibility

Size: 3.7 MB

Download:

Ziddu OR Rapidshare


Read More......

Professional IIS 7 and ASP.NET Integrated Programming



Author: Dr. Shahram Khosravi
Publisher: Wiley
ISBN: 978-0-470-15253-9
Pub. Year: 2007
Page: 699


Book Description

Professional IIS 7 and ASP.NET Integrated Programming. The deep integration of IIS 7 and ASP.NET provides both IIS 7 administrators and ASP.NET developers with a rich integrated programming environment to implement features and functionalities that were not possible in earlier versions of IIS.
This book provides in-depth coverage of all the major systems that make up the IIS 7 and ASP.NET integrated infrastructure, as follows:

  • IIS 7 and ASP.NET integrated request processing pipeline
  • IIS 7 and ASP.NET integrated configuration system and its associated declarative schema extension markup language
  • IIS 7 and ASP.NET integrated imperative management system
  • IIS 7 and ASP.NET integrated graphical management system
  • IIS 7 and ASP.NET integrated providers model
  • IIS 7 and ASP.NET integrated tracing and diagnostics
  • ASP.NET and Windows Communication Foundation integration in IIS 7

This book not only shows how these major systems work from the inside out and how to use them in your own applications, but also provides comprehensive coverage of the extensibility points of these systems and shows you how to take advantage of them to add support for new features and functionalities.
The discussions of this book are presented in the context of numerous step-by-step recipes and detailed code walkthroughs and in-depth analyses of real-world examples that use these recipes to help you gain
the skills, knowledge, and experience you need to use and extend these major systems.

Size: 3.8 MB
Download:

Ziddu OR Rapidshare


Read More......

Professional ADO.NET 2 Programming with SQL Server 2005, Oracle®, and MySQL®




Professional ADO.NET 2 Programming with SQL Server 2005, Oracle®, and MySQL® - Programmer to Programmer

Author: Wallace B. McClure, Gregory A. Beamer, John J. Croft IV, J. Ambrose Little, Bill Ryan, Phil Winstanley, David Yack, Jeremy Zongker
Publisher: Wiley
Pub. Year: 2006
Page: 644

The following list provides a breakdown of the topics covered in each chapter:

Chapter 1—Abrief history of data access technologies so you can see why some of the features are needed. It also touches on the major design goals of ADO.NET 2.0 and highlights what is covered in the rest of the book.
Chapter 2—Basic database design concepts, primarily in Microsoft SQL Server 2005. It also covers creating databases, tables, and views following third normal form and the importance of primary and foreign keys. It shows you how to optimize performance using indexes and other methods, and in general provides you with a solid foundation for developing database-driven applications.
Chapter 3—The basics of creating a connection, executing a query, and returning a result. It also digs deeply into many of these areas, showing best practices and techniques for optimizing your code. It covers scenarios for which it may or may not be appropriate to use features such as DataSets and DataViews. It also covers the various options for persisting data back to a database, and introduces new techniques in ADO.NET 2.0. Finally, it introduces the new APIs available for schema discovery and connection pooling.
Chapter 4—Delves into the new data types available in the 2.0 framework, and discusses the appropriate situations in which to use them.
Chapter 5—Covers many of the new features available for XML integration. It offers a brief overview of how XML evolved, the numerous designer enhancements and new features available in XmlReader and XmlWriter, and introduces the XPathDocument as the new standard for storing XML documents. It details new validation features and highlights many of the performance gains available in this framework, and provides a roadmap to where XML technologies are heading.
Chapter 6—Looks into the new transactional capabilities available in the ADO.NET 2.0 Framework and how to integrate them with Microsoft SQL Server 2005 and other data sources. It covers locking, replication, and other design issues.
Chapter 7—Covers the details of data binding. It shows how to use the ADO.NET 2.0 design time programmability features in Visual Studio.NET. It also shows off the new TableAdapters and DataConnectors. You will see how you can data bind not only to database queries, but to Web services, business objects, and other sources.
Chapter 8—In this chapter, you learn how to create a custom ADO.NET managed provider. Step by step, you’ll create your own provider, including the various interfaces for creating connections, commands, readers, and adapters.
Chapter 9—Shows the new TSQL language enhancements available in Microsoft SQL Server 2005. It also covers how these new features tightly integrate with the ADO.NET 2.0 Framework.
Chapter 10—Covers the details of integrating the new Microsoft SQL Server 2005 features into a client application using ADO.NET 2.0. In this chapter, you learn about the new asynchronous support features, the capability to return multiple result sets from a query, and how to initiate bulk copies. You also learn how to use the new caching features, create your own user-defined data types, and explore various new APIs for working with Microsoft SQL Server 2005.
Chapter 11—Shows how to use many of the new CLR capabilities of Microsoft SQL Server 2005. You’ll learn how to create CLR code in stored procedures, how to use CLR objects for data types, and how to debug your CLR code in Microsoft SQL Server 2005.
Chapter 12—Provides a detailed description of how to create a Notification Services application in Microsoft SQL Server 2005. It starts from the beginning, assuming no prior experience with notification services, and shows how to create an application from the ground up, including how to interface with that application from custom .NET code.
Chapter 13—Shows off the message queuing functionality in the .NET 2.0 Framework by introducing the Service Broker. It covers the feature set and the various options and describes how to use them to develop scalable applications.
Chapter 14—Displays how to use the full text search capabilities of Microsoft SQL Server 2005. It provides a background on full text searches, covers the new features available and how to enable them, and describes the best practices for using them.
Chapter 15—Many tools are available for retrieving data and presenting it in various ways. This chapter covers some of the most common tools, such as Crystal Reports, Microsoft SQL Reporting Services, OLAP, and other business analysis tools, and shows how to best use them with Microsoft SQL Server 2005.
Chapter 16—MySQL is an option for data storage that is rapidly growing in popularity. In this chapter, you examine the new provider available for MySQL and learn how to best utilize it to maximize performance and scalability.
Chapter 17—Shows how to best use Oracle in the ADO.NET Framework. It shows off the features specific to the Oracle Managed provider in ADO.NET 2.0. It covers topics such as blobs, clobs, bfiles, packages, and transactions

Size: 4.5 MB
Download: Ziddu OR Rapidshare


Read More......

Beginning PHP5, Apache, and MySQL Web Development



  • Paperback: 816 pages
  • Publisher: Wrox -February 4, 2005
  • Language: English
  • ISBN-10: 0764579665
  • ISBN-13: 978-0764579660
This update to a Wrox bestseller dives in, and guides the reader through the entire process of creating dynamic, data-driven sites using the open source "AMP" model: Apache Web server, the MySQL database system, and the PHP language. The team of expert authors covers PHP scripting, database management, security, integration and e-commerce functions and comes complete with a useful syntax reference

More Review
Download : rapidshare
Buy : amazon Read More......

High Performance MySQL



  • Paperback: 265 pages
  • Publisher: O'Reilly Media, Inc -April 8, 2004
  • Language: English
  • ISBN-10: 0596003064
  • ISBN-13: 978-0596003067
In High Performance MySQL you will learn about MySQL indexing, and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs

More Review
Download : rapidshare
Buy : amazon Read More......

The Art of SQL



  • Page: 349 pages
  • Publisher: O'Reilly Media, Inc. March 1, 2006
  • Language: English
  • ISBN-10: 0596008945
  • ISBN-13: 978-0596008949
The Art of SQL offers best practices, that teach experienced SQL users to focus on strategy rather than specifics, Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others, They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

More Review
Download : rapidshare
Buy : amazon Read More......


Didn't Find What You'Re Looking For? Try Search Using Search Box

Related Books