von Kerem Koseoglu
- Verlag
- Rheinwerk Publishing
- Unsere Artikel-Nr.
- E6WWR4E
Beschreibung
Whether you're managing large datasets or writing your first query, build your SQL skills with this practical guide. Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-word applications. Highlights: 1) Schemas 2) Tables 3) Views 4) Keys 5) PostgreSQL 6) Data definition language (DDL) 7) Data manipulation language (DML) 8) Transaction control language (TCL) 9) Data query language (DQL) 10) Data control language (DCL) 11) Entity-relationship diagrams (ERD).
Spezifikationen
| Sprache | Englisch |
|---|---|
| Autor | Kerem Koseoglu |
| Auflage | 1 |
| Erscheinungsjahr | 2025 |
| Erscheinungsland | Deutschland |
| Format | Buch (Softcover) |
| Detailformat | Softcover |
| Anzahl Seiten | 490 |
Inhaltsverzeichnis
1 ... Introduction ... 15
1.1 ... Relational Databases ... 17
1.2 ... What Is SQL? ... 20
1.3 ... Target Audience ... 23
1.4 ... What You’ll Learn from This Book ... 24
1.5 ... Tips for Reading This Book ... 26
2 ... Basic Elements of Relational Databases ... 29
2.1 ... Fundamentals ... 29
2.2 ... Structures ... 38
2.3 ... Keys and Indexing ... 49
2.4 ... Normalization ... 59
2.5 ... Operations ... 62
2.6 ... Authorization ... 68
2.7 ... Summary ... 70
3 ... Setting Up the Environment ... 71
3.1 ... Our Database of Choice ... 73
3.2 ... Local Database Setup ... 75
3.3 ... SQL IDE Setup ... 83
3.4 ... Summary ... 97
4 ... Data Definition Language ... 99
4.1 ... Database Manipulation ... 100
4.2 ... Schema Manipulation ... 107
4.3 ... Table Manipulation ... 115
4.4 ... View Manipulation ... 147
4.5 ... Common Pitfalls of Data Definition Language ... 153
4.6 ... Summary ... 154
5 ... Data Manipulation Language ... 155
5.1 ... Building a Data Manipulation Language Playground ... 156
5.2 ... Data Manipulation Language Operations ... 162
5.3 ... Data Manipulation Language Automation ... 191
5.4 ... Summary ... 220
6 ... Transaction Control Language ... 221
6.1 ... Building a Transaction Control Language Playground ... 222
6.2 ... Why Is Transaction Control Language Necessary? ... 228
6.3 ... COMMIT and ROLLBACK ... 230
6.4 ... Save Points ... 235
6.5 ... Locks and Concurrency ... 241
6.6 ... Common Pitfalls of Transaction Control Language ... 251
6.7 ... Summary ... 251
7 ... Data Query Language ... 253
7.1 ... Building a Data Query Language Playground ... 254
7.2 ... Single Table Queries ... 273
7.3 ... Multitable Queries ... 312
7.4 ... String Functions ... 358
7.5 ... Math and Numeric Functions ... 373
7.6 ... Temporal Functions ... 383
7.7 ... Window Functions ... 389
7.8 ... Miscellaneous Functions ... 410
7.9 ... Summary ... 418
8 ... Data Control Language ... 421
8.1 ... Building a Data Control Language Playground ... 422
8.2 ... User and Role Manipulation ... 424
8.3 ... Granting Access ... 431
8.4 ... Revoking Access ... 440
8.5 ... Reporting Privileges ... 441
8.6 ... Summary ... 446
9 ... Conclusion ... 447
10 ... Appendices ... 449
A ... Entity-Relationship Diagrams ... 451
A.1 ... Entity-Relationship Diagrams and Their Significance ... 452
A.2 ... Entities ... 453
A.3 ... Relationships Among Entities ... 457
A.4 ... Entity-Relationship Diagrams Exercises ... 465
A.5 ... Summary ... 470
B ... Tips and Tricks ... 471
B.1 ... SQL Injection ... 471
B.2 ... Application-Level Authorization ... 473
B.3 ... Sensitive Data ... 476
B.4 ... Logical Deletion ... 477
B.5 ... Indexes versus Summary Tables ... 478
B.6 ... Legal Concerns ... 479
B.7 ... Primary Key Determination ... 480
B.8 ... Logging ... 482
B.9 ... Backup and Recovery ... 482
C ... About the Author ... 485
... Index ... 487
1.1 ... Relational Databases ... 17
1.2 ... What Is SQL? ... 20
1.3 ... Target Audience ... 23
1.4 ... What You’ll Learn from This Book ... 24
1.5 ... Tips for Reading This Book ... 26
2 ... Basic Elements of Relational Databases ... 29
2.1 ... Fundamentals ... 29
2.2 ... Structures ... 38
2.3 ... Keys and Indexing ... 49
2.4 ... Normalization ... 59
2.5 ... Operations ... 62
2.6 ... Authorization ... 68
2.7 ... Summary ... 70
3 ... Setting Up the Environment ... 71
3.1 ... Our Database of Choice ... 73
3.2 ... Local Database Setup ... 75
3.3 ... SQL IDE Setup ... 83
3.4 ... Summary ... 97
4 ... Data Definition Language ... 99
4.1 ... Database Manipulation ... 100
4.2 ... Schema Manipulation ... 107
4.3 ... Table Manipulation ... 115
4.4 ... View Manipulation ... 147
4.5 ... Common Pitfalls of Data Definition Language ... 153
4.6 ... Summary ... 154
5 ... Data Manipulation Language ... 155
5.1 ... Building a Data Manipulation Language Playground ... 156
5.2 ... Data Manipulation Language Operations ... 162
5.3 ... Data Manipulation Language Automation ... 191
5.4 ... Summary ... 220
6 ... Transaction Control Language ... 221
6.1 ... Building a Transaction Control Language Playground ... 222
6.2 ... Why Is Transaction Control Language Necessary? ... 228
6.3 ... COMMIT and ROLLBACK ... 230
6.4 ... Save Points ... 235
6.5 ... Locks and Concurrency ... 241
6.6 ... Common Pitfalls of Transaction Control Language ... 251
6.7 ... Summary ... 251
7 ... Data Query Language ... 253
7.1 ... Building a Data Query Language Playground ... 254
7.2 ... Single Table Queries ... 273
7.3 ... Multitable Queries ... 312
7.4 ... String Functions ... 358
7.5 ... Math and Numeric Functions ... 373
7.6 ... Temporal Functions ... 383
7.7 ... Window Functions ... 389
7.8 ... Miscellaneous Functions ... 410
7.9 ... Summary ... 418
8 ... Data Control Language ... 421
8.1 ... Building a Data Control Language Playground ... 422
8.2 ... User and Role Manipulation ... 424
8.3 ... Granting Access ... 431
8.4 ... Revoking Access ... 440
8.5 ... Reporting Privileges ... 441
8.6 ... Summary ... 446
9 ... Conclusion ... 447
10 ... Appendices ... 449
A ... Entity-Relationship Diagrams ... 451
A.1 ... Entity-Relationship Diagrams and Their Significance ... 452
A.2 ... Entities ... 453
A.3 ... Relationships Among Entities ... 457
A.4 ... Entity-Relationship Diagrams Exercises ... 465
A.5 ... Summary ... 470
B ... Tips and Tricks ... 471
B.1 ... SQL Injection ... 471
B.2 ... Application-Level Authorization ... 473
B.3 ... Sensitive Data ... 476
B.4 ... Logical Deletion ... 477
B.5 ... Indexes versus Summary Tables ... 478
B.6 ... Legal Concerns ... 479
B.7 ... Primary Key Determination ... 480
B.8 ... Logging ... 482
B.9 ... Backup and Recovery ... 482
C ... About the Author ... 485
... Index ... 487
Bewertungen
Produkt bewertenFür dieses Produkt liegt noch keine Bewertung vor. Wenn Sie es gekauft haben, teilen Sie gerne Ihre Erfahrung.
Zahlungsarten
Rechnung (Einzahlungsschein mit QR-Code), Twint, Kreditkarte, PostFinance, Apple, Google oder Samsung Pay.
Versand
Kostenlos: Schweiz & Liechtenstein
Rückgabe
Kein Rückgaberecht
Bei diesem Produkt hat entweder der Hersteller/Verlag das Rückgaberecht ausgeschlossen oder eine Rückgabe ist aufgrund des Vertriebssystems nicht möglich.
