Just another CUNY Academic Commons site
We have covered how to CREATE, DROP and ALTER several objects including user-defined functions, stored procedures, triggers and sequences. We have also covered normalization as well as learning how to CREATE, DROP and ALTER logins and users. Download the class notes for day 6.
We continued working on normalization replacing values of cities/counties with FIPS (Federal Information Processing Standards) values for these cities/counties. We had to import data into our working database WS231. We ran into errors along the way and had to make the proper changes to normalize our data. In any case, the main part of the […]
Applied statistics (not software, but good old math) including general understanding of machine learning (artificial intelligence). R and/or Python with libraries like NumPy and/or pandas. Structured Query Language (SQL) with a broad understanding of extensions (vendor-specific syntax) depending on the relational database management system (RDBMS) that the company (your employer) has like Oracle, MySQL, PostgreSQL […]
We have covered normalization, primary keys (PK), foreign keys (FK) and composite primary keys (CPK). Download the class notes for day 8 and theory regarding rights management (22 pages), which we will cover this coming Wednesday.
We have now covered normalization — in other words how to clean up a relational database to make it faster and avoid redundancy of data that may cause errors in the long run. A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or […]
