☕️ Buy me a coffee: https://paypal.me/donationlink240
🙏🏻 Support me on Patreon: https://www.patreon.com/c/ahmadbazzi
I was curious to see if Redis is capable of supporting advanced queries like we do in SQL databases such as aggregations, where clause, etc. It did not disappoint. In this video, I’ll go over 10 different queries and show you how you can use it in your own Redis project. I’m using the Redis OM Python SDK, Redis Insight GUI tool, the RediSearch module and Python to perform these queries.
Redis OM SDK (Python)
Redis Insight Desktop GUI
Redis Cloud (Sign up and get $200 credit, plus a chance to win a Telsa)
Redis Launchpad (Contains 100s of Redis examples)
Developer Hub (Start here)
Scripts – https://github.com/therealbazzi/EmployeeDB
📚📚About
In this dense tutorial, I explain how to use advanced redisearch querying functionalities using python for full text searching, indexing, querying, tag searches, geo localization, aggregation, grouping, filtering and much more. The tutorial also shows you how to connect to redis cloud as well as localhost. The code is oriented towards an employee management backend – but is pretty generic in a sense that you could re-use the code for your beautiful app that you’re trying to develop and sell.
⏲⏲Outline
00:00 Introduction
00:49 Redis Cloud Registration + Tesla giveaway participation
01:24 Preparing our localhost
02:08 Docker Container
04:32 venv configuration for virtual environment
07:07 RedisInsight Configuration (optional)
08:07 Database employee records
09:05 Employee HashModel
10:38 Employee JSONModel
12:03 Upload Employees (localhost way)
14:31 Upload to Redis Cloud (redis cloud way)
16:12 SEARCH BY first name
18:35 RediSearch Client
23:48 Wildcard searches
25:06 SEARCH by first name and last name
25:52 SORT BY Salary (Ascending)
26:53 SORT BY Salary (Descending)
27:38 Aggregate reducers
28:37 Aggregate alias
30:04 Aggregate limit
30:49 GROUP BY department
32:21 GROUP BY department only those who are admins
33:51 GROUP BY salary
35:12 Count number of employees w/ salary greater than 75K USD
37:48 SEARCH BY tags ( single tag )
41:09 SEARCH BY tags ( multiple tags )
42:05 SEARCH BY GEOLOCATION
45:10 Outro
User Management app w/ Nodejs x Redis – https://youtu.be/1_8Er3sgQ1I
📚📚 MY FREE ONLINE COURSES: 📚📚 OTHER RECOMMENDED COURSES WHO AM I: 🌍 My website / lecture notes – http://bazziahmad.com/
GET IN TOUCH: #database #tutorial #programming
📚 Convex Optimization Course – https://youtube.com/playlist?list=PL-DDW8QIRjNOVxrU2efygBw0xADVOgpmw
🤖 Machine Learning Course- https://youtube.com/playlist?list=PL-DDW8QIRjNMQavfdmZYh8S2smrKfqAba
CREDITS x MENTIONS:
Redis – https://redis.io/
Redis Cloud – https://redis.com/redis-enterprise-cloud/overview/
RediSearch – https://github.com/RediSearch/RediSearch
RedisJSON – https://oss.redis.com/redisjson/
Redis-om – https://github.com/redis/redis-om-python
RedisInsight – https://redis.com/redis-enterprise/redis-insight/
Python – https://www.python.org/
Tesla – https://www.tesla.com/
Docker – https://www.docker.com/
VSCode – https://code.visualstudio.com/
👩🏽💻 MATLAB Course – https://www.youtube.com/playlist?list=PL-DDW8QIRjNOaKOV5SR3_0yp-A2bYBePY
BE MY FRIEND:
📸 Instagram – https://www.instagram.com/drahmadbazzi/
ⓕ Facebook – https://www.facebook.com/drahmadbazzi/
🐦 Twitter – https://twitter.com/drahmadbazzi
I am an Electrical Engineer and YouTuber w/ a PhD in Electrical Engineering from @EURECOM Communication Systems Department , Sophia Antipolis in France. I am also a EURECOM alumni, w/ a Masters studies from @CentraleSupélec(Summa Cum Laude). I have many publications in well-known @IEEEorg conferences, including a nomination award and is a co-inventor in several patents. I am also a former student member of @IEEE Signal Processing Society . I also dedicate time to publish high level lectures on Mathematics (including convex optimization) and Programming. I also focus on Math for Machine Learning, Convex Optimization, Linear Algebra, Python, SymPy, NumPy, Pandas, CVXOPT, MATLAB, and more.
I try my best to respond to each and every comment here on YouTube, you guys are my family ❤️
