Unit I RELATIONAL DATA MODEL & MYSQL ADMINISTRATION
Relational Data Model
Introduction to database concepts- CODD’s Rules – Components of DBMS –
Table Structure – Keys : types of Keys – Data Constraints and types of
Constraints -difference between SQL and MySQL
MySQL Installation
Install ,configure and test MySQL server on Microsoft Windows
Working with MySQL Admin
Creating , selecting and describing database – show command – backing up
databases

Ex No 1: Install, configure and connect to MySQL server and MySQL workbench
in Windows
Ex No 2: Write a query to create a database, show and backing up databases
Unit II INTERACTIVE MYSQL
Introduction to MYSQL
MySQL data types – Data Definition Commands – Data Manipulation Commands
– Data Retrieval Commands
MySQL operators and Expressions
Types of operators – Arithmetic, Comparison and Logical Operators – Pattern
Matching- Import and Export Data
Built – in Functions
Single Row functions – Aggregate functions – conversion functions

Ex No 3: create a database named ‘college’ and create a table for student and
employee with the fields as you like.
Ex No 4: create a table ‘student’ with marks field for 10 students. Apply built in
functions to do calculations.

Unit III FLOW CONTROL IN MYSQL
Flow Control
IF(), IF NULL(),CASE ,LOOP,LEAVE ,ITERATE , REPEAT,WHILE
Querying the table
Selecting rows using where, order by, group by and Having clauses-Sub-queriescorrelated sub-queries
Views
Introduction – Advantages of views – creating , updating and deleting views
Ex No 5: create a table ‘bank’ and apply flow control statements to do some
transactions
Ex No 6: create a table ‘ library’ with proper fields and create another table ‘
library1’ and insert rows from library using views

UNIT IV MYSQL PERORMANCE TUNING
Indexes and Sequences
Index Types – simple and compound – Sequences : creating , altering and
dropping sequences
Joins & Unions
Joins- definition-types of joins : natural join,inner join,self join,outer join. Union
types : union , Union All, Union Distinct- order by and limit handling
User and transaction management
Creating – deleting – renaming users grant and and revoke commands –
transaction command : commit , rollback and save points.

Ex No 7: create a table named ‘student’ with sequences
Ex No 8: create any two tables with common column name and perform join
and union

UNIT V STORED PROGRAM CONCEPTS & DEVELOPMENT
MySQL Procedures & Functions
Creating –executing and deleting stored procedures – creating – executing and
deleting stored functions -advantages
MySQL Trigger & Cursor
Use of trigger – creating trigger – types of triggers Cursor: creation and deletion