task

CREATE-list# #

[previously]

  1. [2017-04-12][00:00] NEW task IN ?
    1. ] # # - CREATE-article# # 
  2. [00:00] NEW article IN db-tech-dev/ ?ana ? research 
    1. ] # # - LIST-skills-sql - a listing of frequently used sql skills
  3. [00:00] NEW article IN tech-dev-db/research/index 
    1. ] # 5686 - sql-reference - article collection of various resources for learning how to create, use, design, ..., better SQL databases
    2. x] # 5686- COLLECTION-SQL-REFERENCE - a collection of articles related to learning and using SQL.  - REFERENCE - 
  4. [00:00] NEW task IN 
    1. x] # 7266 - CREATE-article# # - postgres overview - listing of articles to use as reference for postgres
  5. [2017-04-26]>[00:00] UPDATE article 
    1. x] # # - COLLECTION-SQL-best-of-2016, x] add sum article(8/8), i] add links(2/10) to art comments, i] add dates(3/8)

[currently]

  1. ] WORKBENCH
    1. ] CREATE connection 
    2. ] reverse engineer database schema 
    3. ] forward engineer database schema
    4. ] schema document 
  2. ] DDL
    1. ] CREATE schema
    2. ] CREATE Table
    3. ] ALTER Table
    4. ] CREATE Index
    5. ] CREATE VIEW
    6. ] ...
  3. ] DML 
    1. ] SELECT - the list of table fields(columns) that will be returned in the query result , use * to return all fields in a table
      1. ] SELECT DISTINCT - 
      2. ] SELECT AS - 
      3. ] SELECT INTO - 
      4. ] SELECT count(*)
    2. ] FROM - the name of the table* where the feilds will come from, 
      1. ] *FROM can be a query instead of a table, 
      2. ] example = FROM employees 
    3. ] WHERE - the condition(s) that the records must meet in order to be included for selection in the result set
      1. ] example = WHERE employee.ID = '1234' 
    4. ] JOIN  - is the statement you use to connect aka join information from multiple tables into a single table, 
      1. ] example = employees join skills/roles/positions on employee.skillID = skills.ID
    5. ] HAVING - The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.
      1. ] example = HAVING COUNT(ID) > 5;
      2. ] REF https://www.w3schools.com/sql/sql_having.asp 
    6. ] GROUP BY 
      1. ]
    7. ] ORDER BY - order the returned records by the 
      1. ] ORDER by 
    8. ] INSERT INTO table VALUES(v1,v2,...)
    9. ] UPDATE fieldnameEXage SET WHERE user_id = 1234 
    10. ] DELETE 
    11. ] subqueries
    12. ] nested subqueries
    13. ] FUNCTIONS-aggregate
    14. ] stored procedures
    15. ] transactions
    16. ] window functions (postgres) 
    17. ] run( SCRIPT, function) 
    18. ] VIEWS 
    19. ] 
  4. ] OTHER
    1. ] normalization 
    2. ] relationships 
    3. ] 

[next]

  1. >[00:00] NEW task IN 
    1. ] # # - SQL quiz - @w3schools, 25/25, 8 minutes, very basic
    2. ] # # - SQL interview questions -, toptal, https://www.toptal.com/sql/interview-questions
    3. ] cover letter snippet - quicky/quirky sql test - 
  2. [00:00] NEW task IN ] hn.aloglia?='sql' ] this.year = 
    1. *] CC article collection # 5686 for top ranking aritcles 
  3. [00:00] NEW task IN ] hn.aloglia?='sql' ] all time
    1. x] Modern SQL in PostgreSQL (slides, 2015) + SITE = http://modern-sql.com/
    2. ] Learn SQL Interactively on Khan Academy (2015) 
    3. ] Appropriate Uses for SQLite 
    4. ] What PostgreSQL has over other open source SQL databases: Part II
    5. ] Embracing SQL in Postgres
    6. ] Easy Steps to a Complete Understanding of SQL (link broken) - https://news.ycombinator.com/item?id=6319870
    7. ] SQL, Scaling, and What's Unique About Postgres 
  4. [00:00] NEW task IN ] bohn-review?=sql
    1. ] 2017-03 - ... - 2016-11, result = 12
    2. x] writing more legible sql, 
    3. ] SQL server on linux, 
    4. ] postgresSQL anti patterns, 
    5. ] postgresSQL inheiritance,
    6. x] best online resource to learn advanced SQL, 2017-01-17
    7. ] rethinkDB vs PostgreSql,2017-02-08
    8. x] 7 things developers should know about sql server, 2017-02-11 - ] by Brent Ozzar - Ozzar an industry consultant, offers up a handful of tips for use with msfts mssql rbdms 
    9. ]  postgreSQL good enough
  5. [00:00] NEW task IN ] + = 
    1. ] mysql V postgresSQL, BB rem 
Details Photos Edit more

Details

ID: 7228

NAME: CREATE-list-sql

DESCRIPTION: ] including ] Collection-sql-articles ] LIST-skills-sql

START DATE TIME: 2017-04-12 20:35:29

EST DURATION: 01:00:00

END DATE TIME: 2017-04-12 21:35:29

STATUS: To-Do

PRIORITY: -5

OWNER ID: 1

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities