A crash course in SQL. How to write SQL from scratch in 1 hour.
In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL.
TABLE OF CONTENTS
Skip Intro/Discuss Management Studio 3:27
Create Database 5:10
Create Table 7:26
Insert Data 10:29
Select Statement 17:43
Where Clause 19:00
Update Statement 22:25
Delete Statement 24:33
Adding Comments 27:41
Adding Columns 29:33
Drop Table 32:38
Add Primary Key 33:17
Create Products Table 36:00
Create Orders Table 38:54
Foreign Keys 45:37
Joins 50:30
Functions/Group By 56:50
READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE
YOUTUBE NEWS UPDATES
VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
SUBSCRIBE TO OUR EMAIL LIST!
LET’S CONNECT!
Google+:
Facebook:
Twitter:
Linkedin:
SQLTrainingOnline:
Nguồn: https://sam-pointer.com/
Xem thêm bài viết khác: https://sam-pointer.com/cong-nghe/
Xem thêm Bài Viết:
- Chipset B550 – Kẻ thay thế X570 với mức giá MỀM hơn rất nhiều
- Which SSD Is Better – Samsung 860 PRO vs 850 PRO SSD
- Installing Samsung Evo 860 250Gb SSD in G41 Board | Unbox, Review & how to install OS in ssd + HDD
- Samsung 860 EVO Review and Installation
- Lounch Startup Repair Windows 7 #Start Windows Normally #Blue Screen Starting Windows
![[ADR! Review] Trải nghiệm phòng Tổng Thống tại Vinpearl HaLong resort](https://i.ytimg.com/vi/1ifLKpYQrU4/maxresdefault.jpg)
![[Bí kíp du lịch] Cách săn vé máy bay giá rẻ chặng nội địa: Đà Nẵng, Hà Nội, Phú Quốc…](https://i.ytimg.com/vi/WBle6GXK7us/maxresdefault.jpg)
![[Hướng dẫn] Cách sử dụng Voucher Vinpearl khi đặt phòng khách sạn](https://i.ytimg.com/vi/15Igl8pFkbQ/maxresdefault.jpg)
I've learned more in 1 hour for free than 3 weeks on coursera for $80
okay that´s creepy now
still great video
Misleading title …
I learned SQL in 1Hour and 2 minutes !!!
40:00
Have you guys checked out this guy Akmar Nasir at goldenhacker794@gmail.com dude's a cyber guru, involved with cloning phones, hacked into my ex's gmail and Facebook, what let me knowing she was infidel and also gave my nephew some really outstanding school scores which he upgraded himself, cool way to have financial freedom as well. Get your bank blank ATM cards which could debit money from any a.t.m machine. Make $20,000 and more in a couple days. Bank transfers and wire transfers as well as PayPal jobs, change of credit record hes that good, had to make him my personal hacker. You could mail him as well if you got issues, he's as discreet and professional. He's kinda picky though so make mention of the reference. James referred you. Your welcome
Best thing that video is not from another indian guy. Don't get me wrong but, man, their accent it THICC and it's hard to listen through it for even 20 minutes
really nice video and well explained.
So good !
Thank you
That was awesome 👏
wow… it is a wonder lesson, go ahead, it is good job…….
Thank you so much, that was an amazing video, I can't believe that I understood the concept of SQL in an hour and this is thanks to you
Great video! Thank you!
why does a baseball bat cost nearly $200?
This video makes me extremely sleepy. The guy should do bedtime stories for Audible. On the other side the training is very good and a great introduction.
Great video!! Covered up every single thing I was not able to understand at school. Thanks man!!
thank god he talks normal.
Very interesting video – Well done!
Thanks very helpful ☺️☺️
Sir, you are a Professional and thanks a lot I actually learned very well as a beginner
Love such aesthetic presentation,very smart!
Great
Thank you Joey
Good
Thanks for sharing wonderful tutorial video. I have installed MSSQL-CLI on linux system, can you please share that how can we create users, and set full or specific permission on database through command prompt.
Regards
Sunny (sunglimp@gmail.com)
28:03
34:53
06:33
Thank you sir, you saved my life …
start lose my focus when talking about join :crying: ,
looks like i need more exercise with this SQL things.
Thanks for your great explanation!
A big like here. I will look it up on Udemy.. many thanks.
Legend – thank you for this super helpful and easy to understand tutorial!
Clear understanding
Needed a refresher. Thank you very much!
Thank you
Awesome work Joey… I really appreciate you.
3:00 Toad KEKW
Thanks it help me alot.
INTRO = One Direction – You & I
Hey Joey Blue i think you listened my requirement …thanks
Hi Joey, thank you for the video. How do I get the SQL environment like yours so that I can start entering the commands? Thanks so much!
This is such a helpful guide, 3 months of school into 1 clip!
Great video, make more of it!!!
Thank you for making SQL clearer to understand. I don't think it is hard, but if no one explains to you where to use a column and a table… and the brackets and use them to get a space, well I was taught by my instructor if you cannot get the name right, use the brackets and that will make the red marks go away.
@Joey Blue 33:33 why don't you have to specify how many Ints you want? I thought the number inside the varchar( ) was to set the max amount of first name and last name rows the table can handle
Where do I download the SQL you used?? If it is a beginner video then you should address where to download everything and not just assume we know.
ive been learning sql, i worked in a transport office where they used access and excel and it just didnt work, so I thought id have ago at building a full transport and warehouse db, which so far works easier and better. However with the db built, would you have to build a gui or some software to use it externally? As ppl who cant use sql wont know how to do it, however if they had a simple userface, it would just need inserting and would update itself