Getting Started with Java and MySQL

TEACHING UNIT 1. DEVELOPING AND TESTING PROGRAMS USING JAVA TECHNOLOGY 1. Introduction 2. Installing and configuring the Sun Development Kit (JDK) 3. Steps for Creating a Java Program 4. Class Structure TEACHING UNIT 2. OBJECT-ORIENTED PROGRAMMING 1. Introduction 2. Classes 3. Class Methods TEACHING UNIT 3. DECLARING, INITIALIZING, AND USING VARIABLES 1. Introduction 2. Basic Elements of the Java Language and Syntax 3. Variable Scope 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 of MySQL 5. Features LEARNING UNIT 5. MYSQL INSTALLATION 1. Introduction 2. Installing XAMPP 3. Verifying the XAMPP Installation 4. PHPMyAdmin 5. Root Password 6. User Management 7. Accessing Our Database via the Console 8. Table Types in MySQL 9. Creating Tables 10. One-to-Many Relationships 11. Many-to-Many Relationships LESSON 6. DATA TYPES 1. Introduction 2. Summary of Data Types 3. String and Char Data Types 4. Numeric data types 5. Date and time data types 6. Storage based on field type 7. The importance of choosing the correct column type 8. Relationship with other database data types