The Complete SQL Bootcamp
4.6 /5- 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  |
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
The Complete SQL Bootcamp at UDEMY Course details
- Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
- Use SQL to query a database
- Use SQL to perform data analysis
- Be comfortable putting SQL and PostgreSQL on their resume
- 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
Student Forum
Anything you would want to ask experts?