SQL Fundamentals

มีใบรับรองให้

อัปเดตแล้ว 03/2569

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

สร้างบัญชีฟรีของคุณ

หรือ

เมื่อดำเนินการต่อ คุณยอมรับข้อกำหนดการใช้งานของเรา นโยบายความเป็นส่วนตัวของเรา และยอมรับว่าข้อมูลของคุณจะถูกจัดเก็บไว้ในสหรัฐอเมริกา

Certification Available

โดย

Industry recognized certifications help you stand out and prove your skills. Prepare for certification by completing this track.

Included with Premium

Included with Premiumเรียนรู้เพิ่มเติม

คำอธิบายแทร็ก

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.

ข้อกำหนดเบื้องต้น

ไม่มีข้อกำหนดเบื้องต้นสำหรับหลักสูตรนี้

Course
AI Native
1
Introduction to SQL
Learn how to create and query relational databases using SQL in just two hours.
Course
AI Native
2
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!
Project
โบนัส
Analyzing Students' Mental Health
Use your data manipulation skills to perform exploratory data analysis on a dataset around student mental health.
Course
4
Joining Data in SQL
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
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
โบนัส
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
โบนัส
Data Analysis in SQL (PostgreSQL)