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

Published: 15 December 2018
on channel: Questpond

263,294

Buy Sql Server course from here https://www.questpond.com/sql-server-...
For more such videos visit http://www.questpond.com
For more such videos subscribe    / questpondvideos

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 :-
JavaScript Interview Questions:    • JavaScript Interview Questions & Answ...
Python Tutorial for Beginners:-    • Python Tutorial for Beginners | Learn...
Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- https://tinyurl.com/y6thhkxw
PHP Interview Questions :    • PHP Interview Questions and Answers |...
Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN
Learn Tableau step by step :- https://tinyurl.com/kh6ojyo
Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu
C# tutorial for beginners(4 hrs):-    • C# Tutorial for Beginners | C# Step b...
ASP.NET MVC Core Interview Questions with answers:-    • ASP.NET MVC Interview Questions with ...
C# interview questions and answers:-    • C# Interview Questions and Answers | ...
Learn Angular tutorial step by step https://tinyurl.com/ycd9j895
Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv
Learn Azure Step by Step:-    • Azure Tutorial for Beginners | Azure ...
Azure AZ-900 fundamentals certification :-    • AZ 900 Certification | AZ 900 Certifi...
Angular Interview Questions and Answers :-    • Angular Interview Questions and Answe...
Learn Design Pattern Step by Step https://goo.gl/eJdn0m
Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHePu

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?

For more details contact questpond@questpond.com OR call +919967590707-9619842789.

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

On this page of the site you can watch the video online Learn SQL in 1 Hour | SQL Tutorial for Beginners | SQL Tutorial Step by Step with a duration of hours minute second in good quality, which was uploaded by the user Questpond 15 December 2018, share the link with friends and acquaintances, this video has already been watched 263,294 times on youtube and it was liked by 4 thousand viewers. Enjoy your viewing!