Getting Started with SQL and Databases: Managing and Manipulating Data with SQL - Image 1

£42.29

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

Name: Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Brand: Apress
Price: 39.4 GBP
Availability: InStock

Information Systems

Price History & Forecast

Last 30 days • 30 data points (No recent data available)

Historical

Generating forecast...

Price Distribution

Price distribution over 30 days • 4 price levels

Days at Price

Current Price

Price Analysis

Most common price: £39 (14 days, 46.7%)

Price range: £39 - £43

Price levels: 4 different prices over 30 days

Description

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 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. What You Will Learn Filter, sort, andcalculate data Summarize data with aggregate functions Modify data with insert, update, and delete statements Study design principles in developing a database Who This Book Is For Developers and analysts working with SQL, as well as web developers who want a stronger understanding of working with databases

Key Features

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

Product type: ABIS BOOK

Product Specifications

Brand: Apress
Format: paperback
ASIN: 1484294920
Category: Books > Subjects > Computing & Internet > Computer Science > Information Systems
Domain: Amazon UK
Release Date: 08 June 2023
Listed Since: 23 March 2023

Barcode

No barcode data available

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

Price History & Forecast

Price Distribution

Price Analysis

Description

Key Features

Product Specifications

Barcode

Similar Products You Might Like

Beginning T-SQL: A Step-by-Step Approach

Simple SQL: Beginner’s Guide To Master SQL And Boost Career (Zero To Hero)

Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

SQL for Data Science: Data Cleaning, Wrangling and Analytics with Relational Databases (Data-Centric Systems and Applications)

Beginning Databases with PostgreSQL: From Novice to Professional

Relational Database and Transact SQL Second Edition

Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

Database Development and Management (Foundations of Database Design)

Database Systems: A Pragmatic Approach

SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL

Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence

Relational Database And SQL: Third Edition

Practical Guide for Oracle SQL, T-SQL and MySQL

Grokking Relational Database Design

Essential ASP.NET Web Forms Development: Full Stack Programming with C#, SQL, Ajax, and JavaScript

A Practical Guide to Database Design

SQL: The Practical Guide

Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL

Database Principles: Fundamentals of Design, Implementation, and Management

Beginning Database Design: From Novice to Professional

Pro Oracle SQL (Expert's Voice in Oracle)

Beginning Database Programming Using ASP.NET Core 3: With MVC, Razor Pages, Web API, jQuery, Angular, SQL Server, and NoSQL