SQL CTAS | How to Create SQL Tables From a Query | #SQL Course 30

☕ *Stay Connected*

📚 *Free Courses*

🎓 *If You Need Certifications*

⏱️ *Timestamp*
00:00 Intro
00:20 What are Tables?
03:05 Table Types
03:52 CREATE/INSERT vs CTAS
06:36 CTAS vs Views
11:26 CTAS Syntax
14:10 #1 Use Case: Optimize Performance
19:42 How to Refresh CTAS?
21:49 #2 Use Case: Creating a Snapshot
23:15 #3 Use Case: Physical Data Marts in DWH

#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*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*

[ndifsmurida]

It goes without saying that you are the best tech teacher across all platforms. The pizza analogy was smart, and it gave me a chuckle that you actually went to get a real pizza, ha ha ha! Thanks for sharing your knowledge with us.

[ajay_sahoo]

I am learning SQL from past 3 months. Everytime I see a SQL tutorial on youtube, I get bored when i reach joins topic but this is the first SQL tutorial I reached till views due to your presentation and teaching skills. Thank you Baraa.

[TheUnknowns]

Out of all the SQL tutorials that i have come across so far, this is the best ever explained one..with deep insight into the details..You are the best SQL tutor out here. Glad i came across your channel.

[schanduriable]

You are an amazing SQL teacher! Your explanations are incredibly clear and easy to follow. Thank you so much for sharing your knowledge, Barra!

[deepam.g]

I think we all can learn even Rocket Science like a cake walk if Baraa is a TEACHER. Flawless teaching.

[valeriamoscoso]

Hi Baraa, thank you so much!, I just passed my tableau cert and I wouldn't have done it without your videos

[SahilLodhi]

CTAS seems very useful as well and the way you explain their use cases in real life scenarios just make you the best teacher. Thank you so much baraa

[konstantinostsekmeres]

Top quality content like all your videos. Keep up the good work! You have a talent in passing through the knowledge. The least I can to is to refer your channel to my peers.

[kebincui]

Barra is the best SQL teacher 👍. With his creative teaching style, it is easier to understand the key points in the originally boring topics and easy to follow in practice. Thanks Barra ❤

[micaelzekarias]

Baraa As always I have no word to thank you. May God bless you all the time. With big respect Mike.

[bubletech]

Thank you so much for this amazing course you've provided for us. You're truly the best teacher I've ever had!

[mangorez]

Thank you Mr Baraa for your effort to create such a TOP Quality content!

[Jp-yxod]

Concepts are beautifully explained. Thanks!!

[sivasai]

great experience with all the videos baraa, completely sound knowledge with crisp detailing. cant help myself but liking all the videos and sharing it to my frnds.

[deepam.g]

I agree with all the POSITIVE comments here. LOADS OF THANKS BARAA.

[gowthamiheroorsrikanth]

Like always, An amazing video. It just feels like a delicious piece of cake :) I started falling in Love with SQL :)

[sandipkundu]

So, CTAS is very useful in some complex scenarios, just like how a pizza can satisfy hunger . By the way i love the facts between VIEWS & CTAS .

[TanveerAhmad-eicu]

Can you please create a detailed videos on indexing concept and performance tuning?

[joshacosta]

the coffee in that mug cant possibly be steaming every time lol, love the content mate

[infinitevideos]

I am learning so much .... Please do videos about data engineering and data related stuff more and more