- 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-codefor bookmarking, requires login.- In app
Northwindinstance. - Query exercises.
RESOURCES: https://www.dofactory.com/sql/subquery