SQL Subquery | SQL Beginner Guide

SQL Subquery is another tool SQL Server has which can be used to fetch data from other tables to be used in main query according to the needs.  Inner query and nested query are other names of SQL Subquery. SQL Subquery can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators … Continue reading SQL Subquery | SQL Beginner Guide

SQL View Create Alter & Drop

SQL VIEW is very useful database object .  We will learn SQL CREATE VIEW , ALTER VIEW & DROP VIEW Statements today with the conceptual understanding of it as well. Now , If you have our College database you can do basic SQL queries practice . You can use our Sample College Database script & … Continue reading SQL View Create Alter & Drop

SQL Joins Explained | SQL Beginner Guide

SQL Joins is an SQL clause and it combines data from multiple tables on basis of related columns between them. So you have designed a wonderful DBMS & you have created an SQL database ( If Not? Use our sample database) to support your DBMS . You created an ERD & normalized it as well & … Continue reading SQL Joins Explained | SQL Beginner Guide