This eBook will guide you to design a database from scratch and work with the database using SQL.

• It covers the concepts of Relational Database and its implementation in SQL.

• It will help you design a database from scratch using an application:

  • • • The data needed for the application will be discussed.

      • Details on entities and relationships between entities will be established.

      • ER Model will be designed.

      • The ER model will be converted to Relations in Relational Database.

      • The relations will undergo the process of Normalization.

      • The relations will be normalized up to the third normal form.

• You will be implementing the database using MySQL relational database management system:

  • • • SQL will be discussed in detail.

      • Installation of MySQL will be illustrated.

      • Every concept in SQL will be illustrated using appropriate code snippets and resulting screenshots.

      • Every SQL statement will have syntax and practice sessions.

• Practice sessions include the following:

  • • • creating database and tables, modifying tables and specifying constraints;

      • inserting, retrieving, updating and deleting data;

      • querying tables using clauses, functions, operators and joins;

      • working with transaction statements;

      • working with stored procedures, compound statements, triggers and cursors;

      • creating user accounts and roles.

      • granting and revoking privileges.