In this project, I worked extensively with the RetailSales database to demonstrate proficiency in database management, querying, and security. I started by verifying the database structure, ensuring it contained the necessary tables: Customers, Suppliers, Products, and Transactions. I inserted new records into each table with the specified details, maintaining data integrity and proper relational links. I then executed multiple queries to display the content of each table, retrieve specific records (such as the top five customers and the last supplier entry), and list all table names within the RetailSales database.

I fully backed up the RetailSales database and verified the backup file size to ensure data protection. Afterward, I updated the database with additional customer, supplier, product, and transaction entries. Following the updates, I conducted a transaction log backup to capture recent changes and maintain database recovery points. I ran queries to retrieve the most recent entries from each table, confirming the successful addition of the new records.

I created dynamic data masking to strengthen database security to hide sensitive information such as customer phone numbers and supplier addresses. Additionally, I encrypted the cost field in the Products table to protect financial data. I verified these security measures by running queries that demonstrated the masking and encryption were correctly applied. Through these tasks, I successfully showcased advanced skills in database operations, backup management, and security configurations using SQL Server.