Learning PostgreSQL 11
PostgreSQLisoneofthemostpopularopensourcedatabasemanagementsystemsintheworld,anditsupportsadvancedfeaturesincludedinSQLstandards.ThisbookwillfamiliarizeyouwiththelatestfeaturesinPostgreSQL11,andgetyouupandrunningwithbuildingefficientPostgreSQLdatabasesolutionsfromscratch.LearningPostgreSQL,11beginsbycoveringtheconceptsofrelationaldatabasesandtheircoreprinciples.You’llexploretheDataDefinitionLanguage(DDL)andcommonlyusedDDLcommandssupportedbyANSISQL.You’llalsolearnhowtocreatetables,defineintegrityconstraints,buildindexes,andsetupviewsandotherschemaobjects.Asyouadvance,you’llcometounderstandDataManipulationLanguage(DML)andserver-sideprogrammingcapabilitiesusingPL/pgSQL,givingyouarobustbackgroundtodevelop,tune,test,andtroubleshootyourdatabaseapplication.ThebookwillguideyouinexploringNoSQLcapabilitiesandconnectingtoyourdatabasetomanipulatedataobjects.You’llgettogripswithusingdatawarehousinginanalyticalsolutionsandreports,andscalingthedatabaseforhighavailabilityandperformance.Bytheendofthisbook,you’llhavegainedathoroughunderstandingofPostgreSQL11anddevelopedthenecessaryskillstobuildefficientdatabasesolutions.
·14.1萬字