SQL Crash Course 2024 From Zero – Learn SQL with PostgreSQL_1

SQL Crash Course 2024 From Zero – Learn SQL with PostgreSQL, available at $54.99, has an average rating of 4.9, with 74 lectures, 8 quizzes, based on 23 reviews, and has 163 subscribers.

You will learn about 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 This course is ideal for individuals who are Business Analysts or Data Scientists or Developers or Marketers or Researchers It is particularly useful for Business Analysts or Data Scientists or Developers or Marketers or Researchers.

Enroll now: SQL Crash Course 2024 From Zero – Learn SQL with PostgreSQL

Summary

Title: SQL Crash Course 2024 From Zero – Learn SQL with PostgreSQL

Price: $54.99

Average Rating: 4.9

Number of Lectures: 74

Number of Quizzes: 8

Number of Published Lectures: 74

Number of Published Quizzes: 8

Number of Curriculum Items: 82

Number of Published Curriculum Objects: 82

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

Business Analysts

Data Scientists

Developers

Marketers

Researchers

Target Audiences

Business Analysts

Data Scientists

Developers

Marketers

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.

I really look forward to seeing you in this course!

Course Curriculum

Chapter 1: Course Overview and 10 Minutes of SQL

Lecture 1: Course Overview

Lecture 2: 10 Minutes of SQL

Lecture 3: Quick Tip: Show Line Numbers in DBeaver

Lecture 4: Udemy Tipps

Chapter 2: Database Introduction – Basic Terminology and Course Setup

Lecture 1: Databases Overview

Lecture 2: Types of Databases

Lecture 3: SQL Standard and Common Groups

Lecture 4: Installation of PostgreSQL and DBeaver on Windows, Mac, Linux

Lecture 5: Import the course files

Lecture 6: Explore the course projects

Chapter 3: Tables and Inserting Data – with CREATE & INSERT

Lecture 1: CREATE a Database

Lecture 2: CREATE a Table

Lecture 3: INSERT Statement

Lecture 4: More on the INSERT Statement

Chapter 4: Query Data – with SELECT, WHERE, ORDER, LIMIT

Lecture 1: Query Overview – SELECT Everything

Lecture 2: SELECT with Columns and Labels

Lecture 3: WHERE Condition

Lecture 4: DISTINCT Values

Lecture 5: NULL Values

Lecture 6: ORDER BY Clause

Lecture 7: LIMIT and OFFSET

Chapter 5: Data Types – Numeric, String, Date, Boolean

Lecture 1: Data Types Overview

Lecture 2: Numeric Data Types

Lecture 3: Character Data Types

Lecture 4: Date and Time Data Types

Lecture 5: Boolean Data Type

Chapter 6: Remove Data & Objects – DROP, TRUNCATE

Lecture 1: DELETE Statement

Lecture 2: TRUNCATE Statement

Lecture 3: DROP Table

Lecture 4: DROP Database

Chapter 7: Modify Data & Objects – ALTER, UPDATE

Lecture 1: Overview ALTER and UPDATE

Lecture 2: ALTER Statement

Lecture 3: UPDATE Statement

Chapter 8: Constraints – for good data & structure

Lecture 1: Constraints Overview

Lecture 2: DEFAULT Constraint

Lecture 3: CHECK Constraint

Lecture 4: NOT NULL Constraint

Lecture 5: UNIQUE Constraint

Lecture 6: PRIMARY KEY Constraint

Lecture 7: FOREIGN KEY Constraint

Chapter 9: Normalization – How to structure a database

Lecture 1: Normalization Overview

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

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

Lecture 4: Second Normal Form (2NF)

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

Lecture 6: Create Database Diagrams in DBeaver

Chapter 10: Operators – for Arithmetic, Comparison, Logic

Lecture 1: Operators Overview

Lecture 2: Arithmetic Operators

Lecture 3: Comparison Operators

Lecture 4: Logical Operators

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

Lecture 1: Functions Overview

Lecture 2: String Functions

Lecture 3: Formatting and Conversion Functions

Lecture 4: Aggregate Functions

Lecture 5: Date and Time Functions

Lecture 6: Mathematical Functions

Lecture 7: Conditional Functions

Chapter 12: Joins – Bringing 2+ tables together

Lecture 1: Joins Overview

Lecture 2: Cross Join

Lecture 3: Inner Join

Lecture 4: Left Join

Lecture 5: Right Join

Lecture 6: Full Join

Lecture 7: Self Join

Chapter 13: Subqueries – How to nest queries

Lecture 1: Subquery Introduction

Lecture 2: Subquery with EXISTS

Lecture 3: Subquery with IN

Chapter 14: Security – The basics

Lecture 1: Create roles and users

Lecture 2: Grant and Revoke

Chapter 15: Views – A way of storing queries

Lecture 1: Create and Use Views

Chapter 16: Summary – Course Wrap up

Lecture 1: Congratulations and Surprise

Chapter 17: Extra Material

Lecture 1: What to Avoid

Lecture 2: Official Documentation and Book Recommendation

Lecture 3: Bonus Lecture

Instructors

Samuel Lenk
Talend ? SQL ? Java ? Linux ? Google Cloud Platform (GCP)

Diamond Consulting UG
Talend ? SQL ? Java ? Linux ? Cloud Computing

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 1 votes

4 stars: 4 votes

5 stars: 16 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!