Netside where knowledge is shared, ideas are spread.

[Notes] CSCI 585 DB Structured Query Language (SQL)

04 Feb 2020 | CSCI585, English/英文, Note

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

outline

  • The basic commands and functions of SQL
  • How to use SQL for data administration (to create tables and indexes)
  • How to use SQL for data manipulation (to add, modify, delete, and retrieve data)
  • How to use SQL to query a database for useful information

[Notes] CSCI 567 lec3 Linear Regression, Perceptron, Logistic RegressionLinear Regression, Perceptron, Logistic Regressionk

29 Jan 2020 | CSCI567, English/英文, Note

Credit to: Prof. Yan Liu, CSCI567, Spring 2020

Outline

  • Linear Classifier and Surrogate losses
  • Perceptron
  • Logistic regression

[Notes] CSCI 585 DB (DE/)Normalization

28 Jan 2020 | CSCI585, English/英文, Note

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

outline

  • What normalization is and what role it plays in the database design process
  • About the normal forms 1NF, 2NF, 3NF, BCNF, and 4NF
  • How normal forms can be transformed from lower normal forms to higher normal forms
  • That normalization and ER modeling are used concurrently to produce a good database design
  • That some situations require denormalization to generate information efficiently

[Notes] CSCI 585 DB Advanced Data Modeling

28 Jan 2020 | CSCI585, English/英文, Note

Credit to: Prof. Saty Raghavachary, CSCI 585, Spring 2020

outline

  • Extended Entity Relationship (EER) model

[Notes] CSCI 567 lec2 LR

24 Jan 2020 | CSCI567, English/英文, Note

Credit to: Prof. Yan Liu, CSCI567, Spring 2020

Outline

  • Linear regression
  • Linear regression with nonlinear basis
  • Overfitting and Preventing Overfitting