Saturday, February 7, 2015

MySQL and Java workshop

Saeid Zebardast at workshop
Me at workshop

Preface

A few weeks ago, there was a Ubuntu 14.10 release party in Tehran, Iran. I had a workshop about developing software with MySQL and Java. Nearly 70 people were attended.
The workshop had three part:
  1. MySQL for beginners
  2. Java for beginners
  3. Developing software with MySQL and Java
Also, I create cheat sheets for Java and MySQL for participants.  I'm going to publish the presentations and cheat sheets in this post.

MySQL for beginners

The agenda for this presentation is:
  • Introduction
  • Installation
  • Execute SQL Statements
  • SQL Language
  • Some of The Most Important SQL Commands
  • SQL Syntax
  • Data Types
  • Operators
  • Some exercises

Java for beginners

The agenda for this presentation is:
  • Introduction
  • JVM
  • Java Principles
  • Java History
  • Java Uses
  • Installation
  • Java Syntax
  • Data Types
  • Variables
  • Operators
  • Select Statements
  • Iteration Statements
  • Comments Syntax
  • Access modifiers
  • Methods
  • Classes
  • Inheritance
  • Interfaces
  • Abstract
  • Java File Structure
  • Simple exercise


Developing software with MySQL and Java

The agenda for this presentation is:

  • Requirements
  • MySQL Data Definition
  • Java Classes
  • Methods for PhonebookApp
  • Compile and Run

MySQL Cheat Sheet


Java Cheat Sheet


Photos

Saeid Zebardast - MySQL and Java workshop
Saeid Zebardast - MySQL and Java workshop

MySQL and Java workshop
MySQL and Java workshop

Saeid Zebardast - MySQL and Java workshop
Saeid Zebardast - MySQL and Java workshop

MySQL and Java workshop
MySQL and Java workshop

Ubuntu 14.10 Release Party
Ubuntu 14.10 Release Party