Learning CRUD operations is essential for learning MySQL. Compare the performance cost of different query types. Also learn about the dangers of unrestricted queries in MySQL, and the possibility of data loss even from well-meaning users.
- [Instructor] Despite having to design Python scripts…to capture performance data,…this challenge turned out to be fairly straightforward.…None of the SQL queries was very difficult,…and the data sets were small.…Some of the tasks were a bit esoteric,…but not in a way that presented any serious difficulty…in terms of query design.…Even so, I was able to show a few new tricks.…The replace function is useful for finding text…that needs replacing,…just as the in string function was useful for…matching text without needing the use…of wildcard characters.…We were also able to see the relative performance costs…of each type of operation.…Although those queries didn't take long,…you can easily imagine how those milliseconds would add up…over millions of rows.…
Now that you've seen all the CRUD operations,…I feel like it's important to note something.…You saw how easy it is to make changes to the table values.…Those changes are almost never reversible.…MySQL has no undo function.…It's entirely possible to destroy entire databases…
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Appropriate for all
1. Data and MySQL in under Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
Searching a database1m 51s
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Next steps1m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.