- This project started as a freeCodeCamp zip line for front a front end development certificate and has turned into a project to benefit the community.
- Before the content maintenance will continue, it is being migrated to another platform. Migrating from static html and css site to a docz site.
For existing site and for migration, once migration has been implemented and reviewed new document will be published.
Document item | Scoped | Migrated/drafted | Reviewed | Refined | Published | Improve |
---|---|---|---|---|---|---|
About | 1 | 1 | 0 | 0 | 0 | 0 |
Getting Started | 1 | 1 | 0 | 0 | 0 | 0 |
Creating the database demo | 1 | 1 | 0 | 0 | 0 | 1 |
Concepts and semantics | 1 | 1 | 0 | 0 | 0 | 0 |
Database objects | 1 | 1 | 0 | 0 | 0 | 1 |
Data types | 1 | complete tables | 0 | 0 | 0 | 1 |
Data query language | 1 | 1 | 0 | 0 | 0 | |
Data manipulation language | 1 | 1 | 0 | 0 | 0 | |
Logical operations | 1 | 0 | 0 | 0 | 0 | |
Query execution method | 1 | 1 | 0 | 0 | 0 | |
Reserved words | 1 | 0 | 0 | 0 | 0 | |
Using comments | 1 | 0 | 0 | 0 | 0 | |
Data definition language | 1 | 0 | 0 | 0 | 0 | |
Joining tables | 0 | 0 | 0 | 0 | 0 | |
Computation and Functions | 0 | 0 | 0 | 0 | 0 | |
Sub-queries | 0 | 0 | 0 | 0 | 0 | |
Transaction concurrency | 0 | 0 | 0 | 0 | 0 | |
Database views | 0 | 0 | 0 | 0 | 0 | |
Merging | 0 | 0 | 0 | 0 | 0 | |
Unions | 0 | 0 | 0 | 0 | 0 | |
Triggers | 0 | 0 | 0 | 0 | 0 | |
Declaring and using variables | 0 | 0 | 0 | 0 | 0 | |
Stored procedures | 0 | 0 | 0 | 0 | 0 | |
Common table expressions | 0 | 0 | 0 | 0 | 0 | |
Conditional operations (IF, CASE) | 0 | 0 | 0 | 0 | 0 | |
Loops | 0 | 0 | 0 | 0 | 0 | |
Importing data | 0 | 0 | 0 | 0 | 0 | |
Exporting data | 0 | 0 | 0 | 0 | 0 | |
Using backups | 0 | 0 | 0 | 0 | 0 | |
Advanced topics | 0 | 0 | 0 | 0 | 0 | |
Data modeling | 0 | 0 | 0 | 0 | 0 | |
Systems development life cycle | 0 | 0 | 0 | 0 | 0 | |
Additional resources | 0 | 0 | 0 | 0 | 0 | |
COPY TO CLIPBOARD: Demo section copy northwind database sql snippet to clipboard, display and download implemented.
- On front page briefly describe what is covered and what there is to learn
- Add a colum to data types tables to indicate conversion possibilities.
- Add a section to explain user time and system time.
CodeMirror-code
for bookmarking, requires login.- In app
Northwind
instance. - Query exercises.
RESOURCES: https://www.dofactory.com/sql/subquery