SQL: A Step-by-Step Guide for Beginners, Paperback/Daniel Bell

Descriere

Description 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 My SQL or SQL Server. XAMPP or Wamp Server. 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 it