Join 132,065 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,138 people online right now. Registration is fast and FREE... Join Now!
Hopefully this is where I need to put this...I am probably even less than a beginner when it comes to any kind of programming and maybe this forum is to advanced for me, but I have been searching through all the tutorials here tring to find out how to build a shopping cart eor a web site I am building. Everything I have found just confusses me, so I was wanting to know if anyone had a suggestion as to a book i could buy or if there is something at this forum that I miss please let me know. Please take into consideration I have no idea what I am doing. Thanks.
Preventing SQL Injection in MySQL and SQL Server with a variety of languages with examples on removing its abilities. I'm still a beginner in Databases and I think it would be good to be safe with SQL before I delve into using it.
I know there is a tutorial in the PHP section, I just don't think it would be a very effective method in an enterprise application.
It would be good if the functions and examples of more challenging SQL queries(Eg. nested joins, aggregate functions, etc.) are included in the tutorial. Explanation on the Relational Model would also be useful for beginners like me
I'd really like a tutorial on how to handle creation and updating of many-to-many relationships. E.g. student-student_klasses-klasses or name-name_phone-phone (one person has several phone numbers, one number leads to several persons.
To me personally SELECT isn't a problem but how do I update or insert? I write the name to names, then I write the phone number - if not already there - to phone numbers, but how do I know what to write in the name_phone table?
I think this whole business with inserting and/or updating tables in many-to-many relations would benefit from a good tutorial. Also; how do I handle constraints during update and/or insert?
One other tutor I'd like to see is something about transaction handling in SQL server. How do I implement start transaction, rollback, commit? How do I handle it from VB.NET? How do I turn it on? (Seems that SQL Express doesn't require transaction handling by default)
In this tutorial (or another) I'd like to see somthing about different methods of locking, locking tables versus rows in multi user systems. And how do we handle deadlock situations?
And while we're at it, how about some philosophy on what kinds of transaction handling there are and why one is better than another in certain situations?
@jens: Give me some time and Ill see what I can come up with. I'm kind of swamped at work right now but when I get a free moment Ill work on something along these lines
I would like to see a couple that are not mssql or mysql, maybe postgresql or sqlite. Basics maybe even the differences in them from more main stream like mssql or mysql.
9 Feb, 2008 - 10:16 PM
| 