SQL Portfolio Project - Part 2 - Zomato | Analytics | Ashutosh Kumar скачать в хорошем качестве

SQL Portfolio Project - Part 2 - Zomato | Analytics | Ashutosh Kumar

The best technique of learning a skill is completing a project which is based on real life scenario and when it comes to analytics , SQL is the one of the most asked skillset in all the interviews, so friends in this video i have created an end to end project on data analysis using SQL, thi will be relevant to all those people who want to make a career into data analytics, business analytics ,data science , in this video i have analysis on zomato dataset . You can find the code attached below - drop table if exists goldusers_signup; CREATE TABLE goldusers_signup(userid integer,gold_signup_date date); INSERT INTO goldusers_signup(userid,gold_signup_date) VALUES (1,'09-22-2017'), (3,'04-21-2017'); drop table if exists users; CREATE TABLE users(userid integer,signup_date date); INSERT INTO users(userid,signup_date) VALUES (1,'09-02-2014'), (2,'01-15-2015'), (3,'04-11-2014'); drop table if exists sales; CREATE TABLE sales(userid integer,created_date date,product_id integer); INSERT INTO sales(userid,created_date,product_id) VALUES (1,'04-19-2017',2), (3,'12-18-2019',1), (2,'07-20-2020',3), (1,'10-23-2019',2), (1,'03-19-2018',3), (3,'12-20-2016',2), (1,'11-09-2016',1), (1,'05-20-2016',3), (2,'09-24-2017',1), (1,'03-11-2017',2), (1,'03-11-2016',1), (3,'11-10-2016',1), (3,'12-07-2017',2), (3,'12-15-2016',2), (2,'11-08-2017',2), (2,'09-10-2018',3); drop table if exists product; CREATE TABLE product(product_id integer,product_name text,price integer); INSERT INTO product(product_id,product_name,price) VALUES (1,'p1',980), (2,'p2',870), (3,'p3',330); select * from sales; select * from product; select * from goldusers_signup; select * from users; ---------------------------------------------------------------------------------------------------------------------- Check out some more relevant content here 👉 SQL Portfolio Project Indian Census- Part 2    • SQL Portfolio Project - Part 2 | Analytics...   👉 SQL Portfolio Project - Shark Tank India    • SQL Portfolio Project - Shark Tank India |...   👉 How to Learn SQL    • How to learn sql for beginners | Step by s...   👉 Complete playlist on Sql Interview questions and answers    • HackerRank SQL problems and solution   👉 Top free and best resources to learn analytics -    • Free and Best resources to learn analytics   👉 How to become a data analyst complete roadmap-    • Data Analyst Complete Roadmap in 2022 | Fr...   👉 Data analytics internships and job stipend-    • 70,000 + per month data analyst internship...   👉 Top 3 you tube channels to learn sql for free for beginners    • Видео   👉 How to get data analytics internships-    • How to apply for data analyst internships   👉Check out the roadmap to become a business analyst -   • Business Analyst Complete Roadmap in 2022 ...   👉All about analytics playlist-    • All about analytics   👉 Top 3 you tube channels to learn excel for free for beginners    • Top 3 you tube channels to learn excel for...   ____________________________________________________________________ Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - https://docs.google.com/forms/d/e/1FA... Why you should definitely fill the analytics job updates google form -    • Job Openings into business analyst data an...   _______________________________________________________________________ Connect with me 📸Instagram -   / ashutoszh   💻Linkedin-   / ashutosh.analytics   _____________________________________________________________________ Comment down if you have any doubts Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science. _____________________________________________________________________ 🏷️ Tags sql, sql for analytics, sql tutorials for beginners, portfolio project sql, sql portfolio project, portfolio project on sql for resume, sql interview portfolio project, sql interview questions and answers, sql for data analytics, sql data science, interview questions on sql, sql hard questions, sql problem solving, ashutosh, ashutosh kumar, ashutosh kumar analytics 🏷️ HashTags #sql #portfolio #project