database course
-
I need to give an introductory database course to a bunch of people who generally are able to write simple SQL queries, but still mainly use files to save stuff. (fits files, ascii files, csv files, ...) My course starts with presenting some pro's and con's, explaining the basic structure (tables, links, constrains, keys, indexes, ...) and diving into some basic SQL. A second lesson (still under development) would be coding against databases (creating a connection, SQL injection, ...) I also included a lab with exercises (for lesson 1, lesson 2 to be done). I looked at some tutorials on the internet, but still would like some advice on how to best bring this topic. thanks in advance.
-
I need to give an introductory database course to a bunch of people who generally are able to write simple SQL queries, but still mainly use files to save stuff. (fits files, ascii files, csv files, ...) My course starts with presenting some pro's and con's, explaining the basic structure (tables, links, constrains, keys, indexes, ...) and diving into some basic SQL. A second lesson (still under development) would be coding against databases (creating a connection, SQL injection, ...) I also included a lab with exercises (for lesson 1, lesson 2 to be done). I looked at some tutorials on the internet, but still would like some advice on how to best bring this topic. thanks in advance.
V. wrote:
A second lesson (still under development) would be coding against databases (creating a connection, SQL injection, ...)
I'd recommend explaining sprocs and functions, moving to Xml in the third lesson. Creating a connection to the database from a non-sql language has little to do with SQL. What's their role? If design comes into play, you could reserve a week for the topic of database-normalization. There's examples on structures that break normalization on the wikipedia[^]; the update-anomaly is always a nice intro as people recognize it from the real world :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
-
V. wrote:
A second lesson (still under development) would be coding against databases (creating a connection, SQL injection, ...)
I'd recommend explaining sprocs and functions, moving to Xml in the third lesson. Creating a connection to the database from a non-sql language has little to do with SQL. What's their role? If design comes into play, you could reserve a week for the topic of database-normalization. There's examples on structures that break normalization on the wikipedia[^]; the update-anomaly is always a nice intro as people recognize it from the real world :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]
Thanks! that already helps !