5 out of 5
5
1 review on Udemy

Learn SQL with PostgreSql Database [ SQL In A Lunch Break ]

Learn SQL incredibly fast with high quality videos and real-life examples
Instructor:
AKINCI Training
12 students enrolled
English
Create or drop databases
Create or drop tables
Insert or delete data into tables
Select and show table contents
Select table contents that has a condition
Select only distinct(unique) items of a table
Order the result by ascending or descending order
Understand and use primary and foreign keys
Create unique or not null table columns
Set default values automatically to table columns
Check a condition before inserting data into a table
Use indexes to have higher performance
Use AND, OR and NOT operators to have more than one conditions
Select table values that has a pattern within
Select values in the given range
Add, drop or modify table columns
Update or delete table values
Show the union of more than one tables
Group table contents
Group table contents that has a condition
Get the minimum or maximum value of a table column
Count table values
Calculate the sum or average or a table
Create auto incremental primary keys

This course contains detailed information about SQL.

Do you want to learn SQL less than a hour? We designed this course to teach important points of SQL in 1 hour.

Every video on this course is designed for you to teach every topic less than 2 minutes. You’ll learn every topic in 1-2 minutes with animations and effects!

SQL, which stands for Structured Query Language, is a programming language that is used to communicate with and manipulate databases.

You’ll learn all SQL statements, constraints, operators, clauses and functions on real-life examples. We prepared lots of example queries for you to teach them all.

We’ll teach you SQL with real life examples on popular PostgreSQL database.

We don’t want to waste your time, because we eliminated unnecessery parts, comments and etc. We focused only the important points of topics. And also we are trying teach slow enough for you to follow easily too.

In addition to them, this course also contains AKINCI Training’s quality standards:

  • Dubbed by 40-year-experienced voiceover professional, in his professional recording studio,

  • All videos has 1920 x 1080 full HD resolution, video animations and effects,

  • All videos have closed captions for you to understand easily,

  • And contains premium support which means average response time is less than 24 hours

Join us now!

Introduction to the Course

1
About Author

This course provides an information about the author of this course.

2
About Our Video Quality Standards

This course provides an information about the video quality standards of AKINCI Training that's applied to this course too.

3
About Our Audio Quality Standards

This course provides an information about the audio quality standards of AKINCI Training that's applied to this course too.

Basic Operations - Part 1

1
CREATE DATABASE Statement : Creating Databases

In this video, you'll briefly learn using PostgreSql database management software, named PgAdmin. We'll create database with using "CREATE DATABASE" statement.

2
DROP DATABASE Statement : Dropping(Removing) Databases

In this video, you'll learn dropping an existing database with using "DROP DATABASE" statement in your queries.

3
CREATE TABLE Statement : Creating Tables

In this video, you'll learn creating tables with using "CREATE TABLE" statement in your queries. In addition to it, you'll learn to specify some basic properties of a table in CREATE TABLE queries.

4
DROP TABLE Statement : Dropping(Removing) Tables

In this video, you'll learn dropping an existing table with using "DROP TABLE" statement.

5
INSERT INTO Statement : Inserting Values Into A Table

In this video, you'll learn inserting data into a table with using "INSERT INTO" statement.

6
SELECT FROM Statement : Getting All Data From A Table

In this video, you'll learn selecting all values of a column with using "SELECT FROM" statement.

7
WHERE Clause : Filtering Records Before Getting Them

In this video, you'll learn using "WHERE" clause to specify a condition while selecting values of a table.

8
SELECT DISTINCT Statement : Selecting Only Distinct(Different) Data

In this video, you'll learn selecting only different values of a table column with using "SELECT DISTINCT" statement.

9
ORDER BY Keyword : Ordering Result By Ascending or Descending Order

In this video, you'll learn ordering table values in ascending or descending order according to a column with using "ORDER BY" keyword.

Constraints

1
Introduction to Constraints

This video contains introductory information about SQL constraints.

2
PRIMARY KEY Constraint & SERIAL : Auto Incremental Unique Identifier Columns

In this video you'll learn the meaning and the usage of a primary key and assigning a column as auto incremental.

3
FOREIGN KEY Constraint : Creating Links To Other Tables

In this video you'll learn the meaning and the usage of a foreign key.

4
NOT NULL Constraint : Setting Table Columns As Not Null
5
UNIQUE Constraint : Ensure That Columns Have Unique(Different) Values Within
6
DEFAULT Constraint : Providing Default Values To Columns
7
CHECK Constraint : Checking A Condition Before Completely Executing A Query
8
INDEX Statement : Creating Indexes to Have Higher Performance

Basic Operations - Part 2

1
LIKE Operator : Searching A Specified Pattern In A Column
2
AND, OR & NOT Operators : Using More Than One Conditions In A Query
3
BETWEEN Operator : Selecting Values In The Given Range
4
ALTER TABLE Statement : Adding, Dropping And Modifiying Table Columns
5
UPDATE Statement : Updating Column Data
6
DELETE Statement : Deleting Table Data
7
UNION Operator : Combining More Than One Table Data
8
GROUP BY Statement : Grouping Table Column Values
9
HAVING Clause : Grouping Table Column Values That Have A Condition

Functions

1
AVG() Function : Calculating The Average Value of A Column
2
MIN() and MAX() Functions & AS : Getting Minimum And Maximum Values In A Column
3
COUNT() Function : Counting Table Data
4
SUM() Function : Calculating The Sum of Column Values
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
5
5 out of 5
1 Ratings

Detailed Rating

Stars 5
1
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0
c1fe5c5ab0073452a399348b65dbbd68
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion