Please like the video as it takes lots of effort to record these videos. Checkout my high quality data analytics courses : www.namastesql.com/
@revathigangisetty9065
5 ай бұрын
Hi Ankit, can you please kindly help the below requirement. create table #temp ( DepartmentId int, Name varchar(255),Hiredate date,Sal float,Ruleid int) Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Sai','2021-10-23',5500) Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Sairam','1999-10-23',6000) Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Saikrishna','2002-10-23',3000) Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Sair','2021-10-23',5000) Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'Raj','2015-10-23',8000) Insert into #temp (DepartmentId,Name,Hiredate,Sal) values ( 10,'SRK','2021-10-23',5000) Create table #Rules (Departmentid int,Ruleid int, Condition Varchar(2000)) Insert into #Rules values ( 10,1,'Name like ''Sai%''') Insert into #Rules values ( 10,2,'Hiredate >= ''2000-01-01''') Insert into #Rules values ( 10,3,'sal >= 5000') output Departmentid Name Hiredate sal ruleid 10 Sai 10/23/2021 5500 2,10,30 10 Sairam 10/23/1999 6000 2,30 10 Saikrishna 10/23/2002 3000 2,10 10 Sair 10/23/2021 5000 2,10,30 10 Raj 10/23/2015 8000 10,30 10 SRK 10/23/2021 5000 10,30
@revathigangisetty9065
5 ай бұрын
DepartmentId is used to join #temp and #Rules. check each condition dynamically from #Rules against the corresponding rows in #temp. If a condition is satisfied, concatenate the Ruleid value from #Rules to the existing Ruleid in #temp
@ankitbansal6
5 ай бұрын
@@revathigangisetty9065 send the problem on sql.namaste@gmail.com
@revathigangisetty9065
5 ай бұрын
@@ankitbansal6 i shared the details in the email ankit. its urgent requirement ankit please kindly help me. i will be eagerly waiting for your input.
@revathigangisetty5734
5 ай бұрын
i shared the problem to you via email and tried multiple times but i didnot get the exact solution. please kindly help ankit
@jaybharat3949
4 ай бұрын
First of all, thank you very much for the project. But there’re couple of concerns which you may have overlooked - 1. In every query where we’re doing analysis based on sales, I guess it’s better to consider sale_price*quantity as sales rather than sale_price only 2. In the last problem, profit should have been taken into consideration rather than sale_price But again I’m repeating that, above are some modification we can make to get the best business answers, otherwise in the video you’ve shown the approach how to handle an end to end project - from that pov it’s absolutely fine. We students can make necessary changes.
@ankitbansal6
4 ай бұрын
Thanks for the feedback. Appreciate it 🙂
@IMRANAHMED-eh7yl
2 ай бұрын
I have noticed same thing but overall good Video for learning
@KennethDarby-o3j
17 күн бұрын
I assumed the sale_price is the result of this calculation, which would make the way he does it correct.
@randyawuri1664
4 ай бұрын
You sir, are a wonderful teacher! I am currently learning Data Engineering. This video has enabled me to catch up and understand some core concenpts that I found challenging because I missed live classes. Thank you!
@ankitbansal6
4 ай бұрын
Glad to help!
@HarshGupta-rn6db
5 ай бұрын
You are the torchbearer for many Ankit, trust me! Cheers!
@ankushjain4128
5 ай бұрын
Great video! Loved the easy explanation of the full ETL process and data analysis. Keep up the good work!
@HaroutBlack
4 ай бұрын
Jesus is the only way to healing, restoration and salvation to all souls. Please turn to him and he will change your life, depression into delight, soul heading from hell to heaven all because of what he did on the cross “Whoever calls upon the name of the Lord shall be saved” Romans 10:13
@divyanshisharma4054
5 ай бұрын
I thoroughly enjoyed this video and followed along with you. Thanks for this. Please keep posting more of such end to end analysis problems. Thanks a ton for taking the effort to make these videos so that we keep learning :)
@ankitbansal6
5 ай бұрын
More to come!
@joydeepsarkar3092
4 ай бұрын
Very Helpful video Ankit! Thanks a lot for the efforts you have put for creating this guided project. Looking forward for many more guided projects :)
@mrrathore55
2 ай бұрын
Thanks Ankit for this wonderful end to end course,I have gone through it and cleared many of the doubts.
@gunaravi6224
4 ай бұрын
Hello Ankit Sir, am a fresher and am looking forward to start my career in data analytics or data engineering field. This video is awesome and very helpful for me. Thank you so much for making the End ot End videos like this. And the way you explaining each and everything is very nice and clear. Keep it up Sir
@ankitbansal6
4 ай бұрын
Keep it up 👍
@piyushsharma8294
5 ай бұрын
Thank you bro for the best explanation i’ve ever seen about this topic.
@bhanujuneja58
2 ай бұрын
Very nice video. Just a little doubt. In the last question we have to calculate subcategory with highest growth by profit but in the video highest growth by sales is calculated. So the one given in the video is right or not?
@jeniyakulshreshtha7555
5 ай бұрын
Today only i was seraching for data analytics ..and just saw your vedio ...thank you so much..pls post more such content on data analytics and any course on this as well please 😊
@himanshshakk3083
3 ай бұрын
Bro I think you have done mistake in top 10 highest revenue generating products category you should use SUM(orders_quantity*selling_price) because sum of only selling price cannot produce the revenue it should be multipied by quantity
@KapilSinghSenwal
2 ай бұрын
While watching the video I also has thought the same. Could you please clarify it @ankitbansal6
@vivekkumar6546
5 ай бұрын
Ankit bhai no words.. new things learned today..❤
@ankitbansal6
5 ай бұрын
Glad to know 😊
@ShekoniTaofeek
4 ай бұрын
Thank you very much. Never believed I could really joy it as much as I did. I really really appreciate your effort
@ankitbansal6
4 ай бұрын
Awesome 👍
@shreecrafts651
2 ай бұрын
Thank you so much!! You are the motivation and this is the first step for me!! It means a lot thank you so much Ankit🙏🙏
@ankitbansal6
2 ай бұрын
Keep it up💪
@mohitjoshi8984
5 ай бұрын
Thank you ankit it's really helpfull. Can you make a practical video on A/B Testing plzz
@ankitbansal6
5 ай бұрын
Sure
@satishwalaki
5 ай бұрын
This was really helpful as a beginner me. thanks a lot & we need more n more videos like this.
@nikhilreddy4582
5 ай бұрын
Thankyou so much Ankit sir For this project👍
@koa1663
3 ай бұрын
how do you document your findings. please make a video on how you put everything together for a portfolio showcasing your skills in python and sql
@sakeenasammi1768
Ай бұрын
I liked the way you explained every query... Keep it up..
@ankitbansal6
Ай бұрын
Thank you so much 🙂
@Abhilash_Jose
5 ай бұрын
Hi Ankit, You have made this video at the correct time, I was looking for something like this. Could you also make a project on end to end problems while loading data in CSV to MySQL. I recently had a issue where I was not able to fully load all the data , only partially even though I did null treatment. Please make a video on it and also post it in your LinkedIn once you have done it so i may get notified about it
@ankitbansal6
5 ай бұрын
Sure
@bodybuildingmotivation5438
5 ай бұрын
really love this kind of content, please make more video like this.
@anoopdube9581
5 ай бұрын
Liked your video, I am from Australia.
@ankitbansal6
5 ай бұрын
Thanks for watching!
@macx8360
5 ай бұрын
thanks , i was waiting for this ....honestly
@deviprasadgharpehai3315
5 ай бұрын
Thanks a lot bhai love nd support from berhampur❤
@ravitejatavva7396
5 ай бұрын
Wow, Appreciate your effort and work! 😍
@ankitbansal6
5 ай бұрын
Thank you so much 😀
@subhajitdutta9983
Ай бұрын
Thanks for this awesome project.
@abolisabne4887
5 ай бұрын
Thankyou so much for this Vedio Ankit.
@satyajeet7633
4 ай бұрын
In the last question of sql Should we calculate growth by profit change or sale change because the question is for profit change Also in total revenue quantity of each order is not included
@reddysekhar459
5 ай бұрын
Thank you so much for the video! great video👍
@brishtisaha4785
5 ай бұрын
Sir please upload more SQL projects with datasets from kaggle.. Thank you for this..
@SunilKumar_67
5 ай бұрын
Can't add the ODBC Sql Server even after having the MySQL that was installed for working on your SQL Course. I am getting an error message saying TEST FAILED. Can you please share any link that can help us to get that server name present in the list of servers available to connect or better a follow up video showing how to do it on your system. Thanks in advance
Anaconda3\lib\site-packages\sqlalchemy\exc.py", line 258 except Exception, e: how to fix sqlalchemy error?
@DA_Guy123
3 ай бұрын
Did you get the solution?😅
@MayureshRajendraKalbande
3 ай бұрын
@@DA_Guy123 no but instead i inserted record using pandas - df_orders_table_create=("""create table if not exists df_orders( ) cur.execute(df_orders_table_create) conn.commit()
@AsifDawood
Ай бұрын
Great video. Thanks for sharing
@tarekmustafa2525
Ай бұрын
Excellent tutorial, thank you!
@ankitbansal6
Ай бұрын
You're very welcome!
@adityavamsi12
Ай бұрын
Thank You so much for your content
@ParthMistry-c3x
2 күн бұрын
Hi Ankit sir, I'm facing continuous issues connecting Jupyter Notebook to SQL Server Management Studio (SSMS). I've installed the necessary drivers and tried all the solutions, but I'm still unable to connect. As a workaround, I saved the updated file from Jupyter Notebook and manually loaded it into SSMS, changing all instances of df_orders to updated_orders in my queries. Could you please advise me on which drivers and software are needed? I've watched several KZitem videos, but they often lead to lengthy errors.
@MayankGadiya-uq1el
4 ай бұрын
"for each category which month had highest sales" above question has different output from your youtube video and sql queries that u have provided in sql file.
@Sudarshan-d7s
2 ай бұрын
Bhai tumne company ka experience karwa diya kaise kaam hota he ❤it man
@074_umairkidwai8
2 ай бұрын
Showing error in changing order date to datetime
@yadavikasAnalyst
4 ай бұрын
Sir when you solved the first question why didnt you multiplied the quantity column with the sale price?? For total revenue by product I'd?
@jaybharat3949
4 ай бұрын
Yes, I think likewise. Revenue should have been qty*sale_price
@rizwan1396
Ай бұрын
Great work sir , sir i have one problem im using mysql and for third questionsy output showing me only 2 rows for same query why is that
@shubhamtayde3797
3 ай бұрын
cant't we direclty open csv file in python using read_csv no need of kaggle API
@sukanyaiyer2671
2 ай бұрын
There is no folder called .kaggle..
@ankitbansal6
2 ай бұрын
Create it
@shivakumar-ic9dh
2 ай бұрын
Simple and good explanation😊
@ankitbansal6
2 ай бұрын
Thank you 🙂
@rakeshkoli4384
5 ай бұрын
thanks bro and kindly make video on ETL process
@ShashankVeerabomma
4 ай бұрын
with t1 as (select month(order_date) as month1,sum(sale_price) as sales1 from orders where year(order_date)=2022 group by 1), t2 as (select month(order_date) as month2,sum(sale_price) as sales2 from orders where year(order_date)=2023 group by 1) select month1 as months,sales1 as 22sales, sales2 as 23sales from t1 inner join t2 on t1.month1=t2.month2 order by 1 asc; another way for the year on year query
@othmaneallouch326
3 ай бұрын
Great content! thank you so much for sharing !
@ankitbansal6
3 ай бұрын
Glad you enjoyed it!
@othmaneallouch326
3 ай бұрын
@@ankitbansal6 thanks to you i'm discovering a whole new level of sql with your constant use of cte and complex analysis, I will surely watch every single video in your channel
@gurutech7398
5 ай бұрын
It's really great bro❤
@arunkumarkesavan6077
2 ай бұрын
Superb explanation !!!
@ankitbansal6
2 ай бұрын
Thank you 🙂
@Ranidalvi-n3o
Ай бұрын
please share the link for Microsoft Sql server management studio installation.
@subodhthore6454
5 ай бұрын
For first question, Don't we need to multiply sale_price with the quantity for revenue generated for each product?
@ankitbansal6
5 ай бұрын
We can do that. I assumed it was total sales in the sale price.
@subodhthore6454
5 ай бұрын
@@ankitbansal6 ok sir
@yousrasaadaoui1238
4 ай бұрын
same question. my answer is SELECT top 10 product_id, SUM(sale_price * quantity) AS total_revenue FROM df_order GROUP BY product_id ORDER BY total_revenue DESC;
@sidindian1982
2 ай бұрын
excelllent Sir
@navaneeth6414
5 ай бұрын
Hi Ankit, Wonderful Explanation. Can I have those DDL statement in SqL Server. Not able to find in Github
@sagarjadhav3564
Ай бұрын
Hi Ankit , What should I do If I don't see ODBC driver for SQL server in ODBC data source administrator ?
@rahulagrawal622
5 ай бұрын
Hi Ankit Can you please also show us How to add triggers To update the data every month on database Thanks
@amithvalentine1479
4 ай бұрын
hey Ankit, great content, thanks fro the video! How did you obtain the list the columns names with the datatypes and memory allocation to create the new empty table?
@ankitbansal6
4 ай бұрын
You can right click on the table name in the browser and choose create to
@ajaykumar8725
24 күн бұрын
Thank you for the valuable content that i found so helpful for my profile . I have been going through a problem where after transforming the data in Jupyter and loading it to SSMS , the code runs in the notebook with no error but I can't find that data file in SSMS, can you clarify Please. Thanks.
@ankitbansal6
24 күн бұрын
You need to commit
@kishorereddy3155
Ай бұрын
Hi Ankit where can I can these type of queries to get hands on can you please tell
@asrarahmad1691
4 ай бұрын
Hello Ankit when I am Importing date from python to SQL and running code in my Jupyter Notebook I am getting below error AttributeError: 'Connection' object has no attribute 'cursor' Please let me know
@Azkaban819
4 ай бұрын
Finallyy, thanks!
@chethuchethu6530
2 ай бұрын
great vedio
@tenzinchoepheldev
4 ай бұрын
Thanks for the effort 🎉😂
@kantipudisaisowmith9628
4 ай бұрын
Can you explain how to connect sql server on mac with jupytor
@abhinandannaskar9403
2 ай бұрын
Hi Ankit, I am trying to connect and load the data to my local mysql workbench client. Continuously getting error. Any help?
@ParthMistry-c3x
2 күн бұрын
same here with me
@akashjha7277
5 ай бұрын
Great video❤
@WiseCoder-rp2zn
4 ай бұрын
Good Video, Keep it up
@friendofnature1662
2 ай бұрын
Hello and congratulations on the course! In the first part where I have to put the json file in the .kaggle file this is doesn't t seed to exist So what can I do?
@ankitbansal6
2 ай бұрын
Create one folder
@jonathangriffiths8213
2 ай бұрын
How can I log into the MS SQL Server database when following along with a Mac, not Windows? I've installed Azure Data Studio but it seems the steps in connecting to the db engine are different.
@shreyagupta.1203
Ай бұрын
Try this, when connecting to MS SQL Server in Azure Data Studio in Mac import pyodbc conn = pyodbc.connect('Driver={ODBC Driver 18 for SQL Server};' 'Server=localhost;' 'Database=master;' 'UID=your username;' 'PWD=your password;' 'TrustServerCertificate=yes;')
@ayat5483
3 ай бұрын
Brother, I am new to data science. I want to know which language will be good to learn data analysis? I have learned python, numpy and am currently learning panda.
@ActiveLifePicks
4 ай бұрын
Hello Ankit, all these queries can be made while using pandas library, can you tell why your made sql server database and used sql for queries?
@Blacksmiths23
Ай бұрын
Hello Bhaiya! Thank You. If i need help in my career.Will you help me with your knowledge and experience? It would be very grateful of you.
@PravinMane-el5fo
4 ай бұрын
Nice one
@beaver499
4 ай бұрын
Hi Sir! I am not able to connect the SQL Server at 22:10. I have used the same syntax because the driver name is same still getting errors. Please help
@Hustler19
3 ай бұрын
Bro, I'm facing the same problem! do you have resolve it?
@sambeetpanda6919
3 ай бұрын
@@Hustler19 hey were u able to solve this,m having same issue as well
@meghanagovindhu7358
3 ай бұрын
Bro can you pls help me ! Download the dataset in vscode when it runs it show an error
@vijaypratap8173
5 ай бұрын
Awesome😍😍😍😍
@malathithatipamula4051
2 ай бұрын
after cleaning i.e., after droping those 3 columns, can we connect this jupyter notebook to mysql workbench?? if yes, how do i that pls help me! if not, jst tell me the reason y it cant be connected to workbench. wht is difference b/w mysql workbench & Ms Sql server mngmt studio?
@ankitbansal6
2 ай бұрын
You can connect to MySQL. Just change the connection string
@mohammedaslam7372
Ай бұрын
How to load the data in to MySQL?
@hamzazahidulislam3490
3 ай бұрын
Thank you so much
@ankitbansal6
3 ай бұрын
You're most welcome
@chintanshah35
5 ай бұрын
Hi all, i am not able to see my odbc drivers details for sql.can anybody please help me out
@AnushaGanipisetty-t5u
20 күн бұрын
Hi, In my C drive i dont have .Kaggle folder so do we need to create new folder for .Kagglejson file to save
@ankitbansal6
20 күн бұрын
Yes
@ShivamGupta-wn9mo
4 ай бұрын
brilliant
@sowmya6471
5 ай бұрын
V useful
@srikrishnanr8155
5 ай бұрын
To insert or load data frames into sql what is the maximum number of rows that can be inserted
@misterymatters
2 ай бұрын
Bro, there is no limitations.
@atharvkalambkar9869
3 ай бұрын
can i use my pdf instead of kaggle
@vijaypradeep8315
5 ай бұрын
bro can you show us an project where you have done the analysis in python why did you do that and store in s3 bucket and so on .Can you make an vedio on pyspark as well
@ankitbansal6
5 ай бұрын
Sure
@PANDURANG99
4 ай бұрын
We can use power bi
@Blacksmiths23
Ай бұрын
mssql server connect code does not work
@professorx5823
4 ай бұрын
Hi sir how can I add this to my resume and what are the exact project description should I write for this project..please help ..So that I can write the same thing by myself for other kind of projects
@ankitbansal6
4 ай бұрын
Create a GitHub profile and put it there and use that link in your resume .
@maduguyamini6805
5 ай бұрын
Hi sir I have a doubt Top 5 highest selling products should be in terms of quantity right?
@ankitbansal6
5 ай бұрын
sales.
@rajvardhan465
4 ай бұрын
Your a goat 🐐 in data filed sir
@vivekbhatt7357
5 ай бұрын
Hello ankit i followed your video its great to learn . I have one scenario where i have two database one is postgrey and second mysql. what i need is there are 25 lakh product in mysql product table which has pricing and inventory which i want to update in postgrey database based on sku column which will be same. I used query and api its taking 4 to 5 hours to update can we do something with database to update pricing and inventory using procedure database to database. Please suggest
@ankitbansal6
5 ай бұрын
Using python you can move data from MySQL to postgres and then run update on postgres
@sabShrav
4 ай бұрын
hi , kaggle.json file is not found in home directory . please advise on this
@ankitbansal6
4 ай бұрын
Create yourself
@devendrabarasker4987
5 ай бұрын
Sir will not we multiply the quantity with sales price to get the overall sales price of particular product and then sum it????
@ankitbansal6
5 ай бұрын
We can do that. I assumed it was total sales in the sale price.
@devendrabarasker4987
5 ай бұрын
@@ankitbansal6 ok sir🙌
@saiteja-gb8ho
5 ай бұрын
Thank you so much Ankit bro
@g-ij9km
5 ай бұрын
yaaaaaay!!
@ushihaya
5 ай бұрын
How to find length of a feature in df to create identical column in database table
@ankitbansal6
5 ай бұрын
df.dtypes
@ushihaya
5 ай бұрын
Ji how to know what is the maximum length of a feature with decimal postions so that there will not be any data loss while uploading data to table
Пікірлер: 237