|
Setup |
Download files required for the lesson |
00:00 |
1. Introduction
|
What is a database management system and why it is a good idea to use one?
What are the differences between relational and non-relational databases?
|
01:30 |
2. MySQL Basics
|
What are the core SQL commands you need to know to interact with a MySQL database?
How do you create, update, and delete records in a MySQL database?
|
01:30 |
3. 03 Break
|
|
01:30 |
4. SQLAlchemy and MySQL: Exercises
|
How to perform CRUD operations using SQLAlchemy?
How to query and filter records in SQLAlchemy?
|
01:41 |
5. A bit more on queries
|
How to perform SQL Join?
How to make use of different SQL joins?
|
03:11 |
6. Conditions Database Example Using SQLAlchemy
|
|
03:11 |
7. 07 Break
|
|
03:11 |
8. SQLite
|
What is SQLite?
How do I create an SQLite database?
|
04:41 |
9. Intro to NoSQL and Opensearch Queries
|
What is NoSQL database and Opensearch?
How to perform indexing in Opensearch?
How to query and filter records in opensearch?
|
04:47 |
10. Opensearch Text Based Queries
|
How to perform text based search in opensearch?
What are the ways to do text based search in opensearch?
|
04:49 |
Finish |
|
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.