Phandeeyar Institute

01 - May 30 ,2020 - Part 1

02 - May 30 ,2020 - Part 2 ( mySQL )

03 - May 30 ,2020 - Part 3 ( mySQL )

04 - May 30 ,2020 - Part 4 ( mySQL )

05 - May 31 ,2020 - Part 1 ( mySQL )

06 - May 31 ,2020 - Part 2 ( mySQL )

07 - May 31 ,2020 - Part 3 ( mySQL )

08 - May 31 ,2020 - Part 4 ( mySQL )

09 - May 31 ,2020 - Part 5 ( mySQL )

01 - June 6 ( Part 1 )

02 - June 6 ( Part 2 )

03 - June 6 ( Part 3 )

04 - June 6 ( Part 4 )

05 - June 6 ( Part 5 )

06 - June 7 ( Part 1 )

07 - June 7 ( Part 2 )

08 - June 7 ( Part 3 )

09 - June 7 ( Part 4 )

10 - June 7 ( Part 5 )

01 - June 13 - Part 1

02- June 13 - Part 2

03 - June 13 - Part 3

04 - June 13 - Part 4

05 - June 13 - Part 5

06 - June 14 - Part 1

07 - June 14 - Part 2

08 - June 14 - Part 3

01 - June 20

02 - June 21

01 - June28

Chapter 1 - What is Database and The Purpose of Database System

Chapter 2 - How Database related in Apps Systems and MySQL Installation

Chapter 3 - DML(Querying Data) & SQL Conditions & Operators

Chapter 4 MySQL data types & Constraints

Chapter 5 - SQL Joining tables

Chapter 6 - Data Modeling

Chapter 7 - Database Normalization

Chapter 8 - Stored Procedure in MySQL

Chapter 1 - What is Database and The Purpose of Database System

Chapter 2 - How Database related in Apps Systems and MySQL Installation

Chapter 3 - DML(Querying Data) & SQL Conditions & Operators

Chapter 4 MySQL data types & Constraints

Chapter 5 - SQL Joining tables

Chapter 6 - Data Modeling

Chapter 7 - Database Normalization

Chapter 8 - Stored Procedure in MySQL

Q1)What is Data?How does it important in Information Processing System?

Q2)Difference between Database and DBMS?Are they same?

Q3)What are the main benefits of using a DBMS to manage data in applications involving extensive data access?

Q4)What is a data model? What is the relational data model? What is data independence and how does a DBMS support it?

Q5)Explain the different roles of database administrators, application programmers, and end users of a database. Who needs to know the most about database systems?

Q1)What is a transaction? What guarantees does a DBMS offer with respect to transactions?

Q2)Which of the following plays an important role in representing information about the real world in a database'? Explain briefly.

Q3)What is ACID Properties of Databases?

Q1)What is DDL and show three example keywords.

Q2)What is DML and show three example keywords.

Q3) What is SQL?

Q4) How to select all records from the table?

Q5) Define the SQL DELETE statement.

Q6) Define UNION, MINUS, UNION ALL, INTERSECT?

Q7) Difference between TRUNCATE, DELETE and DROP commands?

Q1)Define EmployeeInfo Table and EmployeePositon Table in your custom database.

Q1 Continue)Define EmployeeInfo table and EmployeePositon table in your custom database

Q2). Write a query to fetch the number of employees working in the department ‘HR’.

Q3. Write a query to get the current date.

Q4)Write a query to find all the employees whose salary is between 50000 to 100000.

Q5)Write a query to find the names of employees that begin with ‘S’

Q6)Write a query to fetch all employees who also hold the managerial position.

Question 1 to 5 for Chapter 5.

Get Dummy Data for Music Database

Question 1 to 3 for Chapter 6.

Learning MySQL (Recommended Book)

MySQL Workbench Data Modeling & Development (Oracle Press)

Sam's Teach Yourself MySQL in 21 Days

web site link for Database Technologies

Get the un-normalized spreadsheet doc(excel file)

Write the SQL Query to get the following .

Project Description (Database Design,Data Modeling,SQL with MySQL)