Learn SQL in 1 Hour | SQL Tutorial for Beginners | SQL Tutorial Step by Step
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 [email protected] OR call +919967590707-9619842789.
#SQLServer #LearnSQL #SQLServerTutorial #SQLStepbyStep #SQLServerTutorialforBeginners
#StucturedQueryLanguage #SQLTutorial
Смотрите видео Learn SQL in 1 Hour | SQL Tutorial for Beginners | SQL Tutorial Step by Step онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Questpond 15 Декабрь 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 263,29 раз и оно понравилось 4 тысяч людям.