Learn SQL with PostgreSql Database [ SQL In A Lunch Break ] (Udemy.com)

Learn SQL incredibly fast with high quality videos and real-life examples

Created by: AKINCI Training

Produced in 2018

icon
What you will learn

  • 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 col

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 100 / 100

icon
Course Description

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!Who this course is for:
  • This course is for everyone who want to learn and use databases(especially PostgreSql)
  • This course focuses on SQL with PostgreSql. But everyone can take and start learning SQL with this course. Only some small points are different for other databases. This course will probably be very helpful for you to understand and use the SQL for other databases too

icon
Instructor Details

placeholder

Since its establishment in 2015, AKINCI Training has focused on e-learning, consultancy, software development, web programming and design with its experts who have more than 8 years of professional experience.
AKINCI Training's vision is to become a solution-oriented and reliable global company with highest customer satisfaction.
AKINCI Training has expertise mainly on software engineering, Java and Java Technologies training. Most of these courses were given to large-scale companies and multinational corporations.
AKINCI Training has experienced computer engineers that have worked on large-scaled software development projects at least 8 years, and now gives courses on:
- Java Programming Language (Beginner/Intermediate/Advanced Level)
- Java Design Patterns
- Java 2 Enterprise Edition (including nTier Architecture, Servlets, EJB(Enterprise Java Beans), JTA(Java Transaction API), JDBC, JAXP-SAX, JAXP-DOM)
- Hibernate with MySQL, PostgreSQL, SQL Server Express Edition and Oracle Databases,
- Spring Framework
- UML(Unified Modeling Language)
- JSP(JavaServer Pages)

- JSF(JavaServer Faces)
to share their experiences.
In AKINCI Training, the only important thing is you, and your success. And all of ou

icon
More courses by AKINCI Training

Step By Step Java Programming Complete Course

$11.99

icon
More postgresql courses

Rock the JVM! Akka Persistence with Scala

$11.99

SQL and PostgreSQL: The Complete Developer's Guide

$11.99

Practical SQL Bootcamp for Data Analysts and Data Scientists

$11.99

Python 3 Complete Masterclass - Make Your Job Tasks Easier!

$11.99

REST APIs with Flask and Python

$11.99

Python Django Dev To Deployment

$11.99

icon
Reviews

5.0

1 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Dane Scott

Things I like about this course:

- No large assumptions are made about prior experience. He takes it right from ground zero and explains the basics.

- The presentation is presented slowly enough to be understandable even if English isn't your first language.

- Pretty amazing price for what you're getting!