Description
This book offers a unique teaching approach: it will help you learn the fundamentals of the SQL programming language in 2 weeks. Additionally, it will provide you with examples that can aid you in mastering this language immediately.
Basically, SQL is a computer language used in databases. It involves data rows, column modifications, and database generation.
SQL – Structured Query Language
SQL is a language that you can use to store, manipulate, and retrieve information stored inside a relational database.
This is considered as the standard computer language for RDSs (i.e. Relational Database Systems). Modern database systems such as MySQL, Oracle, Informix, Sybase, and MS Access utilize SQL as their standard language.
The Main Advantages Offered by SQL
SQL allows you to do the following:
- Access information within relational database systems.
- Add descriptions for the information you ‘ ll store.
- Define and manipulate the data stored in your databases.
- Use other languages through its built-in libraries, pre-compilers, and modules.
- Generate and delete tables and databases.
- Generate, view, and store functions within your databases.
- Assign access rights on your tables and database objects.
Table Of Contents
Introduction
Chapter 1: SQL – Basic Information
Chapter 2 – The Basic Concepts of Relational Database Management
Systems
Chapter 3: The Syntax of SQL Statements
Chapter 4: The Different Data Types in SQL
Chapter 5: The Operators in the SQL Language
Chapter 6: The SQL Expressions
Chapter 7: How to Use SQL in Your Databases
Chapter 8: How to Combine Records Using SQL
Conclusion