Introduction To SQL & Databases
Bryan Jenks - A tech enthusiast and Programmer
▬▬▬▬▬▬▬▬▬▬ ► CHECK THESE OUT ◀︎▬▬▬▬▬▬▬▬▬▬ 📧️ NEWSLETTER: https://bryanjenkstech.ck.page/d4ec0713d5 💬 DISCORD: https://discord.gg/MxCVshN 🗣️ SOCIALS: https://linktr.ee/bryanjenks ▬▬▬▬▬▬▬▬▬▬ ► SUPPORT THE CHANNEL ◀︎▬▬▬▬▬▬▬▬▬▬ 👨🏻💻️ GITHUB SPONSOR: https://github.com/sponsors/tallguyjenks 🙏🏻️ AMAZON WISHLIST: https://www.amazon.com/hz/wishlist/ls/17FRLE35NC7G8?ref_=wl_share 😇 PATREON: https://www.patreon.com/bryanjenks?fan_landing=true 🙌🏻️ YOUTUBE MEMBERSHIP: https://www.youtube.com/c/BryanJenksTech/join ☕ BUY ME A COFFEE: https://www.buymeacoffee.com/tallguyjenks 💵 PAYPAL: https://www.paypal.me/tallguyjenks 📊️ FREE STOCKS: http://join.robinhood.com/bryanj67 ▬▬▬▬▬▬▬▬▬▬ ► My Newsletter ◀︎▬▬▬▬▬▬▬▬▬▬ 📧️ NEWSLETTER: https://bryanjenkstech.ck.page/d4ec0713d5 ▬▬▬▬▬▬▬▬▬▬ ► My Gear ◀︎▬▬▬▬▬▬▬▬▬▬ ⚙️GEAR: https://kit.co/tallguyjenks/my-gear ▬▬▬▬▬▬▬▬▬▬ ► Questions? ◀︎▬▬▬▬▬▬▬▬▬▬ ❓️FAQ: https://github.com/BryanJenksCommunity/FAQ/discussions ▬▬▬▬▬▬▬▬▬▬ ► Social ◀︎▬▬▬▬▬▬▬▬▬▬ 💬 DISCORD: https://discord.gg/MxCVshN 🐦 TWITTER: https://twitter.com/tallguyjenks 📜️ MEDIUM: https://medium.com/@tallguyjenks 💼️ LINKEDIN: https://www.linkedin.com/in/bryanjenks/ 🖥️ GITHUB: https://github.com/tallguyjenks 🌎 WEBSITE: https://www.bryanjenks.dev/ ▬▬▬▬▬▬▬▬▬▬ ► The Rest ◀︎▬▬▬▬▬▬▬▬▬▬ Thanks for watching and if you liked this video please leave a 👍🏻 Subscribe to my channel and click the 🔔 icon for notifications when I post a new video
If you read this far put a 🐄 in the comments! ▬▬▬▬▬▬▬▬▬▬ ► TAGS ◀︎▬▬▬▬▬▬▬▬▬▬ #obsidian #zettelkasten #bryanjenks
▬▬▬▬▬▬▬▬▬▬ ► TIMESTAMPS ◀︎▬▬▬▬▬▬▬▬▬▬
0:00:00 - Intro 0:00:33 - Support the Channel 0:00:54 - What is SQL? 0:01:20 - What Does A Database look like? 0:06:03 - Database objects 0:29:38 - SQL Language Syntax 0:30:18 - USE Database 0:31:22 - Basic SELECT Statement 0:32:47 - DISTINCT Keyword 0:34:02 - The WHERE Clause 0:34:56 - Aggregation Functions 0:37:59 - Aliasing New Columns 0:39:00 - Date Range Operator BETWEEN 0:42:24 - The IN Operator 0:43:11 - GROUP BY 0:44:58 - The HAVING Clause 0:45:36 - Exclude NULL 0:48:44 - SQL JOINS 0:51:06 - Aliasing Tables 0:52:29 - INNER JOIN 0:53:45 - LEFT JOIN 0:55:02 - RIGHT JOIN 0:55:48 - FULL OUTER JOIN 0:58:05 - Date Functions 1:02:37 - Integer Functions 1:03:16 - CAST Data Types 1:0 ... https://www.youtube.com/watch?v=Vzj9S0XpPbI
563738522 Bytes