Jump to content



Photo

any tutorials on sql?


  • Please log in to reply
14 replies to this topic

#1 +ultimate99

ultimate99

    Neowinian Senior

  • Joined: 20-August 02

Posted 16 November 2013 - 10:50

There are nice tutorials on youtube on java and c++ (thenewboston), does anyone know of any sql/sql server tutorials as good?

Maybe some other websites? I prefer free, but can look at others.

 

Thanks




#2 +LambdaLambdaLambdaFn

LambdaLambdaLambdaFn

    Neowinian

  • Joined: 13-November 13

Posted 17 November 2013 - 17:13

Are you looking for tutorials on how to write SQL or manage database servers? 



#3 OP +ultimate99

ultimate99

    Neowinian Senior

  • Joined: 20-August 02

Posted 17 November 2013 - 17:46

Are you looking for tutorials on how to write SQL or manage database servers? 

write SQL, i took an paid intro course, looking for something intermediate. Managing db servers would be great too.



#4 +LambdaLambdaLambdaFn

LambdaLambdaLambdaFn

    Neowinian

  • Joined: 13-November 13

Posted 17 November 2013 - 18:01

Putting the cart before the horse, I think.  Learn SQL first, then to be a DBA. 

 

If it's intermediate level SQL, there are gobs of tutorials online that you can find by typing "PL/SQL tutorial" into any search engine.  The canonical course would be Oracle University, and while not cheap is a good stepping stone to certification.  Personally, I wouldn't try to learn programming for a YouTube video -- I think you'll get better results with a book or online course, but maybe that's just me. 

 

You could go to a local college bookstore and buy the text book that the students are using and you'll get 90% of what you need from there.  HTH.



#5 OP +ultimate99

ultimate99

    Neowinian Senior

  • Joined: 20-August 02

Posted 17 November 2013 - 18:14

hmm...oracle. I thought learning general sql would be more flexible and easier than Oracle.



#6 +LambdaLambdaLambdaFn

LambdaLambdaLambdaFn

    Neowinian

  • Joined: 13-November 13

Posted 17 November 2013 - 18:23

The SQL use you at an intermediate level with Oracle will mostly be the same as any other database server.  You'll find some difference (eg, Oracle's "DECODE").  For the most part, though, I don't think you'll see much difference at the intermediate level.



#7 Enron

Enron

    Windows for Workgroups

  • Joined: 30-May 11
  • OS: Windows 8.1 U1
  • Phone: Nokia Lumia 900

Posted 17 November 2013 - 18:28

I never took a class or tutorial. Just learned SQL as I go with a handy reference guide as things come up in my job.

 

Probably not the best way to go about things, but it's not the most complicated thing in the world.



#8 Andre S.

Andre S.

    Asik

  • Tech Issues Solved: 6
  • Joined: 26-October 05

Posted 17 November 2013 - 19:09

http://www.w3schools.com/sql/ is a decent tutorial.



#9 OP +ultimate99

ultimate99

    Neowinian Senior

  • Joined: 20-August 02

Posted 17 November 2013 - 21:21

http://www.w3schools.com/sql/ is a decent tutorial.

 I used that site before, but would like something more robust. I suggested youtube because i like to watch an listen. When it comes to books I have no clue which book to study from and what makes one differ from the other?



#10 Hallmarsh435

Hallmarsh435

    Resident One Post Wonder

  • Joined: 18-November 13

Posted 18 November 2013 - 09:26

bestdotnettraining.com will provide best SQL server videos they covered all the topics in-depth in each video they provide materiial as well. 



#11 Andre S.

Andre S.

    Asik

  • Tech Issues Solved: 6
  • Joined: 26-October 05

Posted 18 November 2013 - 18:32

bestdotnettraining.com will provide best SQL server videos they covered all the topics in-depth in each video they provide materiial as well. 

That page is just a link to http://www.microsoft.com/web/ ...



#12 buchman

buchman

    Neowinian

  • Joined: 25-July 05

Posted 19 November 2013 - 16:17

This site should be useful, but it is MS SQL Only

http://www.mssqltips...utoriallist.asp



#13 OP +ultimate99

ultimate99

    Neowinian Senior

  • Joined: 20-August 02

Posted 30 November 2013 - 00:29

So from all these 4 books, which one would you recommend?

 

http://www.amazon.ca...&pf_rd_i=915398

 

www.amazon.ca/SQL-Cookbook-Anthony-Molinaro/dp/0596009763/ref=pd_sim_sbs_b_3

 

http://www.amazon.ca.../ref=pd_sim_b_4

 

http://www.amazon.ca...words=databases



#14 +LambdaLambdaLambdaFn

LambdaLambdaLambdaFn

    Neowinian

  • Joined: 13-November 13

Posted 30 November 2013 - 22:15

I haven't read any of them.  I don't like the SAMS books, so I'd steer clear (other mights have different opinions). 

 

So just looking at the description briefly and what I understand what you want, I'd say the first one plus http://www.amazon.ca...l in a nutshell

 

That last one you listed is about database design, which I don't get the impression is what you're after.T

 

Take this advice with BIG grain of salt.



#15 ArnavKumar

ArnavKumar

    Neowinian

  • Joined: 29-October 13

Posted 03 December 2013 - 12:45

I use this site for May be this link help you as you want

http://tkhts.com/sql/mysql/index.jsp





Click here to login or here to register to remove this ad, it's free!