forked from DarrellAucoin/IntroSQL
-
Notifications
You must be signed in to change notification settings - Fork 1
Install SQLite Browser
Darrell edited this page Feb 13, 2015
·
1 revision
#Installation of SQLite Browser
Download and install the file below
Download and install the package below
In terminal execute the following command
sudo apt-get install sqlitebrowser
Common SQL Commands
Using SQL within R
Quiz Solutions
Motivation
Different Implementations of SQL
##Theory
- Relational Databases
- The E-R Model
- E-R Relationships
- Normalization
- 1st Normalization
- 2nd Normalization
- 3rd Normalization
- Primary and Foreign Keys
- Relational Algebra Operations
- Constraints
##How to Query in SQL
- Data Types
- Projection (SELECT Clause)
- SQL Functions
- DISTINCT Prefix
- Aliases
- Selection (WHERE Clause)
- Predicate Operators
- LIKE Predicate
- ALL, ANY / SOME Operator Modifiers
- AND, OR Operators
- GROUP BY Clause (Aggregation)
- HAVING Clause (Filtering using Aggregation)
- Aggregate Functions
- GROUP BY with ROLLUP/CUBE
- Joining Tables
- CROSS JOIN
-
INNER JOIN
1. ON Clause - OUTER JOIN
- NATURAL JOIN
- Subqueries
- Non-Correlated Subqueries
- Correlated Subqueries
- Set Operations (Vertically Joining Tables)
- UNION
- INTERSECT
- Difference (EXCEPT)
- WITH Clause
- CASE Expressions
- ORDER BY Clause
- LIMIT Clause