sql for beginners – دانلود

Learn SQL In 60 Minutes

In this video we will cover everything you need to know about SQL in only 60 minutes. We will cover what SQL is, why SQL is important, what SQL is used for, the syntax of SQL, and multiple examples of SQL. SQL is the standard language for interacting with and manipulating data in a relational database system, and is one of the most important concepts you can learn in programming. It allows you to create, read, update, and delete data which is something nearly every application will need to do.

IMPORTANT: Exercises Worksheet Repository:

How to Install MySQL:

Outline:
[00:00] – Intro
[05:10] – SQL Syntax
[07:30] – Create Database
[09:20] – Drop Database
[10:34] – Use Database
[11:22] – Create Table
[13:01] – Alter Table
[14:47] – Drop Table
[15:08] – Create Table (Part 2)
[15:35] – Band Table
[15:55] – Not Null
[16:10] – Primary Key/ID/Auto Increment
[18:40] – Album Table
[20:05] – Foreign Key/Table Relationships
[23:05] – Insert Into
[25:40] – Select
[26:27] – Limit
[26:52] – Specific Columns
[27:18] – As/Alias Columns
[28:20] – Order By
[29:24] – Insert Into (Part 2)
[32:04] – Distinct Select
[33:07] – Update
[33:40] – Where
[33:15] – Less Than
[33:55] – Like String Filter
[37:26] – Or
[38:04] – And
[38:40] – Between
[39:20] – Is Null
[39:46] – Delete
[41:00] – Join
[43:25] – Inner/Left/Right Comparison
[46:42] – Aggregate Functions
[48:05] – Group By
[50:40] – Combined With Join
[51:15] – Alias Tables
[53:57] – Having vs Where

Learn X in Y Minutes Playlist:

Twitter:

GitHub:

CodePen:

#SQL #LearnSQL #MySQL

#Learn #SQL #Minutes

learn sql

webdevsimplified,learn sql,learn sql in 1 hour,learn sql in 60 minutes,learn sql fast,learn sql for beginners,learn mysql,how to learn sql,how to learn sql quickly,how to learn sql fast,sql for beginners,sql for beginners tutorial,sql for beginners course,free sql course,free sql course for beginners,learn sql queries,learn sql queries step by step,how to write queries in sql,sql tutorial,sql tutorial for beginners,sql explained,sql in one video,sql

SQL For Beginners Tutorial | Learn SQL in 4.2 Hours | 2021

SQL is one of the most easy yet powerful programming languages. In SQL tutorial you will learn SQL in 4 hours and cover important SQL concepts. In this tutorial you will will learn about PostgreSQL and everything you need to know to get you started with databases.

Full SQL and Database Courses can be found below
1 ►
2 ►
3 ►

Exercise Files –

???? Subscribe to Amigoscode –

► Courses Available for free here –
► Join Private Facebook Group –
► Join Discord –

⭐ Table Of Contents ⭐
00:00 – Intro
02:30 – Quick Word Before we begin
03:25 – What is Database
07:18 – What is SQL
08:48 – SQL Example
12:33 – Postgres
15:05 – Install Postgres (MAC OS)
18:43 – Setup Postgres (MAC OS)
22:31 – Install Postgres (Windows
25:51 – PSQL (Windows)
30:55 – Learn SQL the right way
32:18 – Create Database
35:46 – Connecting to Databases
40:24 – Create Table Syntax + Datatypes
44:36 – Create Table Without Constraints
48:12 – Create Table With Constraints
54:56 – Insert Data
58:16 – Insert Into
1:01:47 – SELECT FROM
1:04:38 – Adding Data
1:14:39 – Sorting
1:19:22 – Removing Duplicates
1:21:30 – WHERE clause
1:25:00 – Comparison Operators
1:29:06 – LIMIT OFFSET and FETCH
1:32:24 – IN
1:35:28 – BETWEEN
1:37:30 – LIKE
1:42:55 – GROUP BY
1:46:30 – HAVING
1:52:04 – Car Table
1:55:45 – MIN MAX & AVG
1:59:53 – SUM
2:02:03 – Arithmetic Operators
2:06:14 – Working with Arithmetic Operators
2:10:01 – Alias
2:12:48 – Coalesce
2:16:34 – NULLIF
2:20:39 – Timestamps & Dates
2:20:39 – Adding & Subtracting Dates
2:26:36 – Extracting Fields From Dates
2:28:27 – Age Function
2:30:11 – Primary Keys
2:32:16 – Primary Keys (Part 2)
2:37:30 – Adding Primary Keys Constraints
2:41:58 – Unique Constraints
2:30:11 – Primary Keys
2:50:00 – Check Constraints
2:55:30 – Deleting Records
3:02:25 – Updating Records
3:06:44 – On Conflict Do Nothing
3:11:57 – On Conflict Do Update
3:17:29 – Foreign Keys & Relationships
3:20:45 – Adding Foreign Keys
3:25:59 – Updating Foreign Keys
3:30:26 – Inner Joins
3:36:04 – Left Joins
3:41:49 – Deleting Foreign Keys
3:48:37 – Sequences
3:55:19 – Extensions
3:57:42 – UUID
4:04:12 – UUID in Action
4:14:47 – Exporting to CSV
4:18:02 – Next steps
4:20:00 – Database Design Course

???? Here are the goods for all my videos video:

► Recommended Books

Clean Code
–

HTTP: The Definitive Guide
–

Clean Architecture
–

► Computer and Monitor

New Apple MacBook Pro
–

Dell 27 INCH Ultrasharp U2719D Monitor
–

Double Arm Stand Desk Mount
–

USB C Hub Multiport Adapter
–

► Camera Gear

Sony ILCE7M3B Full Frame Mirrorless Camera
–

Sigma 16 mm F1.4 DC DN
–

Sigma 33B965 30 mm F1.4 DC DC
–

Awesome Screen Saver
–

IDE I use for coding
– Iterm
– VsCode
– GoLand
– IntelliJ
– Sublime

???? You can also follow me here:
► Don’t forget to subscribe |
► Join Closed Facebook Group for discussion and early access videos and courses |
► Follow me on Instagram |
► Join Discord –

❤️ Thanks for watching

#SQL #Beginners #Tutorial #Learn #SQL #Hours

learn sql

amigoscode,sql,postgresql,structured query language,postgresql course,sql tutorial,learn sql,postgresql tutorial,database,postgresql tutorial for beginners,databases,postgres,relational database,pgadmin,sql beginners,sql course,postgres tutorial,postgressql,history of postgresql,what is postgres,what is postgresql,datagrip,learn how to code,sql for beginners,sql interview questions and answers,sql injection