SQL Fundamentals

Offered byDataCamp

SQL Fundamentals
at
DataCamp
Overview

Gain the fundamental SQL skills you need to interact with and query your data

Duration	26 hours
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

SQL Fundamentals
at
DataCamp
Highlights

Earn a certificate after completion of the course
Learn from the industry best faculty

SQL Fundamentals
at
DataCamp
Course details

Who should do this course?

Aspiring Data Analysts and Scientists

Database Administrators

Business Analysts

Software Developers

What are the course deliverables?

Overview of SQL and its role in database management

Understanding relational databases and database management systems (DBMS)

Writing SELECT statements to retrieve data from tables

Filtering data with WHERE clauses

Sorting and limiting query results with ORDER BY and LIMIT

Inserting new records into tables with INSERT statements

Updating existing records with UPDATE statements

Deleting records from tables with DELETE statements

More about this course

In this course you'll learn the SQL fundamentals you need to level up your data skills. Through hands-on exercises, you’ll discover SQL basics, such as how to structure and query relational databases

As you progress, you’ll use these foundations to quickly summarize and join tables and use window functions and built-in PostgreSQL functions to analyze your data

By the time you finish this track, you’ll have a firm understanding of the SQL essentials and have the confidence to apply them to your own data sets

SQL Fundamentals
at
DataCamp
Curriculum

Introduction to SQL

Learn how to create and query relational databases using SQL in just two hours

Intermediate SQL

Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today

Analyzing Students' Mental Health

Use your data manipulation skills to perform exploratory data analysis on a dataset around student mental health

Joining Data in SQL

Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries

Data Manipulation in SQL

Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL

PostgreSQL Summary Stats and Window Functions

Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon

Functions for Manipulating Data in PostgreSQL

Learn the most important PostgreSQL functions for manipulating, processing, and transforming data

Database Design

Learn to design databases in SQL to process, store, and organize data in a more efficient way

Data Analysis in SQL (PostgreSQL)

SQL Fundamentals
at
DataCamp
Faculty details

Izzy Weber

Izzy is a Curriculum Manager at DataCamp. She discovered a love for data during her seven years as an accounting professor at the University of Washington. Her passion is making learning technical topics fun.