Research Agenda

These are my immediate research goals for the attempt to change my courses to more open source, and to develop data analytics courses.

• Explore Postgres, both on Windows and Linux. The first task will be to build a version of my CommunityAssit charity database on PostGres.
• Run through the complete SQL ITC 222 Assignment list in PostGres, including functions, triggers and stored procedures
• Explore ETL and reporting for PostGres with open source tools
• Explore Data Warehousing with PostGres, and developing data cubes
• Explore input and output of JSON and communication with Mongo
• Python and analytics

In addition I want to deepen my knowledge of MongoDb and some other NoSQL databases. Best practices for "schema" building, more sophisticated search and analytic techniques and also administrative tools and practices

I also intend to try Microsoft's ADO Entity Framework with Postgres to see how it works.

That should be enough to keep me for a couple of days