SQL CTAS | How to Create SQL Tables From a Query |
🎬 Full Advanced Course: • How I'd Learn Advanced SQL and Why (I...
This video, you'll learn how to create Tables from SQL Query and when to use this method.
⬇️ Free Materials (Downloads): https://datawithbaraa.substack.com
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE
☕ Stay connected
► Subscribe: http://bit.ly/3GiCVUE
► LinkedIn: / baraa-khatib-salkini
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join: / @datawithbaraa
📚 Free Courses
✅ Tableau: • Complete HR Tableau Project End-to-En...
✅ Tableau Project: • Complete HR Tableau Project End-to-En...
✅ SQL Basics: • SQL Tutorial for Beginners [Ultimate ...
✅ SQL Advanced: • How I'd Learn Advanced SQL and Why (I...
✅ ChatGPT: • ChatGPT Tutorial for Beginners [Ultim...
🎓Other Platforms (Certifications)
► Udemy: https://bit.ly/BaraaUdemy
► Skillshare (1 Free Month): https://bit.ly/BaraaSkillshare
⭐ My favorite books: https://kit.co/DataWithBaraa/my-favor...
💻 My gear: https://kit.co/DataWithBaraa/my-deskt...
⏱️ 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*
