Database tutorial requests?

  • (3 Pages)
  • +
  • 1
  • 2
  • 3

32 Replies - 26202 Views - Last Post: 06 May 2013 - 04:45 PM Rate Topic: -----

#1 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1637
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Database tutorial requests?

Posted 09 February 2008 - 11:16 PM

If there is a topic you'd like to see covered in either SQL Server or mySQL then put your request here.
Is This A Good Question/Topic? 0
  • +

Replies To: Database tutorial requests?

#2 capty99  Icon User is offline

  • i am colt mccoy
  • member icon

Reputation: 98
  • View blog
  • Posts: 10,081
  • Joined: 26-April 01

Re: Database tutorial requests?

Posted 09 February 2008 - 11:42 PM

i'd be interested but i only do the basic calls and sets to them so i don't even know what else is out there.... i'm a big fan of snippets.
Was This Post Helpful? 0
  • +
  • -

#3 Footsie  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 23
  • View blog
  • Posts: 370
  • Joined: 20-September 07

Re: Database tutorial requests?

Posted 10 February 2008 - 04:40 AM

In MySQL maybe a tutorial on granting "Priveleges", I think you have to work with the Grant tables or something.

This is one of the next things I have to research for a small project I'm busy with. I think a tutorial would help a lot.

Thanks for asking! ;)
Was This Post Helpful? 1
  • +
  • -

#4 SamIsMe  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 8
  • Joined: 09-February 08

Re: Database tutorial requests?

Posted 17 February 2008 - 06:39 AM

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.
Was This Post Helpful? 1

#5 RodgerB  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 66
  • View blog
  • Posts: 2,284
  • Joined: 21-September 07

Re: Database tutorial requests?

Posted 26 April 2008 - 05:32 PM

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.
Was This Post Helpful? 0
  • +
  • -

#6 myra  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 25
  • Joined: 04-April 08

Re: Database tutorial requests?

Posted 27 April 2008 - 05:23 AM

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 :)
Was This Post Helpful? 0
  • +
  • -

#7 jens  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 67
  • View blog
  • Posts: 430
  • Joined: 09-May 08

Re: Database tutorial requests?

Posted 10 May 2008 - 06:50 AM

Hi!

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?

Regards
Jens
Was This Post Helpful? 0
  • +
  • -

#8 jens  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 67
  • View blog
  • Posts: 430
  • Joined: 09-May 08

Re: Database tutorial requests?

Posted 10 May 2008 - 06:59 AM

Hi (again)!

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?

Regards
Jens
Was This Post Helpful? 0
  • +
  • -

#9 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1637
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: Database tutorial requests?

Posted 10 May 2008 - 07:13 AM

@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 :)
Was This Post Helpful? 1
  • +
  • -

#10 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1637
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: Database tutorial requests?

Posted 22 May 2008 - 08:08 AM

There is a new MSSQL Tutorial Available


User Defined Functions In MSSQL


Happy reading :)
Was This Post Helpful? 0
  • +
  • -

#11 linuxunil  Icon User is offline

  • New D.I.C Head
  • member icon

Reputation: 5
  • View blog
  • Posts: 46
  • Joined: 07-March 06

Re: Database tutorial requests?

Posted 16 June 2008 - 06:55 PM

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.
Was This Post Helpful? 0
  • +
  • -

#12 jens  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 67
  • View blog
  • Posts: 430
  • Joined: 09-May 08

Re: Database tutorial requests?

Posted 12 November 2008 - 03:27 PM

A toddlers guide to stored procedures in MSSQLserver?

A little somthing about how to add a user to MSSQLserver and change what tables (s)he can use? Bonus: By using SSMSE.

/Jens
Was This Post Helpful? 0
  • +
  • -

#13 airamana  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 16-February 09

Re: Database tutorial requests?

Posted 19 February 2009 - 09:25 AM

I'd like to request for a tutorial on PHP with MYSQL..
Was This Post Helpful? 0
  • +
  • -

#14 akj_  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 32
  • Joined: 23-March 09

Re: Database tutorial requests?

Posted 23 March 2009 - 08:19 PM

make sql tutorial videos..dat'd be great
Was This Post Helpful? 0
  • +
  • -

#15 crazyclint  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 29-October 08

Re: Database tutorial requests?

Posted 30 April 2009 - 11:12 AM

Can you please add tutorials on how to add forms to your database tables in access and oracle. :^:
Was This Post Helpful? 0
  • +
  • -

  • (3 Pages)
  • +
  • 1
  • 2
  • 3