The Complete SQL Bootcamp
180,382 students enrolled
The Complete SQL Bootcamp
Become an expert at SQL!
Bestseller
180,382 students enrolled
Created by
Jose Portilla
Last updated 9/2019
English
English,
French [Auto-generated],
8 more
- German [Auto-generated]
- Indonesian [Auto-generated]
- Italian [Auto-generated]
- Japanese [Auto-generated]
- Polish [Auto-generated]
- Portuguese [Auto-generated]
- Spanish [Auto-generated]
- Turkish [Auto-generated]
30-Day Money-Back Guarantee
This course includes
- 8.5 hours on-demand video
- 26 articles
- 16 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 3,500+ top Udemy courses anytime, anywhere.
Try Udemy for Business
What you'll learn
- Use SQL to query a database
- Use SQL to perform data analysis
- Be comfortable putting SQL and PostgreSQL on their resume
Requirements
- No prior technical experience is required! All you need a computer!
Description
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!
Who this course is for:
- Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
Featured review
Jerry Rodgers
(
43 courses,
2 reviews
)
3 months ago
The course went smooth and it was straight-forward and easy to comprehend much better than other courses that I've took. Very easy to understand the professor and not back-tracking trying to trouble-shoot the course.
Which should of already been done with a quality assurance check from the creators of the course itself. I was pleased with the information that was provided within this class.
Now, it's time to practice, practice, practice!!!
Course content
Expand all
88 lectures
08:36:34
+
–
Course Introduction
7 lectures
37:05
+
–
SQL Statement Fundamentals
17 lectures
01:40:59
SQL Statement Fundamentals
00:42
SELECT Statement
10:48
Challenge: SELECT task.
02:45
SELECT DISTINCT
05:46
Challenge: SELECT DISTINCT
02:05
SELECT WHERE
14:03
Challenge: SELECT WHERE
03:45
LIMIT
02:59
ORDER BY
10:05
Challenge: ORDER BY
03:38
BETWEEN
08:44
IN
08:27
LIKE
10:24
General Challenge 1
09:54
+
–
GROUP BY Statements
6 lectures
52:43
+
–
Assessment Test 1
3 lectures
01:43
Overview of Assessment Test 1
01:08
Assessment Test 1
00:21
Solutions to Assessment Test 1
00:14
+
–
JOINS
8 lectures
01:10:36
Overview of JOINS
00:21
AS Statement
03:37
Overview of Inner Join
18:52
Examples of Inner Joins
16:21
Overview of Join types
12:55
Example of Outer Joins
11:47
Union
06:21
Join Challenges
00:22
+
–
Advanced SQL Commands
6 lectures
53:05
Overview of Advanced SQL Commands
00:33
Mathematical Functions
06:37
String Function and Operators
07:11
SubQuery
15:01
Self-Join
14:17
+
–
Creating Databases and Tables
16 lectures
01:50:53
Overview of Section
03:28
Data Types
07:21
Primary Keys and Foreign Keys
09:43
Resource for Create Table Code
00:44
Note on Constraints
00:19
Create Table
19:47
Challenge: Create Table
00:24
Challenge: Create Table - SOLUTION
05:50
Insert
15:31
Update
10:30
Delete
04:23
Alter Table
06:38
Drop Table
05:24
CHECK Constraint
09:48
NOT NULL Constraint
06:09
UNIQUE Constraint
04:53
+
–
Assessment Test 3
2 lectures
01:27
Assessment Test 3
00:58
Solutions to Assessment Test 3
00:28
+
–
Extra: Views
1 lecture
08:48
Views
08:48