Count Function in SQL | Count_BIG() | Count(DISTINCT Col)| WHILE Loop in SQL | ASNI NULL Warning

This channel would provide new videos on SQL, ETL and Data warehouse concepts. I would create a separate play list for SQL Tutorials for beginners, advanced concepts, Interview questions and data warehousing concepts

Feel free to drop me an email at [email protected] in case of any queries you have in SQL :)

Text Version of Video: https://sqlwithravimartha.blogspot.com/2020/09/count-function-in-sql-20-20-count.html

Video 19: Warnings SQL? | Null value is eliminated by an aggregate or other SET operation --*https://youtu.be/XjXn-QQqHN0
Text Version of Video: https://sqlwithravimartha.blogspot.com/2020/08/can-we-update-view-in-sql-18-click-here.html

Video 18: Can we Update a View in SQL? --*https://youtu.be/0D_KQrMdGmw
Text Version of Video: https://sqlwithravimartha.blogspot.com/2020/08/can-we-update-view-in-sql-18-click-here.html

Video 17: Sorting in SQL | Sorting Interview Questions --*https://youtu.be/lVRkp_Ern3s
Text Version of Video: https://sqlwithravimartha.blogspot.com/2020/08/sorting-interview-questions-17-create.html

Video 16: Union Vs Union All | With Examples | Prerequisites for Union and Union All | Performance Comparison --*https://youtu.be/1DRZ4P7UaqQ
Blog: https://sqlwithravimartha.blogspot.com/2020/08/union-vs-union-all-with-examples-16.html

Video 15: Import data from File to table in SQL Server |.txt, .csv files to table|Import Flat File|Import Data --*https://youtu.be/55JpeOxmNgM
Blog: https://sqlwithravimartha.blogspot.com/2020/08/import-data-from-file-to-database-15.html

Video 14: Find Employees With Salary Lower Than Their Department Average in SQL --*https://youtu.be/7q6TlvTIHB8
Blog: https://sqlwithravimartha.blogspot.com/2020/08/find-employees-whose-salary-is-higher.html

Video 13: Find Employees With Salary Lower Than Their Department Average in SQL --*https://youtu.be/2I9FRVzxa1g
Blog: https://sqlwithravimartha.blogspot.com/2020/07/blog-post_26.html

Video 12: Import Tables from one Server to another Using SSMS | Import tables using SQL Query in SSMS --*https://youtu.be/MZ1UfBPoxvg
Blog: https://sqlwithravimartha.blogspot.com/2020/07/importing-tables-from-one-server-to.html

Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --*https://youtu.be/dkQB9I3PgrQ
Blog: https://sqlwithravimartha.blogspot.com/2020/07/table-variables-in-sql-server-11-click.html

Video 10: Quick Practical onTemporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table--*https://youtu.be/QxMeM1QNveM
Blog: https://sqlwithravimartha.blogspot.com/2020/07/temporary-tables-quick-practical-in-sql.html

Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- *https://youtu.be/3zUBwtlY1u4
Blog: https://sqlwithravimartha.blogspot.com/2020/07/temporary-tables-in-sql-server-temp.html

Video 8: Running total & Avg in SQL | Cumulative Sum & Avg in SQL | Calculating running total & Avg in SQL -- *https://youtu.be/ACv9JNHmmPw
https://sqlwithravimartha.blogspot.com/2020/07/running-total-avg-or-cumulative-sum-avg.html

Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- * https://youtu.be/3wnFJ0d9WFs
https://sqlwithravimartha.blogspot.com/2020/07/tricky-case-statement-interview.html

Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- * https://youtu.be/oVFYlK9zrpc
https://sqlwithravimartha.blogspot.com/2020/07/tricky-case-statement-interview.html

Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- * https://youtu.be/XzfPpP_VWgs
https://sqlwithravimartha.blogspot.com/2020/07/blog-post.html

Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- * https://youtu.be/DaflPqe3Q3M
https://sqlwithravimartha.blogspot.com/2020/06/differences-between-truncate-drop-and.html

Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting -- *https://youtu.be/eqSThzHVbSw
https://sqlwithravimartha.blogspot.com/2020/06/sorting-interview-questions-part-1.html

Video 2 Title: Difference between Primary Key and Unique Key -- *https://youtu.be/kRBVT-uDJYA
https://sqlwithravimartha.blogspot.com/2020/06/differences-between-primary-key-and.html

Video 1 Title: Logical Processing of SELECT Statement -- *https://youtu.be/YZB8p2Anhr4
https://sqlwithravimartha.blogspot.com/2020/06/logical-processing-of-select-statement.html

SQL Step by Step Video 8 Title: UPDATE | DELETE | WHERE | ALTER | DROP in SQL -- *https://youtu.be/cOoV0rcYBdQ
https://sqlwithravimartha.blogspot.com/2020/08/sql-for-beginners-series-session-8.html


Blog: https://sqlwithravimartha.blogspot.com/

Facebook Page:
https://www.facebook.com/SQL-With-RaviMartha-109497027391239/
https://www.facebook.com/ETL-DWH-Testing-100494175057349/

Youtube Channel:
https://www.youtube.com/channel/UCSmWjwGkxhgHTUBvQEA3l4Q/