ANA420

Examine Relational Databases and Connecting with Python

Basic CRUD Operations in Python with Relational Databases

1. Go to W3schools to access Python MySQL.
2. Using the navigation panel on the left-hand side, scroll down to Python MySQL.
3. Review the following: 
   • MySQL Get Started
   • MySQL Create Database
   • MySQL Create Table
   • MySQL Insert
   • MySQL Select
   • MySQL Where
   • MySQL Order By
   • MySQL Delete
   • MySQL Drop Table
   • MySQL Update
   • MySQL Limit
   • MySQL Join

LinkedIn Learning