The Language of SQL

Autori

• LARRY ROCKOFF

Parametri

• Business & Management
• Commercio
• Computer & Internet
• Saggistica
• Tecnologia

Maggiori informazioni sul libro

Get started quickly with SQL! This essential guide equips students with a practical understanding of SQL and relational databases without overwhelming them with exhaustive syntax details. Unlike many SQL texts that serve as encyclopedic references, this book emphasizes general concepts and provides clear explanations and examples of SQL statements. Unique features include the absence of software download requirements, allowing students to grasp SQL usage through reading alone. Topics are organized logically, introducing SQL keywords progressively to enhance understanding. The book covers the latest syntax for Microsoft SQL Server 2019, MySQL 8.0, and Oracle 18c, with special "Database Differences" sidebars highlighting syntax variations. Students will learn to retrieve data from relational databases, apply functions and calculations, group and summarize data, and use complex logic for targeted data retrieval. Additionally, they will design relational databases for intuitive data access, update data, create new tables, and utilize spreadsheets for meaningful data displays. The guide also covers retrieving data from multiple tables through joins, subqueries, views, and set logic, as well as creating, modifying, and executing stored procedures. Instructions for installing free versions of the databases are included, making this a comprehensive resource for beginners.

Lingua: Inglese

Pubblicato: 2021

(In brossura)