Databases

468 Items

Sort by Date | Title | Popularity

1.	Using SQL to Manage Data By Paul Dubois Apr 29, 2013 SQL is the means by which you tell the server how to perform data management operations, and fluency with it is necessary for effective communication. This chapter covers how to use SQL to manage data, including changing the SQL mode to affect server behavior, referring to elements of databases, using multiple character sets, creating and destroying databases, tables, and indexes, obtaining information about databases and their contents, retrieving data using joins, subqueries, and unions, using multiple-table deletes and updates, performing transactions that enable statements to be grouped or canceled, setting up foreign key relationships, and using the FULLTEXT search engine.
2.	A Crash Course in Test-Driven Development By Max Guernsey Apr 4, 2013 Get a crash course in test-driven development, including the test-first technique, a test's proper role in your organization, what you want to specify, and traditional database design concepts.
3.	Ten Tips for Constructing an Agile Database Development Environment that Works By Max Guernsey Feb 26, 2013 Max Guernsey, III, author of Test-Driven Database Development: Unlocking Agility, shares ten fundamental prescriptions and proscriptions to help you be more successful in your database development endeavors.
4.	A Database Technology Recommended Reading List by Mike Hernandez By Michael J. Hernandez Feb 11, 2013 If you're interested in an in-depth study of database technology, Michael J. Hernandez, the author of Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, 3rd Edition, recommends these books.
5.	Database Design for Mere Mortals: Keys By Michael J. Hernandez Feb 11, 2013 Michael J. Hernandez explains the different types of keys, and how each type plays a different role within the database.
6.	Database Design for Mere Mortals: An Interview with Mike Hernandez By Michael J. Hernandez, Ken Getz Jan 31, 2013 Ken Getz interviews Mike Hernandez, author of Database Design for Mere Mortals, third edition, about the importance of database design, the problem with database tools, and why he really did write his book for mere mortals.
7.	Retrieving Data with the SQL SELECT Statement By Ben Forta Dec 10, 2012 In this lesson, you’ll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
8.	Working with Arrays in PHP and MySQL By Christian Wenz Nov 20, 2012 This chapter presents the most important problems you’ll have to solve when working with arrays—and, of course, solutions for these problems.
9.	Database Administration: Creating the Database Environment By Craig S. Mullins Nov 7, 2012 Establishing a usable database environment requires a great deal of skill, knowledge, and consideration. This chapter will outline the principles involved in establishing a usable database environment.
10.	FileMaker 12 Product Line By Bob Bowers, Dawn Heady, Steve Lane, Scott Love Oct 30, 2012 This chapter provides a quick overview of the purpose and profile of each piece of the FileMaker software suite, along with relevant operating system requirements.
11.	Cloud Computing Reference Architecture: Data Ingress and Storage Access By Buck Woody Oct 24, 2012 Buck Woody, Senior Technical Specialist on Windows Azure at Microsoft, describes how to create a centralized, off-premises (cloud-based) data store that provides flexibility, security, consistency, and guards against vendor lock-in.
12.	SQL Standards and Guidelines for DB2 Developers By Tony Andrews Oct 15, 2012 This chapter shows how to create a set of SQL standards and guidelines for developers to follow when running applications that involve DB2.
13.	Using FileMaker Pro By Jesse Feiler Oct 5, 2012 This chapter introduces you to how to make the most of FileMaker databases that have already been built.
14.	Administering Storage, I/O, and Partitioning in Microsoft SQL Server 2012 By Ross Mistry Sep 27, 2012 This chapter focuses on the use and most effective configuration of storage components within a Database Engine instance of SQL Server 2012.
15.	Leveraging SQLite Application Databases for Android Wireless Application Development By Lauren Darcey, Shane Conder Sep 25, 2012 In this chapter, learn one of the most powerful ways you can store, manage, and share application data with Android: an application database powered by SQLite.
16.	Introduction to Polyglot Persistence: Using Different Data Storage Technologies for Varying Data Storage Needs By Pramod J. Sadalage, Martin Fowler Sep 5, 2012 Different databases are designed to solve different problems. Using a single database engine for all of the requirements usually leads to non- performant solutions. In this chapter, the authors introduce the term polyglot persistence to describe using different data storage technologies to handle varying data storage needs.
17.	The Economics of Cloud Computing: An Overview For Decision Makers By Bill Williams Jul 30, 2012 In this chapter, Bill Williams explores the standard definition of cloud computing to establish a baseline of common terminology. Understanding the essential characteristics of cloud computing platforms, as well as cloud deployment and service models, is critical for making informed decisions and for choosing the appropriate platform for your business needs.
18.	Principles of Decision Management Systems By James Taylor Jul 16, 2012 James Taylor discusses the four specific principles that are at the heart of identifying and building Decision Management Systems.
19.	pureXML: Using XML in DB2 for z/OS By Craig S. Mullins Jun 4, 2012 This chapter introduces you to the basics of XML and provides an overview of pureXML, IBM’s implementation of XML support embedded in DB2.
20.	End-to-End JPA Collections with MySQL, Part 2 By Stephen B. Morris May 1, 2012 Stephen Morris provides simple, end-to-end working code illustrating how to modify JPA collection code. Also, the area of MySQL stored procedures is looked at, using some simple examples in this the concluding part of a two-part series.

< Prev 1 2 3 4 5 Next >