- A Crash Course in Test-Driven Development
- 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.
|
- Ten Tips for Constructing an Agile Database Development Environment that Works
- 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.
|
- 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.
|
- 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.
|
- Database Design for Mere Mortals: An Interview with Mike Hernandez
-
By
Michael J. Hernandez
- 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.
|
- Retrieving Data Using the SQL SELECT Statement
- Dec 10, 2012
- In this lesson, learn how to use the SELECT statement to retrieve one or more columns of data from a table.
|
- Working with Arrays in PHP and MySQL
- 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.
|
- Database Administration: Creating the Database Environment
- 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.
|
- FileMaker 12 Product Line
- 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.
|
- Cloud Computing Reference Architecture: Data Ingress and Storage Access
- 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.
|
- SQL Standards and Guidelines for DB2 Developers
- 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.
|
- Using FileMaker Pro
- Oct 5, 2012
- This chapter introduces you to how to make the most of FileMaker databases that have already been built.
|
- Administering Storage, I/O, and Partitioning in Microsoft SQL Server 2012
- 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.
|
- Leveraging SQLite Application Databases for Android Wireless Application Development
- 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.
|
- Introduction to Polyglot Persistence: Using Different Data Storage Technologies for Varying Data Storage Needs
- 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.
|
- The Economics of Cloud Computing: An Overview For Decision Makers
- 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.
|
- Principles of Decision Management Systems
- Jul 16, 2012
- James Taylor discusses the four specific principles that are at the heart of identifying and building Decision Management Systems.
|
- pureXML: Using XML in DB2 for z/OS
- 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.
|
- End-to-End JPA Collections with MySQL, Part 2
- 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.
|
- End-to-End JPA Collections with MySQL, Part 1
- Apr 30, 2012
- Having difficulty getting your JPA collection code up and running? Stephen Morris demonstrates an end-to-end, working example of a JPA collection in this first part of a two-part series.
|