The referred dataset is in .sqlite file format and not able to import to mysql workbench. Can anyone help me out plz ?

Ok. I've got a windows laptop. My Navicat is open. How do you download the EA Sports database? I downloaded it and it shows a lot of technobabble. What's next? Thanks.

Good video, just confusing that you have set columns as INT but set data in those columns as varchars

Adam whats with the jump in part 3? Have been trying for DAYS to spin up an instance and every single time I get the same error "Sorry, we encountered an error and were unable to complete your request Error ID: ad9760ef" so frustrating that i've made it to the final section but can't follow along and finish the reports. I guess i'll just switch to another BI tool because google cloud is so complicated for someone who's never used it or trying to follow along for the first time

That was excellent -- you just helped me loads with this video. Thanks mate!

This was helpful. Thank you!

Really helpful. We have been observing that enterprise data migrations have been using legacy methodology for too long

Should at least Provide the “DataSet.xls” file at open source level in the description directly and not with the paid course material ….. so that at least school students can practice at their own pace though working professionals can buy the course

Thank you for sharing your experience, it sounds like you had a tough time at the hospital - 28 days! I had a similar diagnosis and procedure two years ago, it's really important to act fast as my cancer hadn't spread. A dark humour always helps, I'm stealing the semicolon line ;) - nice work 🤭 Keep positive and best wishes for the rest of your recovery.

❤❤❤

can i get the link to the database

why date is in blue?

use higher resolution in your screen captures. Can barely read it

❤️

Is the artist Mcadam. The album I have no clue

Praying to God !! I need my Mentor !! 🙏🙏🙏

Hi Adam! Thank you so much for the video! I would like to clarify why we can join the inventory and s2 on different keys (item_id and ing_id)? I thought we could only join tables with the same key.

SQL = SELECT FROM WHERE GROUP BY HAVING ORDER BY + JOINS + TVCs + CTEs + WINDOW FUNCTIONS....etc Then you are good to go

I've got to say, I was a bit disappointed that I couldn't follow the tutorial all the way through to the end. I saw all of the positive comments and got excited, and even bought the data to follow along, which I did until the Looker part. At about 35:00, there is a huge jump, where the instructor explains that you should connect your database to an instance of MySQL in Looker. However, there is no explanation on how to do it. I tried setting it up by myself but was so lost. I was quite disappointed that I couldn't follow the tutorial from that point onwards. I think this was a good tutorial until that part, but IT IS NOT a Follow-Along type of tutorial, so keep that in mind!

One of my studies is Data Analytics, almost finished. But I'm still struggling with SQL. KAGGLE ... data to explore, clean, etc...!!! Great video, thank you. I hope to be better and know how to work with

Hi, great video, can you help me with this? Hi I have these values: Product | Sales | Price A 1500 10 B 5000 15 C 250 25 D 1700 30 Leader sales product price is 15 Want to get Product | Sales | Price | Price Diff A 1500 10 -33% B 5000 15 0% C 250 25 67% D 1700 30 100% How do i achieve this in looker studio using all my dimensions values? Thank you!

very clear and understandable english for not native people like me , ty god

getting a head start on studying before I take a college course on SQL in the fall

Your videos are great, thanks so much. I guess if we want to upload a table directly, and not write all the fields manually, it would be possible too right? :)

Nice work, subscribed. I would recommend to include a coda: always insert a semi-colon at the end of every statement as a best practice. In some db client apps like DBeaver, you are highly, highly advised to always end your statement with a semi-colon: ; else if you accidentally hit the "play/execute" button on the sql query file, the app will attempt to execute each and every single statement until it hits one that ends with a semi-colon.

Just waoo..! What a systematic approach.

I am sorry, but I cannot find the dataset link. Can anyone help?

Amen, I need my teacher back & well. God bless you

i wanna cry but im a man so i cant do that and even though women say its ok to be emotional do it at your peril, so instead ill say thank you for making sql actually quite fun, ive looked at so many tutorials and found learning python easier lol, but now i get it, damn you make it easy to understand, im at university now studying data science, between you, uni, and chat gpt, i feel invincible lol, thanks again.

just blown away, just thank you

Thank you very much Mr i see some changes once i decide to follow your videos

Keep taking care of your health, wishing you the best !

Thanks for all ur work

Love the tutorial, but please don't put a pay wall for the data! I had to stop quarter of the way because I cant get the data files I need. A donate tab is a far better option.

THANK YOU SO MUCH, could you explain how to get the instance connection name?

How to freeze header in looker studio dashboard?

I am getting errors when I import sheet files as csv files

Thank you sharing as I starting to transition into the BIA career

Thanks a lot

Great explanation but only 10 free tables, unless you upgrade to pro

How I will data font size increase in looker studio it is very little.

I like you and very thankful that you are good now, and wish to recover very soon, i know you will, and will be waiting for you 🙏

You elaborated SQL basics in such a great way that can be learned quickly and easy. Appreciated

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql

ref 10:49 , how come item_id under inventory table is connected to ing_id under recipe table ?

Any link to the FIFA dataset?

Brother thank you