As a side project in my Calculus course, my partner Tobin and I made our first Django App! Given the dimensions of a cylindrical can, it calculates the maximum number of cans that could fit in a standard 20ft shipping container and the amount of wasted space. Perhaps we’ll host it on AWS sometime in the … Continue reading Django: Calculus Canning Calculator
Lab 10 1. Fill in the variable names to complete the DECLARE statements. You can infer these names from the INSERT statement further down the script. Finish the INSERT query. Because SalesOrderID is an IDENTITY column, this ID will automatically be generated for you. You can use the hardcoded value ‘CARGO TRANSPORT 5’ for the … Continue reading T-SQL: Programming and Error Handling
Continuing with Microsoft’s T-SQL certificate, here I’m grouping sets and using the PIVOT operator to summarize data. Lab 8 1. include a grand total for all sales revenue and a subtotal for each country/region in addition to the state/province subtotals that are already returned. Make sure to use the aliases provided, and default column names elsewhere. … Continue reading T-SQL: Grouping Sets and Pivoting Data
Notes on Using Table Expressions Querying Views: A presentation of the data which provides abstraction and acts as a layer of security over the database. Named queries with definitions stored in a database. Creating a View: CREATE VIEW SalesLT.vCustomerAddress AS SELECT c.CustomerID, FirstName, LastName, AddressLine1, City, StateProvince FROM SalesLT.Customer AS c JOIN SalesLT.CustomerAddress AS ca … Continue reading T-SQL: Using Subqueries, APPLY, and Table Expressions
Furthermore, here is how I completed labs four and five using Set Operators and Functions to Aggregate Data: Lab 4 1. Write a query that retrieves the company name, first line of the street address, city, and a column named AddressType with the value ‘Billing’ for customers where the address type in the SalesLT.CustomerAddress table … Continue reading T-SQL: Using Set Operators and using Functions to Aggregate Data
I’ve been taking Microsoft courses in Redmond following the Data Science Professional Certification. Part of the course includes two T-SQL components, it’s been really fun and a great refresher, you can find an online version here. Here are a few notes and labs for reference, starting from the basics: Lab 1 1. Write a Transact-SQL … Continue reading T-SQL: Querying Tables with SELECT and JOIN
June Cadenhead 