Getting Started with Java and MySQL

TEACHING UNIT 1. DEVELOPING AND TESTING PROGRAMMES USING JAVA TECHNOLOGY

1. Introduction
2. Installing and configuring the Sun Development Kit (JDK)
3. Steps for creating a programme in Java
4. Class outline

TEACHING UNIT 2. OBJECT-ORIENTED PROGRAMMING

1. Introduction
2. Lessons
3. Classroom methods

TEACHING UNIT 3. DECLARING, INITIALISING AND USING VARIABLES

1. Introduction
2. Basic elements of the Java language and syntax
3. Scope of variables
4. Declaring variables
5. Type conversion (casting)
6. Lab 1: Defining data types
7. Lab 2: Defining data types II
8. Lab 3: Defining data types III
9. Lab: Casting between data types

TEACHING UNIT 4. INTRODUCTION TO MYSQL

1. What is MySQL?
2. MySQL Open Source
3. Why use MySQL?
4. Some technical details about MySQL
5. Features

TEACHING UNIT 5. INSTALLING MYSQL

1. Introduction
2. Installing XAMPP
3. Check that XAMPP has been installed
4. PHPMyAdmin
5. Root password
6. User management
7. Access our database via the console
8. Types of tables in MySQL
9. Create tables
10. One-to-many relationships
11. Many-to-many relationships

TEACHING UNIT 6. DATA TYPES

1. Introduction
2. Summary of data types
3. String and Char data types
4. Types of numerical data
5. Data types for date and time
6. Storage by field type
7. The importance of choosing the right type of column
8. Relationship with other types of database data