SQL Basics Tutorial for Beginners (Practice SQL Queries)

  Рет қаралды 1,179,044

techTFQ

techTFQ

Күн бұрын

SQL Basics Tutorial for Beginners is made to help you learn SQL the right way.
Video also includes Practice SQL Queries which can be downloaded from my blog (link mentioned below).
This is a complete SQL Tutorial covering all the SQL Basics including how to write simple SQL Queries. This Basic SQL Tutorial is aimed at beginners who are new to SQL programming language or are just exploring an easy programming language to get started.
This SQL Tutorial for Beginners not only explains the concept of SQL but also go through all the different types of queries that can be written using the basic SQL concepts.
Timestamps:
00:00 Intro
01:42 What is SQL
03:14 Different types of SQL Commands
03:36 What is Data Definition Language (DDL)
04:46 What is Data Type in SQL
06:11 What are Constraints in SQL
08:33 What is Data Manipulation Language (DML)
09:40 Practice SQL Commands (DDL, DML)
21:10 What is Data Query Language (DQL)
23:13 Practice simple SQL Queries
25:18 Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators)
34:48 Case Statement in SQL
36:15 Different ways to write queries in SQL
42:30 UNION and UNION ALL Operators in SQL
47:18 GROUP BY Statement in SQL
56:10 Sub Queries in SQL
58:55 Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM)
01:01:56 SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join)
At 70 minutes this video tries to cover all of the Basic SQL concepts and SQL Queries which are required to get started with SQL.
We cover the following:
1. Introduction to SQL
• Why is it important to learn SQL.
2. What is SQL?
3. SQL Commands
• DDL (Data Definition Language)
i. CREATE Table
ii. ALTER Table
iii. DROP Table
iv. TRUNCATE Table
• DML (Data Manipulation Language)
i. INSERT
ii. UPDATE
iii. DELETE
• DCL (Data Control Language)
i. GRANT
ii. REVOKE
• TCL (Transaction Control Language)
i. COMMIT
ii. ROLLBACK
iii. SAVEPOINT
• DQL (Data Query Language)
i. SELECT
4. Different SELECT Query functionalities:
• SQL Operators
i. Logical Operators
ii. Comparison Operators
iii. Arithmetic Operators
• CASE Statement
• Two ways of writing SQL Queries
i. Using comma separator
ii. Using JOIN
• UNION & UNION ALL Operators
• GROUP BY Statement
i. HAVING Clause
• Subquery
• Aggregate Functions
i. COUNT
ii. AVG
iii. MIN
iv. MAX
v. SUM
• SQL JOINS
i. INNER JOIN
ii. OUTER JOIN
1. LEFT OUTER JOIN
2. RIGHT OUTER JOIN
3. FULL OUTER JOIN
In this video, I am using PostgreSQL to practice and execute the SQL commands and SQL Queries. However the SQL syntax and SQL concepts are applicable to any other Relational Database or RDBMS (Relational Database Management System).
Download Link:
Download the SQL Scripts (DDL, DML and all SELECT Queries) from here:
techtfq.com/blog/sql-basics-t...
From this link click on:
1) “Download DDL & DML” button to download a “.sql” file which has all the Create table and Insert Table scripts to create required tables and to insert meaningful data into it.
2) “Download SELECT Queries” button to download another “.sql” file which contains all the SELECT Queries which we practiced in this video.
My Blog:
techtfq.com
Where you can find useful blog related to SQL, Database and many more in near future.
Reference Links:
If you wish to know more about SQL then I suggest going through the below links:
PostgreSQL All supported Data Types:
www.postgresql.org/docs/9.5/d...
PostgreSQL Tutorial blog:
www.postgresqltutorial.com/
SQL Tutorial blog:
www.w3schools.com/sql/default...
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training

Пікірлер: 711
@techTFQ
@techTFQ 3 жыл бұрын
Since it's a long video, I am adding the timestamp to each of the sections covered in this video so you can skip and watch only the sections, you are interested in. A BIG THANK YOU to each and everyone one of you for appreciating this video!!! Timestamps: 00:00​ Intro 01:42​ What is SQL 03:14​ Different types of SQL Commands 03:36​ What is Data Definition Language (DDL) 04:46​ What is Data Type in SQL 06:11​ What are Constraints in SQL 08:33​ What is Data Manipulation Language (DML) 09:40​ Practice SQL Commands (DDL, DML) 21:10​ What is Data Query Language (DQL) 23:13​ Practice simple SQL Queries 25:18​ Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators) 34:48​ Case Statement in SQL 36:15​ Different ways to write queries in SQL 42:30​ UNION and UNION ALL Operators in SQL 47:18​ GROUP BY Statement in SQL 56:10​ Sub Queries in SQL 58:55​ Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM) 01:01:56​ SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join)
@anishabanerjee379
@anishabanerjee379 2 жыл бұрын
Ha you missed an as before c3 in query 1 and query2 at 22:17 minute
@skarthikasakthi560
@skarthikasakthi560 2 жыл бұрын
Nice explanation and your voice
@supriyagaddam7857
@supriyagaddam7857 Жыл бұрын
Tried to contact you, regarding sql classes
@ashukumar-wh3qb
@ashukumar-wh3qb Жыл бұрын
​ @techTFQ @36:21 in case statement what is order by 2 desc; what is 2 here ??
@randeeppidichetty1754
@randeeppidichetty1754 Жыл бұрын
Sir can you pls change the theme of application. My request
@sonamkumar059
@sonamkumar059 Жыл бұрын
For the past 3 days, I have been trying to learn the basics of SQL from different channels. This video is, so far, the best in explanation. I love the fact that you make SQL sound so simple and easy to understand. I would definitely recommend you to other people who want to go into the data analytics business. Thank you so much.
@iReaperYo
@iReaperYo 9 ай бұрын
This video is absolutely brilliant. 1 hour to learn what I've been struggling with for months! This was vital in understanding the bigger picture. I am so grateful.
@aleskerovw
@aleskerovw 3 жыл бұрын
I don't understand why this video has so small number of views and likes... The video is very informative, thank you very much!
@techTFQ
@techTFQ 3 жыл бұрын
Thank you so much! Glad that you found it useful...
@abdulreeves2742
@abdulreeves2742 3 жыл бұрын
Share it with your friends and people who u think it might be helpful....and don't forget to tell then to like and share😉😉
@techTFQ
@techTFQ 3 жыл бұрын
Thanks a lot Reeves for your kind words 🙏🏼☺️
@techTFQ
@techTFQ 3 жыл бұрын
Thank you Veena 🙏🏼🙏🏼☺️
@praveen4892ify
@praveen4892ify 3 жыл бұрын
Exactly the video is to the point and made with perfection
@aaronschwartzman2926
@aaronschwartzman2926 2 жыл бұрын
Incredible content! You explain SQL very well. Never thought I’d learn SQL in an hour and 10 minutes. Thank you!
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Aaron I am glad this helped
@gerrielegue1095
@gerrielegue1095 Жыл бұрын
Today I took basic SQL lessons. A very good and clear explanation. Thank you for setting up the lessons professionally. I am already looking forward to the next lessons. I wish you and your family a healthy 2023
@vshal3880
@vshal3880 23 күн бұрын
Bro, i have to admit you are the best SQL teacher of the KZfaq even better than my offline faculty. Thank You very much man.
@hemantgoyal6651
@hemantgoyal6651 Жыл бұрын
Hands down one of the best SQL tutorials I've seen on the Internet! Perfectly planned and executed!
@jamesorior
@jamesorior Жыл бұрын
Chat GPT is replacing Database Professionals
@sudarshanmhaisdhune1039
@sudarshanmhaisdhune1039 Жыл бұрын
@@jamesorior chatGPT site is down bro! Go & get some coffee......
@shubhamshanker2947
@shubhamshanker2947 2 жыл бұрын
Amazing video in 1 hour you will understand all the basics concepts of SQL. Otherwise rest of the videos are 3 to 4 hours long. Thank you so much for the amazing and informative content
@payalsingh9917
@payalsingh9917 26 күн бұрын
Thanks, I am giving interviews ri8 now and its so helpful to clear all doubt in less time. I love the fact that you make SQL sound so simple and easy to understand. I would definitely recommend you to other people who want to go into the data analytics business. Thank you so much.
@subramanianramasamy6524
@subramanianramasamy6524 2 жыл бұрын
One of the best SQL Fundamental video I have seen!! You have really co ordinated every thing you can cover!! Well Done Mate!
@samratdey6564
@samratdey6564 2 жыл бұрын
Excellent! You are doing a great job dude. Hats off to your dedication and expertise. Wish our schools and colleges could atleast deliver 1% of what you are doing.
@tekndesign5721
@tekndesign5721 Жыл бұрын
You are a legend man! This is one of the best SQL tutorials out there. And the provided downloadable SQL Scripts just made it the best ever! The plain english language reference in front of each SQL queries, just gave me a goosebumps. A massive thank you, just what I've been looking for as SQL beginner.
@techTFQ
@techTFQ Жыл бұрын
Thank you so much buddy. very glad you liked it
@sivaramakrishnachilukuri3093
@sivaramakrishnachilukuri3093 Жыл бұрын
can you please share that SQL scripts I will download it.
@terihandrick2333
@terihandrick2333 5 ай бұрын
Wow I am glad I found your channel. You have an excellent teaching ability! Clear and concise and you have presented content I have not seen elsewhere laying the groundwork for SQL. Great job!!
@peterwan1808
@peterwan1808 Жыл бұрын
This guide was extremely informative, clear, and well organized; thank you for this video! Wish you were a professor at my college!
@praveenkumar-nm9lv
@praveenkumar-nm9lv Жыл бұрын
This video is the most useful video among other videos on KZfaq for SQL. Great way of presenting things. Please make more such important videos on SQL and databases. please share the tables link with Answers for Practice with the help of your content
@rufaiabiodun4334
@rufaiabiodun4334 2 жыл бұрын
Great course for the beginners. Much appreciated! Thank you so much.
@sheebaparveen3630
@sheebaparveen3630 3 жыл бұрын
Absolutely amazing video. Have watched so many videos on SQL but never such video like this where the required concepts are brilliantly explained without any dragging and just to the point. Perfect video for people who want to learn SQL in just little time. Great job. Loved this. Looking forward for more such videos.
@techTFQ
@techTFQ 3 жыл бұрын
Thank you very much Sheeba.. So glad you liked it and found it useful.. ☺️
@dataengineerazure2983
@dataengineerazure2983 Жыл бұрын
​@@techTFQ, How can I have the source data such as CSV files to follow with you, the SQL course? Thank you very much in advance,
@yeasinarafat9074
@yeasinarafat9074 Ай бұрын
One of the best tutorials in SQL on KZfaq. Thanks a lot for your contribution ❤
@ushalandesahoo1794
@ushalandesahoo1794 2 жыл бұрын
Recently I switched from BA to DA role and your SQL videos are very useful. I have watched many videos but your way of explanation is easy to understand.
@techTFQ
@techTFQ 2 жыл бұрын
Very happy to read this :) thank you
@bradboxrud9641
@bradboxrud9641 11 ай бұрын
Great job on this video. I'm learning a TON. Maybe 2 tons. Thanks, Thoufiq!
@anilkumarpasumarthi2200
@anilkumarpasumarthi2200 4 ай бұрын
You have put things in an easy way and more practical. Great way of explanation, I thoroughly enjoyed the session.
@tombsmaker
@tombsmaker 11 ай бұрын
# Timestamps 3:40 DDL 3:59, 4:19 create 4:02 alter 4:08 drop 4:12 truncate 9:48 datatype 5:16 varchar 5:29 Int 5:36 date 5:45 float 5:54 boolean 6:06 sample data type 6:12 constraints 6:34 check constraints 6:54 not null constraints 7:01 unique constraint 7:21 primary key 7:43 foreign key 8:10 drop 8:17 alter 8:34 DML 8:43 insert 9:03 update 9:22 delete 9:42 DDL & DML operations practical 9:44 create table 9:52 datatype 9:56 varchar 10:17 not null 10:24 check constraint 10:39 primary key 10:42 foreign key 11:02 select address, school, staff 11:33 insert 12:00 check constraint insertion error 12:30 primary key constraint error 13:00 not null constraint error 13:27 foreign key constraint error 14:34 Drop table 14:56 After command (datatype, rename table, rename column, 16:58 add constraints alter 17:36 DML 17:48 2 different insert syntax style 18:30 multiple records insertion 18:58 update 20:18 delete 21:10 DAL 21:13 Select 24:40 fetch all records 25:10 fetch particular columns 25:50 where =!-comparison 26:33
@onyxnatural1797
@onyxnatural1797 10 ай бұрын
Beautiful! You've really helped my learning path on Data Analysis. Thank you. Moreover,if the video can be enlarged that will help more as they're very tiny.
@lifeisagame9224
@lifeisagame9224 Жыл бұрын
Sir, you are a legend. The way you explain is mind blowing. Hats off to you !! Keep up the good work.
@mohammedshahil4898
@mohammedshahil4898 3 жыл бұрын
Loved it 👍🏻👌🏻 Best SQL video for beginners and for people who want to strengthen their base in SQL. Good Job👏🏻👏🏻 Waiting for more videos explaining SQL in depth🤞🏻
@techTFQ
@techTFQ 3 жыл бұрын
Thank you Shahil ☺️
@ignacioa3698
@ignacioa3698 Жыл бұрын
Great stuff!!!!!! I know you have other videos which shows more detailed explanations and logic on the different JOINS. HOWEVER, in showing your JOINS examples in this video best to show the original tables (along with the table original columns) somewhere else in the screen off to the side so it's better to follow along, actually we can see table and columns names of the tables, and try to visualize it. And makes it better to follow along and actually try to replicate the exercises as well.
@BenDieselBasicAutomotive
@BenDieselBasicAutomotive Жыл бұрын
This is very comprehensive.... yet simplified topic.... Thank you... Sir...
@rakeshbabumulugu7517
@rakeshbabumulugu7517 2 жыл бұрын
You have put things in an easy way and more practical. Great way of explanation, I thoroughly enjoyed the session. 💯👌🏻
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Rakesh 🙏 Glad you liked it..
@Ji-yoon
@Ji-yoon 2 жыл бұрын
This video is the most useful video among other videos on KZfaq for SQL. Great way of presenting things. Please make more such important videos on SQL and databases.
@techTFQ
@techTFQ 2 жыл бұрын
Thank you and will do 🙏🏼
@pritamsarkar3371
@pritamsarkar3371 3 жыл бұрын
best brief sql vid in youtube till now
@techTFQ
@techTFQ 3 жыл бұрын
Thank you very much ☺️
@P_satheesh99
@P_satheesh99 7 ай бұрын
Well curated, Definitely people will understand all the concepts without any doubt as you explained with examples in this video ❤
@injera-powered
@injera-powered 6 ай бұрын
You are the GOAT of explanation my friend thank you!
@fathimafarahna2633
@fathimafarahna2633 3 жыл бұрын
Video though long, you've made it very interesting. Explaining very eloquently without jargons & gobbledygook. Great job... Your efforts have translated into easy understanding. Keep going👍Thank you
@techTFQ
@techTFQ 3 жыл бұрын
Thank you very much...
@rangabashiammanavazhagan6691
@rangabashiammanavazhagan6691 Жыл бұрын
Hi Thoufiq, Your explanations are simply superb. Your way of teaching is encouraging me to learn more. Please keep continue your work. Thank you.
@darreljohnmanlugon6123
@darreljohnmanlugon6123 13 күн бұрын
This video helped me land a job.
@drashar841
@drashar841 Жыл бұрын
Your kind of teaching is good for people who are coming from computer background and are intermediate not for beginners. I expected step by step tutorial , for example how to create tables , inserts . step,
@marcuswest4572
@marcuswest4572 Жыл бұрын
Top notch content. Brilliant visual presentation. ENJOY!
@sumam.b9475
@sumam.b9475 28 күн бұрын
Very informative and easy to follow the concepts are explained very well.
@TeluguAbbai802
@TeluguAbbai802 11 ай бұрын
Thank you for your videos; you are one of the best teachers on KZfaq so far. However, it would be even more helpful if you could guide us through the process of creating a table for beginners instead of directly presenting the table and its explanation. thank you for your help.
@shaikusman536
@shaikusman536 2 жыл бұрын
WOW ...Started to learn SQL ...You are a Good Teacher Brother...Thanks a Ton....
@techTFQ
@techTFQ 2 жыл бұрын
Thank you so much Shaik :) Happy to know you benefit from this video :)
@karanamhimabindu9671
@karanamhimabindu9671 Ай бұрын
I'm much more interested in learning SQL from basic so I hope your videos will be helpful for me
@subramanianchenniappan4059
@subramanianchenniappan4059 2 жыл бұрын
Thanks. I am an experienced java developer . Useful for interviews
@yunusteli8697
@yunusteli8697 Жыл бұрын
Hi, I want to import data in postgres sql from csv file but it is huge table and it have 50 column and 10k records pls help me for the same, is there any way to import data without using create table command
@sivananthm6334
@sivananthm6334 Жыл бұрын
Thank you soo much for too easy understanding of SQL Queries.
@ketanwadnerkar1148
@ketanwadnerkar1148 Жыл бұрын
U r legend sir. U understood in very easy way..GBU thanks alot and made more videos ahead.
@Pravin33unique95
@Pravin33unique95 2 ай бұрын
way of explanation truly appreciate no words. I have seen lots of videos but your way is different
@twaca
@twaca 2 жыл бұрын
Great course for SQL beginner. Much appreciated!
@techTFQ
@techTFQ 2 жыл бұрын
Glad you liked it
@privateprivate3668
@privateprivate3668 6 ай бұрын
May God bless you for providing this content for free! 🙏
@karthikakarunakaran8857
@karthikakarunakaran8857 2 жыл бұрын
I learn join query using SQL in depth because of you thank you .it was amazing 👍 keep upload many videos like that
@techTFQ
@techTFQ 2 жыл бұрын
Thank you and will do
@RazvanStanescueu
@RazvanStanescueu 2 жыл бұрын
Very nice in depth structured courses for particular commands. Thank you!
@techTFQ
@techTFQ 2 жыл бұрын
Your welcome buddy
@a.kumaresan.47esan27
@a.kumaresan.47esan27 2 жыл бұрын
Yeah it really a good innovation to learn lot of member about SQL
@maheshmanyapuri147
@maheshmanyapuri147 2 жыл бұрын
Excellent information shared ...Tq
@relaxingbeatz4468
@relaxingbeatz4468 4 ай бұрын
Awesome content! Best place to learn SQL if you have a very minimum understanding of sql and joints
@user-os7kd2bk8g
@user-os7kd2bk8g Жыл бұрын
I came here by shakra shamim reference by her post on linkedin and i am literally enjoying it. First kudos to shakra obviously and next to you toufiq.
@ZoYaBoBo
@ZoYaBoBo 2 жыл бұрын
Thank you so much for this awesome tutorial, and also BIG thanks for sharing all scripts. Thank you !!!
@techTFQ
@techTFQ 2 жыл бұрын
Glad you liked it
@onlinesaidasa9105
@onlinesaidasa9105 Жыл бұрын
Namaste As a practice we must explain the designed query and check if the indexes etc. have been used. This would help in effective usage of DB Resources In my career of 21 + years , I have seen that Script developers seldom check if the query is optimized for best performance. They are only concerned about getting the output Thanks
@riyaverma4540
@riyaverma4540 2 жыл бұрын
Highly recommended!!! Each and every concept is made so easy to understand and grasp!! Great Work!!
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Riya 🙏🏼 Glad you liked it
@fardeenburhan221
@fardeenburhan221 Жыл бұрын
Marvelous! This is a great work, and very useful.. thanks!
@AJ-yr2fc
@AJ-yr2fc Жыл бұрын
Thanks Taufiq! This Video is very thorough and helpful.
@ketankumar5689
@ketankumar5689 2 жыл бұрын
Marvelous tutorial just around in an hour! I will definitely go through the whole SQL playlist. Expecting a few videos on business intelligence too. If possible, could you please make it?😊😇 Thanks a ton by the way !!!
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Ketan .. What topics you looking in BI?
@EveryDaymast
@EveryDaymast Жыл бұрын
@@techTFQ SSRS AND SSIS
@DebbyDaniel
@DebbyDaniel 5 ай бұрын
Understandable work Thanks so much for your simplicity 🎉
@Royal-ek4tw
@Royal-ek4tw 2 жыл бұрын
It's not a video, it's a package of all the relevant details, appreciate it mate, preparing for the interview with this video.
@techTFQ
@techTFQ 2 жыл бұрын
Awesome bro.. good luck and thank you 🙏🏼
@Royal-ek4tw
@Royal-ek4tw 2 жыл бұрын
@@techTFQ Thanks, Cracked interview, next round is due tomorrow
@techTFQ
@techTFQ 2 жыл бұрын
Awesome bro.. good luck for tomorrow 👍
@pallavichaudhary6636
@pallavichaudhary6636 Жыл бұрын
Thank you so much for this tutorial !!! Best tutorial..!
@adibanaazfatima7192
@adibanaazfatima7192 Жыл бұрын
Hi, How to get back drop and Alter table as later on I need those tables. Thank you
@J-yr6vb
@J-yr6vb 11 ай бұрын
Hi !! I've tried to import the .ddl file in PostgreSQL 15 but no tables appear. Could someone help me please? I'd like to practice with these data.
@damianfargoes529
@damianfargoes529 8 ай бұрын
Incredible and Insight full content across al three SQl stages (beginner, Intermediate and advanced). I am a data analytics consultant with 4 years of experience in SQL and this was much helpfull during my interview prep. Just a small suggestion it would be nice if you include a session on wild cards in sql. Thanks again!
@techTFQ
@techTFQ 7 ай бұрын
Welcome. Noted
@lucario3682
@lucario3682 5 ай бұрын
@@techTFQ unable to restore given .sql files for practice
@adapureddyatchutarao1327
@adapureddyatchutarao1327 2 жыл бұрын
Best SQL tutorial for beginners. Thank you so much
@techTFQ
@techTFQ 2 жыл бұрын
Glad you think so bro!
@sindhuvi5236
@sindhuvi5236 Жыл бұрын
You're the best :) Thank you so much for your efforts that you've spent in creating this content, Extremely helpful and very well explained too!
@deepakkumar0176
@deepakkumar0176 4 ай бұрын
This was very helpful. Thank you👌🏽👍🏽👏🏽
@republicgreenfather3068
@republicgreenfather3068 Жыл бұрын
Excellent outstanding tutorial Thank you Brother for your Explanation
@prabinpatro8777
@prabinpatro8777 Жыл бұрын
Hi, I have been trying to read SQL and I think your teaching techniques are too good. Can you please make a video Of ETL Process using SQL! And if you are a tutor then please let me know I would like to get tutored by you sir😊
@erigelavani4162
@erigelavani4162 Жыл бұрын
Thanks sir for dng videos,keep uploading more videos it will help us to learn more knowledge
@ishasinfo2432
@ishasinfo2432 2 жыл бұрын
Excellent session to learn in practical way...Thank u very much...iam expecting more sessions ....Thanks in advance
@techTFQ
@techTFQ 2 жыл бұрын
Thank you so much 🙏🏼 Glad you liked it ☺️☺️
@bodaashoknayak6493
@bodaashoknayak6493 Жыл бұрын
good job bro amazing explanation superb
@sumam.b9475
@sumam.b9475 28 күн бұрын
Hi. May I know where we can find the data set to practice for the above explained select queries(Practice simple SQL Queries)
@sr5726
@sr5726 6 ай бұрын
what is the shortcut to execute the line alone. Do you double click. its looks like you are double cliking or triple clicking
@simhabenny510
@simhabenny510 11 ай бұрын
Very happy to follow ur each and every video of urs and clean explanation, thank you soo much 🥰
@davidjebbett6990
@davidjebbett6990 Жыл бұрын
Good video, learning SQL at the moment, thanks
@shreyansraghu6709
@shreyansraghu6709 9 ай бұрын
HI Imagine I have downloaded csv file from kaggle, now I want to use that data in Oracle sql live. How do I do that ?
@ysmanikanta2706
@ysmanikanta2706 Жыл бұрын
Thanks a lot no words, it would be great if you provided the dataset also along the query file you provided......it would ba easy to practice n see whats happening while executing the query brother
@karpagammohan6605
@karpagammohan6605 2 жыл бұрын
Awesome video and clear explanation!! Thank you so much for the video.
@techTFQ
@techTFQ 2 жыл бұрын
Your welcome :) Glad this helped..
@Michael_Tseye
@Michael_Tseye 2 жыл бұрын
Bro you can teach💯💯 Best teacher I’ve seen so far Details 💯
@techTFQ
@techTFQ 2 жыл бұрын
Thank you Ael for the kind appreciation 🙏🏼 Glad you liked it..
@jaitiwari241
@jaitiwari241 Жыл бұрын
This basic tutorial is amazing but can anybody tell me, the SQL script given by sir is not running on MySQL RDBMS. It is showing an error. which platform should I use to run these scripts? Thanks
@natureiseverything5110
@natureiseverything5110 3 жыл бұрын
I am very much happy to listen to your tutorial thank you for infinity times sir.I will be waiting for your next videos.Thank you so much....
@techTFQ
@techTFQ 3 жыл бұрын
Thanks a lot for your kind words.. I am so glad you liked it.. 🙏🏼 I have recently posted another video on window function in sql. Link below: kzfaq.info/get/bejne/jd1nZM6f2861Xac.html
@gabrielalade7793
@gabrielalade7793 Жыл бұрын
Hello techTFQ, thanks for this great training its a huge one. I have a data i am playing with, it has a datetime column so i got the time difference between each rows. But i am trying to sum the time difference in a new column with the alias name, its showing the time_diff column as a string. I tried converting/casting that to an int but its through an error. Is there any other way to do this? Thanks
@ladiidiok9411
@ladiidiok9411 10 ай бұрын
i would like to know how your created the tables you were using in the examples.
@abdushabab
@abdushabab 4 ай бұрын
thank you so much for your videos. , good quality explanations
@TheMalVivant
@TheMalVivant 9 ай бұрын
i downloaded the two SQL files on your blog. How do I use them? Sorry, I am very new to all of this. When I click on the files, they open up in VSCode, and it all looks exactly like what's in your video, but I can't figure out how to execute a query to show up in the Output window at the bottom like you are doing in your video.
@nikitarai3701
@nikitarai3701 Жыл бұрын
Hey where can I find this dataset to practise on?
@danielwong445
@danielwong445 Жыл бұрын
When I heard you mentioned about 'Malaysia' when updating the address table, I am glad someone knows about Malaysia 🤣🤣 Btw your teaching in SQL is great 👍👍 Showing what happen when different queries is executed 👍👍
@eteekavats
@eteekavats 5 ай бұрын
Very well explained buddy, truly appreciate it!
@neetudey9204
@neetudey9204 2 жыл бұрын
Thanks a lot for sharing a nice, clean, understandable video on SQL.Its really helpful
@techTFQ
@techTFQ 2 жыл бұрын
Your welcome 🙏🏼 Glad you liked it
@sakthipriya8653
@sakthipriya8653 Жыл бұрын
Best channel for SQL, great content bro... Keep posting, looking forward ❤
@themysterybox0994
@themysterybox0994 2 жыл бұрын
Hi sir actually I have ssms installation error in my laptop after downloading it was stuck in loading packages please wait .. Can. You help out how to install SSMS with SQL server...?
@PettakaTechnologies
@PettakaTechnologies Жыл бұрын
Superb. I appreciate your hard work for making this video with superior quality in both visual and voice. Keep doing more videos like this.
@user-lb3me2yz9l
@user-lb3me2yz9l 9 ай бұрын
Hi Toufiq, where can I find the csv file for plasticizing the sql quries
@sumardjo
@sumardjo 2 жыл бұрын
Thanks you very much your knowledge is very nice
@bodaashoknayak6493
@bodaashoknayak6493 Жыл бұрын
thank you so much bro for uploading this video lot of knowledgeable topics covered in just one hour ten minutes
@PakkaLogic
@PakkaLogic Жыл бұрын
thank you..Is there any specific course for Sybase ASE in ur library?
@priyankamaity3290
@priyankamaity3290 5 ай бұрын
Thank u for the informative video, its really useful and most underrated video on KZfaq!
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 170 МЛН
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 163 МЛН
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 42 МЛН
How to learn SQL for free | Roadmap to learning SQL
27:20
techTFQ
Рет қаралды 838 М.
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,1 МЛН
SQL Tutorial for Beginners
44:57
Kevin Stratvert
Рет қаралды 2 МЛН
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
SQL Tutorial for Beginners [Full Course]
3:10:19
Programming with Mosh
Рет қаралды 11 МЛН
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 170 МЛН