🎬 Full Advanced Course: ua-cam.com/video/ELdz0dXzWGM/v-deo.html
This video, you'll learn how to create Tables from SQL Query and when to use this method.
⬇️ Free Materials (Downloads): datawithbaraa.substack.com
👉 Support & Subscribe to Channel: bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: bit.ly/3GiCVUE
► LinkedIn: www.linkedin.com/in/baraa-khatib-salkini/
► Website: www.datawithbaraa.com
► Newsletter: bit.ly/BaraaNewsletter
► PayPal: paypal.me/baraasalkini
► Join: ua-cam.com/channels/8_RSKwbU1OmZWNEoLV1tQg.htmljoin
📚 Free Courses
✅ Tableau: ua-cam.com/video/UcGF09Awm4Y/v-deo.html
✅ Tableau Project: ua-cam.com/video/UcGF09Awm4Y/v-deo.html
✅ SQL Basics: ua-cam.com/video/NTgejLheGeU/v-deo.htmlsi=2-m6dgYPRvoFUSgS
✅ SQL Advanced: ua-cam.com/video/ELdz0dXzWGM/v-deo.html
✅ ChatGPT: ua-cam.com/video/LJLNfei4i-c/v-deo.htmlsi=EhUNYN38dkswAvZH
🎓Other Platforms (Certifications)
► Udemy: bit.ly/BaraaUdemy
► Skillshare (1 Free Month): bit.ly/BaraaSkillshare
⭐ My favorite books: kit.co/DataWithBaraa/my-favorite-books
💻 My gear: kit.co/DataWithBaraa/my-desktop-gear
⏱️ 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**