HTML

Home
Basics Elements and Attributes Headings and Paragraphs Styles and Colors Class and ID Attribute Quotation and Formating Elements Forms Tasks
Introduction CSS Types pseudo class Table with Styles Overflow Properties Display Properties Position Property Line-Height&Letter-Spacing Periodic Table
Introduction Display Properties Identifiers Operators String Methods Array Functions Object Event Handling Dialog Boxes Calculator Design
Introduction Basic Sql Alter and Tables Constraints Insert and Select Operators Joins Group by&Union Backup Exception Handling Views&User Defined Functions Company Database
Introduction Variables & Operators Conditional & Looping Statements Functions & String Expressions Pointers & Recursion Array & Files Patterns
Introduction
Configuration Introduction Sql
MasterDev
Creating Tables
1.Location table
Output:
2.Department Table
Output:
3.Monitor Table
Output:
4. Cpu Table
Output:
5.Employee Table
Output:

6. Creating Status Table




Output:


Write a query to display Department details along with department head
Output:
Write a query to display shift details along with number of Employees in each shift
Output:
Write a query to display average salary in each department and the employee details whose salary is less than average salary
Output
write a query to display all employees details with their Head Name
Write a query to display employee details and monitor id, cpu id along with head name and head monitor id and cpu id

Write a query to display Number of Employees Present at a particular Date

Output:
Subscribe to: Posts (Atom)