The best part about creating YouTube videos?
It's not just the views, likes, money, or reachโฆ
Itโs the comments from people whose learning journey youโve impacted. โค๏ธ
My recent video "PAN Card Validation in SQL" has received an incredible wave of appreciation. I knew the video was good even before I posted it, but I did not expect so much love from all of you.
SQL projects like this are rare on YouTube, and that's probably why people have loved it so much.
If you havenโt seen it yet, hereโs your chance ๐
https://youtu.be/J1vlhH5LFY8?si=TS4No...
P.S. The image below showcases some of the amazing comments
101 - 2
๐ข Last Call!
Tomorrow (Aug 9), we kick off the final live SQL & Python Bootcamps of 2025! ๐
Want to learn real-world SQL and Python in a fun, interactive, and beginner-friendly way?
This is your chance!
๐ก What youโll get:
โ
Live classes with real-time Q&A
โ
Practical exercises & projects
โ
SQL for interviews & Python from scratch
๐ Choose your track and join now:
SQL Bootcamp ๐ bootcamp.techtfq.com/course/sql-interview-prep-booโฆ
Python Bootcamp ๐ bootcamp.techtfq.com/course/python-bootcamp-for-beโฆ
๐ฏ Perfect for: Beginners, Analysts, Data Enthusiasts, Career Switchers
Letโs make learning fun โ just like in the image below! ๐
#sql #python #bootcamp #liveclasses #sqlcourse #pythoncourse #learncoding
39 - 2
DO NOT miss today's YouTube video, it's pretty special! We shall be working on an SQL project that involves data cleaning, data validation, and more.
It's a PAN Number validation project that uses SQL, but the same can be done more easily using Python. The Python version of this project will be posted next week.
Let me know if you watched the video, or if you plan to watch it soon, and your thoughts about this project.
Happy learning!
https://www.youtube.com/watch?v=J1vlh...
#SQL #SQLProject #DataCleaning #DataValidation #DataAnalytics #DataEngineering
watch video on watch page
111 - 6
SQL Quiz time!
You are given a table named "computers" in a PostgreSQL database, which has four records as shown below:
+-----------+-------------+
| BRAND | PRODUCTS |
+-----------+-------------+
| Apple | MacBook Pro |
| Dell | XPS |
| Apple | MacBook Air |
| Lenovo | ThikPad |
+-----------+-------------+
Guess the output of the below query?
SELECT
COUNT(*) AS Total_Computers,
COUNT(*) FILTER(WHERE brand = 'Apple') AS Total_Apple_Computers,
COUNT(*) FILTER(WHERE brand = 'Dell') AS Total_Dell_Computers
FROM computers;
32 - 3
Update on my upcoming all-in-one SQL learning platform - SQLNest
(Sharing our brand-new logo! ๐)
The platform is nearly ready for a beta launch; we could go live today.
But I'm holding off just a little longer to finish developing a special feature that will add tremendous value for anyone learning #SQL.
We're aiming for an August beta launch, and I couldn't be more excited for you all to try it out!
There's a lot happening behind the scenes, and we're working hard to ensure that SQLNest truly makes your SQL learning journey smooth, practical, and enjoyable.
P.S. What do you think of the SQLNest logo? Drop your thoughts in the comments!
187 - 28
SQL Quiz time!
Imagine the PRODUCTS table has three records (non-null values only).
Could you look at the two queries below and guess the no of records they returned?
Q1)
SELECT COUNT(product_name)
FROM products
GROUP BY ROLLUP (product_name);
Q2)
SELECT COUNT(product_name)
FROM products
GROUP BY CUBE (product_name);
If you are unaware of ROLLUP and CUBE concepts in SQL, check out this ๐ video.
https://youtu.be/Ccye_H34hBo?si=dRCgH...
27 - 2
Just launched a new YouTube tutorial ๐ on one of the most underused #SQL techniques - Grouping Sets, Rollup & Cube
These advanced extensions to Group by clause can simplify your reporting logic, reduce repetitive code, and improve efficiency of your code.
watch video on watch page
42 - 1
Are you ready for a quick SQL challenge?
Can you explain what the data type VARCHAR(50)[] means in PostgreSQL?
34 - 3
The one thing that gives me the most joy in my professional career is when I publish a video on YouTube.
It doesn't matter its performance; just the feeling of completing something and releasing it gives me immense satisfaction and pleasure.
But it's been a struggle to post videos on YouTube.
Something is stopping me from prioritizing YouTube, and I've been trying to sort this out for over a year now.
As a small step towards fixing this, I just posted a simple video today explaining the Lateral keyword in SQL.
Hope you guys find it useful.
Link below:
https://youtu.be/NiiN63lEzvI?si=i9Qf7...
P.S. The image is of my new video shoot setup ๐
111 - 7
What is the output from the #SQL query below in PostgreSQL?
SELECT *
FROM (
VALUES
(1,'Python & SQL'),
(2,'Bootcamp'),
(3,'Starts'),
(4,'SOON')
) AS users(ID, NAME)
WHERE name ~ '&';
24 - 0
Hi, I am Thoufiq! On this channel, I teach SQL, Python and Database concepts in the field of Data Analytics and Data Science in the most simplest manner possible. If this excites you then do consider subscribing.
You will also find videos covering interview questions and also videos where I provide career guidance in the field of Data Analytics and Data Science which should help you find your dream job.
I aim to make techTFQ a go to YouTube channel for anyone learning SQL, Python and Databases in the field of Data Analytics and Data Science.
Thank you for begin here :)