Datacamp – Data Analyst in SQL 2023-11

Data Analyst in SQL, Database design is critical for a high-performance application. Just like you wouldn’t build a house without a blueprint, you need to plan how you’ll store your data beforehand. In this interactive SQL track, you’ll learn the fundamentals of database design and how to: ✓ Write basic SQL queries ✓ Group and aggregate data to produce summary statistics ✓ Join tables and apply filters and sub-queries ✓ Write functions to explore and manipulate data Working with real-world datasets, gain the SQL skills you need to query a database, analyze results, and effectively communicate your insights to stakeholders. There’s no prior SQL knowledge required—start your journey to becoming a confident data analyst.

What you’ll learn

• Introduction to SQL
• Joining Data in SQL
• Data Manipulation in SQL
• PostgreSQL Summary Stats and Window Functions
• Functions for Manipulating Data in PostgreSQL
• Introduction to Statistics
• Data-Driven Decision Making in SQL
• Understanding Data Visualization
• Data Communication Concepts

Specificatoin of Data Analyst in SQL

• Publisher : Datacamp
• Teacher : IZZY WEBER
• Language : English
• Level : All Levels
• Number of Course : 11
• Duration : 39 hours to complete the course

Content of Data Analyst in SQL

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720p

Download Links

Introduction to SQL

Download – 31 MB

Intermediate SQL

Download – 78 MB

Joining Data in SQL

Download – 67 MB

Data Manipulation in SQL

Download – 134 MB

PostgreSQL Summary Stats and Window Functions

Download – 55 MB

Functions for Manipulating Data in PostgreSQL

Download – 54 MB

Introduction to Statistics

Download – 172 MB

Exploratory Data Analysis in SQL

Download – 75 MB

Data-Driven Decision Making in SQL

Download – 70 MB

Understanding Data Visualization

Download – 76 MB

Data Communication Concepts

Download – 95 MB

File size

912 MB