Mô tả

Learn how to use SQL quickly and effectively with this course!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!

In this course you will learn everything you need to become a SQL Pro! Including:

  • Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools

  • Learn he basics of SQL syntax

  • Analyzing data using aggregate functions with GROUP BY commands

  • Running advanced queries with string operations and comparison operations

  • Learn to use logical operators to add logic flow to your SQL queries

  • Learn common SQL JOIN commands

  • Learn to create tables and databases with constraints on data entries

  • Learn to use Python to further advanced your SQL skills

  • and much, much more!

This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.

I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

I'll see you inside the course!

Check out the free preview videos for more information!

Bạn sẽ học được gì

Use SQL to query a database

Use SQL to perform data analysis

Be comfortable putting SQL and PostgreSQL on their resume

Learn to perform GROUP BY statements

Replicate real-world situations and query reports

Yêu cầu

  • No prior technical experience is required! All you need a computer!

Nội dung khoá học

12 sections

Course Introduction

8 lectures
Welcome Message
00:34
Introduction
02:15
Course Curriculum Overview
01:41
Overview of Databases
07:37
Course FAQs
01:14
Windows Installation - PostGreSQL and PgAdmin with Database Setup
21:09
MacOS Installation - PostgreSQL and PgAdmin with First Query
23:06
pgAdmin Overview
09:44

SQL Statement Fundamentals

18 lectures
Overview of Challenges!
01:36
SQL Cheat Sheet
00:18
SQL Statement Fundamentals
00:42
SELECT Statement
08:40
Challenge: SELECT
04:29
SELECT DISTINCT
05:38
Challenge: SELECT DISTINCT
01:53
COUNT
07:23
SELECT WHERE - Part One
04:30
SELECT WHERE - Part Two
07:04
Challenge: SELECT WHERE
05:35
ORDER BY
08:11
LIMIT
05:06
Challenge: ORDER BY
05:00
BETWEEN
06:57
IN
04:55
LIKE and ILIKE
09:36
General Challenge 1
09:54

GROUP BY Statements

7 lectures
Introduction to GROUP BY
00:57
Aggregation Functions
07:59
GROUP BY - Part One
07:48
GROUP BY - Part Two
10:42
GROUP BY - Challenge
04:05
HAVING
06:25
HAVING - Challenge Tasks
02:47

Assessment Test 1

3 lectures
Overview of Assessment Test 1
01:08
Assessment Test 1
00:20
Solutions to Assessment Test 1
00:13

JOINS

9 lectures
Overview of JOINS
00:16
Introduction to JOINs
01:14
AS Statement
07:48
Inner Joins
14:49
Full Outer Joins
14:22
Left Outer Join
11:18
Right Joins
04:21
UNION
02:26
JOIN Challenge Tasks
12:15

Advanced SQL Commands

9 lectures
Overview of Advanced SQL Commands
00:47
Timestamps and Extract - Part One
07:38
Timestamps and Extract - Part Two
10:06
Quick Note on TO_CHAR
00:15
Timestamps and Extract - Challenge Tasks
03:38
Mathematical Functions and Operators
05:00
String Functions and Operators
08:24
SubQuery
15:11
Self-Join
10:55

Assessment Test 2

4 lectures
READ ME FIRST PLEASE
01:20
Setting up New Database for Assessment Exercises
07:26
Assessment Test 2
00:15
Solutions to Assessment Test 2
23:45

Creating Databases and Tables

11 lectures
Introduction to Section
01:12
Data Types
06:27
Primary Keys and Foreign Keys
09:04
Constraints
05:17
CREATE Table
18:28
INSERT
09:05
UPDATE
07:58
DELETE
03:12
ALTER Table
06:46
DROP Table
03:18
CHECK Constraint
07:04

Assessment Test 3

2 lectures
Assessment Test 3
00:53
Solutions to Assessment Test 3
00:26

Conditional Expressions and Procedures

8 lectures
Conditional Expressions and Procedures Introduction
00:43
CASE
22:39
CASE - Challenge Task
03:08
COALESCE
05:35
CAST
07:07
NULLIF
10:34
Views
07:07
Import and Export
13:29

Extra: PostGreSQL with Python

3 lectures
Overview of Python and PostgreSQL
00:31
Psycopg2 Example Usage
10:24
Psycopg2 Resources
00:13

BONUS SECTION: THANK YOU!

1 lectures
Bonus Lecture
00:10

Đánh giá của học viên

4.5
Course Rating
5
50%
4
50%
3
0%
2
0%
1
0%

Bình luận khách hàng

  • tricuongphan.031203@gmail.com 23:17:55, 17/11/2023

    Đã nhận email qua drive

  • tricuongphan.031203@gmail.com 23:20:05, 17/11/2023

    Đã nhận email qua drive

  • tricuongphan.031203@gmail.com 23:22:54, 17/11/2023

    Đã nhận email qua drive

  • quan@gmail.com 23:46:41, 17/11/2023

    3

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.