Publisher's Synopsis
This book in detail will explain SQL statements in layman terms and will help beginners start writing statements that are related to SQL in very less time. SQL is one of the most famous database query languages and can easily make things work in the database applications. We will start with a thorough explanation of the relational databases and the relationships that are present. It is obvious to introduce the basic history of SQL and this book does the same. We will then start discussing about the special characteristics of the SQL language. In the next chapter we will in detail will discuss about all the data types that are present. Data types are used to hold the information that we are giving to the system. In the next chapter we will start discussing about a lot of basic commands like CREATE, DROP, ALTER. And the next chapter will deal with more advanced commands with a lot of examples. At the end we will even discuss about some of the tools that SQL can possess with. All the concepts in the book are explained in easy to understand way. All these can be understood using the varied conditions and the examples. Below in detail we will explain about the most important topics that this book deals with.
- Introduction of the relational database systems
- Introduction to SQL and all its characteristics such as schema and conversation
- Learn about basic data types that are present in the query language.
- You can have a detailed command syntax for creating, deleting and modifying database objects.
- Learn about indexes and constraints in depth
- Know how to search data using operators and wildcard characters.
- Know how to modify or update the data using different statements
- Know how to get proficient in a lot of tools that the SQL offers.
What are you waiting for? Go and grab this layman introduction to SQL and start writing your own syntax for database applications.