Thursday, January 24, 2019

sql easy sql programming database management for beginners

SQL

Easy SQL Programming & Database Management For Beginners. Your Step-By-Step Guide To Learning The SQL Database.

Felix Alvaro


Acknowledgments

Firstly, I want to thank God for giving me the knowledge and inspiration to put this informative book together. I also want to thank my parents, my brothers and my partner Silvia for their support.

Table of Contents

Chapter One: SQL Overview

- History of SQL

- Uses of SQL

- People Using SQL

Chapter Two: The Database Essentials

- Database Fundamentals

- Relational Database Fundamentals

- Database Management Systems

Chapter Three: The SQL Structure

- SQL Fundamental Features

- SQL Command Types

- SQLite Database Features and Installation Instructions

-

Chapter Four: Data Types

- Definition of Data

- Types of Data

- User-Defined Data Type

Chapter Five: Data Definition Language Statements

- CREATE Statement

- ALTER Statement

- DROP Statement

Chapter Six: Data Manipulation Language Statements

- INSERT Statement

- UPDATE Statement

- DELETE Statement

Chapter Seven: Data Query Language Statements

- SELECT Statement

- WHERE Statement

- ORDER BY and GROUP BY Statements

Chapter Eight: Transactional Control Commands

- COMMIT Command

- ROLLBACK Command

- SAVEPOINT Command

Chapter Nine: Database Views

- Defining Views

- Creating Views