Getting Started with SQL and Databases : Managing and Manipulating Data with SQL

✍ Scribed by Mark Simon

Publisher: Apress
Year: 2023
Tongue: English
Leaves: 377
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO.

✦ Table of Contents

Cover
Front Matter
1. Starting with SQL
2. Database
3. Filtering Data
4. Ordering Results
5. Calculating Column Values
6. Joining Tables
7. Aggregating Data
8. Working with Tables
9. Set Operations
Back Matter

📜 SIMILAR VOLUMES

Getting Started with SQL and Databases:

📁 Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

✍ Mark Simon 📂 Library 🏛 Apress 🌐 English

Learn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to

The SQL Workshop: Learn to create, manip

📁 The SQL Workshop: Learn to create, manipulate and secure data and manage relational databases with SQL

✍ Frank Solomon, Prashanth Jayaram, Awni Al Saqqa 📂 Library 📅 2019 🏛 Packt Publishing 🌐 English

Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases<h4>Key Features</h4><ul><li>Understand the features and syntax of SQL and use them to query databases</li><li>Learn how to create databases and tables and manip

GETTING STARTED WITH SQL: Exercises with

📁 GETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL

✍ Remy Lentzner 📂 Library 📅 2023 🏛 Éditions Remylent 🌐 English

SQL (Structured Query Language) is a query language for relational database management. In this book, you will discover the basics of its organization and its characteristics. Using the PhpMyAdmin environment, you will learn how to create a database, tables, columns, constraints, keys (primary and f

Learn SQL with MySQL: Retrieve and Manip

📁 Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition)

✍ Ashwin Pajankar 📂 Library 📅 2020 🏛 BPB Publications 🌐 English

A step-by-step guide that will help you manage data in a relational database using SQL with ease Key Features<li>Understand the concepts related to relational databases. </li><li> Learn how to install MariaDB and MySQL on Windows, Linux and tools to access it. </li><li> Learn how

Learn SQL with MySQL: Retrieve and Manip

📁 Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease (English Edition)

✍ Ashwin Pajankar 📂 Library 📅 2020 🏛 BPB Publications 🌐 English

SQL QuickStart Guide: The Simplified Beg

📁 SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL

✍ Walter Shields 📂 Library 📅 2019 🏛 ClydeBank Media LLC 🌐 English

<h4>"THE BEST SQL BOOK FOR BEGINNERS IN 2021 - HANDS DOWN!"</h4>*INCLUDES FREE ACCESS TO A SAMPLE DATABASE, SQL BROWSER APP, COMPREHENSION QUIZES & SEVERAL OTHER DIGITAL RESOURCES!* Not sure how to prepare for the data-driven future? This book shows you EXACTLY wha