London Programming Languages Meetup Group

SQL Language Essentials:

Step 1: Identify Primary keys, Foreign Keys and relation ships

STEP 2: The SQL Select Statement, Order By Clause, Column Aliases

STEP 3: SQL Conditions and the Where Clause

STEP 4: SQL Arithmetic Operations, Expression Queries, Limit/Top,

STEP 5: Group by and aggregates

STEP 6: Inner Joins

STEP 7: Challenge: Which country buys more beverages, the UK or the USA?

JAVA 1 hour basics course. Code Win the Lottery
This is great for beginners or cross-over.

STEP 1: Using variables. Integers. Strings. String Functions.
Getting user input from console using the Scanner class.

STEP 2: Decision Making(If-else) using numbers and Strings. For Loop and While Loops. Repeat code by using loops.

STEP 3: String arrays: Declare, get the length, and working with the elements in the Array.

STEP 4: Create methods with parameters and return values.

STEP 5: Random numbers, Get Random Numbers and when the end-user guesses this number, then ...... ??

STEP 6: You will Love it!