Udemy

SQL Crash Course From Zero – Learn SQL with Postgres - 2026

立即報名
  • 393 名學生
  • 更新於 2/2026
4.5
(29 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
4 小時 20 分鐘
教學語言
英語
評分
4.5
(29 個評分)
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

SQL Crash Course From Zero – Learn SQL with Postgres - 2026

Start from Zero: Become confident using SQL in any database - for Marketer, Business Analyst, Data Scientist, Researcher

Let me take you back to 2009:


Back then, I thought I had it all figured out. I had just finished my master's degree and thought, "Now I'm ready to work on any data project and be the best.

But then I joined my first project and walked into a meeting where I heard so many words that I had no idea what they meant. I began to feel insecure.

The month didn't get better. In fact, it got worse. By the time the on-boarding was over, I was sitting there with all these tools, terms, tasks, and I was really frustrated.

Fortunately, I met some great people along the way who had the willingness and talent to share their knowledge about things that just seemed weird to me. So I found help in simple words and precise examples. Finally, I began to understand.


Can you relate to my story? Maybe you are at this point now. Then I want this for you.

I would love to be one of those coaches on your journey to mastering data, SQL, and databases.

What can you expect to learn in this course?


  • We will start at zero, 0, null. Promised!

  • Use lots of examples and small steps to build your skills.

  • Sprinkle in a lot of exercises and repetition.


If you ever get stuck, don't hesitate to send me a message.

We can walk this path together.


I really look forward to seeing you in this course!

課程章節

  • 17 個章節
  • 74 堂課
  • 第 1 章 Course Overview and 10 Minutes of SQL
  • 第 2 章 Database Introduction - Basic Terminology and Course Setup
  • 第 3 章 Tables and Inserting Data - with CREATE & INSERT
  • 第 4 章 Query Data - with SELECT, WHERE, ORDER, LIMIT
  • 第 5 章 Data Types - Numeric, String, Date, Boolean
  • 第 6 章 Remove Data & Objects - DROP, TRUNCATE
  • 第 7 章 Modify Data and Objects - ALTER, UPDATE
  • 第 8 章 Constraints - for good data & structure
  • 第 9 章 Normalization - How to structure a database
  • 第 10 章 Operators - for Arithmetic, Comparison, Logic
  • 第 11 章 Functions – Built-in Code for Strings, Numbers, Conversion, Dates and more
  • 第 12 章 Joins – Bringing 2+ tables together
  • 第 13 章 Subqueries - How to nest queries
  • 第 14 章 Security - The basics
  • 第 15 章 Views - A way of storing queries
  • 第 16 章 Summary - Course Wrap up
  • 第 17 章 Extra Material

課程內容

  • Use SQL to answer real questions, Write advanced queries, like joins, groups and subqueries, Become comfortable putting SQL and PostgreSQL on your resume, Use available functions and operators in SQL, Understand important database concepts, Create your own databases

評價

  • J
    Jeremy Haakenson
    4.0

    Good introduction to SQL.

  • M
    Mandy Eickmeyer
    5.0

    Good examples!

  • M
    Mat Kreven
    5.0

    Best SQL course for me so far: well explained right from the start!

  • R
    Randy Bailey
    5.0

    Perfect for me learning SQl as real novice

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策與使用條款才繼續瀏覽。

我已閱讀及同意