Project 1: Writing complex Sub Queries
Problem Statement: How to create sub queries using SQL
Topics: This project will give you hands-on experience in working with SQL sub-queries and utilizing it in various scenarios. Some of the sub-queries that you will be working with and gain hands-on experiences in are – IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries.
- Accessing and manipulating databases
- Operators & Control Statements in SQL
- Executing queries in SQL against databases.
Project 2: Querying a large relational database
Problem Statement: How to get details about customers by querying the database
Description: In this project you will work on downloading a database and restoring it on the server. You will then query the database to get customer details like name, phone number, email id, sales made in a particular month, increase in month-on-month sales and even total sales made to a particular customer.
- Table basics and data types
- Various SQL Operators
- Various SQL Functions.
Project 3: Relational database design
Problem Statement: How to convert a relational design into a table in SQL Server
Topics: In this project you will work on converting a relational design that has enlisted within it the various users, user roles, user accounts and their statuses. You will create a table in SQL Server and insert data into it. With at least 2 rows in each of the tables, you have to ensure that you have created respective foreign keys.
- Define Relations/Attributes
- Define the Primary Keys
- Create Foreign Keys