Cursos relacionados
640 € 320 €
830 € 415 €
900 € 450 €
100 €
These days everything uses a database, and MySQL is one of the most popular databases out there. FREE and Open Source, Mysql is a great database for just about all your needs.
Likewise, Python is one of the most popular and powerful programming languages today. Pairing the two together is a powerful combination!
Emagister S.L. (responsable) tratará tus datos personales con la finalidad de gestionar el envío de solicitudes de información y comunicaciones promocionales de formación con tu consentimiento. Ejerce tus derechos de acceso, supresión, rectificación, limitación, portabilidad y otros, según se indica en nuestra política de privacidad.
Objetivos
Understand how to use MySQL Databases With Python ,understand the basics of what a Database can do Install Python, MySQL, Git Bash, and MySQL Connector You\'ll Learn How To Create a Database and Table How to put data in and take data out using Python ,how to update and delete data from the database How to explore what\'s in the database whenever you want, how to create basic reports with the data from your database
Temario completo de este curso
- Using mysql databases with python
- Introduction
- What is a database
- Install python
- Install git bash terminal
- Install mysql and workbench
- Install mysql connector
- Connect to database in python
- Explore mysql workbench
- Create a database
- Create a table
- Insert one record into table
- Insert many records into table
- Understanding data types
- Select data from table
- Format our results
- The where clause
- The like clause and wildcards
- Using and and or
- Limit and ordering
- records
- Delete (drop) a table and backups
- Conclusion
197 €
280 €
+ IVA