Category Archives: Database Design

Coming in October – MySQL Explained (updated)

MysqlMy newest book, MySQL Explained, is due to be published this month! You can check out the LeanPub page to show your support and to sign up for notifications of when it’s published.  See the description of the book below.

UPDATE 10/24/2015 – MySQL Explained is now available in both EPUB and MOBI (Kindle) formats with the first chapter available for FREE from LeanPub.com and Amazon.com! Read more about this guide to the leading database for online applications and on the official page!

About the Book

MySQL Explained is a step-by-step tutorial for everyone who’s ready to learn about the database software most commonly used for storing information behind some of today’s most popular websites and online applications.

Written especially for people outside the I.T. world, MySQL Explained provides the background information you need to get familiar with database theory and the principles behind organizing data. This book starts from the ground up, helping the reader to understand the very definition of a database, the forms it can take and the different options for storing information. By the end of this book, you’ll understand the reasons for choosing MySQL, the options for installing it and the tools that it offers to store and safeguard your data.

If you are in any way involved in designing or managing a website or data solution of any kind, you owe it to yourself to understand the tools involved. Quality database management sytems are essential in today’s data-driven world and such essential tools should not be a mystery to those who depend on them. MySQL Explained can help you unravel the mystery and learn more about a technology that will be around for a long time to come.

MySQL Explained is published through OS Training which, in addition to publishing tutorials like this one, offers onsite and online training in web technologies including Joomla, Drupal and WordPress.

SQL Server for Beginners: Part V – Using SQL Server 2012 LocalDB

In a previous chapter, I described the installation process for SQL Server 2012 Express which included all the bells and whistles of the advanced services package. While it’s great to have all the tools at your disposal to learn from, some people might not want such a large installation on a particular machine or the administration that goes with it but might still want the basic database capabilities of SQL Server on their desktop. In this case, SQL Server 2012 offers a new edition called LocalDB.

LocalDB is a minimized version of SQL Server Express specifically for developers who still need all the programming features including the ability to create stored procedures and other objects within an instance of SQL Server. It has a few restrictions that the average beginner probably won’t be bothered by and you can connect to it with SQL Server Management Studio (SSMS) or other tools to create and manage databases. You can even install the AdventureWorks sample database to work with through an instance of LocalDB.

In this article, I’ll describe the process of installing both LocalDB and SSMS in order to create a small desktop database environment to work with as a developer or a beginner in database design.

Continue reading

SQL Server for Beginners: Part IV – The AdventureWorks Database

In the last part of this series I wrote about SQL Server Management Studio (SSMS), the interface that enables you to work with SQL Server objects such as databases and tables. The program enables you to do quite a bit with a SQL Server installation. You can create entire databases and manipulate all the objects within them just through context menus.

Having a graphical interface is nice but the real work of SQL Server is done through commands issued to the service which the menu options in a program like SSMS often do for you. If you really want to be knowledgeable about SQL Server, it’s important to learn the syntax of these commands and how to write and issue them on your own.

Continue reading

SQL Server for Beginners: Part III – SQL Server Management Studio

Once you have SQL Server and all the necessary updates installed, the next step is to learn how to create databases and work with them. The easiest interface available to the beginner is Microsoft SQL Server Management Studio (SSMS), a graphical environment where you can view and manipulate all of the databases and other objects on your SQL Server instance and perform other advanced functions.

If you installed the Express edition with Management Tools or Advanced Tools as detailed in the last chapter, you should have SSMS installed and showing in the Program Menu under whichever version of SQL Server you have installed. Just click on the program to open it.

Continue reading

SQL Server for Beginners: Part II – Installing SQL Server Express

Just like with any software, SQL Server uses a standard installation program to install its components on your system. Depending on the edition that you’re using, you will be installing it from media that you purchased or from the free install packages that you can download from Microsoft’s website. Unlike other installs, the SQL Server installation can be a long process as there are a number of components, requirements and options to consider, many of which I’ll be detailing in this article.

Continue reading

SQL Server for Beginners: Part I – From Desktop to Network

In an earlier series of articles, I wrote about getting started with Microsoft Access, which is one of the foremost desktop database packages available and an excellent tool for small to mid-size database projects. While it was not the first database software that I used, it was the one that took me from novice to professional status. Once I reached that level, however, I had to start learning more advanced tools in order to advance in my career and take on new projects. One important set of tools was Microsoft SQL Server which remains one of the most popular network database systems on the market.

Continue reading

What You Need to Know About Database Technology

In the modern world, our daily activities follow and leave a rich trail of electronic data from e-mail and text messages to credit card transactions and medical records. At its simplest, the data could be an address book or contact list stored in a text file while more complex information such as a store’s inventory and customer information might take up terabytes of space on network servers and require full-time administrators to maintain it. Most of this data is stored in electronic databases of one kind or another where it can be searched, sorted and easily retrieved as needed.

After a basic understanding of how to work with computers, knowing the basics of how data is stored and manipulated is an important part of being technically savvy in today’s world. Whether you work with large amounts of data and need to organize it better or you need to communicate with the people who do, the better you understand the technology, the more effectively you’ll be able to face the daily challenges that come from living in a data-driven world.

Continue reading

Installing SQL Server 2012 Express on Windows 8

Doing this tonight. Found out that the .Net 3.5 framework needs to be disabled by turning it off under the System Programs and Features. Otherwise, the installation is still trying to install the setup files after more than an hour. One of Windows 8’s little quirks. See this link for more …

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/18f60327-d4ce-407d-ace8-9fc98e52c37c/sql-server-2012-express-is-not-compatible-with-windows-8?forum=sqlsetupandupgrade

‘Your First Guide to Database Design’ – Now available in Adobe PDF!

firstguidecoverMy latest book is now available on Scribd.com in Adobe PDF format. That means that even if you don’t have a Kindle or a Nook, you can STILL learn how to organize any kind of information and create your own database applications. In a world so completely dependent on the flow of information, this is a valuable career skill and a valuable perspective on how your own information is managed by others. Your First Guide to Database Design is written to present the concepts involved in database design in a clear and logical manner using everyday examples and is available for only $9.99, far less than the average technology guide. Check out the free preview on Scribd.com! If you’d like more information first, you can also check out the book’s official page on AndrewComeau.com which contains links to the free PDF preview and all the locations where you can purchase the book for the Kindle and Nook as well.

Finally Published!

firstguidecoverIt’s finally here!  Your First Guide to Database Design is now available on Amazon.com and BarnesAndNoble.com.  Another PDF version will soon be available for purchase on Scribd.com.

Your First Guide to Database Design is a clear, easy-to-use guide to relational database design for both beginners and I.T. professionals who need to know how to organize and store any amount of information on any subject. Whether you’re using SQL Server, MySQL or another database software, this book will show you how to model the data, create a system of tables and use Structured Query Language (SQL) to read and write to your new database. Your First Guide to Database Design uses multiple examples including the Job Search Plus database to help the average user understand the principles behind database design.

For more information, check out the official book page or the support page on AndrewComeau.com. The support page includes full-size diagrams of example databases used in the book and will be updated with answers to reader questions so be sure to bookmark it!