UDEMY
UDEMY Logo

The Complete SQL Bootcamp 

  • Offered byUDEMY

The Complete SQL Bootcamp
 at 
UDEMY 
Overview

Duration

4 hours

Total fee

499

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

The Complete SQL Bootcamp
 at 
UDEMY 
Highlights

  • Compatible on Mobile and TV
  • Earn a Cerificate on successful completion
  • Get Full Lifetime Access
  • Learn from Jose Portilla
Read more
Details Icon

The Complete SQL Bootcamp
 at 
UDEMY 
Course details

Who should do this course?
  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
What are the course deliverables?
  • Use SQL to query a database
  • Use SQL to perform data analysis
  • Be comfortable putting SQL and PostgreSQL on their resume
More about this course
  • 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! Check out the free preview videos for more information!

The Complete SQL Bootcamp
 at 
UDEMY 
Curriculum

Course Introduction

Introduction

Course Curriculum Overview

Overview of Databases

Course FAQs

Time to get Set-up!

Time to get your Computer Set-Up!

Setting Up with pgAdmin 4

Installing PostGreSQL and PgAdmin with Database Setup

Setup and Installation of PgAdmin and PostgreSQL

Installation Notes

PostGreSQL Installation (Mac OS)

PostGreSQL Installation (Windows)

Databases and Tables

SQL Statement Fundamentals

Overview of Challenges!

SQL Cheat Sheet

SQL Statement Fundamentals

SELECT Statement

Challenge: SELECT task.

SELECT DISTINCT

Challenge: SELECT DISTINCT

SELECT WHERE

Challenge: SELECT WHERE

COUNT

LIMIT

ORDER BY

Challenge: ORDER BY

BETWEEN

IN

LIKE

General Challenge 1

GROUP BY Statements

MIN MAX SUM and AVG

GROUP BY

Challenge:GROUP BY

HAVING

Quick Note

Challenge:HAVING

Assessment Test 1

Overview of Assessment Test 1

Assessment Test 1

Solutions to Assessment Test 1

JOINS

Overview of JOINS

AS Statement

Overview of Inner Join

Examples of Inner Joins

Overview of Join types

Example of Outer Joins

Union

Join Challenges

Advanced SQL Commands

Overview of Advanced SQL Commands

Timestamps and Extract

Mathematical Functions

String Function and Operators

SubQuery

Self-Join

Assessment Test 2

Assessment Test 2 Overview

Assessment Test 2

Solutions to Assessment Test 2

Creating Databases and Tables

Overview of Section

Data Types

Primary Keys and Foreign Keys

Resource for Create Table Code

Note on Constraints

Create Table

Challenge: Create Table

Challenge: Create Table - SOLUTION

Insert

Update

Delete

Alter Table

Drop Table

CHECK Constraint

NOT Constraint

UNIQUE Constraint

Assessment Test 3

Assessment Test 3

Solutions to Assessment Test 3

Extra: Views

Views

Extra: PostGreSQL with Python

Overview of Python and PostgreSQL

Psycopg2 Example Usage

Psycopg2 Resources

Databases and Tables

Databases and Tables Overview

Creating and Restoring a Database

Challenge: Restore a Database!

Restoring a Table Schema

Challenge: Restore a Table Schema!

Review of Section

Command Line Install Lectures (OPTIONAL -- FEEL FREE TO SKIP)

Mac OS X - Quick Note

Mac OS Installation

Mac Sample Database Download

Mac Database Set-up

Review of Set-up

Windows - Quick Note

Windows Installation

Sample Database Download

Windows Command Line Installation Lecture

BONUS SECTION: THANK YOU!

Bonus Lecture

Other courses offered by UDEMY

649
– / –
11 hoursCertificate
– / –
– / –
455
– / –
3.5 K
– / –
View Other 2339 CoursesRight Arrow Icon

The Complete SQL Bootcamp
 at 
UDEMY 
Students Ratings & Reviews

4.6/5
Verified Icon69 Ratings
J
Jui Kulkarni
The Complete SQL Bootcamp
5
Learning Experience: It was an amazing experience. The tutor was very thorough with the methods. It was a very good introduction to the PostgreSQL platform.
Faculty: Quality of lectures was amazing. Peer group was also supportive. Resources for the course were very much helpful. The course curriculum was wholesome.
Course Support: The course gave basic introduction to SQL it was helpful for getting indepth knowledge further.
Reviewed on 22 Feb 2023Read More
Thumbs Up IconThumbs Down Icon
I
Indranil Kundu
The Complete SQL Bootcamp
5
Learning Experience: If anyone don't have any knowledge regarding then this course will make them beginner to advance
Faculty: Very knowledgeable Beginner level to advance level all topic covered
Course Support: I didn't have any knowledge regarding SQL but after completing this course now I am very confident about SQL
Reviewed on 11 Feb 2023Read More
Thumbs Up IconThumbs Down Icon
K
Kasi Nivas
The Complete SQL Bootcamp
5
Learning Experience: The content was soo good and informative
Faculty: Faculty is teaching was crisp and clear Course curriculum in as per their teaching
Course Support: Great support
Reviewed on 4 Feb 2023Read More
Thumbs Up IconThumbs Down Icon
H
Himani kalra
The Complete SQL Bootcamp
5
Learning Experience: It was great!!
Faculty: There might be live sessions but for that you have to talk to them personally These courses are up to date
Reviewed on 4 Feb 2023Read More
Thumbs Up IconThumbs Down Icon
C
Chirag Khare
The Complete SQL Bootcamp
5
Learning Experience: The course was very steady, Jose Portilla instructed very well, I understand SQL to bits, I gained a little confidence and can say that I know SQL.
Faculty: Excellent faculty, good at his job ;) The course curriculum was in compliance with the modern requirements, anyone with zero knowledge can turn into a hero here.
Course Support: Not yet
Reviewed on 23 Jan 2023Read More
Thumbs Up IconThumbs Down Icon
View All 39 ReviewsRight Arrow Icon
qna

The Complete SQL Bootcamp
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...