Learn SQL with PostgreSql Database [ SQL In A Lunch Break ]
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
This course provides an information about the author of this course.
This course provides an information about the video quality standards of AKINCI Training that's applied to this course too.
This course provides an information about the audio quality standards of AKINCI Training that's applied to this course too.
Basic Operations - Part 1
In this video, you'll briefly learn using PostgreSql database management software, named PgAdmin. We'll create database with using "CREATE DATABASE" statement.
In this video, you'll learn dropping an existing database with using "DROP DATABASE" statement in your queries.
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.
In this video, you'll learn dropping an existing table with using "DROP TABLE" statement.
In this video, you'll learn inserting data into a table with using "INSERT INTO" statement.
In this video, you'll learn selecting all values of a column with using "SELECT FROM" statement.
In this video, you'll learn using "WHERE" clause to specify a condition while selecting values of a table.
In this video, you'll learn selecting only different values of a table column with using "SELECT DISTINCT" statement.
In this video, you'll learn ordering table values in ascending or descending order according to a column with using "ORDER BY" keyword.
This video contains introductory information about SQL constraints.
In this video you'll learn the meaning and the usage of a primary key and assigning a column as auto incremental.
In this video you'll learn the meaning and the usage of a foreign key.