Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

The Complete SQL Bootcamp

Jose Portilla, Data Scientist

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
60 Videos (7h 60m)
    • 001 introduction

      2:15
    • 002 course curriculum overview

      1:41
    • 003 overview of databases

      7:37
    • 006 setting up with pgadmin 4

      14:57
    • 009 Mac OS Installation

      5:56
    • 011 mac database setup

      10:42
    • 014 windows installation

      4:07
    • 016 windows command line installation lecture

      19:45
    • 017 databases and tables overview

      1:12
    • 018 creating and restoring a database

      6:21
    • 019 overview of challenges

      1:36
    • 020 challenge restore a database

      0:42
    • 021 restoring a table schema

      6:13
    • 022 challenge restore a table schema

      0:43
    • 025 sql statement fundamentals

      0:42
    • 026 select statement

      10:48
    • 027 challenge select task

      2:45
    • 028 select distinct

      5:46
    • 029 challenge select distinct

      2:05
    • 030 select where

      14:03
    • 031 challenge select where

      3:45
    • 032 count

      5:00
    • 033 limit

      2:59
    • 034 order by

      10:05
    • 035 challenge order by

      3:38
    • 036 between

      8:44
    • 037 in

      8:27
    • 038 like

      10:24
    • 039 general challenge 1

      9:54
    • 040 min max sum and avg

      8:06
    • 041 group by

      18:10
    • 042 challengegroup by

      12:15
    • 043 having

      10:17
    • 045 challengehaving

      3:44
    • 046 overview of assessment test 1

      1:08
    • 050 as statement

      3:38
    • 051 overview of inner join

      18:53
    • 052 examples of inner joins

      16:22
    • 053 overview of join types

      12:56
    • 054 example of outer joins

      11:47
    • 055 union

      6:21
    • 058 timestamps and extract

      9:26
    • 059 mathematical functions

      6:37
    • 060 string function and operators

      7:12
    • 061 subquery

      15:02
    • 062 selfjoin

      14:17
    • 063 assessment test 2 overview

      6:36
    • 066 overview of section

      3:28
    • 067 data types

      7:21
    • 068 primary keys and foreign keys

      9:43
    • 071 create table

      19:48
    • 073 challenge create table solution

      5:51
    • 074 insert

      15:31
    • 075 update

      10:30
    • 077 alter table

      6:38
    • 078 drop table

      5:25
    • 079 check constraint

      9:48
    • 080 not null constraint

      6:10
    • 081 unique constraint

      4:53
    • 084 views

      8:48

About This Class

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!

4

Students

--

Projects

0

Reviews (0)

Jose Portilla

Data Scientist

Jose Marcial Portilla has a BS and MS in Mechanical Engineering from Santa Clara University and years of experience as a professional instructor and trainer for Data Science and programming. He has publications and patents in various fields such as microfluidics, materials science, and data science technologies. Over the course of his career he has developed a skill set in analyzing data and he hopes to use his experience in teaching and data science to help other people learn the power of pr...

See full profile