Chapter 8: Structured Query Language-002
Structured Query Language
Advantages of using Structured Query Language, Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data Types.Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, Data Query: SELECT, FROM, WHERE.Data Manipulation: INSERT, UPDATE, DELETE.Math functions: POWER (), ROUND (), MOD ().
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().
Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*). Querying and manipulating data using Group by, Having, Order by. Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN
| Questions | 15 Questions |
|---|---|
| Duration | 15 Minutes |
| Negative Marks | 1 Marks |
| Positive Marks | 5 Marks |
| Paid/Free | Paid |
| Amount | 5 |