sql training institute in ambala ! batra computer centre

Email: info.jatinbatra@gmail.com

BATRA COMPUTER CENTREISO CERTIFIED 9001:2008

Website: www.batracomputercentre.comPh. No.: 8222066670, 4000670

Introduction๏A Business need๏Database

“An organized collection if information”Or

“Set of tables each having different class of data”

Structured Query Language (SQL)๏A language to communicate with the database๏A tool to retrieve the required information from database๏Elements

» Syntax of SQL is in plains English» To question the database

What SQL can do?1. Execute queries against a database2. Perform CRUD function:

» CREATE New database New table in a database Records in a database» READ Retrieve data from a database» Update Update Records in a database» DELETE Delete records from a database

Pre – requisites for SQL๏ Relational Database๏ Tables๏ Fields๏ Records๏ Different Relationships

» 1-1» 1-m

SYNTAX

SQL Queries

Function QueriesFunction queries in SQL involve manipulating functions in SQL statements to retrieve desired information from the databaseSuch function queries are of two board categories:» Aggregate Function queries

» Scalar Function queries

SQL join QueriesSQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.

Inner JoinThe Inner JOIN keyword return rows when there is an least one match in both tablesSyntaxSELECT column_name(s)

FROM table_name1INNER JOIN table_name2ON table_name1.column_name=table_name2.column_name

Outer JoinThe outer join clause differs from the INNER JOIN in that row are returned even when there are no matches through the JOIN criteria on the second table.Difference Explained:Assuming you’re joining on columns with no

duplicates, which is by far the most common case:An Inner join of A and B gives the results of A intersect B, i.e. the inner part of a Venn diagram intersectionAn outer join of A and B gives the results of A union B, i.e. the outer parts of a Venn diagram union

Left Outer JoinThe left JOIN Keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2)SyntaxSELECT column_name(s)FROM table_name1LEFT JOIN table_name2ON table_name1.column_name=table_name2.column_name

Right Outer JoinThe RIGHT JOIN Keyword Return all rows from the right table (table_name2), even if there are no matches in the left table (table_name2)SyntaxSELECT column_name(s)FROM table_name1LEFT JOIN table_name2ON table_name1.column_name=table_name2.column_name

Full JoinThe FULL JOIN keyword return rows when there is a match in one of the tables.SyntaxSELECT column_name(s)FROM table_name1LEFT JOIN table_name2ON table_name1.column_name=table_name2.column_name

ADDRESS:

SCO -15, Dayal Bagh,

Near Hanuman Mandir

Ambala Cantt-133001

Haryana

Ph. No.: 9729666670, 8222066670 &0171-4000670

Email ID: info.jatinbatra@gmail.com

Website: www.batracomputercentre.com

sql training institute in ambala ! batra computer centre

Education

seo services in ambala ! batra computer centre

internet training in ambala ! batra computer centre

photoshop training in ambala ! batra computer centre

ppc training in ambala ! batra computer centre

html training in ambala! batra computer centre

seo training in ambala ! batra computer centre

smo training in ambala! batra computer centre

smo training in ambala ! batra computer centre

learning institute in ambala ! batra computer centre

ppc learning in ambala ! batra computer centre

basiccomputer training in ambala ! batra computer centre

computer courses in ambala ! batra computer centre

seo training in ambala! batra computer centre

sql training centre in ambala ! batra computer centre

networking training in ambala ! batra computer centre

technology training in ambala ! batra computer centre

php training in ambala! batra computer center

internet training in ambala! batra computer centre

javascript training in ambala ! batra computer centre

php training in ambala ! batra computer centre