SQL Fundamentals

Sertifikasi tersedia

Diperbarui 01/2025

Master the SQL fundamentals needed for business, learn how to write SQL queries, and start analyzing your data using this powerful language.

Buat Akun Gratis Anda

atau

Dengan melanjutkan, Anda menyetujui Ketentuan Penggunaan, Kebijakan Privasi kami serta bahwa data Anda disimpan di Amerika Serikat.

Sertifikasi Tersedia

Oleh

Sertifikasi yang diakui industri membantu Anda menonjol dan membuktikan keahlian Anda. Siapkan diri Anda untuk sertifikasi dengan menyelesaikan program ini.

Termasuk dalam Premium

Termasuk dalam PremiumPelajari Lebih Lanjut

Deskripsi Lagu

SQL Fundamentals

Gain the fundamental SQL skills you need to interact with and query your data. SQL is a powerful language used by data-driven businesses, large and small, to explore and manipulate their data to extract meaningful insights. In this track, 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. You’ll be able to start working on a variety of SQL projects and develop your data science portfolio.

Persyaratan

Tidak ada persyaratan prasyarat untuk jalur ini.

Course
1
Introduction to SQL
Learn how to create and query relational databases using SQL in just two hours.
Course
2
Intermediate SQL
Lengkap dengan latihan setiap langkah, kursus ini ajarkan yang perlu diketahui untuk analisis data dengan kode SQL Anda sendiri hari ini.
Project
bonus
Analyzing Students' Mental Health
Use your data manipulation skills to perform exploratory data analysis on a dataset around student mental health.
Course
4
Menggabungkan Data di SQL
Tingkatkan pengetahuan SQL dan pelajari cara gabungkan tabel, terapkan teori himpunan relasional dan bekerja dengan subkueri.
Course
5
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.
Course
6
PostgreSQL Summary Stats and Window Functions
Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!
Course
7
Functions for Manipulating Data in PostgreSQL
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Course
8
Database Design
Learn to design databases in SQL to process, store, and organize data in a more efficient way.
Project
bonus
Impact Analysis of GoodThought NGO Initiatives
Use SQL to explore and analyze GoodThought NGO's database, uncovering key insights from over 13 years of transformative projects.
Skill Assessment
bonus
Data Analysis in SQL (PostgreSQL)