- 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
Open Source
Birth of BASIC
“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
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
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
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
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
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.
How to Install SQL Server 2016 Express Edition & SQL Server Management Studio
Although these instructions refer to the 2016 version, the instructions are similar for previous versions. You can also also query YouTube.
The mind behind Linux – Linus Torvalds – TED Talks
This is a TED Talk interview with Linus Torvalds.
Database Administration Fundamentals (WS17SQL1007) – Day 1
We have started a new SQL course.
As I explained last night, each relational database management systems (RDBMS) vendor has some proprietary syntax and tools. Therefore some code has to be converted when moving code from SQL Server to Oracle, PostgreSQL or SQLite. Some third-parties have released facilities like SQLines. If you have any questions on other systems, do not hesitate to contact me.
By the way, you can use Valentina Studio Free to access databases similar to the SQL Server Management Studio client that we use in the classroom.
If you have Mac can use VirtualBox and download the Windows 10 with IE 11 VDI. Note you will need to install the .NET framework version 3.51 before the installation of SQL Server Express Edition and the SQL Server Management Studio (SSMS) client.
Download the class notes for day 1. Note that the file includes a lot of theory that you need to know if you are planning to take the certification exam.
If you have any questions regarding any material covered in class or any RDBMS issues you might face at work, do not hesitate to contact me.
