Learn SQL in 1 Hour | SQL Tutorial for Beginners | SQL Tutorial Step by Step

Timestamp -
00:00 - Introduction
5:40 - SQL Practice 1: - Select all columns and all rows of the table.
7:05 - SQL Practice 2: - Select Only Needed Columns from Table.
8:12 - SQL Practice 3: - Select using a numeric criteria.
8:48 - SQL Practice 4: - Select using a string criteria.
9:39 - SQL Practice 5: - Select using AND and OR.
10:32 - SQL Practice 6: - Sort Data using Ascending & Descending.
11:57 - SQL Practice 7: - Provide user friendly ALIAS for column names.
12:38 - SQL Practice 8: - Display unique records from a table.
13:41 - SQL Practice 9: - Searching using patterns and wildcards.
17:31 - SQL Practice 10:- Create runtime calculated columns.
18:50 - SQL Practice 11:- CASE statements with SQL.
23:45 - SQL Practice 12:- Join data from twp SELECTS using UNION and UNION ALL.
30:25 - SQL Practice 13:- Show matching data from two tables.(Inner Join)
32:16 - SQL Practice 14:- Show all records from one table and only matching record from other table.(Left and Right)
34:43 - SQL Practice 15:- Show all records from matching or unmatching.(FULL Outer Join)
35:48 - SQL Practice 16:- Show Cartersian of two tables.(Cross Join)
39:26 - SQL Practice 17:- Writing a complex SQL inner join statement.
45:15 - SQL Practice 18:- Display Aggregate values from a table (GROUP BY).
48:33 - SQL Practice 19:- Filter on Aggregate values (Having Clause).
50:10 - SQL Practice 20:- Self Join
54:19 - SQL Practice 21:- ISNULL
54:58 - SQL Practice 22:- Sub Queries.
57:31 - SQL Practice 23:- Co-related Queries.
1:01:59 - SQL Practice 24:- Find Max, Min and Average.
1:03:22 - SQL Practice 25:- Find the between numeric values.
1:04:42 - SQL Practice 26:- Dump table data into new table (SELECT INTO).
1:06:05 - SQL Practice 27:- Get the top 2 records from a recordset.
1:07:19 - SQL Practice 28 :- Insert data into table.
1:09:00 - SQL Practice 29:- Bulk insert into existing table.
1:11:54 - SQL Practice 30:- Insert data into table.
1:12:40 - SQL Practice 31:- Update data into table.
1:14:44 - SQL Practice 32:- Delete Data from a table.
1:16:34 - Tip:- The SQL designer window.

See our other Step by Step video series below :-

Learn SQL Server Step by Step:-
Lab 1:- Basic Fundamentals Database, Tables, rows and columns.
Lab 2:- Primary key, foreign key, referential integrity and constraints.
Lab 3 :- Database Normalization (1st, 2nd and 3rd normal forms).
Lab 4: - SQL basics(Select, Insert, Update and Delete)
Lab 5 :- DDL (Data definition language) Queries.
Lab 6: - Transactions, Locks and Isolation level in SQL Server.
Lab 7: - ISNULL and Coalesce functions.
Lab 8: - Row_Number, Partition, Rank and DenseRank
Lab 9: - Triggers, inserted and deleted tables
Lab 10: - Instead of and after triggers.
Lab 11: - Denormalization, OLTP and OLAP.
Lab 12: - Understanding Star schema and Snow flake design.
Lab 13: - SQL Server 8 kb pages.
Lab 14 :- Index and performances
Lab 15 :- Page Split and indexes
Lab 16 :- Clustered vs non-clustered
Lab 17: - Stored procedures and their importance.
Lab 18: - Change Data Capture.
Lab 19: - Explain Columnstore Indexes?
Lab 20: - SQL Server agent
Lab 21: - How can we implement Pivot & Unpivot in SQL Server?

#SQLServer #LearnSQL #SQLServerTutorial #SQLStepbyStep #SQLServerTutorialforBeginners
#StucturedQueryLanguage #SQLTutorial

[questpondvideos]

If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free.

[goodyoearsproduction]

@27:12 The reason why you were able to select a result set without error at first, but then second-time SQLServer threw error was, you highlighted the top select statement and executed it. :-) Good video though.

[vijayswamy]

I am a beginner, excellent tutorial. Complete with great depth. Thank you very much

[prathabhardwaj]

the best SQL video i have seen on youtube

thanks a lot

[pravinpawar]

This is more helpful for beginner Thanks so much

[raginikumari]

Excellent course.. Learnt lot of things.. Thank you Questpond.

[AplusAcombatMMASports]

One the best tutorial I have ever seen thank you so much for your knowledge sir I really appreciate 👍👍👍👍👍

[cortinas]

Amazing tutorial, quite straight and great examples.

[dergimorka]

i really thank you much from the bottom of my heart u gave me a clear understanding about the concept of all the video u did

[michaelchrestensen]

Case expression is the correct terminology. Pointing out if you are taking tests the terminology matters, they can try and trick you! Predicate, clause, statement, expression, search argument, try to make sure you understand the differences is my point.

[vipulwaghela]

THANK YOU SIR,
FOR TEACHINING. :-)
GOOD UNDERSDENDING THIS VIDEO CONCEPT FOR SQL,

[ibrahimacoulibaly]

Excellent teaching style! Kudo to you, sir!

[RinilaGasse]

First I want to complement you with this video, it it clearly build up and takes the viewer through the steps in an ordered manner. I am using it to freshen up my SQL knowledge for a test coming up.
Secondly I would like present you with an improvement for practice 23. The query you present is not compatible when products have the same cost. When two products share the same value nothing is returned.

Using the 'SELECT TOP' statement make it so the query is not dependent on the hardcoded COUNT(*) statement.
When using the code below you can play with the integer after SELECT DISTINCT TOP

SELECT a.ProductName FROM tblProduct a
WHERE a.ProductCost =
(SELECT TOP 1 ProductCost FROM
(SELECT DISTINCT TOP 3 b.ProductCost
FROM tblProduct b
ORDER BY b.ProductCost DESC)
tblProduct
ORDER BY ProductCost)

I know their are obviously more ways to things nonetheless I wanted to point this out. I like you vids, keep up the good work

[Aeditya]

For Practice SQL example 2 anyone can help...?
So far my query :
select p.ProductName, sum(productcost) as TotalSales, count(t.Productid_fk) as [Count]

from tblProduct p
full outer join
tblTotalSales t
on p.ProductId= t.Productid_fk
group by ProductName

the problem is with totalsales for count 0 its showing ProductCost as I am taking sum of productcost how to solve this sir..please help me @Questpond

[alfreditomaciasunapaja]

Thanks for sharing this, greetings from Mexico.

[NovPiseth]

thanks you. it is completed teaching and lab.

[tanveersyed]

quality of training very neat nd clear.... excellent

[rehantayyab]

Please can you share such lab for oracle database students as well

Where first u create all schema and tables and then we test these scenarios 1 by 1

[joly-jay]

I am unable to find the PracticeSql file, please provide a link

[marieclairemuhnyong]

Thanks for the video. Please i am not able to get the practice sql database. Can some one help me?