Database Clinic: MySQL
MP4 | Video: 720p | Duration: 1:59:06 | English | Subtitles: VTT | 373.5 MB
MP4 | Video: 720p | Duration: 1:59:06 | English | Subtitles: VTT | 373.5 MB
The Database Clinic series pits experts and their databases of choice against a series of the same challenges, to highlight the unique capabilities of each database. In this installment of the series, Brad Wheeler demonstrates how MySQL—one of the most widely-used database programs—would rise to meet each task. After going over the strengths and weaknesses of MySQL, Brad shows how to create a database, and quickly load data into MySQL. He also explains how to join data sets; how to search, transform, and perform calculations with your data; and how to use external programming tools to interact with MySQL.
Topics include:
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations