Advanced SQL Tutorial | Temp Tables

In today's Advanced SQL lesson we walk through how to use Temp Tables.

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[kstevens]

Great tutorial! Only thing I would add is that temp tables are session or query window specific. If you close your current session the table will not be there as you expect a regular table would. I am always learning so I cant wait to watch more!

[AkporHari]

Thank you, Alex. You give the quickest easy-to-understand tutoring I have received on my DA journey. You explain these things well, and you do not overload the learner with more than they need per time.
One helpful thing I do is practice while I watch and play around with it as you teach. I often break something, though, and that helps too.

[rajpreetcheema]

Hi Alex,
You are so sweet and positive. I been through many of your videos and to be honest I feel hope from you. Seeing you gives hope. Thanks for existing. 🙂

[seekerj]

Such a great example. I was looking for a solution for something I’m working on at work and this is ‘drop table is exist’ is perfect. Thank you.

[shanh]

Once again a great tutorial!! This is the next concept in the Google data analytics course. Thank you so much you made it smooth digestible.

[rachrach]

Great tutorial! This is like querying a query. I’m learning a lot from your videos. Thank you Alex

[uuphqie]

For anyone following along in postgreSQL, use TEMP or TEMPORARY to create your temporary tables. Unfortunately, postgreSQL doesn't recognize the # sign in creating temp tables.
EX:

CREATE TEMP TABLE temp_employee(
employeeid INT,
jobtitle VARCHAR(100),
salary INT
);

[terihandrick]

I just want to say thank you so much for your video's I have learnt more today than I have ever known about SQL and will continue subscribe. You are a HUGE help!!

[oguzozakn]

I got exactly the information I was looking for and I started following your channel, thanks.

[ahmetalperenyildirim]

Simple and functional as always, thanks Alex, data loves you! :)

[sanilkumarbarik]

Liking the video even before start watching it.
That's the faith I have on Alex.

[sisiphosidiya]

Alex Thanks man! All the way from South Africa

[yon_draper]

Helpful video, especially the DROP TABLE tip. Thank you sir

[PlusHD]

I'm preparing for a interview, very helpful video. Thank you

[cloudkungfu]

Nitro shot of knowledge to the brain just when I needed it 💯

[pavodecampo]

Wow! I love the "DROP TABLE IF EXISTS..." command. Really useful too! Thanks Alex. You're GREAT!

[jacquelineconerly]

Ten minutes goes by fast. This was much needed.

[oscarnests]

Thanks for the good content created for free, it is very useful. I would like to add a little bit of information, if you use one # sign the temp table would be considered local (you can use it only in your currect query window), if you use double ## sign the table would be global (you can use it in a new query window). As they mentioned before, when you close the session the tables will be gone forever, so you need to create them again. My two cents!

[goldencricketstars]

Hi Alex your tutorial are game-changing for me. can we combine a temporary table and cte

[tristanwaititlegendary]

You can also check the existence of temporary tables using object explorer. In the object explorer, expand TEMPDB database folder, and then exapand TEMPORARY TABLES folder, and you should see the temporary table that we have created.