Do you use SQL at work or at home and want to learn how to use the right functions and queries to extract the relevant details in the database? Do you want to learn how to generate the right views and more? If you answered yes, then you are in the right place.
Many companies collect information from different sources and use that information to improve their revenue. It is difficult to work with large volumes of data, but companies have to learn how to collect that information in data warehouses or databases. Only when the data is stored can it be analyzed and used to improve business decisions.
If you are using SQL for the first time, then this book is for you. You can use it as your guide through the various and needed aspects of querying. In this book, you will learn more about the language and how you can use it to extract the necessary information from the dataset. You will learn about:
- SQL and its benefits
- Various data types used in SQL
- How to manage and retrieve the relevant objects and data from the database
- Common mistakes and how to overcome them
- How to protect the database from hacking
- Using Joins, Subqueries, and Set Operators
- And more!
If you want to master SQL, then a little practice is required. Use the examples and exercises in this book to improve your skills and learn how to build complex SQL queries. So, what are you waiting for? Grab a copy of this book now!
Introduction Chapter One: Introduction to SQL What Is SQL? How Does It Work with Databases? Benefits of Working with SQL Chapter Two: Basic SQL Commands Data Definition Language (DDL) Data Manipulation Language (DML) Data Query Language (DQL) Data Control Language Data Administration Commands Transactional Control Commands Chapter Three: Data Types You Can Use Inside of SQL Characters Fixed in Length Variable Characters Numeric Values Literal Strings Boolean Values Chapter Four: An Introduction to Numeric Data Types Absolute Numerics Approximate Numerics Operators in SQL Chapter Five: An Introduction to Character Strings Character Data Type Character Varying Data Type Character Large Object (CLOBs) Data Type National Character Large Object Data Type, National Character and National Character Varying Booleans Chapter Six: An Introduction to Datetimes Time without Time Zone Data Type Timestamp with Time Zone Data Type Date Data Type Chapter Seven: An Introduction to Intervals Row Type REF Types Collection Types User-Defined Types Chapter Eight: Manage the Objects in Your Database The Schema Creating a New Table Exercise Chapter Nine: Retrieving Data Retrieving Data Creating Views Adding Data Adding One Row at a Time Deleting Data Solutions Chapter Ten: How to Work with Search Results Through SQL Creating Your New Query Using the SELECT Command Working with Case Sensitivity Chapter Eleven: An Introduction to Joins How to Use A Join Basic Types of Join Examples of SQL Join Types What Do You Do Next? Chapter Twelve: An Introduction to Subqueries Why Should You Use A Subquery? What Do Subqueries Do? Chapter Thirteen: An Introduction to Set Operators UNION and UNION ALL INTERSECT MINUS Chapter Fourteen: Rookie Mistakes Assuming Your Clients Know What They Need Isolating Database Table Designs Ignoring the Scope of the Project Considering Technical Factors Alone Using only one Development Environment Skipping Testing No Documentation Never taking feedback Chapter Fifteen: Retrieving Information From Databases Verify the Structure of the Database Test the Database Always Check Queries with Subselects Summarize Data using GROUP BY Double Check Queries with JOIN Understand Clause Restrictions Handle Error Conditions with Care Always Use Parentheses for Logical Operators Control the Retrieval Privileges Create a Regular Backup Chapter Sixteen: Using SQL With Applications SQL In an Application SQL Embedded Java Program SQL Embedded C Program SQL Embedded FORTRAN Program SQL Embedded COBOL Program Chapter Seventeen: Database Security Delegating Responsibility Referential Integrity Chapter Eighteen: SQL Injections Chapter Nineteen: Exercise Solutions Chapter Twenty: Case Study Using INNER JOIN to Identify the StatusName Combining Reason Table Rows Using UNION Using a Subquery to Produce the Final Result that Includes the Derived Table Final Query Conclusion References
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.