product iamge

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

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Download
Search on Amazon

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

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.

Author(s): Mark Simon
Publisher: Apress
Year: 2023

Language: English
Pages: 377

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