SQL Crash Course For Beginners – Learn SQL With PostgreSQL

Published 2/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.10 GB | Duration: 4h 18m
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
Homepage

https://www.udemy.com/course/sql-with-postgresql/