Book Image

Introduction to Programming

By : Nick Samoylov
Book Image

Introduction to Programming

By: Nick Samoylov

Overview of this book

Have you ever thought about making your computer do what you want it to do? Do you want to learn to program, but just don't know where to start? Instead of guiding you in the right direction, have other learning resources got you confused with over-explanations? Don't worry. Look no further. Introduction to Programming is here to help. Written by an industry expert who understands the challenges faced by those from a non-programming background, this book takes a gentle, hand-holding approach to introducing you to the world of programming. Beginning with an introduction to what programming is, you'll go on to learn about languages, their syntax, and development environments. With plenty of examples for you to code alongside reading, the book's practical approach will help you to grasp everything it has to offer. More importantly, you'll understand several aspects of application development. As a result, you'll have your very own application running by the end of the book. To help you comprehensively understand Java programming, there are exercises at the end of each chapter to keep things interesting and encourage you to add your own personal touch to the code and, ultimately, your application.
Table of Contents (21 chapters)

Creating a database and its structure

Look up how to download and install your preferred database server. A database server is a software system that maintains and manages the database. For our demonstrations, we are going to use PostgreSQL, a free, open source database server.

After the database server is installed, we'll use its console for creating a database and its user with the corresponding permissions. There are many ways to structure the data store and the system of users with different levels of access. In this book, we will introduce only the basic approach, which allows us to demonstrate the main JDBC capabilities.

CREATE and DROP the database and its user

Read the database instructions and create, first...