Never confuse education with intelligence, you can have a PhD and still be an idiot.
- Richard Feynman -



Difference between revisions of "Introduction to Databases"

From Juneday education
Jump to: navigation, search
(Initial revision)
 
(Chapters (Rough outline - subject to changes in the future))
Line 17: Line 17:
 
* [[Database:Deleting rows of data -SQL DELETE]]
 
* [[Database:Deleting rows of data -SQL DELETE]]
 
* [[Database:Adding rows with new data - SQL INSERT]]
 
* [[Database:Adding rows with new data - SQL INSERT]]
* [[Database:Assignment 1]]
+
* [[Database:Assignment 1 - The basics]]
 
* [[Database:Combining rows of data from related tables - SQL JOIN]]
 
* [[Database:Combining rows of data from related tables - SQL JOIN]]
 
* [[Database:Adding constraints to prevent garbage data]]
 
* [[Database:Adding constraints to prevent garbage data]]
Line 24: Line 24:
 
==Book companion - TBD==
 
==Book companion - TBD==
 
We might add some extra reading material here.
 
We might add some extra reading material here.
 +
 
=What this book doesn't pretend to be=
 
=What this book doesn't pretend to be=
 
This book doesn't claim to be computer science or theoretical or even very technical. We strive to give the reader a practical introduction to what databases are, what database management systems are and how to use SQL to retrieve and manipulate data. We will not touch upon theoretical frameworks such as relational theory, relational algebra or set theory. Heck, we aren't even teaching logic. We believe that the reader is perfectly capable of getting a grasp of the basics behind databases and SQL without too much theoretic excursions. We are even inclined to think that understanding the basics of SQL and relational databases on this introductory level isn't simplified by introducing mathematics and computational models.
 
This book doesn't claim to be computer science or theoretical or even very technical. We strive to give the reader a practical introduction to what databases are, what database management systems are and how to use SQL to retrieve and manipulate data. We will not touch upon theoretical frameworks such as relational theory, relational algebra or set theory. Heck, we aren't even teaching logic. We believe that the reader is perfectly capable of getting a grasp of the basics behind databases and SQL without too much theoretic excursions. We are even inclined to think that understanding the basics of SQL and relational databases on this introductory level isn't simplified by introducing mathematics and computational models.

Revision as of 22:51, 8 December 2016

This book is a work in progress

This book is being written and is not yet completed. Feel free to dive in and start reading anyway. Of course all feedback is welcome by the Authors.

Introduction

This book is an introductory book to the concept of databases. It can be used for self-studies, or as course literature for a basic database course (a course which serves as an introduction to databases and SQL).

Regards from the authors: Rikard Fröberg and Henrik Sandklef

Before reading this book

Intended audience

Any one with basic knowledge of computing and IT, who wants to learn the basics of using databases.

Requirements

This book assumes you have knowledge of the working from the command line with a shell like bash. We also assume that you have a basic understanding of the standard streams and how they can be redirected or joined with pipes. If you feel that you need to freshen up your Bash skills before starting with this book, we recommend our Bash book, Bash introduction.

Chapters (Rough outline - subject to changes in the future)

Book companion - TBD

We might add some extra reading material here.

What this book doesn't pretend to be

This book doesn't claim to be computer science or theoretical or even very technical. We strive to give the reader a practical introduction to what databases are, what database management systems are and how to use SQL to retrieve and manipulate data. We will not touch upon theoretical frameworks such as relational theory, relational algebra or set theory. Heck, we aren't even teaching logic. We believe that the reader is perfectly capable of getting a grasp of the basics behind databases and SQL without too much theoretic excursions. We are even inclined to think that understanding the basics of SQL and relational databases on this introductory level isn't simplified by introducing mathematics and computational models.

We focus on the practical and - as usual with our books - base a lot of the teaching through the use of exercises and assignments.

A warning and disclaimer; Some readers with a theoretical background might be offended by our avoiding such terminology as "relational model", "tuples", "Cartesian product", "Relational Calculus", "Cardinality", or, even "Projection"! This book is not for them. There are numerous theoretical books for those who have a strong need for more mathematical or philosophical descriptions of database usage.