more than a query language sql in the 21st century
play

More Than a Query Language: SQL in the 21st Century Markus Winand, - PowerPoint PPT Presentation

Mar 29, 2023 •381 likes •1.55k views

More Than a Query Language: SQL in the 21st Century Markus Winand, winand.at SQL Renaissance Ambassador 1974 1992 SQL-92 Tied to the Relational Idea SQL-92 Tied to the Relational Idea Relational Data Model Atomic types

  1. SQL:1999 — LATERAL Lateral derived tables lift both limitations and can be correlated: “Derived table” means SELECT … it’s in the , ldt.* FROM/JOIN clause FROM t2 CROSS JOIN LATERAL (SELECT column_1, column_2 FROM t1 WHERE t1.x = t2.y ) AS ldt Still … “correlated”

  2. SQL:1999 — LATERAL Lateral derived tables lift both limitations and can be correlated: “Derived table” means SELECT … it’s in the , ldt.* FROM/JOIN clause FROM t2 CROSS JOIN LATERAL (SELECT column_1, column_2 FROM t1 Regular join WHERE t1.x = t2.y semantics ) AS ldt Still … “correlated”

  3. SQL:1999 — LATERAL

  4. SQL:1999 — LATERAL ‣ Top-N per group inside a lateral derived table FETCH FIRST (or LIMIT , TOP ) applies per row from left tables.

  5. SQL:1999 — LATERAL ‣ Top-N per group FROM t JOIN LATERAL (SELECT … inside a lateral derived table FROM … FETCH FIRST (or LIMIT , TOP ) WHERE t.c=… applies per row from left tables. ORDER BY … LIMIT 10 ) derived_table

  6. SQL:1999 — LATERAL Add proper index for Top-N query ‣ Top-N per group FROM t JOIN LATERAL (SELECT … inside a lateral derived table FROM … FETCH FIRST (or LIMIT , TOP ) WHERE t.c=… applies per row from left tables. ORDER BY … LIMIT 10 ) derived_table https://use-the-index-luke.com/sql/partial-results/top-n-queries

  7. SQL:1999 — LATERAL Add proper index for Top-N query ‣ Top-N per group FROM t JOIN LATERAL (SELECT … inside a lateral derived table FROM … FETCH FIRST (or LIMIT , TOP ) WHERE t.c=… applies per row from left tables. ORDER BY … LIMIT 10 ‣ Also useful to find most recent ) derived_table news from several subscribed topics (“multi-source top-N”). https://use-the-index-luke.com/sql/partial-results/top-n-queries

  8. SQL:1999 — LATERAL Add proper index for Top-N query ‣ Top-N per group FROM t JOIN LATERAL (SELECT … inside a lateral derived table FROM … FETCH FIRST (or LIMIT , TOP ) WHERE t.c=… applies per row from left tables. ORDER BY … LIMIT 10 ‣ Also useful to find most recent ) derived_table news from several subscribed topics (“multi-source top-N”). https://use-the-index-luke.com/sql/partial-results/top-n-queries ‣ Table function arguments FROM t ( TABLE often implies LATERAL ) JOIN TABLE (your_func(t.c))

  9. SQL:1999 — LATERAL 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 MariaDB 5.1 MySQL 8.0.14 PostgreSQL 9.3 SQLite 1.0 DB2 LUW 9.1 Oracle 11gR1 12cR1 [0] SQL Server 2005 [1] [0] Undocumented. Requires setting trace event 22829. [1] LATERAL is not supported as of SQL Server 2016 but [CROSS|OUTER] � APPLY can be used for the same e � ect.

  10. 1999 2003

  11. http://www.acm.org:80/sigmod/record/issues/0206/standard.pdf (via Wayback machine)

  12. SQL:2003 — Schemaless & Analytical Schemaless ‣ Introduced XML ‣ Non-uniform documents in a single column

  13. SQL:2003 — Schemaless & Analytical Schemaless ‣ Introduced XML ‣ Non-uniform documents in a single column Later: ‣ JSON added with SQL:2016 ‣ Proprietary JSON support: ‣ 2012: PostgreSQL ‣ 2014: Oracle ‣ 2015: MySQL ‣ 2016: SQL Server

  14. SQL:2003 — Schemaless & Analytical Schemaless Analytical ‣ Introduced XML ‣ Introduced ‣ Non-uniform window functions ‣ Accessing other rows documents in a single column of the current result Later: ‣ JSON added with SQL:2016 ‣ Proprietary JSON support: ‣ 2012: PostgreSQL ‣ 2014: Oracle ‣ 2015: MySQL ‣ 2016: SQL Server

  15. SQL:2003 — Schemaless & Analytical Schemaless Analytical ‣ Introduced XML ‣ Introduced ‣ Non-uniform window functions ‣ Accessing other rows documents in a single column of the current result Later: Later: ‣ JSON added with SQL:2016 ‣ Extended in SQL:2011 ‣ Proprietary JSON support: ‣ Popular among “New SQLs” ‣ 2012: PostgreSQL ‣ 2013: BigQuery, Hive ‣ 2014: Oracle ‣ 2014: Impala ‣ 2015: MySQL ‣ 2015: Spark SQL ‣ 2016: SQL Server ‣ 2016: NuoDB, MemSQL, Cockroach DB, VoltDB

  16. SQL:2003 — Analytical id value SELECT id, value 1 +10 2 +20 3 -10 4 +50 5 -30 6 -20 FROM t

  17. SQL:2003 — Analytical id value bal SELECT id, value 1 +10 2 +20 3 -10 4 +50 5 -30 6 -20 FROM t

  18. SQL:2003 — Analytical id value bal SELECT id, value 1 +10 +10 2 +20 3 -10 4 +50 5 -30 6 -20 FROM t

  19. SQL:2003 — Analytical id value bal SELECT id, value 1 +10 +10 2 +20 +30 3 -10 +20 4 +50 +70 5 -30 +40 6 -20 +20 FROM t

  20. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 3 -10 +20 4 +50 +70 5 -30 +40 6 -20 +20 ) bal FROM t

  21. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 4 +50 +70 5 -30 +40 6 -20 +20 ) bal FROM t

  22. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 4 +50 +70 5 -30 +40 6 -20 +20 ) bal FROM t

  23. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 6 -20 +20 ) bal FROM t

  24. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 6 -20 +20 ) bal FROM t

  25. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  26. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  27. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  28. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  29. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  30. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  31. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  32. SQL:2003 — Analytical id value bal SELECT id, value , SUM(value) 1 +10 +10 OVER ( 2 +20 +30 ORDER BY id 3 -10 +20 ROWS BETWEEN 4 +50 +70 UNBOUNDED PRECEDING 5 -30 +40 AND CURRENT ROW 6 -20 +20 ) bal FROM t

  33. SQL:2003 — Analytical 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 MariaDB 5.1 10.2 MySQL 8.0 PostgreSQL 8.4 SQLite 1.0 3.25.0 DB2 LUW 7.0 Oracle 8i SQL Server 2005 2012 [0] [0] Without framing

  34. SQL:2003 — Analytical Impala Spark BigQuery Hive NuoDB 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 MariaDB 5.1 10.2 MySQL 8.0 PostgreSQL 8.4 SQLite 1.0 3.25.0 DB2 LUW 7.0 Oracle 8i SQL Server 2005 2012 [0] [0] Without framing

  35. 2003 2016

  36. SQL:2016 — JSON http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip

  37. SQL:2016 — JSON [ { "id": 42, "a1": "foo" }, { "id": 43, "a1": "bar" } ] http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip

  38. SQL:2016 — JSON [ { "id": 42, id a1 "a1": "foo" }, 42 foo { 43 bar "id": 43, "a1": "bar" } ] http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip

  39. SQL:2016 — JSON_TABLE [ SELECT * { "id": 42, FROM JSON_TABLE "a1": "foo" }, ( ? { "id": 43, , '$[*]' "a1": "bar" COLUMNS } ] ( id INT PATH '$.id' , a1 VARCHAR(…) PATH '$.a1' id a1 ) 42 foo ) r 43 bar

  40. SQL:2016 — JSON_TABLE [ SELECT * { "id": 42, FROM JSON_TABLE "a1": "foo" }, ( ? { Bind "id": 43, , '$[*]' Parameter "a1": "bar" COLUMNS } ] ( id INT PATH '$.id' , a1 VARCHAR(…) PATH '$.a1' id a1 ) 42 foo ) r 43 bar

  41. SQL:2016 — JSON_TABLE SQL/JSON Path [ SELECT * { ‣ Query language to "id": 42, select elements from FROM JSON_TABLE "a1": "foo" a JSON document }, ( ? { ‣ Defined in the Bind "id": 43, , '$[*]' SQL standard Parameter "a1": "bar" COLUMNS } ] ( id INT PATH '$.id' , a1 VARCHAR(…) PATH '$.a1' id a1 ) 42 foo ) r 43 bar

  42. SQL:2016 — JSON_TABLE SQL/JSON Path [ SELECT * { ‣ Query language to "id": 42, select elements from FROM JSON_TABLE "a1": "foo" a JSON document }, ( ? { ‣ Defined in the Bind "id": 43, , '$[*]' SQL standard Parameter "a1": "bar" COLUMNS } ] ( id INT PATH '$.id' , a1 VARCHAR(…) PATH '$.a1' id a1 ) 42 foo ) r 43 bar

  43. SQL:2016 — JSON_TABLE SQL/JSON Path [ SELECT * { ‣ Query language to "id": 42, select elements from FROM JSON_TABLE "a1": "foo" a JSON document }, ( ? { ‣ Defined in the Bind "id": 43, , '$[*]' SQL standard Parameter "a1": "bar" COLUMNS } ] ( id INT PATH '$.id' , a1 VARCHAR(…) PATH '$.a1' id a1 ) 42 foo ) r 43 bar

  44. SQL:2016 — JSON_TABLE — Use Case [ SELECT * { "id": 42, FROM JSON_TABLE "a1": "foo" }, ( ? { "id": 43, , '$[*]' "a1": "bar" COLUMNS } ] ( id INT PATH '$.id' , a1 VARCHAR(…) PATH '$.a1' id a1 ) 42 foo ) r 43 bar

  45. SQL:2016 — JSON_TABLE — Use Case [ INSERT INTO target_table { SELECT * "id": 42, "a1": "foo" FROM JSON_TABLE }, { ( ? "id": 43, , '$[*]' "a1": "bar" } COLUMNS ] ( id INT PATH '$.id' id a1 , a1 VARCHAR(…) PATH '$.a1' 42 foo ) ) r 43 bar

  46. SQL:2016 — JSON_TABLE 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 MariaDB 5.1 MySQL 8.0 PostgreSQL SQLite 1.0 DB2 LUW 11.1.4.4 [0] Oracle 12cR1 SQL Server 2016 [1] [0] Ridicoulus limitations: only 'strict $' as row expression [1] OPENJSON provides similar functionality

  47. SQL:2016 — JSON_TABLE MDEV-17399 Tagged with 1999 2001 2003 2005 2007 2009 2011 2013 2015 2017 2019 fix/Version: 10.6 MariaDB 5.1 Ready for MySQL 8.0 Committer PostgreSQL SQLite 1.0 DB2 LUW 11.1.4.4 [0] Oracle 12cR1 SQL Server 2016 [1] [0] Ridicoulus limitations: only 'strict $' as row expression [1] OPENJSON provides similar functionality

  48. 2011 2016

  49. SQL:2011 — Time Travelling http://cs.ulb.ac.be/public/_media/teaching/infoh415/tempfeaturessql2011.pdf

  50. SQL:2011 — Time Travelling Application Versioning ‣ Dedicated syntax added ‣ When did something happen in the real world? http://cs.ulb.ac.be/public/_media/teaching/infoh415/tempfeaturessql2011.pdf

Recommend

LANGUAGE & TOOLS WHY GOVERNMENT CANNOT MANAGE THE 21ST CENTURY 21st Century Problems

LANGUAGE & TOOLS WHY GOVERNMENT CANNOT MANAGE THE 21ST CENTURY 21st Century Problems

LANGUAGE & TOOLS WHY GOVERNMENT CANNOT MANAGE THE 21ST CENTURY 21st Century Problems Climate, for example, is hard The Big Threats Nukes, Biotech, Nanotech, Asteroids, Weird Physics, Environment Mostly government funded

300 views • 28 slides
More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL http://www.almaden.ibm.com/cs/people/chamberlin/sequel-1974.pdf More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

1.46k views • 145 slides
More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL http://www.almaden.ibm.com/cs/people/chamberlin/sequel-1974.pdf More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

1.74k views • 146 slides
More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL

More Than a Query Language: SQL in the 21 st Century @MarkusWinand @ModernSQL http://www.almaden.ibm.com/cs/people/chamberlin/sequel-1974.pdf 1974 1992 SQL-92 Tied to the Relational Idea SQL-92 Tied to the Relational Idea

1.37k views • 124 slides
The 21st Century Gig Economy Quality Professional Presented by: Rosemarie E. Christopher The 21st

The 21st Century Gig Economy Quality Professional Presented by: Rosemarie E. Christopher The 21st

The 21st Century Gig Economy Quality Professional Presented by: Rosemarie E. Christopher The 21st Century Gig Economy With almost 0% unemployment in the Science, Technology, Engineering and Mathematics (STEM) workforce, what are YOU doing

461 views • 28 slides
Perl 6 Edward Higgins 2019-03-04 Perl 6 A language for the 21st Century [ Originally presented

Perl 6 Edward Higgins 2019-03-04 Perl 6 A language for the 21st Century [ Originally presented

Perl 6 Edward Higgins 2019-03-04 Perl 6 A language for the 21st Century [ Originally presented in Vim, ] [ best viewed in a full-screen terminal at 70x20 characters ] In the beginning... In the beginning... C sh awk sed grep In the

806 views • 42 slides
Curriculum Update Springfield Township School November 12, 2015 Overview 21st Century Life

Curriculum Update Springfield Township School November 12, 2015 Overview 21st Century Life

Curriculum Update Springfield Township School November 12, 2015 Overview 21st Century Life and Careers K-6 Language Arts Literacy K-6 Mathematics K-6 Social Studies K-6 Health/P.E. K-6 World Language K-6

516 views • 14 slides
Mathematical Linguistics in the 21st Century Jeffrey Heinz New Orleans, LA Workshop on Formal

Mathematical Linguistics in the 21st Century Jeffrey Heinz New Orleans, LA Workshop on Formal

Mathematical Linguistics in the 21st Century Jeffrey Heinz New Orleans, LA Workshop on Formal Language Theory Society for Computation in Language January 5, 2020 FLT SCiL | 2020/01/05 J. Heinz | 1 Thesis Far from being a fossil from a

1.62k views • 114 slides
The 21 st Century Conservation Vision To meet the challenges of the 21st Century, we must:

The 21 st Century Conservation Vision To meet the challenges of the 21st Century, we must:

The 21 st Century Conservation Vision To meet the challenges of the 21st Century, we must: Make strategic, cost-effective conservation investments; Increase efficiency, transparency, accountability; and Design/manage for landscapes

710 views • 30 slides
21st Century Computer Architecture A CCC community white paper

21st Century Computer Architecture A CCC community white paper

21 st Century Computer Architecture Mark D. Hill, Univ. of Wisconsin-Madison 6/2016 @ Architecture 2030 @ ISCA 1. Whitepaper Content (tell a story) 2. Process, Impact & Computing Community Consortium (CCC) 21st Century Computer

558 views • 27 slides
Task 1: If 20th century-type droughts (i.e., 1950s) under 21st century temperatures are the new

Task 1: If 20th century-type droughts (i.e., 1950s) under 21st century temperatures are the new

Task 1: If 20th century-type droughts (i.e., 1950s) under 21st century temperatures are the new normal for drought, how might such droughts impact upper Colorado River flow (UCRB)? Approach : Assess 20th century-type droughts in the

904 views • 34 slides
Confucian Ethics and the 21st Century Global Business Reg Little A Lost Half Century

Confucian Ethics and the 21st Century Global Business Reg Little A Lost Half Century

Confucian Ethics and the 21st Century Global Business Reg Little A Lost Half Century Superiority of Confucian business culture was evident 50 years ago in Japan Australias Beijing Embassy foreshadowed Chinas rise in 1976 Asia

414 views • 7 slides
Schoogle 21st Century Learning Spaces How Google Chrome is becoming a platform for instruction

Schoogle 21st Century Learning Spaces How Google Chrome is becoming a platform for instruction

Schoogle 21st Century Learning Spaces How Google Chrome is becoming a platform for instruction Chrome & Chromebooks Montgomery County Public Schools 2014-2016 Strategic Technology Plan The 21st Century Learning Spaces initiative focuses

246 views • 9 slides
A New Vision for 21st Century 21 st Century Education [Insert Presenter Name] [Insert Presenter

A New Vision for 21st Century 21 st Century Education [Insert Presenter Name] [Insert Presenter

Preparing Students for the A New Vision for 21st Century 21 st Century Education [Insert Presenter Name] [Insert Presenter Title & Company] [Insert Event Name] KTEC Enrollment Meeting [Insert Date] January 09 PLEASE NOTE: This is only a

606 views • 39 slides
Library Instruction in the 21st Century BoE presentation--Oct. 17, 2016 Ellen Lawrence &

Library Instruction in the 21st Century BoE presentation--Oct. 17, 2016 Ellen Lawrence &

Library Instruction in the 21st Century BoE presentation--Oct. 17, 2016 Ellen Lawrence & Kerrin Riley D86 Library Department Chairs Research ReadingTechnologyEnvironment The 21st Century Then Now Library - NOT your typical library!

342 views • 9 slides
From Frege to Gosling: 19th Century Logic and 21st Century Programming Languages Philip

From Frege to Gosling: 19th Century Logic and 21st Century Programming Languages Philip

From Frege to Gosling: 19th Century Logic and 21st Century Programming Languages Philip Wadler Avaya Labs Gottlob Frege, Begriffsschrift , 1879 Part I The Curry-Howard Isomorphism Modus ponens Frege, 1879 Gentzen, 1934 B A

735 views • 60 slides
SQL SQL SQL = Structured Query Language Standard query language for relational

SQL SQL SQL = Structured Query Language Standard query language for relational

SQL SQL SQL = Structured Query Language Standard query language for relational DBMSs History: Developed at IBM in late 70s 1 st standard: SQL-86 2 nd standard: SQL-92 3 rd standard: SQL-99 or SQL3, well over 1000 pages

644 views • 22 slides
The CQL Con*nuous Query Language: Seman*c Founda*ons and Query

The CQL Con*nuous Query Language: Seman*c Founda*ons and Query

The CQL Con*nuous Query Language: Seman*c Founda*ons and Query Execu*on Arvind Arasu, Shivnath Babu, Jennifer Widom Presented by: Young-Rae Kim

580 views • 44 slides
ENERGY PROCUREMENT FOR THE 21ST CENTURY E N E R G Y A U C T I O N E X C H A N G E Table of

ENERGY PROCUREMENT FOR THE 21ST CENTURY E N E R G Y A U C T I O N E X C H A N G E Table of

ENERGY PROCUREMENT FOR THE 21ST CENTURY E N E R G Y A U C T I O N E X C H A N G E Table of Contents (a) Deregulation: The Basics (b) Electricity 101 (c) Index vs. Fixed Rates (d) Mission (e) Problems With Selling And Procuring Energy

584 views • 27 slides
SQL Structured Query Language 1 Best known and most commonly used relational database query

SQL Structured Query Language 1 Best known and most commonly used relational database query

SQL Structured Query Language 1 Best known and most commonly used relational database query and manipulation language. Used in many commercial database systems. 2 SQL includes several components including: Data definition

723 views • 53 slides
Projected sea surface temperatures over the 21st century: changes in the mean, variability and

Projected sea surface temperatures over the 21st century: changes in the mean, variability and

Projected sea surface temperatures over the 21st century: changes in the mean, variability and extremes for large marine ecosystem regions of Northern Oceans. Michael Alexander NOAA/Earth System Research Laboratory Boulder, Colorado, USA

366 views • 14 slides
Project Based Learning: 21st Century Programs to Reinvent Learning and Achievement John McCarthy,

Project Based Learning: 21st Century Programs to Reinvent Learning and Achievement John McCarthy,

PBL: 21st Century Programs to Reinvent 12/12/2011 Learning and Achievement Project Based Learning: 21st Century Programs to Reinvent Learning and Achievement John McCarthy, Ed.S., Wayne RESA Susan Hardin, Macomb ISD & MACUL Chris Wigent,

482 views • 18 slides
Plant biotechnology: Plant biotechnology: a key technology in the 21st century a key technology

Plant biotechnology: Plant biotechnology: a key technology in the 21st century a key technology

Argentine- -Japan Work Shop Japan Work Shop Argentine Plant biotechnology: Plant biotechnology: a key technology in the 21st century a key technology in the 21st century August, 2009 Atsuhiko Shinmyo Nara Institute of Science and

643 views • 30 slides
Database Systems SQL Based on slides by Feifei Li, University of Utah The SQL Query Language n

Database Systems SQL Based on slides by Feifei Li, University of Utah The SQL Query Language n

Database Systems SQL Based on slides by Feifei Li, University of Utah The SQL Query Language n SQL stands for Structured Query Language n The most widely used relational query language. Current standard is SQL:2016 (actually there is a new

1.22k views • 97 slides

More recommend