Databases (27 unread)

Description: Get ready to create your own J2ME game! This updated edition to the popular J2ME Game Programming provides updated sofware coverage as well as updates to the programming approaches specific to Java ME software. It also covers the recent innovations in mobile games with relations to iPods and cell phones. You will learn the essentials of J2ME game development from the ground up. Throughout the book you will discover the issues involved in developing for multiple target devices and how to work through the jungle of device-specific libraries and device capabilities.
Working on a limited platform it is important to squeeze as much as you can out of those precious bytes, so in this book you will find the tools and source code you need to get the most out of the constrained resources. You will also learn how to structure your code and classes to achieve as small an application footprint as possible. As you work toward developing your own J2ME game, you’ll examine the game lifecycle, how to handle resources, various methods of drawing to the screen, optimizing memory usage, handling the users input, and even sharing high-scores online! Previous experience in programming object-oriented languages and a basic level of math skills is recommended.
D0wn10ad - (5 Mb)
Uploading
Paperback: 352 pages
Publisher: Course Technology PTR; 2 edition (October 11, 2007)
Language: English
ISBN-10: 1598634801
ISBN-13: 978-1598634808
Format: PDF
Description: If you are new to programming with C and are looking for a solid introduction, this is the book for you. Developed by computer science instructors, books in the for the absolute beginner™ series teach the principles of programming through simple game creation. C is not an easy language to learn, but fortunately the clear explanations, examples, and pictures in this book make learning C easy and fun. Each chapter contains programming challenges, a chapter review, and a complete program that uses chapter-based concepts to construct an easily built application.
You will acquire the skills that you need for more practical C programming applications and will learn how these skills can be put to use in real-world scenarios. Additionally, by the time you finish this book, you will be able to apply the programming principles you’ve learned to the next programming language you tackle.
D0wn10ad - (2 Mb)
Uploading
Paperback: 492 pages
Publisher: Wiley-IEEE Computer Society Pr (February 9, 2009)
Language: English
ISBN-10: 0470294558
ISBN-13: 978-0470294550
Format: PDF
Description: The book is organized around basic principles of software project management: planning and estimating, measuring and controlling, leading and communicating, and managing risk.
Introduces software development methods, from traditional (hacking, requirements to code, and waterfall) to iterative (incremental build, evolutionary, agile, and spiral).
Illustrates and emphasizes tailoring the development process to each project, with a foundation in the fundamentals that are true for all development methods.
Topics such as the WBS, estimation, schedule networks, organizing the project team, and performance reporting are integrated, rather than being relegating to appendices.
Each chapter in the book includes an appendix that covers the relevant topics from CMMI-DEV-v1.2, IEEE/ISO Standards 12207, IEEE Standard 1058, and the PMI Body of Knowledge.
D0wn10ad - (3 Mb)
Uploading

The Best Fully Integrated Study System Available.
With hundreds of practice questions and hands-on exercises, RHCE Red Hat Certified Engineer Linux Study Guide, Fifth Edition covers what you need to know–and shows you how to prepare–for this challenging exam.
* 100% complete coverage of all objectives for exam RH302.
* Exam Readiness Checklist at the front of the book–you’re ready for the exam when all objectives on the list are checked off.
* Inside the Exam sections in every chapter highlight key exam topics covered.
* Real-world exercises modeled after hands-on exam scenarios.
* Two complete lab-based exams simulate the format, tone, topics, and difficulty of the real exam.
* Bonus content (available for download) includes installation screen review, basic instructions for using VMware and Xen as testbeds, and paper and pencil versions of the lab exams.
Covers all RH302 exam topics, including:
* Hardware installation and configuration.
* The boot process.
* Linux filesystem administration.
* Package management and Kickstart.
* User and group administration.
* System administration tools.
* Kernel services and configuration.
* Apache and Squid.
* Network file sharing services (NFS, FTP, and Samba).
* Domain Name System (DNS).
* E-mail (servers and clients).
* Extended Internet Services Daemon (xinetd), the Secure package, and DHCP.
* The X Window System.
* Firewalls, SELinux, and troubleshooting.
Download

Maximum Linux Security: A Hacker’s Guide to Protecting Your Linux Server and Workstation is designed for system administrators, managers, or Linux users who wish to protect their Linux servers and workstations from unauthorized intrusions and other external threats to their systems’ integrity. Written by an experienced hacker–someone who knows which systems are vulnerable and how crackers get into them–this unique guide to Linux security identifies existing and potential security holes and faults, and then describes how to go about fixing them.
Download

This comprehensive guide can help you administer Red Hat Enterprise Linux 5 effectively in any production environment, no matter how complex or challenging.
Long-time Red Hat insider Tammy Fox brings together today’s best practices for the entire system lifecycle, from planning and deployment through maintenance and troubleshooting. Fox shows how to maximize your efficiency and effectiveness by automating day-to-day maintenance through scripting, deploying security updates via Red Hat Network, implementing central identity management services, and providing shared data with NFS and Samba.
Red Hat Enterprise Linux 5 Administration Unleashed contains extensive coverage of network and web services, from the Apache HTTP server and Sendmail email services to remote login with OpenSSH. Fox also describes Red Hat’s most valuable tools for monitoring and optimization and presents thorough coverage of security including a detailed introduction to Security-Enhanced Linux (SELinux).
* Streamline deployment with Kickstart.
* Find, install, update, remove, and verify software.
* Detect, analyze, and manage hardware.
* Manage storage with LVM, RAID, ACLs, and quotas.
* Use Red Hat Enterprise Linux 5 on 64-bit and multi-core systems.
* Administer users and groups more efficiently and securely.
* Ensure trustworthy backup and rapid recovery.
* Script and schedule tasks to run automatically.
* Provide unified identity management services.
* Configure Apache, BIND, Samba, and Sendmail.
* Monitor and tune the kernel and individual applications.
* Protect against intruders with SELinux and ExecShield.
* Set up firewalls with iptables.
* Enable the Linux Auditing System.
* Use virtualization to run multiple operating systems concurrently.
Download

This practical guide teaches you how to implement effective network protection by using your own customized firewall solution. Based on extensive practical experience, this book distills a unique set of scenario based scripts and guidelines for a proven firewall solution, into one succinct and precise book. This book shows you how to implement Linux firewalls and Quality of Service using practical examples from very small to very large networks.
After giving us a background of network security, the book moves on to explain the basic technologies we will work with, namely netfilter, iproute2, NAT and l7-filter. These form the crux of building Linux firewalls and QOS.Providing only necessary theoretical background, the book takes a practical approach, presenting case studies and plenty of illustrative examples.
Download

FreeBSD the powerful, flexible, and free Unix-like operating system is the preferred server for many enterprises. But it can be even trickier to use than either Unix or Linux, and harder still to master.
Absolute FreeBSD, 2nd Edition is your complete guide to FreeBSD, written by FreeBSD committer Michael W. Lucas. Lucas considers this completely revised and rewritten second edition of his landmark work to be his best work ever; a true product of his love for FreeBSD and the support of the FreeBSD community. Absolute FreeBSD, 2nd Edition covers installation, networking, security, network services, system performance, kernel tweaking, filesystems, SMP, upgrading, crash debugging, and much more, including coverage of how to:
* Use advanced security features like packet filtering, virtual machines, and host-based intrusion detection.
* Build custom live FreeBSD CDs and bootable flash.
* Manage network services and filesystems.
* Use DNS and set up email, IMAP, web, and FTP services for both servers and clients.
* Monitor your system with performance-testing and troubleshooting tools.
* Run diskless systems.
* Manage schedulers, remap shared libraries, and optimize your system for your hardware and your workload.
* Build custom network appliances with embedded FreeBSD.
* Implement redundant disks, even without special hardware.
* Integrate FreeBSD-specific SNMP into your network management system.
Whether you’re just getting started with FreeBSD or you’ve been using it for years, you’ll find this book to be the definitive guide to FreeBSD that you’ve been waiting for.
Download

Hong’s straightforward style makes it easy for the do-it-yourself crowd to build a server quickly using the ports collection (a software package management system). But rather than wade through the thousands of ports available, Hong focuses on the most popular and useful ones. Each package is treated as an independent project (and given a difficulty rating), so readers can dip into the book at any point to install just the packages they need, when they need them.
The book’s modules cover topics like:
* Running common FreeBSD admin commands and tasks.
* Managing the FreeBSD ports collection.
* Installing third-party apps like Apache, Courier-IMAP, SpamAssassin, CUPS, Cyrus SASL, MediaWiki, and WordPress.
* Setting up MySQL, NTP, ISC DHCP, ISC BIND DNS, PHP, OpenLDAP, OpenSSH, OpenSSL, and OpenVPN.
Appendixes explain user management, backup/restore, and network protocols.
Building a Server with FreeBSD 7 will have readers running their own server loaded with useful modules in no time, with a minimum of hassle.
Download

From the publisher who brought you the international best-seller, Hacking Exposed: Network Security Secrets & Solutions…
Learn how to think like a hacker in order to secure your Linux network.
In the ever-changing world of global data communications, inexpensive Internet connections, and fast-paced software development, security is constantly being compromised. Linux has always been considered the digital playground for hackers. Many hacks, exploits, and network security tools are written on Linux because it’s readily available. Hacking Linux Exposed: Linux Security Secrets & Solutions shows you, step-by-step, how to defend against the latest Linux attacks by understanding the hacker’s methods and sinister thought processes. You’ll learn how your adversaries gather information, acquire targets, escalate privilege, gain control, plant back doors, and cover their tracks. Each chapter is divided into bite-sized chunks, covering highly publicized and little-known break-ins, tips on why they occurred, and detailed countermeasures that no Linux professional can afford to be without.
*Get details on the security features of each Linux distribution, including Red Hat Linux, SuSE, Debian, and Slackware.
*Zero in on vulnerable systems using whois, traceroute, DNS zone transfers, OS detection, ping sweeps, and port scans.
*Detect Trojan horses, backdoors, password cracking, IP spoofing, session hijacking, and trail hiding.
*Implement Log analysis tools such as the Advanced Intrusion Detection Environment (AIDE) and advanced kernel security patches, including the Linux Intrusion Detection System (LIDS).
*Learn how to prevent local users from getting root privileges.
*Prevent Denial of Service and other network attacks.
*Configure FTP sites, DNS servers, and other daemons securely.
*Plug common and obscure security holes in Sendmail, Qmail, Postfix, POP, and IMAP servers.
*Defend against Web server attacks using secure scripting techniques, user verification, and secure Apache Server configurations.
*Design, position, and test secure firewalls and other network access restrictions.
Download
The success of Wikipedia has proven just how effective wikis can be for
collaborative editing on a large scale-larger than anyone originally
thought possible. This book shows you how to install, use, manage, and
extend a wiki using MediaWiki-the wiki engine used to power Wikipedia.
As each chapter builds on previous ones, tasks involving wikis progress
from simple to those of increasing complexity and evolve from theory to
case study. You’ll learn wiki terminology and how to create user
accounts and new pages, use wiki links, and find your way around the
wiki. Special focus is placed on how wikis are used in software and web
development projects and how their capabilities ideally suit a specific
environment and audience. You’ll quickly come to discover why wikis are
a valuable addition for any organization that wants to increase
productivity using web-based collaboration tools. What you will learn
from this book:
- When to use wikis instead of a more formal content management system
- What to look for when evaluating wikis in order to avoid unexpected
pitfalls
- How to install MediaWiki using Apache, PHP, MySQL®, and other
alternatives
- How wikitext allows you to edit content from any web browser and
create links to other wiki pages
- Ways to comment on pages, move them, track changes, and syndicate
wiki pages with RSS Who this book is for This book is for programmers,
developers, information architects, designers, and content authors who
are looking to use wikis to improve team productivity. Knowledge of
HTML, XML, CSS, PHP, MySQL, and PostgreSQL is necessary. Wrox
Professional guides are planned and written by working programmers to
meet the real-world needs of programmers, developers, and IT
professionals. Focused and relevant, they address the issues technology
professionals face every day. They provide examples, practical
solutions, and expert education in new technologies, all designed to
help programmers do a better job.
Download
- Windows Live is the collective name for a group of Microsoft tools
whose services and user data are available anywhere-without ever having
to install an application
- Windows Live currently consists of: Windows Live Mail, Windows Live
Safety Center, Windows Live Favorites, Windows Live OneCare, Windows
Live Messenger, Windows Live Search, and Windows Live Local
- Certified Microsoft Software Developer Jon Arking shares his
experience in developing for Windows Live, and teaches readers how to
build applications that embrace the Windows Live platform
- Packed with examples, this hands-on guide offers an insightful look
at the tools and technologies behind Windows Live, using the MSN
Activities APIs, building mapping applications with Virtual Earth APIs,
and developing Gadgets for both online and Windows Vista
- Also examines integrating MSN Search capabilities as well as Live
services into existing sites with Live custom domains
Download
Practical JBoss Seam Projects, written by renowned author and enterprise
Java practitioner Jim Farley, is expected to be the first practical
projects book of its kind on this groundbreaking open source lightweight
JSF-EJB3 framework.
- Practical application scenarios are used to demonstrate the nature
of the JBoss Seam framework, its efficacy, and its limitations.
- The series of scenarios and cases demonstrate key elements of the
framework (e.g., basic web application development, rich web clients
with Ajax, and so forth).
- Real-world case studies offer valuable insight into the new
practices of JBoss Seam Web 2.0 development
What you’ll learn
- See how to use the open source lightweight standards-based Seam
framework in the context of the Java EE 5 environment.
- Get a quick, broad primer on Seam by examining a “canonical” web
application.
- Appreciate the JSF extension capabilities offered by Seam (including
conversations and breadcrumbs), the use of EJB3 session backing beans,
and general persistence management.
- Get practical help from case studies, such as a PayPal-like web
application project.
- Understand page-flow management provided by Seam’s jPDL through a
working case study.
- Design rich web user interfaces using Seam and Ajax in another
working case study.
- Discover the workflow and BPM support provided by Seam’s integration
with jBPM.
Who is this book for?
Intermediate Java developers with fundamental knowledge of enterprise
issues and frameworks. Experience or a basic understanding of J2EE/Java
EE 5 should suffice.
About the Apress Practical Series
The Practical series from Apress is your best choice for getting the job
done, period. From professional to expert, this series lets you apply
project-motivated templates (or frameworks) step by step in a very
direct, practical, and efficient manner toward current real-world
projects that may be sitting on your desk. So whatever your career goal,
Apress can be your trusted guide to take you where you want to go on
your IT career empowerment path.
Related Titles:
Beginning POJOs: Lightweight Java Web Development Using Plain Old Java
Objects in Spring, Hibernate, and Tapestry Beginning JBoss Seam: From
Novice to Professional Pro JSF and Ajax: Building Rich Internet
Components Pro EJB 3: Java Persistence API
Download
The Internet is bigger and better than what a mere browser allows.
Webbots, Spiders, and Screen Scrapers is for programmers and
businesspeople who want to take full advantage of the vast resources
available on the Web. There’s no reason to let browsers limit your
online experience-especially when you can easily automate online tasks
to suit your individual needs. Learn how to write webbots and spiders
that do all this and more:
- Programmatically download entire websites
- Effectively parse data from web pages
- Manage cookies
- Decode encrypted files
- Automate form submissions
- Send and receive email
- Send SMS alerts to your cell phone
- Unlock password-protected websites
- Automatically bid in online auctions
- Exchange data with FTP and NNTP servers Sample projects using
standard code libraries reinforce these new skills. You’ll learn how to
create your own webbots and spiders that track online prices, aggregate
different data sources into a single web page, and archive the online
data you just can’t live without. You’ll learn inside information from
an experienced webbot developer on how and when to write stealthy
webbots that mimic human behavior, tips for developing fault-tolerant
designs, and various methods for launching and scheduling webbots.
You’ll also get advice on how to write webbots and spiders that respect
website owner property rights, plus techniques for shielding websites
from unwanted robots. As a bonus, visit the author’s website to test
your webbots on sample target pages, and to download the scripts and
code libraries used in the book. Some tasks are just too tedious-or too
important!- to leave to humans. Once you’ve automated your online life,
you’ll never let a browser limit the way you use the Internet again.
Download
As a web developer, you’ll already know that JavaScript™ is a powerful language, allowing
you to add an impressive array of dynamic functionality to otherwise static web sites.
But there is more power waiting to be unlocked–JavaScript is capable of full object-
oriented capabilities, and by applying OOP principles, best practices, and design patterns
to your code, you can make it more powerful, more efficient, and easier to work with alone
or as part of a team. With Pro JavaScript Design Patterns, you’ll start with the basics of
object-oriented programming in JavaScript applicable to design patterns, including making
JavaScript more expressive, inheritance, encapsulation, information hiding, and more. With
that covered, you can kick-start your JavaScript development in the second part of the book,
where you’ll find detail on how to implement and take advantage of several design patterns
in JavaScript, including composites, decorators, façades, adapters, and many more.
Each chapter is packed with real-world examples of how the design patterns are best used and
expert advice on writing better code, as well as what to watch out for. Along the way you’ll
discover how to create your own libraries and APIs for even more efficient coding.
* Master the basics of object-oriented programming in JavaScript, as they
apply to design patterns.
* Apply design patterns to your kick-start your JavaScript development.
* Work through several real-world examples.
What you’ll learn:
* How to apply object-oriented programming techniques in JavaScript
* How to take advantage of inheritance, interfaces, and encapsulation and information hiding
to kick-start your JavaScript development
* How to implement several design patterns in your JavaScript projects, including factory,
façade, bridge, composite, adapter, decorator, flyweight, proxy, command, observer,
and chain of responsibility
* How to make your code easier to manage in a team environment, as well as on your own
* How to create your own libraries and APIs
Who is this book for?
This book will be an invaluable learning tool for any experienced JavaScript developer.
Download


Fundamentals of Database Systems has become the world-wide leading textbook because it combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions and modern database technologies. This book has been revised and updated to reflect the latest trends in technological and application development. This fourth edition expands on many of the most popular database topics, including SQL, security, and data mining along with an introduction to UML modeling and an entirely new chapter on XML and Internet databases. Read more...
This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g's significantly improved triggers.
One step at a time, you'll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you've learned, strengthening your understanding through real-world practice.
This book's approach fully reflects the authors' award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes
* Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL's role in PL/SQL
* Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements
* Efficiently handling errors and exceptions
* Working with cursors and triggers, including Oracle 11g's powerful new compound triggers
* Using stored p Read more...
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.
Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.
But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:
* Utilize the built in features of Access and Excel to access data
* Use VBA within Access or Excel to access data
* Build connection strings using ADO and DAO
* Automate Excel reports including formatting, functions, and page setup
* Write complex functions and queries with VBA
* Write simple and advanced queries with the Access GUI
* Produce pivot tables and charts with your data
With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyon Read more...
If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.
Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to:
* Develop basic and sophisticated queries
* Apply aggregate functions, custom functions, regular expressions, and crosstabs
* Apply queries to perform non-passive activities such as inserting, updating, and deleting data
* Create and manipulate tables and queries programmatically
* Manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text
* Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing
* Use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with othe Read more...
This resource provides the tools you need to leverage Access 2007’s built-in functionality and VBA in order to build more dynamic applications. The author team explores all aspects of VBA programming for Access, describes the latest innovations, and explains how to take advantage of key new objects, enhanced macros, and the Office Ribbon. Plus, you’ll find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
From the Back Cover
Access 2007 VBA Programmer's Reference
Written by Access MVPs and Microsoft Access testers, this resource will give you the tools to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. It explores all aspects of VBA programming for Access and describes the latest innovations. You'll also find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
The expert author team will show you how to create and name variables, manipulate data using Data Access Object (DAO) and ActiveX® Data Object (ADO), handle errors, and create classes. You'll also learn how to utilize the latest wizards as well as modify and enhance the code that the wizards create. And you'll learn how to take advantage of key new objects, enhanced macros, and the Office Ribbon.
What you will learn from this book
* All about Access 2007's new features and the buildi Read more...
Create Forms for Business
Ensure Data Entry Accuracy
Build Elegant Form Interfaces
Collect Data Via Email
Design Effective Business Reports
Make an Invoice Report
Create Mailing Labels
Extract Data
Work with Multiple Tables
Calculate Discounts
Analyze Data
Develop your Microsoft Access expertise instantly with proven techniques
Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.
This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.
· Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.
· Avoids database theory in Read more...
Pro Access 2007 covers the new features of Microsoft Access 2007, including working with SharePoint Office Server and customizing Ribbons. The book is aimed at professional developers and power users who are new to Access 2007. Among other topics, youll learn about the new Access menu structure, including customization, as well as new SharePoint features.
This book provides good, short, solid information with as little waffle as possible. And the book includes solid examples that thoroughly explain new features. Author Martin Reid is also a working Access developer who is respected by his peers and knows what working developers face, especially at the time of a new release. Read more...
* Go beyond Excel(r) with Access's more powerful analysis capabilities
* Get better visibility into your data with custom views
* Scale up your data pool without limitation
* Master the four fundamentals of data analysis
* Discover shortcuts with the helpful Input Mask Wizard
* Integrate your data with the web and enterprise data sources
* Avoid the common pitfalls of data crunching
* Harness VBA to improve data analysis
* Leverage information from the field with real-world scenarios Read more...
Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download. Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they're enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies--when they should and should not be used, what you can do with them, and how you can get the most out of them.
The main aim of this book is to show you each of the different types of .NET assemblies now possible within SQL Server 2005. This is a major leap in technology for developers and database administrators alike. Knowing when, how, and why to use this technology is crucial in continuing to offer stable and efficient database servers and database solutions.
By the end of this book, you will not only be competent in building assemblies, but also know which assemblies are safe for your server, what expansions each can give your server, and how you can build and deploy your own assemblies.
The ability to run .NET code in the database is arguably the most exciting development in SQL Server for years. Traditionally, if T-SQL did not meet your needs, then you could write the required logic in either an external business object or an extended stored procedure. With the former, you could often generate unnecessary network tr Read more...
This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g's significantly improved triggers.
One step at a time, you'll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you've learned, strengthening your understanding through real-world practice.
This book's approach fully reflects the authors' award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes
* Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL's role in PL/SQL
* Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements
* Efficiently handling errors and exceptions
* Working with cursors and triggers, including Oracle 11g's powerful new compound triggers
* Using stored p Read more...
In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.
Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.
But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:
* Utilize the built in features of Access and Excel to access data
* Use VBA within Access or Excel to access data
* Build connection strings using ADO and DAO
* Automate Excel reports including formatting, functions, and page setup
* Write complex functions and queries with VBA
* Write simple and advanced queries with the Access GUI
* Produce pivot tables and charts with your data
With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyon Read more...
If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.
Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by manipulating data with VBA, how to process dates and times, and even how to reach into the Excel data analysis toolkit. Recipes demonstrate ways to:
* Develop basic and sophisticated queries
* Apply aggregate functions, custom functions, regular expressions, and crosstabs
* Apply queries to perform non-passive activities such as inserting, updating, and deleting data
* Create and manipulate tables and queries programmatically
* Manage text-based data, including methods to isolate parts of a string and ways to work with numbers that are stored as text
* Use arrays, read and write to the Windows registry, encrypt data, and use transaction processing
* Use the FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with othe Read more...
This resource provides the tools you need to leverage Access 2007’s built-in functionality and VBA in order to build more dynamic applications. The author team explores all aspects of VBA programming for Access, describes the latest innovations, and explains how to take advantage of key new objects, enhanced macros, and the Office Ribbon. Plus, you’ll find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
From the Back Cover
Access 2007 VBA Programmer's Reference
Written by Access MVPs and Microsoft Access testers, this resource will give you the tools to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. It explores all aspects of VBA programming for Access and describes the latest innovations. You'll also find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain.
The expert author team will show you how to create and name variables, manipulate data using Data Access Object (DAO) and ActiveX® Data Object (ADO), handle errors, and create classes. You'll also learn how to utilize the latest wizards as well as modify and enhance the code that the wizards create. And you'll learn how to take advantage of key new objects, enhanced macros, and the Office Ribbon.
What you will learn from this book
* All about Access 2007's new features and the buildi Read more... 










— Thomas Kyte, VP (Public Sector), Oracle Corporation
The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns&emdash;and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?
If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.
The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.
In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewis&emdash;one of the foremost authorities in this field&emdash;describes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, you'll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.


Gavin JT Powell, “Oracle Performance Tuning for 10gR2, Second Edition”
Digital Press | ISBN 1555583458 | September 15, 2006 | 960 Pages | PDF | 11.1 MB
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase. (more…)

Maintaining SQL Server 2005 high availability in a global information environment is the database administrator’s greatest practical challenge. Availability is as much about people and processes as it is about technology. Pro SQL Server 2005 High Availability covers the technology, people, processes, and real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.
With years of experience as a database consultant and production DBA, Allan Hirt provides in-depth, detailed advice on what it takes to ensure SQL Server high availability for businesses of any size. This is not an academic text; it’s not based on lab experiments, but on real-world experience. This book is a dramatic update and revision of the author’s previous best-seller on SQL Server 2000. It gives sound guidance to DBAs and system administrators on how to really get the job done.

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a “Mere Mortal” will indeed be empowered to perform the superhuman. Do not walk past this book!
–Graham Mandeno, Database Consultant
SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries
–Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3–the International SQL Standards Committee
I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the “watch out for this trap” items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database.
–Kenneth D. Snell, Ph.D., Database Designer/Programmer
I don’t think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd’s original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy.
–Arvin Meyer, MCP, MVP
Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what’s usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I’m sure it’ll get so much use that it won’t spend much time on the shelf!
– Doug Steele, Microsoft Access Developer and author
Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users.

Although MySQL’s source code is open in the sense of being publicly available, it’s essentially closed to you if you don’t understand it. In this book, Sasha Pachev — a former member of the MySQL Development Team — provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You’ll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.
The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:
Core server classes, structures, and API
The communication protocol between the client and the server
Configuration variables, the controls of the server; includes a tutorial on how to add your own
Thread-based request handling — understanding threads and how they are used in MySQL
An overview of MySQL storage engines

Relational databases hold data, right? They indeed do, but to think of a database as nothing more than a container for data is to miss out on the profound power that underlies relational technology. A far more powerful way of thinking lies in relational technology’s foundation in the mathematical disciplines of logic and set theory.
Databases contain truths or propositions describing some area of interest such as a business. Those truths are organized into sets. Operations from logic and set theory can be applied to existing sets of truths to derive new sets of truths. Applied Mathematics for Database Professionals introduces you to this way of thinking, to the logic and set theory that underlies relational database technology. All this may sound abstract now, but there are profound benefits from the deeper understanding you’ll gain from this book. You’ll learn to
Become a better database designer. You’ll make fewer mistakes, and your designs will be more flexible in response to changing data needs.
Use the expressive power of mathematics to precisely specify designs and business rules.
Communicate effectively about design using the universal language of mathematics.
Develop and write complex SQL statements with confidence.
Avoid pitfalls and problems from common relational bugaboos such as null values and duplicate rows.
Paperback: 310 pages
Publisher: Irm Press (April 1, 2003)
Language: English
ISBN-10: 1931777470
ISBN-13: 978-1931777476
Focused on the latest research on text and document management, this guide addresses the information management needs of organizations by providing the most recent findings. How the need for effective databases to house information is impacting organizations worldwide and how some organizations that possess a vast amount of data are not able to use the data in an economic and efficient manner is demonstrated. A taxonomy for object-oriented databases, metrics for controlling database complexity, and a guide to accommodating hierarchies in relational databases are provided. Also covered is how to apply Java-triggers for X-Link management and how to build signatures.
Hardcover: 280 pages
Publisher: CRC; 1 edition (November 24, 2003)
Language: English
ISBN-10: 0849318548
ISBN-13: 978-0849318542
Hardcover: 720 pages
Publisher: Lawrence Erlbaum; 1 edition (April 1, 2003)
Language: English
ISBN-10: 0805840818
ISBN-13: 978-0805840810
Created with the input of a distinguished International Board of the foremost authorities in data mining from academia and industry, The Handbook of Data Mining presents comprehensive coverage of data mining concepts and techniques. Algorithms, methodologies, management issues, and tools are all illustrated through engaging examples and real-world applications to ease understanding of the materials.
Hardcover: 424 pages
Publisher: Wiley-Interscience; 1 edition (September 25, 2003)
Language: English
ISBN-10: 0471460540
ISBN-13: 978-0471460541
Hardcover: 483 pages
Publisher: IGI Global (February 4, 2003)
Language: English
ISBN-10: 1591400511
ISBN-13: 978-1591400516
Data Mining: Opportunities and Challenges presents an overview of the state of the art approaches in this new and multidisciplinary field of data mining. The primary objective of this book is to explore the myriad issues regarding data mining, specifically focusing on those areas that explore new methodologies or examine case studies. This book contains numerous chapters written by an international team of forty-four experts representing leading scientists and talented young scholars from seven different countries.
Hardcover: 1232 pages
Publisher: CRC; 1 edition (September 30, 2003)
Language: English
ISBN-10: 084937006X
ISBN-13: 978-0849370069
Technology has spurred the growth of huge image and video libraries, many growing into the hundreds of terabytes.
Paperback: 560 pages
Publisher: McGraw-Hill Osborne Media; 2 edition (April 28, 2003)
Language: English
ISBN-10: 0072228857
ISBN-13: 978-0072228854
Here is the foundation upon which you can build your relational database design and programming, then apply those skills to any SQL-based product. Carefully organized for beginners, you’ll learn step-by-step how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques.
Paperback: 704 pages
Publisher: Wiley; 1 edition (January 7, 2003)
Language: English
ISBN-10: 0471202436
ISBN-13: 978-0471202431
Written by the authors of the Common Warehouse Metamodel (CWM) specification, this book is the official and authoritative developer’s guide
Provides a comprehensive look at how to develop database and data warehouse applications using the Common Warehouse Metamodel
Covers the full development lifecycle including application design
implementation, and deployment
Companion Web site includes updates on the technology, descriptions of tools, and links to vendor sites
Paperback: 336 pages
Publisher: Rampant Techpress; Stg edition (April 1, 2004)
Language: English
ISBN-10: 0974435538
ISBN-13: 978-0974435534
An instructor’s guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, design review meetings, software installation, database objects, backup and recovery, and tuning and performance.
Paperback: 400 pages
Publisher: McGraw-Hill Osborne Media; 1 edition (August 29, 2003)
Language: English
ISBN-10: 0072229659
ISBN-13: 978-0072229653
Create and manage a robust Access database using this advanced guide. You’ll get full coverage of all the new features, including Smart Tags and enhanced XML support. Learn to write advanced queries with the query wizard and the design view, import and export data, program with Web Matrix and .NET, and build Access Data Projects with SQL Server. Database backup and security issues are also covered.
Paperback: 456 pages
Publisher: Wiley (August 8, 2003)
Language: English
ISBN-10: 0471324213
ISBN-13: 978-0471324218
At last, a balanced approach to data warehousing that leverages the techniques pioneered by Ralph Kimball and Bill Inmon
Since its groundbreaking inception, the approach to understanding data warehousing has been split into two mindsets: Ralph Kimball, who pioneered the use of dimensional modeling techniques for building the data warehouse, and Bill Inmon, who introduced the Corporate Information Factory and leads those who believe in using relational modeling techniques for the data warehouse. Mastering Data Warehouse Design successfully merges Inmon’s data ware- house design philosophies with Kimball’s data mart design philosophies to provide you with a compelling and complete overview of exactly what is involved in designing and building a sustainable and extensible data warehouse.
Paperback: 1464 pages
Publisher: Wiley; Pap/Cdr edition (October 3, 2003)
Language: English
ISBN-10: 0764539868
ISBN-13: 978-0764539862
The most comprehensive reference on this popular database management tool, fully updated with the new features of Access “X” including increased use of XML and Web services
Explores the new, tighter integration with SharePoint and BizTalk in Office “X” that enables greater flexibility for gathering and manipulating data
Hardcover: 745 pages
Publisher: Apress (July 17, 2007)
Language: English
ISBN-10: 159059780X
ISBN-13: 978-1590597804
Maintaining SQL Server 2005 high availability in a global information environment is the database administrator’s greatest practical challenge. Availability is as much about people and processes as it is about technology. Pro SQL Server 2005 High Availability covers the technology, people, processes, and real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.
Paperback: 775 pages
Publisher: McGraw-Hill Osborne Media; 1 edition (January 26, 2007)
Language: English
ISBN-10: 0072263504
ISBN-13: 978-0072263503
The Ultimate Microsoft Office Access 2007 Resource
Build a highly responsive a database so you can track, report, and share information and make more informed decisions. This comprehensive resource shows you how to design and develop custom Access 2007 databases—even if you have little or no programming experience. You’ll learn to collect data from a variety of sources, share it securely with others, and integrate it with other Office applications.