MySQL is derived directly from Structured Query Language (SQL), which is a query language for databases that exploit the relational model. It uses the syntax but does not retain all the power since many features of SQL do not appear in MySQL (nested selections, foreign keys ...)
The MySQL database server is very often used with the language of creating dynamic web pages: PHP. It will be discussed here MySQL commands usable via PHP in the typical conditions of use in the context of the management of a personal site hosted free (for example on Free.fr).
This course (105 slides) will allow you to master the MySQL syntax and understand all the features. You will also have knowledge of PHP functions to make the best use of your database within your pages.
You have a lot of data to process and you want to organize it correctly, with a suitable tool? The databases have been created for you!
And especially MySQL, which is a Relational Database Management System (abbreviated RDBMS). That is to say a software that can manage databases, and therefore manage large amounts of information. It uses for this the language SQL. It is one of the most known and used RDBMS (Wikipedia and Adobe use for example MySQL).
MySQL can be used alone, but is mostly combined with another programming language: PHP for example for many websites, but also Java, Python, C ++, and many, many others.
To give you an idea of how to use MySQL, imagine that your animal breeder is asking you for a simple software to manage his critters. You know how to program in python and agree to help him in the hope of having a top gift for Christmas. A database will help you to remember that Poupouche the Poodle was born December 13, 2007, Sami the Persian has white hairs and Igor the turtle is the last representative of a super rare breed!
The design and use of databases is a broad topic, this course will address the basics needed to manage a simple database, namely:
| Learning MySQL | |
| Description : | Download free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL. |
| Submitted On : | 2019-04-21 |
| File type : | |
| Downloads : | 3878 |
| MySQL tutorial for professionals | |
| Description : | Download free MySQL tutorial course in PDF, training file in 70 chapters and 199 pages. Free unaffiliated ebook created from Stack OverFlow contributor. |
| Submitted On : | 2019-04-30 |
| File type : | |
| Downloads : | 2807 |
| Essential MySQL | |
| Description : | This book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it. |
| Submitted On : | 2020-08-29 |
| File type : | |
| Downloads : | 414 |
| MySQL Notes for Professionals | |
| Description : | MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this MySQL Notes for Professionals is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch. |
| Submitted On : | 2020-08-29 |
| File type : | |
| Downloads : | 242 |
| MySQL – Create Database free PDF | |
| Description : | Download free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com. |
| Submitted On : | 2022-07-01 |
| File type : | |
| Downloads : | 340 |