We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Modern SQL in PostgreSQL

00:00

Formal Metadata

Title
Modern SQL in PostgreSQL
Subtitle
Still using Windows 3.1? So why stick to SQL-92?
Title of Series
Number of Parts
29
Author
Contributors
License
CC Attribution - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date
Language
Production PlaceOttawa, Canada

Content Metadata

Subject Area
Genre
Abstract
A lot has changed since SQL:92 SQL has gone out of fashion lately --- partly due to the NoSQL movement, but mostly because SQL is often still used like 20 years ago. As a matter of fact, the SQL standard continued to evolve during the past decades resulting in the current release of 2011. In this session, we will go through the most important additions since the widely known SQL-92, explain how they work and how PostgreSQL extends them. We will cover common table expressions and window functions in detail and have a very short look at the temporal features of SQL:2011 and the related features of PostgreSQL.
Revision controlSubsetSoftware testingMultiplication signWindow functionFunction (mathematics)Standard deviationContext awarenessAsynchronous Transfer ModeDistanceSlide ruleLimit (category theory)XMLUML
Port scannerSineTable (information)Product (business)Order (biology)Limit (category theory)RankingEscape characterData Encryption StandardMultiplicationHash functionPay televisionCategory of beingCASE <Informatik>LogicFunction (mathematics)PlanningTwitterProduct (business)TheorySource codeTable (information)Theory of relativityRow (database)Endliche ModelltheorieQuicksortOrder (biology)Revision controlStatement (computer science)Semantics (computer science)CodeMultilaterationQuery languageMereologyAdditionWordAlgebraAxiom of choiceBitCausalitySlide ruleLimit (category theory)SoftwareParameter (computer programming)1 (number)Normal-form gameHecke operatorLattice (order)2 (number)View (database)Computer animation
MultiplicationOrder (biology)Data Encryption StandardLimit (category theory)Port scannerMathematical singularityPrice indexLoop (music)IEC-BusInterior (topology)Table (information)Imperative programmingMultiplication signQuery languageLine (geometry)NumberPay televisionQuicksortInterior (topology)Limit (category theory)CASE <Informatik>Subject indexingRow (database)Table (information)Goodness of fitResultantFunction (mathematics)View (database)Lattice (order)Mathematical optimizationMultilaterationComputer programmingFigurate numberSoftware testingFood energyPlanningNatural number1 (number)Computer animation
Inclusion mapOracleRegulärer Ausdruck <Textverarbeitung>NP-hardCartesian coordinate systemLine (geometry)Level (video gaming)MereologyQuery languageExpressionCASE <Informatik>DatabaseTable (information)Slide ruleWindow functionAdditionWeightStandard deviation
SineStatement (computer science)Inclusion mapPort scannerDigital filterMusical ensembleNormal (geometry)Price indexSource codeCASE <Informatik>TheoryView (database)Rule of inferenceState of matterTable (information)Query languageDatabaseExpressionForm (programming)Row (database)ImplementationPerspective (visual)Mathematical optimizationRevision controlRotationGame theoryMereologyData managementProgramming languageExtension (kinesiology)Line (geometry)Selectivity (electronic)Multiplication signStatement (computer science)FeedbackStress (mechanics)Parameter (computer programming)Link (knot theory)Disk read-and-write headSubject indexingPhysical systemMultilaterationInsertion lossComputer programmingDifferenz <Mathematik>Standard deviationParallel portControl flowComputer animation
OracleGodVideo gameSlide ruleExtension (kinesiology)Right angleDependent and independent variablesElement (mathematics)CASE <Informatik>TheoryCartesian coordinate systemGame controllerSelectivity (electronic)MathematicsMessage passingInterpreter (computing)Point (geometry)Mathematical analysisTable (information)Web 2.0Function (mathematics)Materialization (paranormal)Order (biology)Mechanism designReal numberStandard deviationGroup actionScalar fieldComputer animation
OracleWeb pageTable (information)Regulärer Ausdruck <Textverarbeitung>SineHyperbolic functionMountain passExt functorIterationProgrammschleifeElectric generatorSQL ServerKnotInfinityRule of inferenceStandard deviationTable (information)CASE <Informatik>ProgrammschleifeExpressionInfinityRecursionIterationObservational studyRevision controlLoop (music)Game theoryQuicksortCondition numberFreezingGraph (mathematics)Process (computing)Self-referenceExtension (kinesiology)Series (mathematics)DatabaseMereologyVertex (graph theory)DemosceneType theoryResultantStaff (military)Query languageArithmetic meanRow (database)Electronic mailing listCore dumpTouchscreenSelectivity (electronic)System callComplete metric spaceTuring testRadical (chemistry)Server (computing)2 (number)Control flowDynamical systemImplementationElectric generatorComputer animation
Statement (computer science)OraclePartition (number theory)Total S.A.SineLimit (category theory)Density of statesFunction (mathematics)IcosahedronOrder (biology)Inclusion mapPort scannerRankingData typeSet (mathematics)Total S.A.System callControl flowCASE <Informatik>Window functionSummierbarkeitType theorySource codeFunction (mathematics)Row (database)ExpressionGroup actionQuery languageRecursionSelectivity (electronic)Keyboard shortcutResultantDifferent (Kate Ryan album)IdentifiabilitySelf-organizationInstance (computer science)BuildingDatabase transactionSheaf (mathematics)AreaPoisson-KlammerEndliche ModelltheorieOrder (biology)Context awarenessMereologyRule of inferenceAxiom of choiceBit rateCartesian coordinate systemSoftware maintenanceMixed realityElectronic mailing listTable (information)Ocean currentPartition (number theory)Reading (process)Physical systemSlide ruleNumberFrame problemRankingCAN busPopulation densityEqualiser (mathematics)Standard deviation1 (number)Transport Layer SecurityOpen setRight angleDisk read-and-write headCoefficient of determinationForm (programming)Interior (topology)Scalar fieldComputer animation
Zoom lensOracleData acquisitionChemical equationSinePort scannerOrder (biology)Chemical equationTable (information)Query languageDifferent (Kate Ryan album)ExpressionNumberRow (database)Order (biology)Window functionArithmetic progressionTotal S.A.Direction (geometry)VarianceSocial classInitial value problemFood energyFunction (mathematics)QuantumRule of inferenceStandard deviationState of matterComputer animation
Division (mathematics)GradientSQL ServerMetropolitan area networkWindowOracleLimit (category theory)Proper mapDensity of statesSineOrder (biology)Limit (category theory)Row (database)Standard deviationRight angleServer (computing)Conformal map1 (number)NumberWindow functionType theorySlide ruleOrder (biology)Computer animation
Regulärer Ausdruck <Textverarbeitung>Server (computing)Musical ensembleHead-mounted displayOracleUniformer RaumSineOrder (biology)Selectivity (electronic)Instance (computer science)Slide ruleStandard deviation1 (number)Cross-platformQuicksortTable
Ext functorSineOrder (biology)Metropolitan area networkOracleWeb pageLink (knot theory)Data Encryption StandardPhysical systemTable (information)Port scannerFrequencySet (mathematics)Revision controlIcosahedronMultilaterationFunction (mathematics)Pairwise comparisonDatabaseRow (database)BefehlsprozessorCASE <Informatik>Goodness of fitRecursionUniform resource locatorFerry CorstenResultantQuery languageMultiplication signGreen's functionPresentation of a groupSlide ruleTable (information)Mathematical optimizationVapor barrierCartesian coordinate systemMetropolitan area networkNumberQuicksortTrailClient (computing)Normal (geometry)Order (biology)Level (video gaming)Formal languageRevision controlRange (statistics)TimestampProgramming languageMathematicsData typeLimit (category theory)Standard deviationStatement (computer science)Server (computing)Sound effectMeta elementPhysical systemFrequencySelectivity (electronic)2 (number)InformationTheoryWeb pageEntropie <Informationstheorie>Source codeWordMereologyFamilyExtreme programmingPoint (geometry)HypermediaFluidTemporal logicDistortion (mathematics)CAN busContent (media)Logical constantPersonal digital assistantTemplate (C++)Process (computing)
Physical systemOracleSQL ServerMetropolitan area networkMathematical singularitySystem callOvalKey (cryptography)FrequencyTemporal logicSound effectType theoryExclusive orPort scannerIdeal (ethics)CodeConstraint (mathematics)Link (knot theory)Multiplication signFrequencySelectivity (electronic)Frame problemDeclarative programmingRevision controlRow (database)DatabaseUniqueness quantificationSubject indexingServer (computing)Cartesian coordinate systemSlide ruleTable (information)Key (cryptography)Right anglePerturbation theoryPhysical systemStandard deviationStatement (computer science)Query languageRange (statistics)Different (Kate Ryan album)Run time (program lifecycle phase)Type theoryTheoryCASE <Informatik>Web pageQuicksortInformationFunction (mathematics)Equals signOrder (biology)Directed graphJSONXMLUML
OracleMathematical singularityNormal (geometry)Software developerBlogMIDIIdeal (ethics)Temporal logicType theoryFrequencyKey (cryptography)Sound effectComputer multitaskingExclusive orPort scannerTimestampFunction (mathematics)Point (geometry)Subject indexingDifferent (Kate Ryan album)Endliche ModelltheorieDisk read-and-write headComputer animation
Revision controlSinePhysical systemTable (information)Port scannerFrequencyPhysical systemType theorySlide ruleMultiplication signTimestampRevision controlWindow functionSpacetimeElectronic mailing listCASE <Informatik>Figurate numberComputer animation
Transcript: English(auto-generated)