SQL Server

In this video we will try to understand what are aggregate functions what is the use of group by clause and how to use the having syantax We have a very simple table here which has country name...

In this lecture we will Learn how to Remove or delete the existing table using SQL statement. Using standard SQL we can create as as well as remove the database table from our existing database. The...

In this lecture we will learn about using UPDATE statement in SQL. As the name suggests UPDATE statement is used to update the data rows in a table. The UPDATE statement can update one or multiple...

In this lecture we will learn about using DELETE statement in SQL. As the name suggests DELETE statement is used to delete the data rows in a table. The DELETE statement can delete one or multiple...

In this lecture we will Learn how to modify or update the database table details using SQL statement. The "ALTER TABLE" statement is used to rename, add or drop table columns in the...

Welcome to Group 1's presentation on the Back end database, SQL Server. My name is Sivakumar. I have Angela, Matthew, and Kevin in our group for the discussion. Next slide please. So, this is...

In this video we will talk about four important Joins Inner Join Left Join Right Join and Full Outer Join In order to understand these four joins you can see that I have created two tables here One...

Hi there, I am Dave and here is my fast track preparation session for Microsoft 70-460 exam which is related to “Microsoft SQL Server 2014” and credits towards “Microsoft Certified Professional and...

Hi there, I am Dave and here is my fast track preparation session for Microsoft 70-458 exam which is related to “Microsoft SQL Server 2012” and credits towards “Microsoft Certified Professional,...

In this video my papa will explain you what is the difference between UNION and UNION All I know This is a tough question in the interview That was my kid Sanjana As she has said that in this video we...