Summary
- Whole experience summary in a PDF file
The summary includes SQL Server, Web Development (both PHP and C#.net), SSRS, SSIS, SSAS, Excel BI, Python, C#, Matlab, Labview demos etc.
- Online deal collection system with database
The online deal collection demo was designed using MVC 5 (C#.net) and SQL Server. It has basic functions for deal collection, such as make comments, link to the deal website, sign in, category, search, load and edit deal as an administrator, and send email to users for registration. The most important one is that registered user can only leave one comment for each deal. They can easily modify their comments. The unregisted users can only leave a comment, they cannot modify their commnets.
The database includes three main tables: User Account, deal, comment. They connected by foreign key constrains to prevent unexpected inputs. The database diagram is shown below:
- Online shopping system with database
The online shopping demo was designed using MVC 5 (C#.net) and SQL Server. It has basic functions for online shopping, such as sign in, shopping cart, category, search, load and edit items as an administrator, and send an email to customers for registration and the order information when they successfully submit the orders, check order information. There are a lot of validations for this shopping system. The most important one is that it can prevent over purchases when the storage is low. It successfully disables the button when the quantity of the item in the database is 0 or the order quantity euqals the storage. It can update the shopping cart immediately when other people already made a purchase (only if the quantity in the shopping cart is larger than the storage in the database and it will be euqal to the quantity in the database). The customers cannot select the quantity larger than the storage in the shopping cart. If shopping cart is changed to 0, people cannot make a purchase. There are also a lot of other validations for sign in, shipping, payment etc.
The database includes five main tables: User Account, Order, Product, Administrator, Shipping. They connected by foreign key constrains to prevent unexpected inputs. One trigger is used to update the quantity in the Product table. The database diagram is shown below:
- Hotel booking dystem with database
The online hotel booking demos was desgined using Web Form (C#.net) and SQL Server. It has basic functions for online booking, such as select check in and out dates, city and hotel room, input personal information and credit card, send an email to customers for the order information when they successfully submit the orders, check booking information. There are a lot of validations for this booking system. The most important one is that it only allows customers to input current date or later than the current date in the checkin box, and to input the date later than the checkin date in the checkout box. It only allows the special date formate in the input box and it actually encourage people to use the calendar selector. Other main validations include the diabled button when room is 0, must check the check box to enable the submit order button, a lot of validations for input boxes and dropdown lists etc.
The database includes four main tables: Booking, Room, Hotel, Member. They connected by foreign key constrains to prevent unexpected inputs. One trigger is used to update the room quantity in the Room table. The database diagram is shown below:
- DVD rental database using C# with two windows forms as inputs
This prompt DVD rental system was desgined using C# and SQL Server. It can record every rental and return process, and save the new member to Table Customers. The only input is the scan of DVD and member card for rental, and the scan of DVD for return. It used two windows forms to accomplish this goal.
The database includes four main tables: Customer, Rental, Inventory, DVDs, Member. They connected by foreign key constrains to prevent unexpected inputs. It uses two triggers and one stored procedure to finish the goal. The database diagram is shown below:
- Database for merging and correcting data using SQL Server
I built a database with the function to merge and correct my research data. Because I measured the samples using different instruments which cover different frequency ranges, I need to merge the data. I also need to correct data from the light scattering and did calculation using the data. SQL Server helped me accomplihs this goal and speeded up the data anlaysis process by 80%. It created tables with setting Primary Key and Non-Clustered Index and loaded all frequency range spectroscopic data to the database using “BULK INSERT” or “bcp” in PowerShell. it merged the data using a “UNION” commend for the FIR range data, and saved the result to the created table. And then it truncated different frequency range tables and merged the shifted and shortened data using a “UNION ALL” command. All frequency range tables and merged tables saved to the schema [2H].
- Machine Learning Python and C# codes
I took a machine learning course on Coursera. Prof. Andrew Ng offered a very interesting course. I like it a lot. I took the courses twice. The second time, I decided to rewrote Matlab codes using Python and C#.
- SQL Server SSRS
- SQL Server SSIS
- SQL Server SSAS
- Excel Business Intelligence
