SQL Tutorial: Learn SQL In One Video | Udemy Instructor, Jon Avis

In this video, SQL Tutorial: Learn SQL In One Video you will learn SQL in under 90 minutes.

You will learn: the basics of relational databases, how to install PostgreSQL, how to create, modify and delete tables, how to insert, update and delete data, how to select data from a table, how to order data, how to use where clauses and how to use joins. This will give you a great foundation in databases and SQL.

If you want to boost your SQL skills to the next level check out the full course, SQL & PostgreSQL for Beginners, using the coupon code link above. In the full course you will:

• Create a database for an online store
• Learn how to select data from a table
• Learn how to use where clauses
• Learn how to use IN, NOT IN, BETWEEN and LIKE statements
• Learn how to order data
• Use the distinct and limit statements
• Create column name aliases
• Write INNER, FULL, LEFT and RIGHT JOIN queries
• Write UNION and UNION ALL statements
• Learn how to use aggregate functions including SUM, COUNT and AVG
• Learn how to group data by column and use having clauses
• Learn how to CREATE, ALTER and DELETE tables
• INSERT INTO, UPDATE and DELETE data from tables
• Complete many exercises and challenges with video solutions

Useful links:

#sql
#postgresql
#databases

#Udemy
#ITeachOnUdemy

Share your story with #BeAble

[ovyjohn]

from Nigeria, I love this tutorial. the explanation is clear

[NnamdiUchegbu-wo]

i had to download this video, in fact you were teaching i was practicing along side, wow, am so glad and i thank God i came across your SQL video as a beginner, i would watch over and over again.

[idriskabiru]

This is one of the amazing classes of SQL I have seen so far. 👌
Thank you very much.

[sarin]

Very helpful for beginners. Up to the point and no loose talks. Worth the time. Thanks.

[olivervanrooyen]

This was a brilliant video for me being new to sql... Thumbs up for this content... 👍

[sabarish]

excellent tutorial for beginners that everyone can easily understand, thank you

[lowenzakirwan]

Most comprehensive piece of information regarding SQL online.
Thank you.

[luciadossantos]

This video is great for a beginner like me! Very easy to follow.

[felexkemboi]

Thank you for this Sir, its a very good resource to jumpstart in sql

[kamalchand]

Well explained most of the important concepts for SQL beginners like me.

[ragavendranravi]

Excellent video for beginners in SQL.. thank you

[unknownhimanshu]

Sir thankyou so much for doing all this work

[henrislyd]

takes the fear away from SQL, very helpful

[immanuelsamuelgwu]

For the PRIMARY KEY example table even the full name column uniquely identifies all row in the table?. correct me If I'm wrong.

[rajaswisama]

How can i change table name....plz ans me

[padamaabhi]

Hey, I am learning the course on udemy, I am stuck at Lecture 78. I have left the query 2 months back. Can you please resolve so I could move forward. When I am inserting values in reserved_seat table: Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails (`cinema_booking_system`.`reserved_seat`, CONSTRAINT `reserved_seat_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`))

[vishnuvrv]

Whenever I try to create a table it throws an error "ERROR: CREATE DATABASE cannot run inside a transaction block
" How to fix this?

[PavanKumar-mhxt]

how to solve ERROR:CREATE DATABASE cannot run inside a transaction block ?

[conradbennett]

I created my own table in Postgre SQL following the directions in video, I get stuck up while adding Foreign Key, Query isn't returning back successfully, I fully understand the steps he described but when I follow in same steps with my own table, I got stuck with Defining Foreign key part, its bit challenging but at the same time, it helping me to apply different approaches and learn more about SQL Queries

[thepuppiesworldedition]

ERROR: CREATE DATABASE cannot run inside a transaction block
how can i sort it ?