What is a good starting point, tutorial or project to learn database programming?

Question

I have been a software developer for over 10 years. I mainly worked in Embedded C with some time spent in C ++ (limited) and Java.

I am looking for new technologies and skills. I thought database programming might be interesting to learn. I would like to make my own project for animals to learn these things.

My platform of choice is Windows, but it can also work on Linux.

My ideal pet project will include a GUI and some network / internet programming that I also have.

I would not mind getting into C #, but I do not want to bite off more than I can chew right now, because my free time is limited.

If I understand correctly, SQLite allows programs to use the database without starting the ODBC server. It's right? Is this a good place to start?

What can I do to get started, it’s not too difficult, but not so simple that I will not study the details either?

Your opinion and feedback will be appreciated.

Answer 1

If you want to learn database development (schema design, query languages), you can use any of several technologies. SQLite, SQL Express (Microsoft), MySQL are examples of relational DBMSs. If you want to learn them, you will need to learn their dialect of SQL. Good circuit design techniques are essentially the same depending on what you use.

If you want to write database-dependent applications, you can use C ++, but if you want to write applications with a graphical interface, I suggest you think about switching to C #. The syntax is pretty close to C ++ and Java that I don’t think that learning it will bother you when you focus on database materials.

There are also "dictionary" databases, such as MongoDB and NoSQL, which essentially store data graphics. They are becoming more popular and allow developers to worry less about the scheme and about problems with resolving problems in the domain.

As for application ideas, just start with a to-do list. Expand it to make it useful, since you are doing this, you need to learn how to make it work. Once you have the basics, look for open source projects. CMS projects such as DNN (which is VB) or Umbraco (which is C #) would be good learning tools.