Publisher's Synopsis
p>
This book is one of the most comprehensive and layman's introduction to writing code that is used traditionally to develop software applications that depend upon database schema and other technologies. It is obvious that SQL is one of the most important query languages that are present. We will have varied definitions to look at it. In this book, we will start with a small introduction and start looking at various types of data types that are present. Then we will have a look at varied basic commands that one should learn to become proficient in this language. The next where we will learn in detail about joins that can perform complex queries. In the next part we will be dealing with views and indexes that are bound to perform at excellence. The last two chapters will deal with integrity and about the administrating concepts. This is one of those few books which deals with these concepts. Below we describe the most important topics of these books.
- The basic concepts and the data types that are present in SQL
- All datatypes that fall with char, string and the datetime type.
- Everything that deals with basic commands like creation, modification, and deletion
- Everything that deals with JOINS. There are many types like inner join, external join and right join. Everything will be discussed in detail with examples.
- Discussion about views, indexes, and constraints in detail with a lot of examples.
- About integrity and how it can be achieved?
- About different database administration operations.
So, what are you waiting for ? Go and grab this layman guide.
