English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 72 lectures (4h 19m) | 2.10 GB
Stand out: Become confident using SQL in any database – for Marketers, Business Analysts, Data Scientists, Researchers
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.
What you’ll learn
- 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
Table of Contents
Course Overview and 10 Minutes SQL
1 Course Overview
2 Minutes SQL
3 Udemy Tipps
Database Introduction a little Terminology and Setup
4 Databases Overview
5 Types of Databases
6 SQL Standard and Common Groups
7 Installation of PostgreSQL and DBeaver
8 Import the course files
9 Explore the course projects
Tables and Inserting Data with CREATE INSERT
10 CREATE a Database
11 CREATE a Table
12 INSERT Statement
13 More on the INSERT Statement
Query Data with SELECT WHERE ORDER LIMIT
14 Query Overview SELECT Everything
15 SELECT with Columns and Labels
16 WHERE Condition
17 DISTINCT Values
18 NULL Values
19 ORDER BY Clause
20 LIMIT and OFFSET
Data Types Numeric String Date Boolean
21 Data Types Overview
22 Numeric Data Types
23 Character Data Types
24 Date and Time Data Types
25 Boolean Data Type
Remove Data Objects DROP TRUNCATE
26 DELETE Statement
27 TRUNCATE Statement
28 DROP Table
29 DROP Database
Modify Data Objects ALTER UPDATE
30 Overview ALTER and UPDATE
31 ALTER Statement
32 UPDATE Statement
Constraints for good data structure
33 Constraints Overview
34 DEFAULT Constraint
35 CHECK Constraint
36 NOT NULL Constraint
37 UNIQUE Constraint
38 PRIMARY KEY Constraint
39 FOREIGN KEY Constraint
Normalization How to structure a database
40 Normalization Overview
41 UnNormalized Form UNF and Primary Key PK
42 From UnNormalized Form UNF to First Normal Form 1NF
43 Second Normal Form 2NF
44 From Second Normal Form 2NF to Third Normal Form 3NF
45 Create Database Diagrams in DBeaver
Operators for Arithmetic Comparison Logic
46 Operators Overview
47 Arithmetic Operators
48 Comparison Operators
49 Logical Operators
Functions Builtin Code for Strings Numbers Conversion Dates and more
50 Functions Overview
51 String Functions
52 Formatting and Conversion Functions
53 Aggregate Functions
54 Date and Time Functions
55 Mathematical Functions
56 Conditional Functions
Joins Bringing 2 tables together
57 Joins Overview
58 Cross Join
59 Inner Join
60 Left Join
61 Right Join
62 Full Join
63 Self Join
Subqueries How to nest queries
64 Subquery Introduction
65 Subquery with EXISTS
66 Subquery with IN
Security The basics
67 Create roles and users
68 Grant and Revoke
Views A way of storing queries
69 Create and Use Views
Summary Course Wrap up
70 Congratulations and Surprise
Extra Material
71 What to Avoid
72 Bonus Lecture
Resolve the captcha to access the links!