CUNY – Page 19 – F.Olvera

Database Administration Fundamentals (WS17SQL1007) – Day 5

2017-07-112021-09-16Francisco Olvera

We are half-way done (fifth class of ten). We will stop covering new material in order to review all the material we have covered so far. You need to understand and know the syntax well as this is the foundation of SQL. We will then continue and cover how to CREATE and ALTER database objects.

Download the class notes for day 5.

Resources to Learn Programming #2

2017-07-102021-09-16Francisco Olvera

Alison – tutorials
Codecademy – tutorials
edX – tutorials
Hacksplaining – tutorials how to protect your code from hacking and exploits
JDoodle – on-line IDE, including Online SQL Editor
MIT OpenCourseWare – free courses
MIT App Inventor – facility to create apps for Android OS
Slashdot – news
TechCrunch – news
TechRepublic – news
Tutorialspoint – tutorials
WhatIs – tech dictionary and encyclopedia
Udemy – paid courses

Birth of BASIC

2017-07-082021-09-16Francisco Olvera

“Professors John Kemeny and Tom Kurtz along with a band of Dartmouth undergraduates invent the Basic computer language.” — the Dartmouth College YouTube channel

The basics of BASIC, the programming language of the 1980s

2017-07-082021-09-16Francisco Olvera

David Murray (The 8-Bit Guy) explains how my generation got started in computers — Beginners All-purpose Symbolic Instruction Code. For more information on BASIC go to (GOTO) Wikibooks for books and Calormen (JS Basic, to run the code below).

10 REM http://www.calormen.com/jsbasic/
20 INPUT "What's your name?"; name$
30 PRINT "Hello, "; name$;
40 INPUT ", how are you? (OK/Not)"; ok$
50 IF ok$ = "OK" THEN PRINT "Glad to hear that."
60 IF ok$ <> "OK" THEN PRINT "Too BAD!"

Database Administration Fundamentals (WS17SQL1007) – Day 4

2017-07-062021-09-16Francisco Olvera

We have covered various functions for strings and numeric values. Last night we looked at FORMAT(), which coverts a numeric value (DATETIME, DATE, TIME, MONEY, FLOAT, DECIMAL, etc.) into a string (VARCHAR(), NVARCHAR(), etc.).

Download the class notes for day 4.

Database Administration Fundamentals (WS17SQL1007) – Day 3

2017-07-052021-09-16Francisco Olvera

We continued looking at functions and how to JOIN tables before the July 4th celebrations.

Download the class notes for day 3.

Resources to Learn Programming

2017-07-032021-09-16Francisco Olvera

As I have pointed out in my previous posts on open source, computer programmers (geeks, nerds, techies, etc.) like to help others. Therefore many programmers (myself included) are active in social groups like bootcamps, workshops and forums. The following is a list of websites where you can study programming and ask an expert for help.

Bridge Troll – workshops
Cloud9 (C9) – on-line IDE
codebar – tutorials & workshops
Codenvy — on-line IDE
Codewars – tutorials
exercism – tutorials
Git – version control, also used for authentication by various sites in this list

Needless to say, there are many others. I will post another list later. You can send your suggestions via my email account — thanks.

Database Administration Fundamentals (WS17SQL1007) – Day 2

2017-06-292021-09-16Francisco Olvera

Review what we have covered so far and last night’s lab. As I mentioned, if you are interested in taking the Database Fundamentals certification exam (MTA 98-364), there is a lot of theory that you would need to know. Refer to the class notes or the Exam 98-364 MTA Database Administration Fundamentals book (ISBN 9780470889169) book in the syllabus for the theory.

As usual, if you have any question, do not hesitate to contact me.

Download the class notes for day 2.