Exams are coming!
Get ready with premium notes and study guides!

Class Notes for CIS 4400 at Baruch College

BARUCHCIS 4400Professor HolowczakSpring

CIS 4400 Lecture 3: OLTP vs. OLAP

OC11612792 Page
23 Feb 2019
0
2/6/19: oltp vs. olap: http://holowczak. com/introduction-data-warehousing, oltp (online transaction processing) [ came out of theory , highly normaliz
View Document
BARUCHCIS 4400Professor HolowczakSpring

CIS 4400 Lecture Notes - Lecture 5: Data Warehouse, Snowflake Schema, Fact Table

OC11612793 Page
23 Feb 2019
0
- how many orders were placed and fulfilled per month? (ask for month and year) Select to_char (o. orderdate, yyyy-mm") as order_month, count(*) as. Yo
View Document
BARUCHCIS 4400Professor HolowczakSpring

CIS 4400 Lecture 4: Dimesional Modeling Process

OC11612793 Page
23 Feb 2019
0
2/13/19: dimensional modeling process http://holowczak. com/data-warehouse-dimensional-modeling/1: dimensional modeling process (follow kimball"s 4 ste
View Document
BARUCHCIS 4400Professor HolowczakSpring

CIS 4400 Lecture Notes - Lecture 2: Relational Algebra, Data Definition Language, Microsoft Excel

OC11612792 Page
23 Feb 2019
0
-figure out what is in the salesperson table. -runs the query, orders by descending order, fetch only the first row. Need to have order by and then fet
View Document
BARUCHCIS 4400Professor HolowczakSpring

CIS 4400 Lecture 1: SQL Introduction

OC11612793 Page
23 Feb 2019
0
1/29/19: course introduction: purpose of this course is to manipulate the data. 1/30/19: review of sql: server, the server is running the database call
View Document
View all professors (1+)

Class Notes (1,100,000)
US (480,000)
Baruch (1,000)
CIS (20)
CIS 4400 (5)