Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 9 hours on-demand video
  • 2 articles
  • 28 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
IT & Software IT Certification PostgreSQL

SQL & PostgreSQL for Beginners: Become an SQL Expert

SQL & PostgreSQL Tutorial: Become an Expert in SQL and PostgreSQL by Writing SQL Queries using PostgreSQL and PgAdmin 4.
Bestseller
Rating: 4.5 out of 54.5 (2,804 ratings)
13,819 students
Created by Jon Avis - SQL Instructor
Last updated 7/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • How to create a database from scratch.
  • Use SQL to perform data analysis.
  • Perform complex SQL queries using joins and subqueries.
  • Understand database concepts such as database relationships.
  • Confident putting SQL and PostgreSQL on your resume.
Curated for the Udemy for Business collection

Requirements

  • No previous knowledge of SQL or PostgreSQL is needed for this course.

Description

Become an expert in SQL and PostgreSQL with this bestselling course!

SQL is one of the most in-demand tech skills across many industries so learning SQL is one of the best ways to boost your career! After taking this course you will be comfortable putting SQL and PostgreSQL on your resume/CV. 

In the age of Big Data and Data Analysis, demand for employees with SQL skills has never been higher and will only increase in the future. Stand out from the crowd and learn SQL today.

PostgreSQL is the World’s most advanced open source relational database. It has a strong reputation for its reliability, data integrity and robustness. Because of this, PostgreSQL is one of the most popular and widely used database systems in the world. Companies who use PostgreSQL include Apple, Cisco, Spotify, Fujitsu, Skype, Netflix and IMDb.

A 2019 survey of stackoverflow developers reported that one third of developers used PostgreSQL on a daily basis in their professional lives, up from 25% in 2018. In 2019 PostgreSQL was the fastest growing database for the third year in a row. PostgreSQL experience really is a desired skill in the tech industry.


Here's what students are saying about this SQL course: 

Christopher says - "A really great course. The structure was well setup and the pacing was perfect. Each section and lecture flowed well in to the next. The exercises and solutions were very helpful. I was new to sql and postgresql before taking this course but I can now say that I am comfortable with both."

Erin Todd says - "I love this course so far very easy to follow and interactive."

Raymond Beauchamp says - "Amount of information is good for a beginner course. Was beneficial in increasing my understanding of the subject. Instructor was knowledgeable, and was easy to follow."

John Hellmann says - "Very concise lectures! Was a great course overall"

Abhinav Sharma says - "The explanations are really clear and the course structure is very well thought out."


By the end of this course you will know how to:

  • Create a relational database from scratch

  • Create, alter and delete tables from a database

  • Insert, update and delete data from a table

  • Retrieve data from a database using select queries

  • Filter data using where clauses and logical operators

  • Order and limit data retrieved from a table

  • Use aggregate functions and group data to gain more meaningful insights from a database

  • Relate tables together using database relationships

  • Use SQL join queries to retrieve data from multiple tables in a single query

  • Master complex SQL subqueries

  • Apply SQL string functions to data in PostgreSQL


A step-by-step video of how to install and setup PostgreSQL is included and the setup is completely FREE.

The SQL code for each video is included as a resource so you can easily access it. 

There are SQL exercises, and video solutions, along the way to help you improve your knowledge and SQL skills. 

I will be actively answering any questions you may have about the course in the Q&A section. 

The course will be continually updated with more sections in the future.

Watch the free preview videos and start learning SQL - one of the most important and in-demand technology skills!

Who this course is for:

  • Anyone wanting to learn SQL or PostgreSQL.
  • Anyone with a basic knowledge of SQL but is new to PostgreSQL.
  • Anyone wanting to learn more about databases.

Featured review

Tsotne Okrostsvaridze
Tsotne Okrostsvaridze
12 courses
7 reviews
Rating: 5.0 out of 56 months ago
Its a perfect course to get you started with SQL basics and main concepts. Everything is explained brilliantly and instructor is very supportive. Quality of video and audio is also very good. Thank you.

Course content

11 sections • 125 lectures • 9h 11m total length

  • Preview02:25
  • A Few Notes on this Course
    00:29

  • What is a Database?
    03:08
  • Relational Databases and SQL
    04:11
  • Installing PostgreSQL for Mac
    05:16
  • Installing PostgreSQL for Windows
    07:51

  • Section Introduction
    01:16
  • Database Tables
    04:02
  • Data Types Explained
    07:44
  • Primary Keys and Foreign Keys
    04:15
  • Unique, Not Null and Check Constraints
    04:28
  • Creating Our First Table
    09:36
  • Creating the Actors Table
    05:21
  • Preview05:29
  • Creating the Movie Revenues Table
    06:05
  • Creating a Junction Table
    04:23
  • Modifying Tables Part 1: Adding Columns
    07:33
  • Modifying Tables Part 2: Changing a Columns Data Type
    Preview04:11
  • Deleting Tables from a Database
    02:44
  • Challenge: Data Definition Language
    01:11
  • Solution: Data Definition Language
    06:25
  • Section Summary
    01:01

  • Section Introduction
    00:40
  • Inserting Data into a Table
    09:12
  • Preview07:22
  • Deleting Data from a Table
    03:47
  • Inserting Data into Our Movie Data Database
    07:13
  • Challenge: Data Manipulation Language
    01:17
  • Solution: Data Manipulation Language
    09:15
  • Section Summary
    00:39

  • Section Introduction
    01:37
  • Select Queries
    Preview03:09
  • Where Clauses
    Preview06:05
  • Logical Operators
    07:34
  • Challenge 1: Select Queries
    01:01
  • Solution 1: Select Queries
    04:19
  • In, Not In
    05:47
  • Like
    07:29
  • Between
    07:32
  • Challenge 2: Select Queries
    01:06
  • Solution 2: Select Queries
    04:54
  • Order By
    08:38
  • Limiting the Number of Results
    04:39
  • Fetch
    03:58
  • Preview03:50
  • Challenge 3: Select Queries
    00:44
  • Solution 3: Select Queries
    04:01
  • Null Values
    05:11
  • Setting a Column Name Alias
    05:10
  • Concatenation
    06:44
  • Challenge 4: Select Queries
    00:44
  • Solution 4: Select Queries
    04:51
  • Section Summary
    01:11

  • Section Introduction
    00:56
  • Aggregate Functions Explained
    01:56
  • Count Aggregate Functions
    04:07
  • Sum Aggregate Function
    Preview04:00
  • Min and Max Aggregate Functions
    05:29
  • Average Aggregate Functions
    02:44
  • Challenge 1: Aggregate Functions
    01:05
  • Solution 1: Aggregate Functions
    04:23
  • Grouping Data
    11:26
  • Having Clauses
    04:51
  • Challenge 2: Aggregate Functions
    00:46
  • Solution 2: Aggregate Functions
    04:42
  • Mathematical Operators
    07:56
  • Section Summary
    00:57

  • Section Introduction
    00:54
  • What Are Database Relationships?
    01:31
  • One to One Relationships
    03:27
  • One to Many Relationships
    04:00
  • Many to Many Relationships
    04:35
  • (Optional) Challenge: Database Relationships
    02:27
  • Solution: Database Relationships
    05:21
  • Section Summary
    00:41

  • Section Introduction
    01:09
  • SQL Joins Explained
    10:07
  • Preview11:28
  • Inner Joins Part 2
    05:30
  • Inner Joins Part 3
    04:34
  • Challenge 1: Joins
    01:08
  • Solution 1: Joins
    07:22
  • Left Joins
    05:55
  • Right Joins
    03:23
  • Full Joins
    03:32
  • Challenge 2: Joins
    00:38
  • Solutions 2: Joins
    05:27
  • Joining More Than Two Tables
    11:33
  • Challenge 3: Joins
    01:06
  • Solution 3: Joins
    08:46
  • Union
    06:09
  • Union All
    03:48
  • Challenge 4: Joins
    00:42
  • Solution 4: Joins
    04:45
  • Intersect
    03:44
  • Except
    04:07
  • Challenge 5: Joins
    00:42
  • Solution 5: Joins
    03:58
  • Section Summary
    01:02

  • Section Introduction
    00:47
  • Subqueries Explained
    05:03
  • Uncorrelated Subqueries Part 1
    08:15
  • Uncorrelated Subqueries Part 2
    06:01
  • Challenge 1: Subqueries
    01:29
  • Solution 1: Subqueries
    08:54
  • Correlated Subqueries
    07:19
  • Challenge 2: Subqueries
    01:12
  • Solution 2: Subqueries
    07:41
  • Summary
    00:58

  • Section Introduction
    01:34
  • Cloning a Database
    04:02
  • Upper and Lower String Functions
    06:19
  • Initcap Function
    04:08
  • Left and Right String Functions
    08:43
  • Reverse Function
    02:17
  • Challenge 1: String Functions
    01:19
  • Solution 1: String Functions
    11:54
  • Substring Function
    05:16
  • Replace Function
    09:04
  • Split Part Function
    07:20
  • Using the Cast Operator to Apply String Functions to Non-String Data Types
    05:40
  • Challenge 2: String Functions
    00:53
  • Solution 2: String Functions
    06:52
  • Summary
    01:04

Instructor

Jon Avis - SQL Instructor
IT Systems Engineer and SQL Instructor
Jon Avis - SQL Instructor
  • 4.5 Instructor Rating
  • 10,906 Reviews
  • 50,748 Students
  • 2 Courses

Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me to become an expert in SQL, Databases, Unix, Shell Scripting and coding in multiple languages.

Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.