For a lot of the posts that I am going to do on here I am going to connect to a database. In case anyone is just starting out databases are a great way to store your data, much better and scale-able than Excel or Access (technically access counts as a DB). There are free versions of most of the databases systems out there. I have more experience with Oracle than anything else so for my home system went with SQL Server.
I am not going to go into detail on here on how to install or get SQL Server set up as there are already great resources or there on how to do (Google it!).
For us the main purpose of the database is to have a source of information from which we can pull data to populate Excel or Word or hold our mail list which we will use to send e-mails in Outlook.
Most companies will have databases that have their Sales information, finance data and their data warehouse. You will need to know SQL in order to extract this data and we will need to be able to establish a connection from python to your database.
No comments:
Post a Comment