SQL for Absolute Beginners

DataCamp · Beginner ·📊 Data Analytics & Business Intelligence ·2y ago

Key Takeaways

This video covers the basics of SQL, including retrieving data from databases, manipulating data, and basic SQL queries, providing a solid foundation for further learning in data science.

Original Description

Data skills are the cornerstone of the 21st-century workforce, and SQL is foundational for any role that involves data. Understanding and effectively using SQL can open doors to greater productivity, better decision-making capabilities, and more career opportunities in this era of digital transformation. In this live training, we'll start from the very basics of what SQL is and why it's essential. We will journey through key components such as retrieving data from databases, manipulation of data, and basic SQL queries. By the end of this training, you'll have a solid foundation of SQL and its applications, preparing you for further learning in data science. Key Takeaways: - A thorough introduction to why SQL is foundational to learn in the 21st century - A deep dive into basic SQL commands on real world data - An overview of advanced SQL topics, and a discussion of the art of the possible with SQL Code Along with Us! https://bit.ly/450W9at Link to slides: https://bit.ly/463b31q [WEBINAR] Ace the SQL Interview: https://bit.ly/3PGV17o [WEBINAR] Supermarket Transaction Analysis in SQL: https://bit.ly/3PK7aIO [CHEAT SHEET] SQL Basics Cheat Sheet: https://bit.ly/48iOgA2 [CHEAT SHEET] SQL Joins Cheat Sheet: https://bit.ly/3PTKvtT [SKILL TRACK] Learn SQL: https://bit.ly/44SMV01 [TUTORIAL] SQL with Power BI: https://bit.ly/3sRTSks [TUTORIAL] SQL Tutorial: How To Write Better Queries: https://bit.ly/44TD0XP [COURSE] Introduction to SQL: https://bit.ly/3t1iYxz [COURSE] Joining Data in SQL: https://bit.ly/45WhNhr [COURSE] Exploratory Data Analysis in SQL: https://bit.ly/3EGK7IG
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from DataCamp · DataCamp · 0 of 60

← Previous Next →
1 SQL Server Tutorial: Date manipulation
SQL Server Tutorial: Date manipulation
DataCamp
 2 R Tutorial: Intermediate Interactive Data Visualization with plotly in R
R Tutorial: Intermediate Interactive Data Visualization with plotly in R
DataCamp
 3 R Tutorial: Adding aesthetics to represent a variable
R Tutorial: Adding aesthetics to represent a variable
DataCamp
 4 R Tutorial: Moving Beyond Simple Interactivity
R Tutorial: Moving Beyond Simple Interactivity
DataCamp
 5 Python Tutorial: Why use ML for marketing? Strategies and use cases
Python Tutorial: Why use ML for marketing? Strategies and use cases
DataCamp
 6 Python Tutorial: Preparation for modeling
Python Tutorial: Preparation for modeling
DataCamp
 7 Python Tutorial: Machine Learning modeling steps
Python Tutorial: Machine Learning modeling steps
DataCamp
 8 R Tutorial: The prior model
R Tutorial: The prior model
DataCamp
 9 R Tutorial: Data & the likelihood
R Tutorial: Data & the likelihood
DataCamp
 10 R Tutorial: The posterior model
R Tutorial: The posterior model
DataCamp
 11 R Tutorial: An Introduction to plotly
R Tutorial: An Introduction to plotly
DataCamp
 12 R Tutorial: Plotting a single variable
R Tutorial: Plotting a single variable
DataCamp
 13 R Tutorial: Bivariate graphics
R Tutorial: Bivariate graphics
DataCamp
 14 Python Tutorial: Customer Segmentation in Python
Python Tutorial: Customer Segmentation in Python
DataCamp
 15 Python Tutorial: Time cohorts
Python Tutorial: Time cohorts
DataCamp
 16 Python Tutorial: Calculate cohort metrics
Python Tutorial: Calculate cohort metrics
DataCamp
 17 Python Tutorial: Cohort analysis visualization
Python Tutorial: Cohort analysis visualization
DataCamp
 18 R Tutorial: Building Dashboards with flexdashboard
R Tutorial: Building Dashboards with flexdashboard
DataCamp
 19 R Tutorial: Anatomy of a flexdashboard
R Tutorial: Anatomy of a flexdashboard
DataCamp
 20 R Tutorial: Layout basics
R Tutorial: Layout basics
DataCamp
 21 R Tutorial: Advanced layouts
R Tutorial: Advanced layouts
DataCamp
 22 Python Tutorial: Time Series Analysis in Python
Python Tutorial: Time Series Analysis in Python
DataCamp
 23 Python Tutorial: Correlation of Two Time Series
Python Tutorial: Correlation of Two Time Series
DataCamp
 24 Python Tutorial: Simple Linear Regressions
Python Tutorial: Simple Linear Regressions
DataCamp
 25 Python Tutorial: Autocorrelation
Python Tutorial: Autocorrelation
DataCamp
 26 R Tutorial: The gapminder dataset
R Tutorial: The gapminder dataset
DataCamp
 27 R Tutorial: The filter verb
R Tutorial: The filter verb
DataCamp
 28 R Tutorial: The arrange verb
R Tutorial: The arrange verb
DataCamp
 29 R Tutorial: The mutate verb
R Tutorial: The mutate verb
DataCamp
 30 R Tutorial: What is cluster analysis?
R Tutorial: What is cluster analysis?
DataCamp
 31 R Tutorial: Distance between two observations
R Tutorial: Distance between two observations
DataCamp
 32 R Tutorial: The importance of scale
R Tutorial: The importance of scale
DataCamp
 33 R Tutorial: Measuring distance for categorical data
R Tutorial: Measuring distance for categorical data
DataCamp
 34 Python Tutorial: Plotting multiple graphs
Python Tutorial: Plotting multiple graphs
DataCamp
 35 Python Tutorial: Customizing axes
Python Tutorial: Customizing axes
DataCamp
 36 Python Tutorial: Legends, annotations, & styles
Python Tutorial: Legends, annotations, & styles
DataCamp
 37 Python Tutorial: Introduction to iterators
Python Tutorial: Introduction to iterators
DataCamp
 38 Python Tutorial: Playing with iterators
Python Tutorial: Playing with iterators
DataCamp
 39 Python Tutorial: Using iterators to load large files into memory
Python Tutorial: Using iterators to load large files into memory
DataCamp
 40 SQL Tutorial: Introduction to Relational Databases in SQL
SQL Tutorial: Introduction to Relational Databases in SQL
DataCamp
 41 SQL Tutorial: Tables: At the core of every database
SQL Tutorial: Tables: At the core of every database
DataCamp
 42 SQL Tutorial: Update your database as the structure changes
SQL Tutorial: Update your database as the structure changes
DataCamp
 43 Python Tutorial: Classification-Tree Learning
Python Tutorial: Classification-Tree Learning
DataCamp
 44 Python Tutorial: Decision-Tree for Classification
Python Tutorial: Decision-Tree for Classification
DataCamp
 45 Python Tutorial: Decision-Tree for Regression
Python Tutorial: Decision-Tree for Regression
DataCamp
 46 Python Tutorial: Census Subject Tables
Python Tutorial: Census Subject Tables
DataCamp
 47 Python Tutorial: Census Geography
Python Tutorial: Census Geography
DataCamp
 48 Python Tutorial: Using the Census API
Python Tutorial: Using the Census API
DataCamp
 49 R Tutorial: A/B Testing in R
R Tutorial: A/B Testing in R
DataCamp
 50 R Tutorial: Baseline Conversion Rates
R Tutorial: Baseline Conversion Rates
DataCamp
 51 R Tutorial: Designing an Experiment - Power Analysis
R Tutorial: Designing an Experiment - Power Analysis
DataCamp
 52 R Tutorial: Introduction to qualitative data
R Tutorial: Introduction to qualitative data
DataCamp
 53 R Tutorial: Understanding your qualitative variables
R Tutorial: Understanding your qualitative variables
DataCamp
 54 R Tutorial: Making Better Plots
R Tutorial: Making Better Plots
DataCamp
 55 SQL Tutorial: OLTP and OLAP
SQL Tutorial: OLTP and OLAP
DataCamp
 56 SQL Tutorial: Storing data
SQL Tutorial: Storing data
DataCamp
 57 SQL Tutorial: Database design
SQL Tutorial: Database design
DataCamp
 58 Python Tutorial: Introduction to spaCy
Python Tutorial: Introduction to spaCy
DataCamp
 59 Python Tutorial: Statistical Models
Python Tutorial: Statistical Models
DataCamp
 60 Python Tutorial: Rule-based Matching
Python Tutorial: Rule-based Matching
DataCamp

This video provides an introduction to SQL, covering the basics of querying and manipulating data, and preparing learners for further study in data science. By the end of the video, learners will have a solid foundation in SQL and its applications. The video is designed for absolute beginners, making it accessible to those new to data analytics.

Key Takeaways
  1. Download the SQL basics cheat sheet
  2. Complete the introductory SQL course
  3. Practice writing basic SQL queries
  4. Explore advanced SQL topics
  5. Apply SQL skills to real-world data analysis
💡 Understanding SQL is foundational for any role that involves data, and can open doors to greater productivity, better decision-making capabilities, and more career opportunities.

Related Reads

📰
12.4 Million US Business Registrations Are Sitting on State Open-Data Portals, Free
Unlock 12.4 million US business registrations for free from state open-data portals and boost your business intelligence
Dev.to · Brad Ju
 📰
Mau Naik Level? Ini Advanced Data Science Techniques untuk Data Analytics
Learn advanced data science techniques for data analytics to improve business decision-making
Medium · Data Science
 📰
I Finally Understood AWS Data Pipelines After Following a Single Customer Click
Learn how to understand AWS Data Pipelines by following a customer click, making it easier to design and implement data workflows
Dev.to · Anupa Supul
 📰
Beyond the Basics: Streamlit, Dash, and Bokeh for Interactive Dashboards
Learn to create interactive dashboards with Streamlit, Dash, and Bokeh, going beyond basic data visualization tools
Dev.to · RoyserVillanueva
Up next
ChatGPT Will Make Your Excel & Google Sheets x10 Better!
Educraft
Watch →