Page 1 :
LIST OF PRACTICALS, STRUCTURED QUERY LANGUAGE, , 1. Creating Database, , Creating a database, , Creating a table, , Specifying relational data types, Specifying constraints, Creating indexes, , 2. Table and Record Handling, , INSERT statement, , Using SELECT and INSERT together, DELETE, UPDATE, TRUNCATE Statement., DROP, ALTER statement, , 3. Retrieving Data From a Database, The SELECT statement, , Using the WHERE clause, , Using Logical Operators in the WHERE clause, , Using In, BETWEEN, LIKE, ORDER BY, GROUP BY & HAVING clause, Using Aggregate Functions, , Combining Tables Using JOINS, , 4. Design of database for any application., , INSTRUCTIONAL STRATEGY, , Explanation of concepts using real time examples, diagrams etc. For practical sessions books along, with CDs or learning materials with specified activities are required. Various exercises and small, applications should be given along with theoretical explanation of concepts., , MEANS OF ASSESSMENT, , Assignments and quiz/class tests, mid-term and end-term written tests, Actual laboratory and practical work, exercises and viva-voce, Software installation, operation, development and viva-voce