What is It?

In this MS SQL Database project I am creating an Automobile Shop Management System database. On this Database project I have tried to apply all the functions of MS SQL.

Content of Data definition language (DDL) File.

The content of this file divided into 9 sections

• SECTION 01: Created a Database Name [ASMSDB]
• SECTION 02: Created Appropriate Tables For The Database
• SECTION 03: Apply Some Modifying Statement (ALTER, ADD, DELET, UPDATE)
• SECTION 04: Created Some Clustered & Non-Clustered Index
• SECTION 05: CREATING VIEWS
• SECTION 06: STORE PROCEDURE (INSERT, DELETE, UPDATE)
• SECTION 07: CREATING FUNCTION (Scalar Value, Table Value )
• SECTION 08: CREATING TRIGGER (FOR TRIGGER, INSTEAD OF TRIGGER )
• SECTION 09: CREATING TRANSACTION

Content of Data Manipulation Language (DML) File.

• SECTION 01: INSERTING DATA INTO TABLE (Normal Insert Into)
• SECTION 02: INSERTING DATA INTO TABLE (Through Store Procedure)
• SECTION 03: TEST (View, Trigger, Function, Transaction)
• SECTION 04: Query to retrieve data from database

---

Some Of The Queries:

1. Find out the customer whos company name IS NULL.
2. Use SPACE() Find Out The Customer (Full Name) As 'Name'and Their Mobile number Where CustomerType_ID = 1
3. Find total number of employee who works in Operation Department
4. Sort Employee Name ascending & descending order
5. Sort Employee Name by an expression USE LEN()
6. Sort by ordinal positions of columns
7. select the OFFSET 10 ROWS
8. select the OFFSET 0 ROWS
9. Find Out The customers from invoice table who have a Payment Due
10. Write a Join Query To find out the employee Details who work in Marketing Department
11. Write a query Using Like Operator
12. Write a query Using NOT Like Operator
13. Write a query Using GROUP BY clause and aggregate functions
14. Write a query Using GROUP BY clause with the MIN and MAX functions
15. Write a query Using GROUP BY clause with the AVG() function
16. Write Sub Queary to find out the customer whos Type_ID =2
17. Write a query Using RollUp
18. Write a query Using CUBE
19. Write a CTE

Feel free to download this database project and modify or use it of your own way.