Dogs Below is an example of a Dog class, and a launcher class that invokes methods from the Dog class. However, not all dogs are created equal, dogs may have different behaviors. public clas...

A Simple Java program The following program prints “Hello World!” Code in Java are all contained within classes. Blocks of code are sectioned out using braces { }. Lines a...

Aggregation So far, all SQL expressions have referred to values in a single row. Aggregation allows us to aggregate multiple rows together. Aggregation can be used in everywhere, bu...

%load_ext sql %config SqlMagic.style = '_DEPRECATED_DEFAULT' %sql sqlite:///cs61a.db Aggregation Aggregation functions can be used to perform aggregation over multiple rows. Simple SELECT st...

%load_ext sql %config SqlMagic.style = '_DEPRECATED_DEFAULT' %sql sqlite:///cs61a.db Joining Tables Queries may span over multiple tables, so we have to join multiple tables into one. ...

SELECT statements A SELECT statement specifies an input table using FROM [table] SELECT [columns] FROM [table] WHERE [condition] ORDER BY [order]; SELECT [expression] AS [name],...

%load_ext sql %config SqlMagic.style = '_DEPRECATED_DEFAULT' %sql sqlite:///cs61a.db The sql extension is already loaded. To reload it, use: %reload_ext sql Databases Database Management S...

Databases Database management systems (DBMS) contains tables with records, which are rows that have a value for each column. Every table has columns and rows A column has a name...

Macros Macros enable us to define new special forms within scheme. Macros perform code transformations. We describe how to take parts of a special form and construct a regular schem...

Quasiquotation We may extend Lisp as a language itself. We may change the language however we want. We may extend Scheme by adding more procedures to it, such as a for loop func...