Skip to content

A document that explains some need to know concepts regarding SQL using MS SQL Server.

License

Notifications You must be signed in to change notification settings

CliffCrerar/learn-transact-SQL-fundamentals

Repository files navigation

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