I think more or less we are done with SQL for now. For 90% of the time using a database, what we been doing would suffice. The process of Creating , Reading , Updating , Deleting information is aka ‘CRUD’ in some programming and database textbooks. What we havn’t covered would be
- ORDER BY
- In-Depth details of SQL Functions
- SQL Programming , eg T-SQL and PL/SQL
- Database Administration
- SQL Security
Before we go into those , I would like to take a detour around the whole ‘Relational Database’ and explore the shallow water of programming. Of course , both topics will overlap eventually. For example , Microsoft LINQ or Ruby on Rails require that you understand both the programming side , such as loops and functions as well as database statements such as SELECT. You will eventually have to know both. The higher you go , both are inseparable. In fact , you could say Google is nothing more than a giant database full of information on the websites. How do you extract data out of it? By using programming languages , Google uses Python extensively , if you want to know.
So here is what I plan to do for foreseeable future…
- General Programming Topics , eg functions , loops ..
- Dive deeper into 2 or 3 languages
- See how both programming languages and database can be integrated
- Have Fun!