Learn SQL for analytics. Learn both the theory and the practice so you can confidently solve hard SQL challenges on your own. No previous experience required and you'll do everything in your browser using BigQuery. Course resources: https://miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab Created by @vladdata741 ⭐️ Contents ⭐️ ⌨️ (00:00:00) Introduction ⌨️ (00:04:42) Syllabus & resources ⌨️ (00:09:04) Meet SQL! ⌨️ (00:10:30) Types of SQL statements ⌨️ (00:12:20) Why BigQuery ⌨️ (00:13:27) How to setup Google Cloud ⌨️ (00:17:02) How to avoid Google Cloud charges ⌨️ (00:22:11) Introduction to our data ⌨️ (00:23:16) How data is organized in BigQuery ⌨️ (00:26:53) Loading our data in BigQuery ⌨️ (00:30:09) The BigQuery Interface ⌨️ (00:37:54) Running our first query ⌨️ (00:46:20) How SQL organizes data ⌨️ (00:54:32) The SQL statement ⌨️ (00:56:05) The three orders of SQL operations ⌨️ (01:00:05) The logical order of SQL operations ⌨️ (01:03:28) Introduction to basics ⌨️ (01:04:10) SELECT and FROM ⌨️ (01:08:22) Transform columns with SELECT ⌨️ (01:19:32) The order of arithmetic operations ⌨️ (01:24:03) The WHERE filter ⌨️ (01:31:28) Boolean algebra ⌨️ (01:48:07) DISTINCT ⌨️ (01:52:04) Create BigQuery tables from queries ⌨️ (01:57:38) UNION 1 ⌨️ (02:05:15) UNION 2 ⌨️ (02:11:57) UNION 3 ⌨️ (02:19:58) UNION 4 ⌨️ (02:22:41) ORDER BY ⌨️ (02:28:52) LIMIT ⌨️ (02:34:06) CASE ⌨️ (02:52:29) Simple aggregations ⌨️ (03:06:59) Subqueries 1 ⌨️ (03:16:28) Subqueries 2 ⌨️ (03:25:46) Subqueries 3 ⌨️ (03:29:43) Nested queries ⌨️ (03:40:11) Common table expressions 1 ⌨️ (03:48:12) Common table expressions 2 ⌨️ (03:53:08) Common table expressions 3 ⌨️ (03:59:18) Joins ⌨️ (05:15:39) GROUP BY And Aggregations ⌨️ (06:04:11) Window Functions ⌨️ (07:09:50) Putting It All Together ⌨️ (07:15:56) Let's Solve A Hard SQL Challenge! ⌨️ (07:33:54) PostgreSQL Exercises - Introduction ⌨️ (07:42:00) PostgreSQL Exercises - Basic ⌨️ (08:10:33) PostgreSQL Exercises - Joins and Subqueries ⌨️ (08:56:45) PostgreSQL Exercises - Aggregations Pt. 1 ⌨️ (09:57:51) PostgreSQL Exercises - Aggregations Pt. 2 ⌨️ (10:57:51) PostgreSQL Exercises - Conclusion 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

On this week's episode of the podcast, freeCodeCamp founder Quincy Larson interviews Andrew Brown, a CTO-turned co-founder of ExamPro.co. Andrew created this cloud certification exam prep website with another Andrew – also from Canada, who also loves Star Trek. We talk about Andrew's early career fixing computers in the 90s, and his early freelance web development work. These ultimately lead to jobs and promotions that leveled him up to CTO. Andrew also shares his advice to devs who want to learn DevOps and Cloud Engineering, and which certs to prioritize. Andrew suffers from Muscle Tension Dysphonia, a disease that causes voice loss. He shares how he's using AI tools to get around this. Andrew also talks about his love of Tetris Attack (also known as Panel de Pon or Pokémon Puzzle League). He built a frame-perfect port for competitive online play. And of course, Andrew's favorite Star Trek episodes of all time. Can you guess what bass line I'm playing on my bass during the intro? It's the theme from a 90s cartoon. Be sure to follow The freeCodeCamp podcast in your favorite podcast app. And share this podcast with a friend. Let's inspire more folks to learn to code and build careers for themselves in tech. Also, I want to thank the 8,933 kind people who support our charity each month, and who make this podcast possible. You can join them and support our mission at: https://www.freecodecamp.org/donate Links we talk about during the interview: Just a few of Andrew's many freeCodeCamp cloud cert prep courses. (He has dozens more on freeCodeCamp's YouTube channel): https://www.freecodecamp.org/news/author/andrew/ His website, ExamPro.co: https://www.exampro.co/ American Mall simulator browser game by Bloomberg: https://www.bloomberg.com/features/american-mall-game/ The Greatest Generation podcast: https://maximumfun.org/podcasts/greatest-generation/

Learn how to implement WebSockets with Socket.IO. WebSockets provide a way for a web browser and a server to communicate with each other continuously without having to close the connection after each exchange. This makes it ideal for real-time applications, like live chat or gaming, where you need quick back-and-forth communication. Course developed by @CybernaticoByNishant Code: https://github.com/nishant-666/Multiplayer-dashboard-using-websockets 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

Learn how to implement RAG (Retrieval Augmented Generation) from scratch, straight from a LangChain software engineer. This Python course teaches you how to use RAG to combine your own custom data with the power of Large Language Models (LLMs). 💻 Code: https://github.com/langchain-ai/rag-from-scratch If you're completely new to LangChain and want to learn about some fundamentals, check out our guide for beginners: https://www.freecodecamp.org/news/beginners-guide-to-langchain/ ✏️ Course created by Lance Martin, PhD. Lance on X: https://twitter.com/rlancemartin ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Overview ⌨️ (0:05:53) Indexing ⌨️ (0:10:40) Retrieval ⌨️ (0:15:52) Generation ⌨️ (0:22:14) Query Translation (Multi-Query) ⌨️ (0:28:20) Query Translation (RAG Fusion) ⌨️ (0:33:57) Query Translation (Decomposition) ⌨️ (0:40:31) Query Translation (Step Back) ⌨️ (0:47:24) Query Translation (HyDE) ⌨️ (0:52:07) Routing ⌨️ (0:59:08) Query Construction ⌨️ (1:05:05) Indexing (Multi Representation) ⌨️ (1:11:39) Indexing (RAPTOR) ⌨️ (1:19:19) Indexing (ColBERT) ⌨️ (1:26:32) CRAG ⌨️ (1:44:09) Adaptive RAG ⌨️ (2:12:02) The future of RAG 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

In this applied Data Science Crash Course, we cover everything you need to know about A/B testing, from the concepts to the practical details they can apply in business. The course merges in-depth statistical analysis (think hypothesis testing, significance levels, and the nitty-gritty of pooled estimates, test statistics, p-values, and assessing statistical significance) with the kind of data science theories big tech firms rely on, all alongside practical Python tutorials for real-world test implementation. Plus, there's a real-life case study thrown in to help you understand the concepts more. ✏️ Course created by Tatev Karen Aslanyan. More from Tatev here: https://lunartech.ai/ ⭐️ Contents ⭐️ ⌨️ (0:00:00) Video Introduction ⌨️ (0:03:49) Introduction to Data Science and A/B Testing ⌨️ (0:05:38) Basics of A/B Testing in Data Science ⌨️ (0:07:06) Key Parameters of A/B Testing for Data Scientists ⌨️ (0:09:24) Formulating Hypotheses and Identifying Primary Metrics in Data Science A/B Testing ⌨️ (0:19:55) Designing an A/B Test: Data Science Approach ⌨️ (0:37:56) Resources for A/B Testing in Data Science ⌨️ (0:39:22) Analyzing A/B Test Results in Python: Data Science Techniques ⌨️ (1:01:00) Data Science Portfolio Project: Case Study with AB Testing ⌨️ (1:04:38) Reintroduction to A/B Testing in the Data Science Process ⌨️ (1:21:07) Data Science Techniques: Loading Data with Pandas for A/B Testing ⌨️ (1:29:19) Data Science Visualization: Using Matplotlib and Seaborn for A/B Test Click Data ⌨️ (1:38:38) Data Science Power Analysis: Understanding A/B Test Model Parameters ⌨️ (1:44:25) Data Science Calculations: Pooled Estimates and Variance for A/B Testing ⌨️ (2:06:48) Computing A/B Test P-Values: Data Science Methods for Statistical Significance ⌨️ (2:12:42) Practical Significance in A/B Testing: A Data Science Perspective ⌨️ (2:29:07) Conclusion: Wrapping Up A/B Testing in Data Science 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

Learn how to deploy to Digital Ocean. You'll learn to deploy Django projects but the steps are similar to deploy projects built with other frameworks. The server will run on Ubuntu 22.04, and you will learn how to use technologies like Nginx, Supervisor, Git, Gunicorn, Postresql and some more. ✏️ Course developed by @CodeWithStein Sign up for Digital Ocean: https://m.do.co/c/d3cdd4293e67 ⭐️ Contents ⭐️ ⌨️ (00:00) Introduction ⌨️ (01:21) Create account ⌨️ (02:15) Create server ⌨️ (07:53) Install software ⌨️ (11:52) Configure Postgresql ⌨️ (15:56) Users and environment ⌨️ (19:41) Requirements.txt ⌨️ (22:26) Separate settings file ⌨️ (24:01) Introducing Git ⌨️ (31:36) Environmental variables ⌨️ (33:16) Init database ⌨️ (36:46) Configure Gunicorn ⌨️ (45:25) Configure Supervisor ⌨️ (48:44) Configure Nginx ⌨️ (57:38) SSL / Let's Encrypt ⌨️ (59:26) Repeat procedure 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

On this week's episode of the podcast, freeCodeCamp founder Quincy Larson interviews Kass Moreno, a Senior Front End Developer and CSS Artist. Kass started learning coding at age 28 and has since built a reputation as one of the most skilled artists who work with CSS. We talk about: Her childhood in Mexico and in Texas Making the hard decision to drop out of architecture school Her dreadful years working as a salesperson Learning from freeCodeCamp and doing the 100DaysOfCode challenge Getting freelance clients and expanding her skills Her rapid career growth as a developer Can you guess what bass line I'm playing on my bass during the intro? It's a 1982 pop classic. Be sure to follow The freeCodeCamp podcast in your favorite podcast app. And share this podcast with a friend. Let's inspire more folks to learn to code and build careers for themselves in tech. Also, I want to thank the 8,904 kind people who support our charity each month, and who make this podcast possible. You can join them and support our mission at: https://www.freecodecamp.org/donate Links we talk about during the interview: Kass's portfolio of CSS art: https://www.cssartist.com/ Bruno Simon's 3D interactive portfolio using Three.js. Drive an RC car around knocking things down: https://bruno-simon.com/ 1 Dimensional PacMan game that Quincy mentions (be careful – it's addictive): https://abagames.github.io/crisp-game-lib-11-games/?pakupaku 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

Learn how to turn Figma designs into code using AI. In this course, you will learn how to easily create and deploy frontend code starting with just a design. ✏️ Course developed by @AniaKubow Sample Figma design to follow along: https://www.figma.com/community/file/1344907822759018861/localhost-website Get started with Locofy: https://www.locofy.ai/ 🏗️ Locofy provided a grant to make this course possible. ⭐️ Contents ⭐️ ⌨️ (0:00:00) Introduction ⌨️ (0:01:54) What is Figma? ⌨️ (0:02:22) The design ⌨️ (0:06:28) Locofy Lightning and LocoAI ⌨️ (0:25:18) Let’s build out our app! ⌨️ (0:40:45) Sync to GitHub ⌨️ (0:49:40) Create a Database ⌨️ (0:54:49) Create Authentication ⌨️ (1:28:20) Let’s deploy our app! 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

This video is a full project-based backend web development course. In this course, you will learn how to build 3 full backend web applications. ✏️ Course developed by Code With Tomi. Check out his channel: https://www.youtube.com/c/CodeWithTomi Backend Mastery Course - https://backendmastery.com/ Projects Built: 1. AI Web App 💻 Github: https://github.com/tomitokko/ai-blog-article-generator 2. Netflix Clone 💻 Github: https://github.com/tomitokko/django-netflix-clone 3. Spotify Clone 💻 Github: https://github.com/tomitokko/spotify-clone 🔗 API Link: https://rapidapi.com/DataFanatic/api/spotify-scraper ⭐️ Course Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:01:30) AI Web App ⌨️ (3:07:35) Netflix Clone ⌨️ (6:11:33) Spotify Clone - Part 1 ⌨️ (6:33:25) Spotify Clone - Part 2 ⌨️ (6:55:45) Spotify Clone - Part 3 ⌨️ (9:50:21) Spotify Clone - Part 4 ⌨️ (10:07:48) Outro 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan 👾 Oscar Rahnama -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

On this week's episode of the podcast, freeCodeCamp founder Quincy Larson interviews Jabril. He's an indie game developer who's building a turn-based fighting game called Ultrabouters. Jabril has developed tons of other games as well. He runs the popular Jabrils gamedev focused-YouTube. He's also published a 5-hour introduction to programming course on freeCodeCamp. We talk about: - Jabril's advice to gamedevs who want to make a career out of building video games - How Jabril got into gamedev as a kid when he got a copy of GameMaker - Jabril's career working at a comedy club and a radio station - The anime that Jabril's been working on for years - Why Jabril puts an "s" at the end of his name Can you guess what bass line I'm playing on my bass during the intro? It's a 2009 song that became popular in the 2010's by being associated with a meme. Be sure to follow The freeCodeCamp podcast in your favorite podcast app. And share this podcast with a friend. Let's inspire more folks to learn to code and build careers for themselves in tech. Also, I want to thank the 8,509 kind people who support our charity each month, and who make this podcast possible. You can join them and support our mission at: https://www.freecodecamp.org/donate Links we talk about during the interview: Jabril's full length Programming for Beginners course on freeCodeCamp: https://www.freecodecamp.org/news/programming-for-beginners-how-to-code-with-python-and-c-sharp/ That time Quincy angered the entire BTS army with a confused tweet: https://twitter.com/ossia/status/993171422863417344 "The best episodes of Shark Tank are the bad ideas." How Jabril created a Fake Shark Tank Episode Generator using AI tools: https://www.youtube.com/watch?v=gcGjYivktyc Subscribe to Jabril on YouTube: @Jabrils