• 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

2018/12/10 SF18SQL10002

Database Administration Fundamentals (SF18SQL10002) – Day 10

2019-01-182021-09-16Francisco Olvera

Congratulate yourself. You finished the Introduction to SQL course. You now have the foundation to work with SQL.

Download the class notes for day 10 (the final).

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 9

2019-01-152021-09-16Francisco Olvera

We have finished all material for this course. We will meet one more time to take care of the final.

Download the class notes for day 9.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 8

2019-01-102021-09-16Francisco Olvera

We have covered most of the material for the course. We have one more class day and then the final.

Download the class notes for day 8.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 7

2019-01-082021-09-16Francisco Olvera

We continue creating, dropping and altering objects like databases, schemata, tables and views.

Download the class notes for day 7.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 6

2019-01-032021-09-16Francisco Olvera

We have started creating objects like databases, schemata and tables.

Download the class notes for day 6.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 5

2018-12-272021-09-16Francisco Olvera

We are half-way finished with the course. We are almost ready to CREATE, DROP and ALTER objects like databases, schemata, tables and views.

Download the class notes for day 5.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 4

2018-12-212021-09-16Francisco Olvera

We have covered INNER JOIN (finding shared data between data sets), built-in functions and data types. We are now ready to create objects.

Download the class notes for day 4.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 3

2018-12-182021-09-16Francisco Olvera

We continue working with built-in functions — those that affect strings and those that affect numeric values.

Download the class notes for day 3.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 2

2018-12-132021-09-16Francisco Olvera

So far, we have covered built-in functions that affect strings and how to retrieve data from one or multiple tables.

Download the class notes for day 2.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment

Database Administration Fundamentals (SF18SQL10002) – Day 1

2018-12-112021-09-16Francisco Olvera

We have started a new course. You will learn the basics of SQL.

Download the class notes for day 1.

2018/12/10 SF18SQL10002, Computer Programming, CUNY, Open Source, SQL Leave a comment
May 2025
S M T W T F S
 123
45678910
11121314151617
18192021222324
25262728293031
« 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