Skip to content

Latest commit

 

History

History
19 lines (15 loc) · 1010 Bytes

README.md

File metadata and controls

19 lines (15 loc) · 1010 Bytes

DBMS-SQL-Queries-with step by step guide

  • This includes a pdf file of all practicals of Database Management Systems of DBATU Lonere
  • Step by step explaination and definations of all queries using MySQL
  • BEST FOR QUICK REVISION

Practicals:

  1. Defining schema for applications
  2. Creating tables, Renaming tables, Data constraints ( Primary key, Foreignkey, Not Null ), Data insertion into a table.
  3. Grouping data, Aggregate functions, Oracle functions (Mathematical, Character functions).
  4. Sub-Queries, SET Operations, Joins.
  5. Creation of databases, writing SQL and PL/SQL queries toretrieveinformation from thev databases.
  6. Assignment on Triggers and Cursors.
  7. Design and implement ER model diagrams (Entity RelationshipModel) of database systems such as office automation, Hotel managementandHospital Management.(Project)
  8. Java Database Connectivity:(JDBC)

GIVE IT A TRY IT WILL SURELY HELP YOU AS I HAVE MADE IT WITH SO MUCH DETAILING AND EXAMPLES!! HOPE IT HELPS ^_^