Advanced Database

 

Advanced Database 

Unit - I MySQL Functions, Subqueries and Join

Aggregate functions (avg, count, min, max, sum)

https://drive.google.com/file/d/15-YJTjrpzFcpxg9G9SNTfReloThOVLq0/view?usp=sharing

String Functions (concat, instr, mid, length, strcmp, trim, ltrim, rtrim)

https://drive.google.com/file/d/19jjHeEv1awCbRyRjtLVQWb7SdHjKJYS-/view?usp=sharing

Math Functions (abs, ceil, floor, mod, pow, sqrt)

https://drive.google.com/file/d/10bjog80_28LEx2-Lxw-lXq6xNacBLcAS/view?usp=sharing

Date and Time Functions (adddate, datediff, day, month, year, hour, min, sec)

https://drive.google.com/file/d/1u1AP6YjeZLnspRzcXbT4paANxrURC-LS/view?usp=sharing

Conceptsof Subqueries, subqueries with IN, EXISTS, NOT EXISTS, subqueries restrictions, Nested subqueries, ANY/ALL clause, correlated sub queries

https://drive.google.com/file/d/1ozPoZ_bRBqYJdJoqel-nZTXWtH8gNOz7/view?usp=sharing

 Group by and Having clause

https://drive.google.com/file/d/10dUNVxEfwTZnSEHzz4V054SGKDL782LA/view?usp=sharing

Concepts of Join, Types of Joins - Inner Join, Outer Join, Left Join, Right Join, Cross Join

https://drive.google.com/file/d/1uGINFxMzKk89SH7xlDNJPnU3kju-VqWL/view?usp=sharing

 Views (creating, altering dropping, renaming and manipulating views)

https://drive.google.com/file/d/1d6P5V0hVjI1gCxpvdA6w4WGJBDHYEOX6/view?usp=sharing

Unit – 2 Advanced MySQL

Control Statements- If, case and loop, Block Structure and Stored procedures – Creating and executing procedures with and without parameters

https://drive.google.com/file/d/1y8VInWb3N2HlbZrpsGcqpMQkx7hAv2fW/view?usp=sharing

Cursors- Declare, open, fetch, close

https://drive.google.com/file/d/1QbEWP-pry7g9Bi4CLZ-erfgDjNBR05pC/view?usp=sharing

Triggers- Create, show and drop trigger, Types of triggers

https://drive.google.com/file/d/1l8UUHDvcd3_mCeSuDCElt-szjq0U3Svz/view?usp=sharing