div class=ts-pagebutton class=gotoPage data-page=1Page 1button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page1jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=1 data-page=1 class=ts-thumb lazyload alt=Page 1: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails1jpg width=140 height=200 adivp1Chapter 01: Relational Databasespdivdiv class=ts-pagebutton class=gotoPage data-page=2Page 2button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page2jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=2 data-page=2 class=ts-thumb lazyload alt=Page 2: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails2jpg width=140 height=200 adivpChapter 1p p 2 pdivdiv class=ts-pagebutton class=gotoPage data-page=3Page 3button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page3jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=3 data-page=3 class=ts-thumb lazyload alt=Page 3: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails3jpg width=140 height=200 adivpChapter 1p p 3 pdivdiv class=ts-pagebutton class=gotoPage data-page=4Page 4button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page4jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=4 data-page=4 class=ts-thumb lazyload alt=Page 4: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails4jpg width=140 height=200 adivpChapter 1p p 4 pdivdiv class=ts-pagebutton class=gotoPage data-page=5Page 5button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page5jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=5 data-page=5 class=ts-thumb lazyload alt=Page 5: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails5jpg width=140 height=200 adivpChapter 1p p 5 p pChapter 02: PostgreSQL in Actionpdivdiv class=ts-pagebutton class=gotoPage data-page=6Page 6button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page6jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=6 data-page=6 class=ts-thumb lazyload alt=Page 6: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails6jpg width=140 height=200 adivpChapter 1p p 6 pdivdiv class=ts-pagebutton class=gotoPage data-page=7Page 7button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page7jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=7 data-page=7 class=ts-thumb lazyload alt=Page 7: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails7jpg width=140 height=200 adivpChapter 1p p 7 pdivdiv class=ts-pagebutton class=gotoPage data-page=8Page 8button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page8jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=8 data-page=8 class=ts-thumb lazyload alt=Page 8: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails8jpg width=140 height=200 adivpChapter 1p p 8 p pChapter 03: PostgreSQL Basic BuildingBlockspdivdiv class=ts-pagebutton class=gotoPage data-page=9Page 9button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page9jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=9 data-page=9 class=ts-thumb lazyload alt=Page 9: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails9jpg width=140 height=200 adivpChapter 1p p 9 pdivdiv class=ts-pagebutton class=gotoPage data-page=10Page 10button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page10jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=10 data-page=10 class=ts-thumb lazyload alt=Page 10: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails10jpg width=140 height=200 adivpChapter 1p p 10 p pChapter 05: SQL Languagepdivdiv class=ts-pagebutton class=gotoPage data-page=11Page 11button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page11jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=11 data-page=11 class=ts-thumb lazyload alt=Page 11: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails11jpg width=140 height=200 adivpChapter 1p p 11 pdivdiv class=ts-pagebutton class=gotoPage data-page=12Page 12button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page12jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=12 data-page=12 class=ts-thumb lazyload alt=Page 12: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails12jpg width=140 height=200 adivpChapter 1p p 12 p pChapter 06: Advanced Query Writingpdivdiv class=ts-pagebutton class=gotoPage data-page=13Page 13button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page13jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=13 data-page=13 class=ts-thumb lazyload alt=Page 13: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails13jpg width=140 height=200 adivpChapter 1p p 13 p pChapter 08: OLAP and Data Warehousingpdivdiv class=ts-pagebutton class=gotoPage data-page=14Page 14button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page14jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=14 data-page=14 class=ts-thumb lazyload alt=Page 14: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails14jpg width=140 height=200 adivpChapter 1p p 14 p pChapter 10: Transactions and ConcurrencyControlpdivdiv class=ts-pagebutton class=gotoPage data-page=15Page 15button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page15jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=15 data-page=15 class=ts-thumb lazyload alt=Page 15: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails15jpg width=140 height=200 adivpChapter 1p p 15 pdivdiv class=ts-pagebutton class=gotoPage data-page=16Page 16button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page16jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=16 data-page=16 class=ts-thumb lazyload alt=Page 16: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails16jpg width=140 height=200 adivpChapter 1p p 16 p pChapter 12: The PostgreSQL Catalogpdivdiv class=ts-pagebutton class=gotoPage data-page=17Page 17button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page17jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=17 data-page=17 class=ts-thumb lazyload alt=Page 17: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails17jpg width=140 height=200 adivpChapter 1p p 17 p pChapter 16: Scalabilitypdivdiv class=ts-pagebutton class=gotoPage data-page=18Page 18button div class=ts-imagea href=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5page18jpg target=_blank img data-url=chapter-01-relational-databases-chapter-1-14-chapter-10-street-numberhtmlpage=18 data-page=18 class=ts-thumb lazyload alt=Page 18: Chapter 01: Relational Databases - packtpubcom · Chapter 1 14 Chapter 10: street number zip code city Session 1 begi INSERT INTO a SELECT 1: Data bases databases loading=lazy src=data:imagegifbase64iVBORw0KGgoAAAANSUhEUgAAAAIAAAACCAQAAADYv8WvAAAAD0lEQVR42mP8X8AwAgiABKBAv+vAXklAAAAAElFTkSuQmCC data-src=https:reader042vdocumentsusreader042viewer20220308065b1463ae7f8b9a4d7c8cc347html5thumbnails18jpg width=140 height=200 adivpChapter 1p p 18 pdiv