
Explore basic to advanced SQL with MySQL, PHP, and Python through practical projects and hands-on exercises. Learn to create, insert, select, and join operations, plus basic and advanced Python elements.
Explore the basics of MySQL queries by learning the select, insert, update, and delete actions, their location and restrictions via where clauses and operators like equals, greater-than, and like.
Compare csv, myisam, memory, and innodb storage engines and their trade-offs for queries, updates, and data integrity. Learn to change engines in phpmyadmin and workbench to fit your needs.
Order results with order by, asc or desc, and sort by date and product ids, then apply arithmetic and string functions like concat and substring.
Master the basics of PHP by declaring variables with a dollar sign, using concatenation to join strings, and outputting results to a web page.
Explore conditional statements in PHP advanced: if, else, and else-if, with operators like equals and greater-than-or-equal-to, and foreach to process arrays and share database information in a user interface.
Connect to a MySQL server from Python, create a database and tables, define fields and a primary key, and fetch results to verify the structure.
Explore SQLite features such as being free and open source, serverless, cross-platform, with no setup or administration, variable length columns, and extensive language APIs across many platforms.
=== Our students' reviews regarding this course ===
"it's good that the course focuses more on the application part rather than just giving some bookish theories or concepts which anyone can read for the plenty of textbooks." -- Deepanshu Kumar
"Very clear and straight forward." -- Chakri Muthyala
"really very explanatory and easy to understand" -- Sekh
"simply the best" -- Frederick Ekow
"Very Informative Course. Thank You" -- Subrata Debnath
"So far so good. The installation has a detailed guide every step of the way. This should be a benchmark for any other tutorials during the installation process of the software." -- Emilio Comiling
"Well based step-by-step information that is clearly understandable" -- Volodymyr Gorbachov
The programming language PHP is one of the most popular scripting languages. It is free, open-source, and server-side (the code is executed on the server). And MySQL is another one of the most popular Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). The combination of PHP and MySQL gives amazing and cool options to create amazing websites, APIs, web portals, and more.
By completing this course, you will be able to read and write basic and complex SQL queries using MySQL. This course gives you hands-on and practical experience on the world's most popular RDBMS databases like MySQL. These skills are also applicable to any other RDMBS databases (Like Oracle, MS SQL Server, SQLite, etc). You will do several practical projects with MySQL, PHP & Python.
Learning both SQL is one of the fastest ways to improve your career. Hope this course will be used as a helping hand for your prospective career. Please dig on free preview videos for more information.