Sometimes, we are not really interested in the specific row or column of data. Rather, we are interested in the summation or count of a column of data. This is where “Aggregation Functions” like SUM and COUNT in SQL are used. “SUM” Function Firstly, we have the SUM Function, which allows us to return the … Continue reading SQL Tutorial 3 : Aggregation Functions
Category: Uncategorized
In reality, the dataset that we want to obtain often requires the application of much more criterias and filters than just 1. Building on what we explored in Topic 1, we will use new functions such as the “AND/OR/IN” functions to build on our “SELECT FROM WHERE” framework. “OR” Function Referring to the same ”world_data” … Continue reading SQL Tutorial 2 : Additional criterias with the use of OR/IN/AND Functions
“SELECT FROM WHERE” The key framework governing SQL are these 3 keywords : “SELECT”, “FROM”, “WHERE”. Firstly, for SELECT, we are choosing which columns in the database that we want to extract data from. Secondly, for FROM, we are choosing which table in the database to extract data from. This is crucial because a database … Continue reading SQL Tutorial 1 : “SELECT FROM WHERE” Framework
"Experience Sharing by Li Shuai" Li Shuai President NUS BACT, AY 17/18 Summary of BACT AY17/18 Workshops Added VBA & R workshops to pro bono activities for NUS Business School students. Shifted workshops from Lecture Theatres to Seminar Rooms. Had to conduct repeat runs due to over-subscription. First Paid Assignment - Conducted Excel & VBA … Continue reading NUS BACT AY17/18 EXCO
