Project 1: Writing Complex Subqueries
Industry: General
Problem Statement: How to create subqueries using SQL?
Topics: This project will give you hands-on experience in working with SQL subqueries and utilizing them in various scenarios. Some of the subqueries that you will be working with and gaining hands-on experience in are: IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries.
Highlights:
- Accessing and manipulating databases
- Operators and control statements in SQL
- Executing queries in SQL against databases
Project 2: Querying a Large Relational Database
Industry: General
Problem Statement: How to get details about customers by querying the database?
Topics: 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 the total sales made to a particular customer.
Highlights:
- Table basics and data types
- Various SQL operators
- Various SQL functions
Project 3: Relational Database Design
Industry: General
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 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 two rows in each of the tables, you will ensure that you have created respective foreign keys.
Highlights:
- Defining relations/attributes
- Defining the primary keys
- Creating foreign keys
Outstanding course
An excellent SQL course for beginners. The trainer was very positive and delivered the course in detail. Presentation was well maintained and the trainer knew where to put what. The trainer explained every topic with the suitable examples. I would definitely recommend this SQL training for beginners.
Amazing course!
The way they have given the SQL training course was really useful (The examples given were real-time examples). Step-by-step explanation of the content was the best part. Thanks for giving such a course. Thanks a lot!