Data Manipulation in SQL

Offered byDataCamp

Data Manipulation in SQL
at
DataCamp
Overview

Equip with the skills needed to effectively manipulate and manage data within relational databases using SQL

Duration	4 hours
Mode of learning	Online
Difficulty level	Beginner
Official Website	Go to Website
Credential	Certificate

Data Manipulation in SQL
at
DataCamp
Highlights

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

Data Manipulation in SQL
at
DataCamp
Course details

Who should do this course?

Data Analysts and Scientists

Database Administrators

Business Analysts

Software Developers

What are the course deliverables?

Using subqueries and correlated subqueries for complex queries

Implementing common table expressions (CTEs) for better query organization

Applying window functions for advanced data analysis

Techniques for data normalization and denormalization

Handling missing values, duplicates, and outliers

Data type conversion and formatting

Understanding and analyzing query execution plans

Indexing strategies to improve query performance

More about this course

This course covers a wide range of data manipulation tasks, including data extraction, transformation, and loading (ETL), data cleaning, and complex query writing

Participants will learn how to efficiently manipulate large datasets, optimize queries for performance, and apply best practices for data management

The course begins with a review of basic SQL concepts and then delves into more advanced topics such as subqueries, common table expressions (CTEs), window functions, and transaction management

Data Manipulation in SQL
at
DataCamp
Curriculum

We'll take the CASE

Basic CASE statements

CASE statements comparing column values

CASE statements comparing two column values part 2

In CASE things get more complex

In CASE of rivalry

Filtering your CASE statement

CASE WHEN with aggregate functions

WHERE are the Subqueries?

Filtering using scalar subqueries

Filtering using a subquery with a list

Filtering with more complex subquery conditions

Subqueries in FROM

Joining Subqueries in FROM

Building on Subqueries in FROM

It's OVER

The match is OVER

What's OVER here?

Flip OVER your results

OVER with a PARTITION

PARTITION BY a column

PARTITION BY multiple columns

Sliding windows

Slide to the left

Data Manipulation in SQL
at
DataCamp
Faculty details

Mona Khalil

As a senior data scientist at Greenhouse, Mona answers questions related to how the hiring process can be improved to find better candidates quicker and reduce bias in the hiring process. They previously worked in education, marketing, and local government