SQL: A Step-by-Step Guide for Beginners - Paperback

by Daniel Bell (Author)

This unique introductory SQL tutorial provides easy-to-understand SQL instructions and allows you to practice what you are learning by using examples in each chapter. After reading this easy guide, you will create your own unique tables and perform selects, inserts, updates, deletes, and drops on your tables. Enjoy your reading Get your copy now. Book Objectives: The following are the objectives of this book:

• To help you understand SQL (Structured Query Language) in detail.
• To help you transition from SQL Beginner to a Professional.
• To help you understand how to use SQL for storage, manipulation and retrieval of data in various relational database management systems.

Who this Book is for? The author targets the following groups of people:

• Anybody who is a complete beginner to SQL.
• Anybody in need of advancing their SQL skills.
• Professionals in data science, and computer programming.
• Professors, lecturers or tutors who are looking to find better ways to explain SQL programming to their students in the simplest and easiest way.
• Students and academicians, especially those focusing on SQL programming, computer science and Databases development.

What do you need for this Book? Your computer should be installed with the following:

• A database management system such as MySQL or SQL Server.
• XAMPP or WampServer.

What is inside the book?

• GETTING STARTED WITH SQL.
• CREATING A DATABASE.
• CREATING TABLES.
• SQL CONSTRAINTS.
• SELECT.
• DELETING RECORDS.
• SQL JOINS.
• DATE AND TIME.
• SQL UNIONS.
• MYSQL TRANSACTIONS.
• SQL VIEWS.
• TEMPORARY TABLES.
• CLONING TABLES.
• SQL SUBQUERIES.
• SEQUENCES.
• SQL ALIASES.
• SQL INJECTION.

From the back cover: This guide is a complete introduction to SQL, with concise and practical examples in each chapter. It covers the essentials for working with SQL. By building a database that is used throughout the book, it becomes easier to grasp the concepts by working with the same data throughout instead of wasting time trying to comprehend the schema before looking at the problem itself. The book is a quick, and an easy read. It can be completed in one week. After reading it you will be ready to design your database. The book has been grouped into chapters, with each chapter exploring a different feature of SQL. The author has provided SQL codes, each code performing a different task. Corresponding explanations have also been provided alongside each piece of code to help the reader understand the meaning of the various lines of the code. Besides this, screenshots showing the output that each code should return have been given. The author has used a simple language to make it easy even for beginners to understand.