'Frequents drinker' diaporamas de présentation

Introduction to SQL

690 views • 61 slides

Databases 1

Databases 1. Third lecture. More SQL. Relations as Bags Grouping and Aggregation Database Modification. Reminder: SQL basic statement. The principal form of a query is: SELECT desired attributes FROM one or more tables WHERE condition about tuples of the tables.

516 views • 45 slides

More SQL

More SQL. Relations as Bags Grouping and Aggregation Database Modification. Union, Intersection, and Difference. Union, intersection, and difference of relations are expressed by the following forms, each involving subqueries: ( subquery ) UNION ( subquery )

579 views • 44 slides

CS145 Introduction

CS145 Introduction. About CS145 Relational Model, Schemas, SQL Semistructured Model, XML. Content of CS145. Design of databases. E/R model, relational model, semistructured model, XML, UML, ODL. Database programming. SQL, XPath, XQuery, Relational algebra, Datalog.

615 views • 42 slides

Union, Intersection, Difference

592 views • 17 slides