- 34
- 1 437
ZeroLagZONE
Приєднався 30 сер 2020
I’m Madan Raj, a Software Developer, and I’m here to share my knowledge and experience with those who are looking to pursue a career in the IT sector. My goal is to help build a strong foundation in basic concepts, as interviews often focus on these fundamentals.
I started this channel with the hope of guiding and empowering young learners to have a successful career in tech. Let’s learn together and grow in this exciting field!
Feedback is always welcome as we continue to improve and learn from each other.
Thank you all for your support!
Don’t forget to like, share, and subscribe!
I started this channel with the hope of guiding and empowering young learners to have a successful career in tech. Let’s learn together and grow in this exciting field!
Feedback is always welcome as we continue to improve and learn from each other.
Thank you all for your support!
Don’t forget to like, share, and subscribe!
Day 20 | Temporary tables in SQL | SQL basics
"Hello everyone,
In this video, we will cover Temporary tables in SQL
Temporary tables are used to store intermediate results temporarily during the execution of a query or a session.
Types of Temporary tables
1. Local Temporary Tables
2. Global Temporary Tables
Link of Previous Video :- ua-cam.com/video/i8-E4xkq-KE/v-deo.html
SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html
View my Channel for more such videos :- www.youtube.com/@UCNau-ybZXju4Idd7XRQzFVw
Like Share and Subscribe
Happy learning!"
In this video, we will cover Temporary tables in SQL
Temporary tables are used to store intermediate results temporarily during the execution of a query or a session.
Types of Temporary tables
1. Local Temporary Tables
2. Global Temporary Tables
Link of Previous Video :- ua-cam.com/video/i8-E4xkq-KE/v-deo.html
SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html
View my Channel for more such videos :- www.youtube.com/@UCNau-ybZXju4Idd7XRQzFVw
Like Share and Subscribe
Happy learning!"
Переглядів: 3
Відео
Day 19 | Indexes in SQL | SQL Advance
Переглядів 150День тому
"Hello everyone, In this video, we will cover Indexes in SQL Syntax:- Create Index IndexName On TableName (ColumnName Asc/Desc) Types of Indexes 1. Clustered Index 2. Non- Clustered Index Link of Previous Video :- ua-cam.com/video/97Ku6YtGvwA/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html View my Channel for more such videos :- www.youtube.com/@UCNau-...
Day 18 | Views in SQL | SQL Basics
Переглядів 5414 днів тому
"Hello everyone, In this video, we will cover Views in SQL Syntax 1.Create a View Create View ViewName As Select * From TableName 2.Drop a View Drop View If Exists ViewName If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/DZtUaItDis0/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc....
Day 17 | Type Casting in SQL | SQL Basics
Переглядів 3621 день тому
"Hello everyone, In this video, we will cover Type Casting in SQL Types 1. Cast() 2. Convert() If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/DZtUaItDis0/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html View my Channel for more such videos :- www.youtube.com/@UCNau-ybZXju4Idd...
Day 16 | Constraints in SQL | SQL Basics
Переглядів 5021 день тому
"Hello everyone, In this video, we will cover Constraints in SQL Types 1. Primary Key (Unique Not Null) 2. Foreign Key (To establish Relationship between tables) 3. Unique 4. Not Null 5. Check 6. default 7. Index If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/Reo2mwPKjwA/v-deo.html SQL Tutorial PlayList:- ua-cam.com/...
Day 15 | Subqueries in SQL | SQL Basics
Переглядів 7721 день тому
"Hello everyone, In this video, we will cover Subqueries in SQL Types of subqueries 1.Single Value Subqueries 2. Multiple Value SubQueries If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/iypudj7UbhE/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html View my Channel for more such...
Day 14 | Self Joins And Cross Joins in SQL | SQL Basics
Переглядів 4621 день тому
"Hello everyone, In this video, we will cover Self Joins And Cross Joins Self Join- Joining done within a table Cross Join - Returns Cartesian Product of two tables If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/o7yZYW-bSvw/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html Vie...
Day 13 | SQL Joins | Inner Joins and Outer Joins | SQL Basics
Переглядів 9221 день тому
"Hello everyone, In this video, we will cover Inner and outer Joins in SQL -Types of Join 1 Inner join 2 Outer Join -Left Outer Join / Left Join -Right Outer Join / Right Join -Full Outer Join / Full Join If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/kdF5kTVGkCE/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLl...
Day 12 | SQL Window Functions | SQL Basics
Переглядів 2721 день тому
"Hello everyone, In this video, we will cover Window Functions used in SQL 1. Rank() 2. Dense_Rank() 3. Row_Number() If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/DGiS99XGtds/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html View my Channel for more such videos :- www.youtube...
ACID Properties | RDBMS | SQL Concepts | Database
Переглядів 5221 день тому
Hello Everyone, In this Video, we will discuss about ACID Properties and its importance in Relational Database Management System. I hope you are Enjoying my Videos, let me know in the comment section Important Links for your reference SQL Tutorial : ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html SQL Exercises: ua-cam.com/play/PLlnOv_y34vKsAd98tMWkrsUuuqmOLHLJ-.html UA-cam Channel Link ...
SQL Exercises | Basic SQL | Part 2
Переглядів 4228 днів тому
Hello Everyone! In this video, we'll walk through how to write SQL queries to solve these problems, step by step. If you're new to SQL, no worries! I recommend checking out the SQL Playlist (link below), where I've covered concepts from beginner to advanced levels. It'll help you build a strong foundation and improve your SQL skills! SQL Tutorial Playlist: ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq...
SQL Commands | Types of SQL Commands | RDBMS
Переглядів 1228 днів тому
Hello everyone! Welcome to my UA-cam channel In this video, we're going to discuss SQL commands. We'll be discussing what SQL commands are, as well as the different types of SQL commands you should know. Important Playlist Links........ SQL Excercises :- ua-cam.com/play/PLlnOv_y34vKsAd98tMWkrsUuuqmOLHLJ-.html SQL Tutorial :- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html UA-cam Channel...
SQL Exercises | Basic SQL | Part 1
Переглядів 52Місяць тому
Hello Everyone! In this video, we'll walk through how to write SQL queries to solve these problems, step by step. If you're new to SQL, no worries! I recommend checking out the SQL Playlist (link below), where I've covered concepts from beginner to advanced levels. It'll help you build a strong foundation and improve your SQL skills! SQL Tutorial Playlist: ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq...
Day 11 | Use of Alias,Top, Percent and Order By in SQL | SQL Basics
Переглядів 50Місяць тому
"Hello everyone, In this video, I'll walk you through the use Alias, Top , Percent and Order By in SQL If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/v9iMRDtl45k/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html View my Channel for more such videos :- www.youtube.com/@UCNau-yb...
Day 10 | Group Function in SQL | SQL Basics
Переглядів 27Місяць тому
"Hello everyone, In this video, I'll walk you through the use of Group Functions in SQL If you have any doubts, feel free to leave your questions in the comments section. Link of Previous Video :- ua-cam.com/video/uA1FczD4OSA/v-deo.html SQL Tutorial PlayList:- ua-cam.com/play/PLlnOv_y34vKuJb3PkAHeq-AsbCi4NDXtc.html View my Channel for more such videos :- www.youtube.com/@UCNau-ybZXju4Idd7XRQzFV...
Day 9 | Date Functions in SQL | SQL Basics
Переглядів 112Місяць тому
Day 9 | Date Functions in SQL | SQL Basics
Day 8 | Number Functions in SQL | SQL Basics
Переглядів 72Місяць тому
Day 8 | Number Functions in SQL | SQL Basics
Day 6 | Use of Alter Command in SQL | SQL Basics
Переглядів 52Місяць тому
Day 6 | Use of Alter Command in SQL | SQL Basics
Day 5 | Like Operator and Wildcard Patterns | SQL Basics
Переглядів 39Місяць тому
Day 5 | Like Operator and Wildcard Patterns | SQL Basics
Day 4 | Distinct Keyword and Sp_Help in SQL | SQL Basics
Переглядів 47Місяць тому
Day 4 | Distinct Keyword and Sp_Help in SQL | SQL Basics
Day 3 | Select and Where Clause | SQL Basics
Переглядів 30Місяць тому
Day 3 | Select and Where Clause | SQL Basics
Day 2 | Syntax to Insert and Update Records in a Table | SQL Basics
Переглядів 29Місяць тому
Day 2 | Syntax to Insert and Update Records in a Table | SQL Basics
Day 1 | Syntax to Create Database and Table | SQL Basics
Переглядів 96Місяць тому
Day 1 | Syntax to Create Database and Table | SQL Basics
Addition of two numbers in C++ || C++ tutorial
Переглядів 33 роки тому
Addition of two numbers in C || C tutorial
To print "hello world " in C++ || C++ tutorial
Переглядів 83 роки тому
To print "hello world " in C || C tutorial
How to do it form level with sql or vba code. Front End Users are mostly working with forms
No idea, Will try to find out ...
plz upload your database too.
Done, Please check the Description Thanks for your Patience