Create Articles: SQL and Relational Databases

[alayek]

This a rough sketch of the road-map for SQL and relational databases wiki articles.

• Introduction
  • Different types of relational databases
  • DDL, DML, DCL Basics
  • Getting Started with SQLite
  • Getting Started with PostgreSQL
  • Getting Started with MySQL
  • Getting Started with MS-SQL
  • Getting Started with Oracle SQL
  • Getting Started with Google Cloud SQL
  • Resources and References
• DDL Basics
  • CREATE Table
  • ALTER Table
  • DROP Table
  • TRUNCATE Table
  • COMMENT
• Database Keys and Relationships
  • Primary Key
  • Foreign Key
  • Candidate Key
  • Unique Key
  • Alternate Key
  • Composite Key
• DML Basics
  • SELECT
  • Asterisk and Column names
  • WHERE
    • WHERE Operators
    • NULL
  • ORDER BY
  • GROUP BY
  • HAVING
  • UPDATE
  • DELETE
  • LIMIT (MySQL or PostgreSQL) / TOP (MS SQL) / RowNum (Oracle SQL)
• TCL Basics
  • COMMIT
  • ROLLBACK
  • SET TRANSACTION
  • SAVEPOINT
• Table Joins
  • Table Aliases
  • INNER
  • LEFT OUTER
  • RIGHT OUTER
  • FULL
  • CROSS
• DDL Intermediate
  • Renaming Tables
  • Renaming Columns
  • Constraints
  • Views
• DML Intermediate
  • Column Aliases
  • Column Operations
  • Concatenating
  • CONVERT / CAST
  • Date Formatting
  • CASE Formatting
  • UPDATE with JOINs
  • DELETE with JOINs
  • WHERE vs AND in JOINs
• Programming SQL Basics
  • Variables
  • Functions
  • Stored Procedures
  • Variable Tables
  • SELECT INTO
  • IF Statements
• DDL Advanced
  • Index
  • Key and Indexing
  • Clustered
  • Non-clustered
  • Column Store
  • UDTs
  • Session / Global temp variables
• DML Advanced
  • Information Schema (ANSI)
  • Sys. Tables (MS-SQL)
  • Combining Information Schema / Sys. Tables
  • PIVOT
  • UNPIVOT
• Programming SQL Advanced
  • Cursors
  • Dynamic SQL
  • Scoping of Temp Tables
• DCL Basics
  • GRANT
  • REVOKE
• Programming Performance Tuning
  • Temp vs. Variable Tables
  • Parameters vs. Variables
  • Functions vs. Stored Procedures

This issue is prepared after discussion with @CaroleAnneHannon.

@koustuvsinha @Rafase282 @raisedadead FYI. Kindly check if I have missed something or if something is inconsistent.

[raisedadead]

LGTM @alayek But then I am not a DB expert

[Rafase282]

@CaroleAnneHannon I'm sure you will feel at home with these if you have the time and interest.

[dakshshah96]

I have a pretty strong idea about DDL Basics as well as DML Basics. Can I work on those? An example template would be great to know what the format of the page should be.

[alayek]

Hey @dakshshah96 sure! Pick whichever you would like and raise PR. If you need help, drop by our Wiki Room.

As for sample template, I am not sure. I had a talk with @CaroleAnneHannon earlier, and she said that we might want to provide some seed data at the beginning of the article (or articles, and refer to them in each article) so that users can run their DDL or DML code on that sample.

What would you suggest a good template would be?

[dakshshah96]

@alayek What prefix do you think should we use for all Database articles? Is this fine — Database-Topic-Name.md?

[alayek]

Yes, let's use that format for now.

[j7an]

Looking forward to the wiki. I'm interested in learning Oracle PL/SQL.