• CUNY Academic Commons
    • People
    • Groups
    • Sites
    • Courses
    • Events
    • Activity
    • About
  • Log In
  • Register
  • Help
Skip to content

F.Olvera

Just another CUNY Academic Commons site

  • Home

Month: March 2023

Intermediate Structured Query Language for Data Analytics (WS231) — Day 10

2023-03-16Francisco Olvera

We have finished another course. Remember that programming is a fun experience as we can tell a machine and tell it what to do. I hope you had fun in this course and continue learning SQL and related technologies like Python.

Download the class notes for day 10.

2023/02/06 WS231, Computer Programming, CUNY, SQL Leave a comment

Intermediate Structured Query Language for Data Analytics (WS231) — Day 9 (π)

2023-03-142023-03-14Francisco Olvera

We are one more session away from finishing this course. I hope you have had fun.

Download the class notes for day 9.

2023/02/06 WS231, Computer Programming, CUNY, SQL Leave a comment

Intermediate Structured Query Language for Data Analytics (WS231) — Day 8

2023-03-09Francisco Olvera

We have finished all new material for this class and have started the review for the final next week.

Download the class notes for day 8.

2023/02/06 WS231, Computer Programming, CUNY, SQL Leave a comment

Intermediate Structured Query Language for Data Analytics (WS231) — Day 7

2023-03-07Francisco Olvera

We continued taking a look at LOGINs, USERs, ROLEs, AUTHENTICATION and other data objects. We also looked at how to BACKUP and RESTORE databases.

Download the class notes for day 7.

2023/02/06 WS231, Computer Programming, CUNY, SQL Leave a comment

Intermediate Structured Query Language for Data Analytics (WS231) — Day 6

2023-03-02Francisco Olvera

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.

2023/02/06 WS231, Computer Programming, CUNY, SQL Leave a comment
March 2023
S M T W T F S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Feb   Apr »

Recent Posts

  • Introduction to Structured Query Language for Data Analytics (WS24SQL10001) — Day 10
  • Introduction to Structured Query Language for Data Analytics (WS24SQL10001) — Day 9
  • Introduction to Structured Query Language for Data Analytics (WS24SQL10001) — Day 8

Archives

Categories

Copyright © 2025 F.Olvera. All rights reserved. Theme: Radiate by ThemeGrill. Powered by WordPress.

Need help with the Commons?

Email us at [email protected] so we can respond to your questions and requests. Please email from your CUNY email address if possible. Or visit our help site for more information:

Visit our help site
CUNY Academic Commons logo
  • People
  • Groups
  • Sites
  • Courses
  • Events
  • Activity
  • About
  • Help
  • Privacy
  • Terms of Service
  • Accessibility
  • Creative Commons (CC) license unless otherwise noted
Built with WordPress Protected by Akismet Powered by CUNY CUNY logo