CS-1j: Introductory Programming in Java
Managing Information in a Database using SQL
Lessons in SQL programming:
The Relational Database:
Intro to SQL:
Linking information in multiple relations (
join
):
The
tuple conditions
in SQL's
where
clause:
Set functions in SQL:
Statistical analysis on data using SQL (
group by
):
The
group conditions
in SQL's
having
clause:
Accessing a SQL database using Programming Languages (Java and Python):
Check out beekeeper-studio to connect to DB