Relational Algebra Sql Cheat Sheet



Weekly Course Materials

Relational Algebra Sql Cheat Sheet

Relational Algebra Sql Cheat Sheet Free

WeekMaterialsNotes
1
  • Chapter 1
2
  • Chapter 3
3
    Materials from previous week used.
  • Chapter 3
4
  • MS Powerpoint: SQL Practice 1
  • PDF Format: SQL Practice 1
5
  • Chapter 4
6
    Materials from previous week used.
  • Chapter 4
7
  • MS Powerpoint: SQL Practice 2
  • PDF Format: SQL Practice 2
  • Homework 1
8
  • Chapter 5
9
  • Chapter 2
10
  • Chapter 6
11Midterm Exam on Nov 4 at 3:30 PM - 4:45 PM
12
    Wednesday, 11/11 - No Classes
    Veterans' Day
13
  • Chapter 7
14
  • Chapter 14
Sheet

Project Team Members

Team numberTeam memberDemo Date
#1
  • Andrew Takemoto
  • Ronald Reyes
  • Roderick Montgomery
    Friday, 12/4 at 6:00 PM
#2
  • Jonathan Lacanlale
  • Armineh Karamian
  • Josue Vega
    Wednesday, 12/2 at 4:30 PM
#3
  • Nicolas Martinez
  • Javier Aguayo
  • Omid Arian
    Wednesday, 12/2 at 2:00 PM
#4
  • Muhammad Hayat
  • Osmar Herrera
  • Austin Lucky
    Friday, 12/4 at 7:30 PM
#5
  • Bryan Rodriguez
  • Young Jin Seo
  • Zhen Sun
    Wednesday, 12/2 at 3:00 PM
#6
  • Cindy Navarrete
  • Ben La France
  • Kavya Dhyasani
    Thursday, 12/3 at 4:00 PM
#7
  • Auhbon Amiri
  • Charleigh McCone
  • Aaron Tiania
    Thursday, 12/3 at 6:30 PM
#8
  • Max Bogatyrov
  • Bayron Pineda
  • Samoel Molhempour
    Wednesday, 12/2 at 2:30 PM
#9
  • Marja Centina
  • Aishwarya Nerlekar
  • Matthew Estes
    Friday, 12/4 at 3:00 PM
#10
  • Ravi Archana
  • Rudri Oza
  • Brian Mcclelland
    Friday, 12/4 at 4:15 PM
#11
  • Kate Go
  • Nick Korpinen
  • Late'jah Whittaker
    Friday, 12/4 at 5:00 PM

Relational Algebra Sql Cheat Sheet Pdf

Core Relational Algebra Union, intersection, and difference. Usual set operations, but both operands must have the same relation schema. Selection: picking certain rows. Projection: picking certain columns. Products and joins: compositions of relations. Renaming of relations and attributes. MS Powerpoint: SQL Practice 2; PDF Format: SQL Practice 2; Database for SQL Practice; SQL Cheat Sheet; Homework 1; 8: Advanced SQL; Chapter 5; 9: Relational Algebra; Chapter 2; 10: Database Design - ER Diagram; ER Case Study; Chapter 6; 11: Exam Review (Chapters 1 - 5) Midterm Exam on Nov 4 at 3:30 PM - 4:45 PM: 12: Transfer ER to Relational Schema. CS2102 Final Examination Cheat-sheet Part 1 Relational Algebra Relational algebra operators: 1. Unary operators: selection σ, projection ρ, renaming π; 2) Binary operators: union, intersect ∩, difference ―, cross-product ×, natural join, inner join, left outer join, left semi-join, left anti-join. Part 2 SQL Language 1.





Comments are closed.