Topic

SQL for Analytics

4 articles · 7 videos

Primary and foreign keys in SQL: what your warehouse enforcesArticle · SQL for AnalyticsPrimary and foreign keys in SQL: what your warehouse enforcesUnderstanding key constraints in SQL for data integrityArticle · SQL for AnalyticsUnderstanding key constraints in SQL for data integrityStored procedures in SQL explained: Benefits, examples, and use casesArticle · SQL for AnalyticsStored procedures in SQL explained: Benefits, examples, and use casesData masking explained: Secure your sensitive dataArticle · SQL for AnalyticsData masking explained: Secure your sensitive data

Videos

How to Use SUBQUERIES in SQL with ExamplesVideo · SQL for AnalyticsHow to Use SUBQUERIES in SQL with ExamplesJoining tables in SQL | INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, UNIONVideo · SQL for AnalyticsJoining tables in SQL | INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, UNIONLinking Database Tables | Primary & Foreign Keys | Data Analytics for BeginnersVideo · SQL for AnalyticsLinking Database Tables | Primary & Foreign Keys | Data Analytics for BeginnersWhat is a Query? Data Analytics for BeginnersVideo · SQL for AnalyticsWhat is a Query? Data Analytics for BeginnersLearn Basic SQL Queries in 20 minutes (Lesson 2) | Data Analytics for BeginnersVideo · SQL for AnalyticsLearn Basic SQL Queries in 20 minutes (Lesson 2) | Data Analytics for BeginnersHow to Use ChatGPT to Write SQL Queries for BigQuery From ScratchVideo · SQL for AnalyticsHow to Use ChatGPT to Write SQL Queries for BigQuery From ScratchLearn Basic SQL Queries in 20 minutes (Lesson 1) | Data Analytics for BeginnersVideo · SQL for AnalyticsLearn Basic SQL Queries in 20 minutes (Lesson 1) | Data Analytics for Beginners