HOT

A Complete SQL Bootcamp

Learn PostgreSQL for Data Science, Analytics and Reports. Start from the scratch and reach all the way!

  • Review rating
  • Review rating
  • Review rating
  • Review rating
  • Review rating
4.6 (41 ratings)
nullnull nullnull

30-day money-back guarantee

This course includes

5 h 58 min of video content
Beginner Difficulty
Perpetual Access
Access on mobile and Tablet
Share

Learning Objectives

learn to use SQL professional way, learn new SQL!
know how to prepare Data structures
start to create table relations by creating relational tables
know how to JOIN multiple table to get single result set for analysis reports
know how to simplify reports like spreadsheets! with huge data sets
learn how to protect your data by doing backup and restore methods!
learn how to write SQL statements easily
learn about pgAdmin GUI for postgreSQL server
learn to write analysis queries
prepare DASH BOARDS using aggregate functions

Table of Contents

54 lectures
5 h 58 min
Introduction
03:35
Course Curriculum overview
03:44
Overview of Databases
07:32
PostgreSQL Installation on Windows
12:38
Connecting to PostgreSQL using psql
04:15
Connecting to PostgreSQL using PgAdmin
07:21
Overview of Challenges
04:01
SQL Statement Basic
07:14
SELECT Statement
12:15
SELECT DISTINCT
09:39
Column AS Statement
06:32
SELECT COUNT(*)
06:46
SELECT WHERE Clause – One
05:43
SELECT WHERE Clause – Two
04:01
ORDER BY
04:53
LIMIT
04:53
BETWEEN
04:53
IN Operator
04:53
LIKE and ILIKE
04:53
Overview of GROUP BY
03:06
Aggregation Function
11:50
GROUP BY - One
04:40
GROUP BY - Two
06:14
HAVING
04:20
Overview of JOINS
06:46
Introduction to JOINS
06:03
AS Statement
04:35
INNER Joins
13:32
Full Outer Joins
04:04
Left Outer Join
02:56
Right Outer Join
04:36
Union
04:57
Basic of Advanced SQL Commands
03:30
Timestamps
16:50
Extract from Timestamp
05:10
Mathematical Functions
06:04
String Functions
16:19
SubQuery
07:59
Basic of Database and Tables
06:24
Data Types
07:08
Primary Keys and Foreign Keys
04:17
Create Table in SQL Script
16:44
Insert Statement in SQL
05:26
Update Statement in SQL
05:22
Delete Statement in SQL
03:15
Alter Table
05:22
Drop Table
01:53
Check Constraint
12:27
NOT NULL Constraint
04:24
UNIQUE Constraint
05:30
Overview of Databases and Tables
02:25
Creating a Database backup
03:15
Restoring a Database from backup
03:33

Description

Learn PostgreSQL, The first step to SQL you need to learn to succeed in SQL development, it is easy to learn and understand our online SQL Training course program is designed for you with the complete steps to require develop dynamic and complex queries. Mr. Sudha Sekhar will explain to you even complex topics to simplify and teach you, where beginners can understand easily with real-time examples.

Create a Good and Strong base foundation in SQL, With the Complete SQL from Scratch with PostgreSQL Course.

What is PostgreSQL

How to Install and Connect PGSQL Server

SQL Skills

SQL DataTypes

SQL Queries

SQL statements

SQL Built-in Functions

SQL Programming

SQL reading data rows

SQL updating data rows

Using PgAdmin for PostgreSQL

SQL Commands and Clauses

Database import and export using GUI tool

A Strong Skillset at Your Hands-on Query

Learn to built SQL applications using the PgAdmin tool. This course assumes no prior SQL knowledge(SQL language basics will help you), just a desire to learn to build your own analytics applications using SQL structures query language.

In this course we cover from scratch to create your own SQL analysis like all professionals creating SQL pages with basic instructions, you also learn inner query and complex Join to interacting with the different tables from a database to read dynamic data.

Content and Summary Who wants to start with beginning in SQL Development, through this course of 50+ lectures and hours of content, you’ll learn all of the PostgreSQL SQL Skills and establish a strong understanding of the concept behind SQL application implementation. Every Section closes with a challenge, putting your new learned skills into practical use immediately and Most of the Lectures are having Assignments to test your knowledge.

Starting with an introduction, how to use PgAdmin, controls, basics, and settings, etc.

Learning with these SQL skills, you will be eager to learn other programming languages very quickly that lead you to become a successful programmer/analyst.

If you really want to learn SQL, This Complete SQL from Scratch Course is for you to develop your skills more than others and you will become strong on SQL database Applications Development.

Who this course is for:

  • Beginner SQL developers curious about SQL course
  • People who want to learn SQL
  • People who have no idea about SQL
  • People who don’t know what is SQL
  • People who want to acquire SQL knowledge
  • People who beginners in SQL
  • People who want to become a professional on SQL

Featured Reviews

Profile Picture
Aug 03, 2021

Leela Venkata Siva K.

  • Review rating
  • Review rating
  • Review rating
  • Review rating
  • Review rating
The course was great. Sekhar Metla gives a lot of detailed information and breaks it down into small chunks with many exercises. The course is very well structured and easy to understand. Fantastic work by the instructor! I was very satisfied with what I got and will pursue other courses created by Sekhar Metla. I’ll definitely recommend it !! Thanks a million !!
Profile Picture
Sep 20, 2021

Abhitanshu K.

  • Review rating
  • Review rating
  • Review rating
  • Review rating
  • Review rating
Good.