SQL - Felix Alvaro.pdf

(2178 KB) Pobierz
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
- Dropping Views
Chapter Ten:
Enhancing Database Designs
-
Assigning Primary and Foreign Keys
- Understanding Indexes
- Normalizing Databases
Chapter Eleven:
Database Advance Topics
- Cursors
- Triggers
- Errors
Recap + Final Words
-
-
Recap and Final words
Check out my other books
© Copyright 2016 by D.A.Alvaro - All rights reserved.
This document is geared towards providing exact and reliable information in regards to the topic and
issue covered.
It is not legal to reproduce, duplicate, or transmit any part of this document in either electronic means or
in printed format. Recording of this publication is strictly prohibited.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin