Self directed project integrating astrology to practice SQL with MS SQL Server.
I ran into a few issues trying to get hold of specific AstroDataBank data, so I decided to create my own small sample of randomised birth dates, locations and names using ChatGPT. I then used AstroGold to generate charts and collect superficial planetary information. I loaded the necessary info into Excel and from there created the 'astrology database.csv' that I loaded into SQL Server.
- TSQL
- Selecting columns from a table
- Filtering rows and grouping data
I'd like to experiment by adding more complexity to this database, like including a column of aspects or reframing it into a small transit database of sorts. A work in progress!