Advanced MySQL tutorial

[AS]

Hi All,

I'm searching for suggestions about some MySQL tutorial, on line courses, books and advanced info in general.
Particularly in interested about C API, use of MySQL with Apache, database administration tasks.
Of course internet is plenty of resource, I would say too much, my difficult is about to identify some good and advanced tutorial.

Thanks in advance. Any suggestion will be greatly appreciated.

AS

[rubentje1991]

Following this thread.... I already used MySQL during programming several times, but that was "learn-during-practice"... 
We've had SQL at school last year (focused on PostgreSQL), with a book that focused both on MySQL and MSSQL (if I can remember correctly)...
If you're interested in that book (it also discuss API, etc...) - I'll lookup the ISBN

[AS]

Following this thread.... I already used MySQL during programming several times, but that was "learn-during-practice"... 
We've had SQL at school last year (focused on PostgreSQL), with a book that focused both on MySQL and MSSQL (if I can remember correctly)...
If you're interested in that book (it also discuss API, etc...) - I'll lookup the ISBN

Look like a good starting point. Title/Author should be enough, if not ISBN.

Thanks 

AS

[rubentje1991]

OK, false alert....
I got the book upstairs - and it's in Dutch   
(always the same, half of my study books are in English, other half in Dutch.... -- never can remember which books are in English)...
But I'll look through the info of that year, if the teachers has suggested another book (I only can say that this book is not a translation from English)...

But the author has also written books in English about SQL and/or MySQL:

Author: Rick F. Van Der Lans
Example of books of him here: http://www.goodreads.com/author/show/815976.Rick_F_van_der_Lans

My book in Dutch:
Title: "Het SQL Leerboek" (~ The SQL guidebook?)
ISBN: 90 395 2302 9
example site: http://www.comcol.nl/detail/57894.htm (this is the book I read, and it was very clear -- part IV was about programming with SQL: embedded SQL, transactions, multi-user, ODBC, ....)

I hope that the books in English are as good as the ones in Dutch -- then it's a good choice....

Maybe I'll send also some slides, if they're in English  (via pm)

[AS]

OK, false alert....
I got the book upstairs - and it's in Dutch   
(always the same, half of my study books are in English, other half in Dutch.... -- never can remember which books are in English)...
But I'll look through the info of that year, if the teachers has suggested another book (I only can say that this book is not a translation from English)...

But the author has also written books in English about SQL and/or MySQL:

Author: Rick F. Van Der Lans
Example of books of him here: http://www.goodreads.com/author/show/815976.Rick_F_van_der_Lans

Thanks!

My book in Dutch:
Title: "Het SQL Leerboek" (~ The SQL guidebook?)
ISBN: 90 395 2302 9
example site: http://www.comcol.nl/detail/57894.htm (this is the book I read, and it was very clear -- part IV was about programming with SQL: embedded SQL, transactions, multi-user, ODBC, ....)

  nope, no Dutch here! 

I hope that the books in English are as good as the ones in Dutch -- then it's a good choice....

Yes, usually it' so unless of bad translation ...

Maybe I'll send also some slides, if they're in English  (via pm)

Anything related is welcome! 

AS

[rubentje1991]

OK, the teacher made the slides in Dutch 
(however, full of English expressions  )...
But too much Dutch to be comprehended by English people

If I find something, I'll still let you know 

[AS]

OK, the teacher made the slides in Dutch 
(however, full of English expressions  )...
But too much Dutch to be comprehended by English people

If I find something, I'll still let you know 

Thank you! Greatly appreciated.

AS

[Mike]

Would this help any 

http://www.tutorialpdf.com/Database/MySQL-Database/Advanced-MySQL-Optimization-Tutorial.html

[AS]

Would this help any 

http://www.tutorialpdf.com/Database/MySQL-Database/Advanced-MySQL-Optimization-Tutorial.html

Thank you, I think I will leave this as a further steep, right now I need to start from something a little more ... didactic... 
I remember that I saw a documentation section on mysql.com website a few years ago... don't seem I can find it right now that mysql is in Oracle hands. 

Fortunately I found these (I think they are a replica of the original documentation) :
http://mariadb.org/en/docs/
http://kb.askmonty.org/en/
http://kb.askmonty.org/en/recommended-mariadb-mysql-books

Thank you, appreciate your help. 

AS

[Mike]

You're very welcome, I am trying....