Where to Start –
Find a Problem To Solve
Start with a real problem
You won’t enjoy learning something new unless you have a real problem to solve that interests you. To learn more about data, envision a reporting system that you need and may want to add more features to.
Start with a spreadsheet
Before you can work with data, you have to create test data. A spreadsheet is the easiest place to start to craft the various data tables that you will learn from. Create multiple tabs, one for each reference point such as clients, employees, sales invoices or time entry logs.
Plan the End Result
Still using a spreadsheet, now create the ultimate presentation where your data should be presented so you can interact with it. This is where you envision something useful, something that pushes the boundaries of what you already have. Make it apply to your needs.
The Next Step –
Get Your Hands Dirty
Create a Database
It is time to move your test data from your spreadsheet into a database. Microsoft SQL Server Express is a great place to start and provides an import feature to help you get started. See below for more links on how to figure the steps out. And you will need to first install SQL Server Express to get moving.
Learn About SQL
Now that you have tables you get to learn how to query the data in ways that make sense to you. However, it won’t initially make sense on how this is done. But the below links will help. We strongly suggest you learn how to store and run your SQL code from a Stored Procedure.
Don’t Give Up
It will be difficult, but if you persist you will be able to create the final queries that would fold into your planned end result. Connecting your queries and your spreadsheet is another project, but if you can get this far you are on your way.