Page 181 - IT-802_class_12
P. 181
Syntax:
SELECT table1.column1,table1.column2,table2.column1,....
FROm table1
FULL JOiN table2
ON table1.matching_column = table2.matching_column;
WHERE,
table1: First table.
table2: Second table
matching_column: Column common to both the tables.
Example:
SELECT Student.NAmE,StudentCourse.COURSE_iD
FROm Student
FULL JOiN StudentCourse
ON StudentCourse.ROLL_NO = Student.ROLL_NO;
Recap Zone
Ð Ð Data is a collection of raw facts and figures, that is processed to produce meaningful information.
Ð Ð A database is an assembled group of data that enables easy and efficient storage, access, modification, and retrieval of data,
regardless of the amount of data being manipulated.
Ð Ð A database management system is a software package that controls the creation, maintenance and use of a database.
Ð Ð RDBMS is a relational DBMS in which tables are linked to each other by fields.
Ð Ð Constraints, are restrictions on the values, stored in a database based on the requirements.
Ð Ð SQL is a high-level interactive language that allows users to specify what is required to be done in the form of queries.
Ð Ð MySQL is one of the most popular database management system (DBMS) used for managing relational databases.
Ð Ð The CREATE TABLE command is used to create a table in SQL.
Ð Ð DESCRIBE or DESC command is used to describe the structure of a table.
Ð Ð In Structured Query Language, the ALTER TABLE statement allows you to add, modify, and delete columns from an existing
table.
Ð Ð UPDATE command is used to modify the existing records in a table.
Ð Ð A join clause is used to join two or more table rows based on the associated columns between them.
Ð Ð The INNER JOIN keyword selects all rows from both the tables as long as the condition is satisfied.
Ð Ð Left join returns all the rows of the table on the left side of the join and matches rows for the table on the right side of the join.
Ð Ð FULL JOIN creates the result set by combining the results of both LEFT JOIN and RIGHT JOIN.
Database Concepts—RDBMS Tool 179

