Gain insights into SQL and database fundamentals. Delve into data manipulation, administration, and normalization with practical tasks using SQL functions for backup, recovery, and user management.

Learn SQL - A Practical Guide for SQL Server and Database Fundamentals.png

sqldockerfile.tar.gz

sql_spa-copy

SQL is a must-know language for all types of roles, including development and data science. This course includes hands-on experience with the fundamentals of the SQL Server database including database administration.

The course covers the fundamentals of relational databases and database normalization. It offers a practical learning experience of retrieval, definition, manipulation, presentation and transformation of data through SQL functions. You will also learn database administration for backup, recovery and restore followed by managing the users, roles and privileges.

This course will teach you how to perform tasks related to SQL Server databases with hands-on experience. It covers the complete range of day-to-day operations.

A Practical Guide to SQL  and Database Fundamentals

Prod.Products Table

align-center

Sales.ProductSales Table

Cust.Customers Table


## Part A

Suppose a person from the sales team only needs to see the top ten latest sales records because they need to gather information about those particular customers. Create a query that they can use to retrieve the `ProductID`, `UnitPrice`, `Quantity`, `ProdTotalCost`, and `CustomerID`.

Remember to present the ten latest records, we would have to sort them by newest to oldest. 



```SQL
SELECT TOP 10
            ProductID,
            UnitPrice,
            Quantity,
            ProdTotalCost,
            CustomerID,
            DatePurchased
FROM Sales.ProductSales
ORDER BY DatePurchased DESC
GO
```
This is the solution for part A, where we apply the `TOP` function to select the top ten records from the table `ProductSales`. We apply `ORDER BY` to sort the records in descending order.



## Part B
Suppose a sales manager has come to get some information regarding current sales and they would like a list of the highest-paid sales to date.

Use the Sales.ProductSales table and write an inner query that obtains the highest total price/cost. Then, write an outer query that retrieves the `ProductID`, `Quantity`, `CustomerID`, `SuptPkgID`, the `ProdTotalCost`, and the `DateModified` of the module.

Practice the concepts of distinct, stored procedures, and views.
