Join Brad Wheeler for an in-depth discussion in this video Database creation, part of Database Clinic: MySQL.
- Alright, it's time for our first challenge.…Lao Tzu said it best,…"The journey of a thousand miles begins with one step."…The first step in our journey is creating a database.…Databases store a combination…of specifically formatted…information and open ended information.…Different database tools store…that information in unique ways.…Flat files use a table,…SQL databases use a relational model.…And NoSQL databases use a key value model.…
Regardless of how they store that data,…many tools are optimized so that if the database…knows that a certain piece…of information will always be in a specific format.…For example, a date, an amount of money,…or a geographical location,…it can treat that information more efficiently.…An important part of creating a database is understanding…the kinds of data that you need to store.…Once your database is set up…and knows what information to expect,…it's time to add that information in.…
Databases are populated in several different ways.…They can be populated by hand, for example,…
- 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.