Archive

Category Archives for "Learn SQLite"

Listed here is my series on learning SQL. These lessons are perfectly suited for anyone that desires to learn how to query a database. We start with the basics, using SQLite, and focus on the command that are used retrieve the data. Once you learn the commands, you can practically use any web or GUI tool to create complex queries. You’ll never feel limited by what you can do, nor frustrated that you’re restricted to a few canned report to rely upon.

You don’t have to be a computer wiz to follow along. I try to use plain English to explain the concepts. Though the courses can help the tech minded, such as developers, I really wrote them for the average computer user. It is my hope all you HR, Business Analysts, Engineers, and Accountants will find my site, learn SQL, and make your jobs and lives easier.

Database Third Normal Form Explained in Simple English

Second Normal Form

This is the fourth in a series of posts teaching normalization.  The third post focused on the second normal form, its definition, and examples to hammer it home. Once a table is in second normal form, we are guaranteed that every column is dependent on the primary key, or as I like to say, the table serves […]

Continue reading

Database First Normal Form Explained in Simple English

First Normal Form

This is the second in a series of posts teaching normalization. The first post introduced database normalization, its importance, and the types of issues it solves. In this article we’ll explore the first normal form. For the examples, we’ll use the Sales Staff Information shown below as a starting point.  As we pointed out in the […]

Continue reading

Database Normalization Explained in Simple English

Database Normalization Explained

Introduction Database normalization is process used to organize a database into tables and columns.  The idea is that a table should be about a specific topic and that only those columns which support that topic are included. For example, a spreadsheet containing information about sales people and customers serves several purposes: Identify sales people in […]

Continue reading
1 2 3