SQL Crash Course For Beginners – Learn SQL with PostgreSQL

Focused View

Samuel Lenk | Certified Talend Developer & Java/SQL/Data Developer

4:18:53

68 View

1 - Course Overview and 10 Minutes SQL

1 - Course Overview.mp4

03:33

2 - 10 Minutes SQL.mp4

11:01

2 - 10-minutes-sql.zip

3 - Udemy Tipps.mp4

01:35

2 - Database Introduction a little Terminology and Setup

1 - Database Introduction Quiz.html

4 - Databases Overview.mp4

04:17

5 - Types of Databases.mp4

01:40

6 - SQL Standard and Common Groups.mp4

01:37

7 - Installation of PostgreSQL and DBeaver.mp4

07:40

8 - Import the course files.mp4

05:11

8 - sql-with-postgresql.zip

9 - Explore the course projects.mp4

01:39

9 - SQL-course-project-list.pdf

3 - Tables and Inserting Data with CREATE INSERT

10 - CREATE a Database.mp4

03:57

11 - CREATE a Table.mp4

05:10

12 - INSERT Statement.mp4

06:27

13 - More on the INSERT Statement.mp4

05:18

4 - Query Data with SELECT WHERE ORDER LIMIT

14 - Query Overview SELECT Everything.mp4

01:47

15 - SELECT with Columns and Labels.mp4

04:58

16 - WHERE Condition.mp4

05:49

17 - DISTINCT Values.mp4

01:42

18 - NULL Values.mp4

03:35

19 - ORDER BY Clause.mp4

03:55

20 - LIMIT and OFFSET.mp4

01:31

5 - Data Types Numeric String Date Boolean

21 - Data Types Overview.mp4

03:49

22 - Numeric Data Types.mp4

04:37

23 - Character Data Types.mp4

06:08

24 - Date and Time Data Types.mp4

05:24

25 - Boolean Data Type.mp4

02:11

6 - Remove Data Objects DROP TRUNCATE

26 - DELETE Statement.mp4

03:30

27 - TRUNCATE Statement.mp4

01:43

28 - DROP Table.mp4

01:22

29 - DROP Database.mp4

02:22

7 - Modify Data Objects ALTER UPDATE

30 - Overview ALTER and UPDATE.mp4

02:40

31 - ALTER Statement.mp4

05:42

32 - UPDATE Statement.mp4

11:34

8 - Constraints for good data structure

33 - Constraints Overview.mp4

02:23

34 - DEFAULT Constraint.mp4

01:51

35 - CHECK Constraint.mp4

03:34

36 - NOT NULL Constraint.mp4

03:04

37 - UNIQUE Constraint.mp4

03:35

38 - PRIMARY KEY Constraint.mp4

02:52

39 - FOREIGN KEY Constraint.mp4

03:23

9 - Normalization How to structure a database

40 - Normalization Overview.mp4

03:24

41 - UnNormalized Form UNF and Primary Key PK.mp4

02:17

42 - From UnNormalized Form UNF to First Normal Form 1NF.mp4

02:03

43 - Second Normal Form 2NF.mp4

01:04

44 - From Second Normal Form 2NF to Third Normal Form 3NF.mp4

04:23

45 - Create Database Diagrams in DBeaver.mp4

02:15

10 - Operators for Arithmetic Comparison Logic

46 - Operators Overview.mp4

03:50

47 - Arithmetic Operators.mp4

04:02

48 - Comparison Operators.mp4

02:27

49 - Logical Operators.mp4

03:08

11 - Functions Builtin Code for Strings Numbers Conversion Dates and more

50 - Functions Overview.mp4

01:00

51 - String Functions.mp4

08:41

52 - Formatting and Conversion Functions.mp4

04:49

53 - Aggregate Functions.mp4

06:27

54 - Date and Time Functions.mp4

04:15

55 - Mathematical Functions.mp4

01:47

56 - Conditional Functions.mp4

04:15

12 - Joins Bringing 2 tables together

57 - Joins Overview.mp4

04:21

58 - Cross Join.mp4

02:00

59 - Inner Join.mp4

02:06

60 - Left Join.mp4

01:54

61 - Right Join.mp4

01:40

62 - Full Join.mp4

01:26

63 - Self Join.mp4

03:46

13 - Subqueries How to nest queries

64 - Subquery Introduction.mp4

04:12

65 - Subquery with EXISTS.mp4

03:15

66 - Subquery with IN.mp4

05:02

14 - Security The basics

67 - Create roles and users.mp4

04:24

68 - Grant and Revoke.mp4

06:28

15 - Views A way of storing queries

69 - Create and Use Views.mp4

03:21

16 - Summary Course Wrap up

70 - Congratulations and Surprise.mp4

00:45

70 - SQL-with-PostgreSQL-cheatsheet.pdf

17 - Extra Material

71 - What to Avoid.html

72 - Bonus Lecture.html

Description

Stand out: Become confident using SQL in any database - for Marketers, Business Analysts, Data Scientists, Researchers

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

Who is this for?

Business Analysts

Data Scientists

Developers

Marketers

Researchers

More details

Description
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!
Who this course is for:
Business Analysts
Data Scientists
Developers
Marketers
Researchers

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, my name is Samuel.I am solution developer in the data universe and have been working in this field for 12+ years. I started this journey after studying computer sciences, specialized in business informatiuon systems.Now I am constantly getting the most out of data, using Talend, Java, SQL, Python, JSON, and many more.It's a pleasure for me to share my knowledge with you!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.