Advanced SQL Tutorial | Temp Tables

The first use case is not really straightforward to me. Can someone point me to a different example that I might find more clear please?

Thanks Alex

Alex often uses the expression to hit sth. off of sth. What does it mean? To copy? To extract? I tried to google this expression, but couldn't find anything that would apply to this context. Can anyone help?

Can anyone explain what the number is we put inside parenthese in fron of VARCHAR?

I don't think # is a pound sign. I call it a hash sign. :)

Hi Alex, kindly explain the difference between 'text' and 'varchar' and why you have to use a parenthesis right after the varchar?

What do you mean by hit off?

Thanks for this Alex!

For those who are working with mysql, the view statement is used as temp tables. I wrote the query in this way:

CREATE view temp_Employee as
SELECT demo.EmployeeID, sal.JobTitle, sal.Salary
FROM employeedemographics demo
JOIN employeesalary sal
ON demo.EmployeeID=sal.EmployeeID;

When I inserted values, I got two the same rows while I did the same as you. Do you know why two same rows has been created for me (EmployeeID: 1001)?

Nice and easy thanks

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
);

Where can I find the temp table

These tutorials are amazing! Thanks so much, Alex. Question: Why would a person use a temp table if it is just session-specific. Why wouldn't one just create a new table using a past query so that it is stored permanently, for use later?

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

can you explain the meaning of varchar? i get the int as integer type of data, but what is varchar? why not put string?

Thanks a lot!

Nice

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

Hello Alex, Could you please explain the difference between Temp tables and CTEs. Also, when should you use which one?

Done

thank You Sr <3

How do i improve the skill of knowing different ways to write a code for the same output. Does learning python improves vocabulary of coding? I am aspiring data analyst and i want to master this skill of yours? plz reply....u speak simple and clear in ur videos. Thanks.

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

Why not to use CREATE TABLE IF NOT EXISTS instead of dropping it and re-creating it again ?

Thanks, really helfpul.

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

Great helpful tutorials.

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.

Thanks much alot

Whenever I created and inserted data in temp table and shut down my computer and come back and select the temp table it doesn’t work I have to Crete and insert datas again and again when ever I come back into it.
Can you please give me some solution for me
Thanks

Yes, I like this video 😀
Thank you!

Great video tutorial

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.

I want to retrieve a row by a max value in a specific column…
Example: I have location, date, and temperature columns. I want to have max temperature in each location with corresponding date. Anyone can help?

Great thanks 👍👌

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

Thank you but I don't understand the advantage of temp tables. Would ot using queries without them be faster? You just added more steps. This is my first time seeing a video regarding temp tables btw.

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

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.

I would like to ask a question. is there any book that you suggest to read for SQL Server? I want a book with full 100% documentation and to learn in deep SQL server.

super, thank you

Whats the point of creating a temp table over a regular view? Is it mainly to do with storage efficiencies. Why not just Drop the table when you're down with it? Or is it because temp tables are good for stored procedures because its more efficient? thanks! just trying to figure it out

You know what's magical / lifesaving? Putting a query result in a temp table.

Geat tutorial. Please, what do the two dots (..) between the table and column mean? Thanks for the video!

Hello Alex, thanks for these videos. How can I delete duplicates on my table?

Это лучшее видео на свете