Learn SQL and Analyze Data - Complete Telugu Tutorial with Sample Queries

SQL అంటే ఏమిటి? దాన్ని ఎలా ఉపయోగించాలి? అది ఎలా install చెయ్యాలి? Queries ఎలా రాయాలి?
అన్నీ ఈ video లో cover చేశాను. చూసేయండి మరి 😀
~
What is SQL, how to use it? How to install SQL in your computer, how to write SQL queries yourself?
I cover all these topics in this video with detailed, practical examples. Let's dive in...
📁 Sample Data Files:
==================
All the data files, installation instructions and useful information here:
chandoo.org/wp/how-to-use-sql...
⏱ Video topics and timestamps:
===========================
0:00 - Introduction to SQL and what to expect in this video?
0:51 - Database & SQL concepts
9:19 - Installing and setting up MySQL on your computer
14:49 - Creating a new database (schema) in MySQL
15:50 - Adding / Creating tables by importing CSV files
21:48 - Writing SQL queries (a story from my life)
25:30 - 10 examples queries with SQL for business situations
~
#sql #telugu
~
SELECT "awesome day" from DAYS
WHERE person="You" 😀

[@krishnachaitanya9879]

SQL+ power Bi meeda oka project cheyyandi anna plz 🙏

[@data_with_chandoo]

Sure. Do watch this video for SQL and my Power BI full-project video for a project. - kzbin.info/www/bejne/bGqbmpt3aKZmjaM I will combine both in a future video -

[@vasakumari2862]

SQL lo vachina data ni power bi ki connect cheyavacha sir😅

[@venkatasrinivaskavala3708]

Waiting for SQL + POWER BI course sir🙏​@@data_with_chandoo

[@HIndustanZindabaad1010]

@@data_with_chandoo thanks anna, looking for it. LOVE FROM MAHARASTRA 🌎

[@guruch3503]

ఇప్పుడు జనాలకి నువ్వు కావాలి అన్న ... I'm telling that 😊

[@rajeshnowduri1244]

Instead of promoting unnecessary webseries promote this guy who is spending his quality time to spread the knowledge.

[@chaitucj7645]

HI chandoo bro, please python kuda indetail ga telugu lo explain chey bro, nen ne english channel lo kuda chusa but telugu lo iythey naku inka chala mandi students ki chala helpfull avthundi.

[@manjunathkb9795]

13) How many shipments we do by each country in the month of March 2023 SELECT g.Geo as Country ,count(s.Geo) as shipment_count FROM shipments_new s JOIN geo g ON s.Geo = g.GeoID WHERE year(s.date) = 2023 AND month(s.date) = 3 GROUP BY Geo Country shipment_count UK 78 India 80 New Zealand 75 USA 60 Canada 70 Australia 67

[@doggasnaidu]

❤❤thala thank you brother .. KZbin lo sriayina channel eppudu kanipinchi sir .. thanks a lot

[@9rrdff06]

Thank u is very small thing to convey❤Thanks a lot

[@teluguhome1675]

Telugu లో చెప్పినందుకు ధన్యవాదాలు సర్

[@pg49460]

Awesome tutorial, that too in telugu by Great Chandoo.

[@vishwanath.b1233]

Hi Anna, I have been waiting for this video. Thank you so much Anna❤❤

[@MrSivaprashanth]

easy to understand and simple explanation. keep it up sir👍👍

[@Chandra_Sekhar152]

select * from people where `Sales Person` like 'S%' and Location ="Hyderabad";

[@NagarjunaNandi]

ఇప్పుడు జనాలకి నువ్వు కావాలి sir ...Are you teach very interesting sir .We want more concepts about MY SQL, Power BI...etc. Thanks you sir 😘😘

[@yadagirijallella4408]

Thank you so much for making this SQL video sir. Plz. Kindly request Next time make Data Analyst real time scenario (Python+SQL+Power Bi) use together video.

[@kalyankalyan5283]

Thank you Chandoo Anna for the video 🙂

[@prudhvipodicheti-fi3ou]

Best Teacher, amazing bro

[@KrishnaGadiraju25]

Super Chandu garu 🎉

[@maheshwaripenumallu4184]

Sir, whole youtube lo power bi evaru cheppina arthamkale mee telugu videos chudagane brain lo ala feed aipoyayi. i know english but telugu is comfortable tto understand. Me courses chusanu, can you teach in Telugu sir please. I want to join. Chaaala ante chaaala baga chepparu. first 5 mins lone artham aipoindhi that you are the one ani.. Please can you teach or upload whole POWERBI videos in telugu. Im ready to join the course if its in telugu sir . please

[@vvnseryl]

hi anna .. Loved the way you explain anna , but can you also make a complete video on interview questions or types of questions asked in interview about DAX and powerbi with examples anna ..Thank you

[@pujithag64]

Need much this kind of content

[@GopalReddyK-wz4by]

Chandoo anna Content never feels boring 💓

[@AshokSankarVarmaChekuri]

Burrapadu Super easy explanation.

[@harshithharsha4066]

Thank you so much ! ❤

[@SatishR-u9v]

Hi Brother , the way you explaining excellent and clear ,please keep posting....could you please take classes for mysql completely ...with charge and all...I am ready for tht

[@Ganesh51515]

Alage mangodb Pai basics to advance level varki cheyandi videos chala takkuva mandi mangodb Pai videos chesaru meeru cheyandi sir reach vasthadi

[@Saivarunvlogs]

Thanks a lot bro

[@hemanthkumar4870]

Anna.., mee telugu vintuntey chalaa Hai gaa vundi..

[@swarnahamsa2896]

❤ thank you 🎉

[@ckumar4013]

Thank you so much Anna 🙏🙏

[@venkateswarlureddyg]

Chala thanks bro

[@seshulatha]

Awesome 🎉 mee home tour kooda cheyara🎉

[@pavithrap959]

Thank you so much

[@tejaswinikodati4037]

nice infomation

[@anilreddy1388]

chandoo Anna please do video on SQL topic "Sub-queries" and how to create sub query with examples and also on CTE(with clause) , window functions. Thank You.

[@guddetimanojkumar]

Please 🙏 Excel + Power Bi + SQL Medha oka complete project chiyandi

[@krchaithanya6693]

Yes please

[@NaiduCenter]

Yes please

[@candysingh2044]

Yes

[@vsagar4b38]

thanks for Video

[@srinumananji800]

I am following all your videos anna i like it i need PowerPoint presentation from basic to advanced level please anna

[@itsganeshnaidu9768]

Thank you Anna ❤

[@galishiva5615]

Thanks anna ❤

[@srilathakalli759]

Hi anna SQL+ Power BI combination lo oka project cheyandi anna please, so many people's are waiting for this vedio

[@febysushannapaamu5202]

Thank u brother 🙏pls explain oracle sql and how to download sql

[@aditya_kittu22]

Thanks anna

[@S.V.R8905]

Sir plz make a complete playlist on data analyst,like plz make a complete course on data analyst

[@sreedharreddyindian9530]

Annaaaaa❤❤😊

[@jashuvakatipalli1717]

Would you plz more information like tutorials

[@user-so6ze7yc1w]

Daily videos upload cheyandi

[@sathishkumarkanukurthi5077]

select * from people p where p.`Sales Person` like 's%' and p.Location = 'Hyderabad';

[@anushetti8452]

Hi Anna,if possible try to teach aptitude/ coding series because many of us like me are suffering to clear that round 🙁

[@srinumananji800]

Annayaa SQL BASICS TO ADVANCE GA VIDEO chiyandii annaya pls

[@vamsivamc7956]

Nice t-shirt😊😊

[@Asha-dc5fu]

Hubspot crm gurinchi video cheyandi

[@mkalyan7496]

7 - Sales persons whose name begins with S (Home Work) select * from people where `Sales Person` like 'S%' and location like 'Hyderabad';

[@dalalappagarianil]

subquery s explain cheyandi sir

[@Oneinlove123]

please give full course sir

[@alakuntlasimhadri5012]

statistics gurinchi video thiyandi bro

[@rahulreddy4632]

select * from peopletel where `sales person` like 's%' and Location ='hyderabad';

[@prashanthlastplayer3860]

whats is sql (sql + my sql + pl sql + Post gre sql )

[@1203sagar]

51:23 - select * from people p where p.sales_person like 'S%' and p.location = 'Hyderabad' ;

[@saijakkampudi4327]

Hi could you explain how to load the data directly from the Success factors into qlik?

[@saileshnellorepalli]

Kia Ora, Hi brother ela vunnaru? I would like to learn power BI but I'm not sure where to start also i don't have any knowledge on technical. Please guide me.

[@amarojusaikumar3]

Hii anna .. im very much about data analyst. Someone says .. not possible with you. Because of I have chemistry background in my masters. And one more thing i know & i will do coding in python also SQL. And also im learning visualization tool like power bi. . . Now tell me brother... It is possible with me or not

[@abhinav3252]

SQL+PowerBI chpandi sir

[@ramagirirahul3726]

Bro, I'm not found tables such as people table, geographical table etc. How I need to download that excel sheets

[@bouncercorn2178]

sir , Can you pls share power bi syllabus to learn as Data Analyst

[@mohithkarthiksamudrala7576]

We want more videos in telugu... English gets bored after some time😅

[@SagaraK-k4b]

hello chandoo garu i'm sagar from bengaluru, i have recently completed MBA graduate , i'm looking for opportunity as a data analyst . can you please explain How to start data analyst as a Fresher , Road map for data analyst, how to crack a interview . koncham data analyst ela avvaloo cheeppagalara chandooo garu please - THANK YOU

[@seshulatha]

Select * from people Where ‘Sales person’ Like ‘s%’ and ‘Location’ = ‘hyd’ ;

[@BalaKrishna-yg8bu]

Please do SQL project

[@user-so6ze7yc1w]

English classes chepandi

[@Chandra_Sekhar152]

we need advance concepts in telugu

[@Jyanshu-24jul]

---How many shipments we do by each country in the month of march 2023 select g.Geo,g.Region,count(*) as 'noofa/cs' from shipments as s join geo as g on g.GeoID=s.Geo where datepart(yy,date)='2023'and datepart(mm,date)='3' group by g.Geo,g.Region

[@yaminianukataru6940]

naa data base loki load avvatam ledu sir data miss ipotundi .csv tho save cheste excel data miss avtondi

[@rajasaisree1351]

Getting error in where clause

[@narendraprasad8398]

Kindly provide step-by-step to install MySQL. I am facing issues while installing.

[@VVSatyanarayanaNarra]

Anna naaku miru chepina power bi vedious motham kavali Anna

[@naveenchitikela]

Hi anna can you do a project

[@KalpanaMatrix]

🎉

[@Jyanshu-24jul]

sales persons whose name begins with s and stay in hyderabad select * from people where 'salesperson' like 's%' and location='hyderabad';

[@dilvenkatesh8983]

select * from people where `sales Person` like 's%' and Location = 'hyderabad';

[@data_with_chandoo]

Bingo!

[@satheshyeruva-rt8lu]

Select * from people where 'sales person' like 's%' and people Location = 'Hyderabad';

[@seshulatha]

Venkat story with sql is so funny 😂

[@NareshKumar-jl6te]

sir Geo lo g3 lu levu meru ichina dataset lo 2.00 3.00 numerics unnai and thanks to wonderful explanation sir

[@data_with_chandoo]

meeru data load chese tappudu, field ki text format set cheyyandi. Number pedithe 2.0 avuthundi.

[@NareshKumar-jl6te]

@@data_with_chandoo okay sir thankyou

[@saikirandharanikota2179]

select * from people where `Sales Person` like 's%'and location ="Hyderabad";

[@rajukommu9774]

Ee video lo sql course complete aenadaa bro 1 hour class anthe na course unadi

[@miriyalanagasaikiran1046]

Hi anna I want to learn Data analytics, I am very much interested in it, but I am not finalizing the best source of Data analytics please suggest the best institute or way to learn anna....... please anna waiting for your reply

[@Mr.Mahesh6]

Learn Excel and Power BI from Chandoo Sir free KZbin videos first

[@manivenkata9912]

Hi chandu i have one doubt can we load data commabd in sql to insert large data into table like if we diwnload dataset from kaggle

[@data_with_chandoo]

Yes, you can. MySQL has a dump command that can be used to dump large datasets directly into your database.

[@sandeepaketi7409]

Where ' Sales Person ' like 's%' and location=Hyderabad;

[@nadendlasairahul66]

SAP ABAP mida oka video cheyandi bro

[@data_with_chandoo]

అది నాకు తెలియదు bro. ఎప్పుడూ వాడ లేదు.

[@tejugodesi7108]

hello bro I have downloaded Sever and when i open workbench in that local desk it was asking password can please overcome from this

[@data_with_chandoo]

You would have set the password during the installation process.

[@parapelliveena8687]

SELECT * FROM people WHERE `Sales Person` LIKE 'S%' AND Location ='Hyderabad';

[@charithkumarbatta7256]

anna,naaku instal kaavatamledu .meeru description lo provide chesindi check chesa and website nundi chesanu bt avatamledu.can u help me ple

[@data_with_chandoo]

May be your computer doesn't meet the requirements for MySQL. dev.mysql.com/doc/mysql-monitor/8.0/en/system-prereqs-reference.html

[@chityalasaikrishna3100]

last home work answers

[@SatishKumar-ps4wj]

8.37 removed how now

[@kommabalaji4845]

SQL server lo cheyyachhu kadaa Aandi syntax maaripotundii. MySQL ki SQL server ki

[@data_with_chandoo]

Anta pedda difference emi vundadhu andi. 95% same syntax. MySQL is widely available so anyone can install and use. SQL Server is tricky to get and use.

[@JayaPrakashBommisetty]

Is it case sensitive SELECT * FROM ....and....select * from

[@data_with_chandoo]

Nope. Should work in any case.

[@padmashankar7466]

select *from shipment s where s. 'sales person' = 'SP02'; error vastunadi

[@sathishkumarkanukurthi5077]

select * from shipments s where s.`Sales Person` = 'SP02';

[@medurirajkumar2376]

select * from people where 'sale person' like ' s%' 'Hyd%';

[@naveengoudettaboyini6451]

Sir time 00:12:25 min dhagara workbench application lo my SQL connections lo m ledhu add setting symbol thppa and I have downloaded 8.0.38 41mb and work bench separately which is also 41.7 mb please guide me on it😅

[@naveengoudettaboyini6451]

services lo kuda MYSQL ledhu if you can guide it will be great help.

[@data_with_chandoo]

You should install the MySQL (and Workbench too) and restart the computer. Check your Programs list to make sure mysql is there.

[@pradeep.tholety]

@1:00:32 in where condition you used p.sales person, but in P table there is SPID and in S table there is sales person. How you can merge both.

[@data_with_chandoo]

Check again. I am using s.`Sales Person`

[@pradeep.tholety]

@@data_with_chandoo in line number 66

[@narendraprasad8398]

SELECT * FROM people p WHERE p.`Sales Person` LIKE 'S%' and p.Location ='Hyderabad';