Einstieg in SQL: F?r alle wichtigen Datenbanksysteme: MySQL, PostgreSQL, MariaDB, MS SQL. ?ber 600 Seiten. Ohne Vorwissen einsteigen ? Ausgabe 2024

Laube, Michael

ISBN 10: 3367105465 / ISBN 13: 9783367105465

Published by Rheinwerk Verlag GmbH, 2024

About this Item

Seller Inventory # 410817073

Bibliographic Details

• Title: Einstieg in SQL: F?r alle wichtigen Datenbanksysteme: MySQL, PostgreSQL, MariaDB, MS SQL. ?ber 600 Seiten. Ohne Vorwissen einsteigen ? Ausgabe 2024
• Publisher: Rheinwerk Verlag GmbH
• Publication Date: 2024
• Language: German
• ISBN 10: 3367105465
• ISBN 13: 9783367105465
• Binding: Hardcover
• Condition: New

About this title

Synopsis

The guide to SQL: understand, use skilfully and look up at any time! Get started with SQL and modeling data can be found here! Step by step, Michael Laube guides you through the SQL commands in this guide, familiarizing you with all the important commands. Building on this foundation, you will learn how to model, link and edit your data correctly. These guidelines make data modeling with SQL simple and straightforward: to create order and ensure high-performance queries.

From the contents:

• Get to know and understand basics
• Basic Table Query Features
• Insert, modify and delete rows (INSERT, UPDATE and DELETE)
• Create tables with CREATE TABLE
• Quantity Operations
• Modeling databases
• Optimize data models
• Transfer data models to tables
• Relationships between tables: JOINs
• Transactions
• Scalar Functions
• Condition Logic
• Work with time and date
• Group column values with GROUP BY
• Subqueries
• VIEWS: Save queries to virtual tables
• Optimise performance.