-
SQL – Introduction
SQL -Introduction (1) What Is SQL? SQL Stands for Structured Query Language. SQL is a query language which helps us to send queries to the database and get our results back. Language allows us to talk to another person and get connected with each other. Similarly, SQL language helps us to connect with the SQL database and get our results. (2) What SQL Can Do? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records into a database SQL can update records in a database SQL can delete records from a database
-
SQL – Syllabus
SQL Syllabus Part-1 Introduction To SQL SQL Syntax Rules SQL Select Statement SQL Select Distinct Statement SQL Where Statement SQL And, Or, Not Keywords Part-2 SQL Order By Statement SQL Insert Into Statement SQL NULL Values SQL Update Statement SQL Delete Statement SQL Select Top Statement Part-3 SQL Min and Max Functions SQL Count(), Avg(), Sum() Functions SQL Like Keyword SQL Wild Card Characters SQL In Keyword SQL Between Operator SQL Aliases Part-4 SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join Part-5 SQL Union SQL Group By SQL Having SQL Exists
