Sql Crash Course For Beginners – Learn Sql With Postgresql

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

Requirements

NO programming or technical experience required

bring your Windows, Mac or Linux computer

complete beginners for database, SQL, or PostgreSQL are welcome

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!

Overview

Section 1: Course Overview and 10 Minutes SQL

Lecture 1 Course Overview

Lecture 2 10 Minutes SQL

Lecture 3 Udemy Tipps

Section 2: Database Introduction - a little Terminology and Setup

Lecture 4 Databases Overview

Lecture 5 Types of Databases

Lecture 6 SQL Standard and Common Groups

Lecture 7 Installation of PostgreSQL and DBeaver

Lecture 8 Import the course files

Lecture 9 Explore the course projects

Section 3: Tables and Inserting Data - with CREATE & INSERT

Lecture 10 CREATE a Database

Lecture 11 CREATE a Table

Lecture 12 INSERT Statement

Lecture 13 More on the INSERT Statement

Section 4: Query Data - with SELECT, WHERE, ORDER, LIMIT

Lecture 14 Query Overview - SELECT Everything

Lecture 15 SELECT with Columns and Labels

Lecture 16 WHERE Condition

Lecture 17 DISTINCT Values

Lecture 18 NULL Values

Lecture 19 ORDER BY Clause

Lecture 20 LIMIT and OFFSET

Section 5: Data Types - Numeric, String, Date, Boolean

Lecture 21 Data Types Overview

Lecture 22 Numeric Data Types

Lecture 23 Character Data Types

Lecture 24 Date and Time Data Types

Lecture 25 Boolean Data Type

Section 6: Remove Data & Objects - DROP, TRUNCATE

Lecture 26 DELETE Statement

Lecture 27 TRUNCATE Statement

Lecture 28 DROP Table

Lecture 29 DROP Database

Section 7: Modify Data & Objects - ALTER, UPDATE

Lecture 30 Overview ALTER and UPDATE

Lecture 31 ALTER Statement

Lecture 32 UPDATE Statement

Section 8: Constraints - for good data & structure

Lecture 33 Constraints Overview

Lecture 34 DEFAULT Constraint

Lecture 35 CHECK Constraint

Lecture 36 NOT NULL Constraint

Lecture 37 UNIQUE Constraint

Lecture 38 PRIMARY KEY Constraint

Lecture 39 FOREIGN KEY Constraint

Section 9: Normalization - How to structure a database

Lecture 40 Normalization Overview

Lecture 41 Un-Normalized Form (UNF) and Primary Key (PK)

Lecture 42 From Un-Normalized Form (UNF) to First Normal Form (1NF)

Lecture 43 Second Normal Form (2NF)

Lecture 44 From Second Normal Form (2NF) to Third Normal Form (3NF)

Lecture 45 Create Database Diagrams in DBeaver

Section 10: Operators - for Arithmetic, Comparison, Logic

Lecture 46 Operators Overview

Lecture 47 Arithmetic Operators

Lecture 48 Comparison Operators

Lecture 49 Logical Operators

Section 11: Functions – Built-in Code for Strings, Numbers, Conversion, Dates and more

Lecture 50 Functions Overview

Lecture 51 String Functions

Lecture 52 Formatting and Conversion Functions

Lecture 53 Aggregate Functions

Lecture 54 Date and Time Functions

Lecture 55 Mathematical Functions

Lecture 56 Conditional Functions

Section 12: Joins – Bringing 2+ tables together

Lecture 57 Joins Overview

Lecture 58 Cross Join

Lecture 59 Inner Join

Lecture 60 Left Join

Lecture 61 Right Join

Lecture 62 Full Join

Lecture 63 Self Join

Section 13: Subqueries - How to nest queries

Lecture 64 Subquery Introduction

Lecture 65 Subquery with EXISTS

Lecture 66 Subquery with IN

Section 14: Security - The basics

Lecture 67 Create roles and users

Lecture 68 Grant and Revoke

Section 15: Views - A way of storing queries

Lecture 69 Create and Use Views

Section 16: Summary - Course Wrap up

Lecture 70 Congratulations and Surprise

Section 17: Extra Material

Lecture 71 What to Avoid

Lecture 72 Bonus Lecture

Business Analysts,Data Scientists,Developers,Marketers,Researchers