Structured Query Language for CUET UG Computer Science Exam
10 videos • 3,362 views • by Learn TechToTech This Playlist covers the syllabus of Structured Query Language Includes: 1. Introduction of SQL 2. Data Definition Language 3. Data Query Language 4. Data Manipulation Language 5. CREATE TABLE, DROP TABLE, ALTER TABLE, 6. SELECT, FROM, WHERE 7. INSERT, UPDATE, DELETE 8. Math Function: POWER (), ROUND (), MOD (). 9. UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM () (Text Function) 10. Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME () 11. Aggregate Function 12. Group By, Having, Order By 13. Operations on Relations