SQL Database Programming: The Ultimate Guide to Learning SQL Database Programming Fast!

By Tim Warren

SQL DATABASE PROGRAMMING

The ability to use SQL (Structured Query Language) is a hugely powerful skill.
This book is aimed at complete beginners, and will take you through all of the steps needed to master SQL.

You will learn how to use databases, the different SQL features, why you need to

• Language: English
• Publisher: Ingram Publishing
• Release date: Apr 20, 2020
• ISBN: 9781761035258

Book preview

Table Of Contents

Table Of Contents

Introduction

Chapter 1: Introduction to Relational Databases

Chapter 2: SQL Basics and Commands

Chapter 3: SELECT in Action

Chapter 4: Let There Be Data

Chapter 5: SELECT: The Sequel

Chapter 6: Wrap-Up

Conclusion

Introduction

The word Database is quite intimidating for programming newbies. It conjures up images of a bunch of computers running complicated scripts and people dragging their feet as they chug on a pitcher of coffee. What a lot of people don’t realize, however, is that databases are not alien concepts. The database concepts have been conceived from the need to organize huge amounts of data. It takes an observant mind to notice that databases are everywhere; they’re in your phone, your email account, your music player, etc. They’re in every computer that needs to add, display, modify, or delete data. When you create a playlist, you’re effectively creating a table. When you add songs to the playlist, you’re effectively inserting rows of data into the table. It doesn’t even matter whether you’re using a computer or simply a paper and a pen; so long as you’re grouping and categorizing data, you’re more or less dealing with a database.

Web developers are aware that with the advent of faster Internet connections and dynamic web design comes a need for updated content. It’s easy to attract curious visitors to a wonderfully designed website, but to attract repeat visitors, you have to have a constant stream of updated content.

While traditional website creation methods still work, it poses a lot of problems in terms of upgradability and modularity. For one thing, content providers are often not capable of coding HTML, and since their content is deeply embedded there, they’ll have to hire full time Webmasters just to copy their work into the HTML code. With HTML design being constantly revamped, it becomes especially tedious to keep rewriting HTML files and almost impossible to stay on top of updated web design concepts. In short, traditional web site creation is boring, tiring, and very inefficient.

Fortunately, database-driven website creation is here to save the day. By separating website design from its content, you can easily change one without affecting the other. Instead of crudely copying content from text files to HTML files, you can create a content management system so that content providers can put their work on their websites without even touching a single line of HTML code!

Whether you’re a beginner, intermediate, or advanced web or app developer, or simply a curious pedestrian interested in exploring the world of SQL, this book will give you insights on how people strive to make meaning out of a bunch of seemingly random data. 

If you’re still wondering whether or not this book is for you, maybe these points will help you out:

You want to master SQL without getting bogged down in overly technical terminologies that most academic books assume you know.

You not only want to master the semantics of SQL, but you also want to learn the best and newest practices involved.

You want to