- 提示:
- 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。
課程資料
課程簡介
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
評價
-
JJeremy Haakenson
Good introduction to SQL.
-
MMandy Eickmeyer
Good examples!
-
MMat Kreven
Best SQL course for me so far: well explained right from the start!
-
RRandy Bailey
Perfect for me learning SQl as real novice