Book Image

The Java Workshop

By : David Cuartielles, Andreas Göransson, Eric Foster-Johnson
Book Image

The Java Workshop

By: David Cuartielles, Andreas Göransson, Eric Foster-Johnson

Overview of this book

Java is a versatile, popular programming language used across a wide range of industries. Learning how to write effective Java code can take your career to the next level, and The Java Workshop will help you do just that. This book is designed to take the pain out of Java coding and teach you everything you need to know to be productive in building real-world software. The Workshop starts by showing you how to use classes, methods, and the built-in Collections API to manipulate data structures effortlessly. You’ll dive right into learning about object-oriented programming by creating classes and interfaces and making use of inheritance and polymorphism. After learning how to handle exceptions, you’ll study the modules, packages, and libraries that help you organize your code. As you progress, you’ll discover how to connect to external databases and web servers, work with regular expressions, and write unit tests to validate your code. You’ll also be introduced to functional programming and see how to implement it using lambda functions. By the end of this Workshop, you’ll be well-versed with key Java concepts and have the knowledge and confidence to tackle your own ambitious projects with Java.
Table of Contents (20 chapters)

Introducing SQL

Structured Query Language (SQL and often pronounced "sequ-el") provides a common language for querying and manipulating data in relational databases. While there are a few differences, SQL mostly works the same in relational database systems such as Oracle, SQL Server, MySQL, and H2.

The first thing you need to do is to create a table. To do so, use the CREATE TABLE SQL command. To create a table, you must provide the name of the table, the names and types of the columns, and any constraints.

Exercise 2: Creating the customer Table

Use the SQL CREATE TABLE command to create a customer table. It should contain the customer ID and the users' first and last names.

  1. Enter the following SQL commands in the upper-right input pane:
    CREATE TABLE IF NOT EXISTS customer
    (
    CUSTOMER_ID long,
    USERNAME varchar(255),
    FIRST_NAME varchar(255),
    LAST_NAME varchar(255),
    UNIQUE(USERNAME),
    PRIMARY KEY (CUSTOMER_ID)
    );
  2. After entering the SQL command, click...