Learn Transact-SQL fundamentals

Where it started

• 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.

What is happening with it now

• Before the content maintenance will continue, it is being migrated to another platform. Migrating from static html and css site to a docz site.

Roadmap

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

Parked migration tasks:

To come back to later

​ COPY TO CLIPBOARD: Demo section copy northwind database sql snippet to clipboard, display and download implemented.

TODO (other):

• On front page briefly describe what is covered and what there is to learn

Improvement ideas:

• 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