edit-task
Home
Up
Delete
Task Name:
Task Description:
] including ] Collection-sql-articles ] LIST-skills-sql
TaskGroup ID:
Start Date:
Start Time:
Duration:
Priority:
Status:
To Do
Completed
In Process
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center;">CREATE-list# #</h1> <h2>[previously]</h2> <ol> <li><strong>[2017-04-12][00:00] NEW task IN ?</strong></li> <ol> <li>] # # - CREATE-article# # </li> </ol> <li><strong>[00:00] NEW article IN db-tech-dev/ ?ana ? research </strong></li> <ol> <li>] # # - LIST-skills-sql - a listing of frequently used sql skills</li> </ol> <li><strong>[00:00] NEW article IN tech-dev-db/research/index</strong> </li> <ol> <li>] # 5686 - sql-reference - article collection of various resources for learning how to create, use, design, ..., better SQL databases</li> <li>x] # 5686- <a href="/view/article?id=5686" target="_blank">COLLECTION-SQL-REFERENCE</a> - a collection of articles related to learning and using SQL. - REFERENCE - </li> </ol> <li><strong>[00:00] NEW task IN </strong></li> <ol> <li>x] # 7266 - CREATE-article# # - postgres overview - listing of articles to use as reference for postgres</li> </ol> <li><strong>[2017-04-26]>[00:00] UPDATE article </strong></li> <ol> <li>x] # # - <a href="/view/article?id=5686" target="_blank">COLLECTION-SQL-best-of-2016</a>, x] add sum article(8/8), i] add links(2/10) to art comments, i] add dates(3/8)</li> </ol></ol> <h2>[currently]</h2> <ol> <li><strong>] WORKBENCH</strong></li> <ol> <li>] CREATE connection </li> <li>] reverse engineer database schema </li> <li>] forward engineer database schema</li> <li>] schema document </li> </ol> <li><strong>] DDL</strong></li> <ol> <li>] CREATE schema</li> <li>] CREATE Table</li> <li>] ALTER Table</li> <li>] CREATE Index</li> <li>] CREATE VIEW</li> <li>] ...</li> </ol> <li><strong>] DML </strong></li> <ol> <li>] SELECT - the list of table fields(columns) that will be returned in the query result , use * to return all fields in a table</li> <ol> <li>] SELECT DISTINCT - </li> <li>] SELECT AS - </li> <li>] SELECT INTO - </li> <li>] SELECT count(*)</li> </ol> <li>] FROM - the name of the table* where the feilds will come from, </li> <ol> <li>] *FROM can be a query instead of a table, </li> <li>] example = FROM employees </li> </ol> <li>] WHERE - the condition(s) that the records must meet in order to be included for selection in the result set</li> <ol> <li>] example = WHERE employee.ID = '1234' </li> </ol> <li>] JOIN - is the statement you use to connect aka join information from multiple tables into a single table, </li> <ol> <li>] example = employees join skills/roles/positions on employee.skillID = skills.ID</li> </ol> <li>] HAVING - The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.</li> <ol> <li>] example = HAVING COUNT(ID) > 5;</li> <li>] REF https://www.w3schools.com/sql/sql_having.asp </li> </ol> <li>] GROUP BY </li> <ol> <li>]</li> </ol> <li>] ORDER BY - order the returned records by the </li> <ol> <li>] ORDER by </li> </ol> <li>] INSERT INTO table VALUES(v1,v2,...)</li> <li>] UPDATE fieldnameEXage SET WHERE user_id = 1234 </li> <li>] DELETE </li> <li>] subqueries</li> <li>] nested subqueries</li> <li>] FUNCTIONS-aggregate</li> <li>] stored procedures</li> <li>] transactions</li> <li>] window functions (postgres) </li> <li>] run( SCRIPT, function) </li> <li>] VIEWS </li> <li>] </li> </ol> <li><strong>] OTHER</strong></li> <ol> <li>] normalization </li> <li>] relationships </li> <li>] </li> </ol></ol> <h2>[next]</h2> <ol> <li><strong>>[00:00] NEW task IN </strong></li> <ol> <li>] # # - SQL quiz - @w3schools, 25/25, 8 minutes, very basic</li> <li>] # # - SQL interview questions -, toptal, https://www.toptal.com/sql/interview-questions</li> <li>] cover letter snippet - quicky/quirky sql test - </li> </ol> <li><strong>[00:00] NEW task IN ] hn.aloglia?='sql' </strong><strong>] this.year = </strong></li> <ol> <li>*] CC article collection # 5686 for top ranking aritcles </li> </ol> <li><strong>[00:00] NEW task IN ] hn.aloglia?='sql' </strong><strong>] </strong><strong>all time</strong></li> <ol> <li>x] <a href="http://www.slideshare.net/MarkusWinand/modern-sql" target="_blank">Modern SQL in PostgreSQL</a> (slides, 2015) + SITE = http://modern-sql.com/</li> <li>] <a href="http://cs-blog.khanacademy.org/2015/05/just-released-full-introductory-sql.html" target="_blank">Learn SQL Interactively on Khan Academy</a> (2015) </li> <li>] <a href="https://sqlite.org/whentouse.html" target="_blank">Appropriate Uses for SQLite</a> </li> <li>] <a href="https://www.compose.io/articles/what-postgresql-has-over-other-open-source-sql-databases-part-ii/" target="_blank">What PostgreSQL has over other open source SQL databases: Part II</a></li> <li>] <a href="http://rob.conery.io/2015/02/24/embracing-sql-in-postgres/" target="_blank">Embracing SQL in Postgres</a></li> <li>] <a href="http://tech.pro/tutorial/1555/10-easy-steps-to-a-complete-understanding-of-sql" target="_blank">Easy Steps to a Complete Understanding of SQL</a> (link broken) - https://news.ycombinator.com/item?id=6319870</li> <li>] <a href="http://citusdata.com/blog/90-sql-scaling-and-whats-unique-about-postgres" target="_blank">SQL, Scaling, and What's Unique About Postgres</a> </li> </ol> <li><strong>[00:00] NEW task IN </strong>] bohn-review?=sql</li> <ol> <li>] 2017-03 - ... - 2016-11, result = 12</li> <li><strong>x] writing more legible sql, </strong></li> <li>] SQL server on linux, </li> <li>] postgresSQL anti patterns, </li> <li>] postgresSQL inheiritance,</li> <li><strong>x] best online resource to learn advanced SQL, 2017-01-17</strong></li> <li><strong>] rethinkDB vs PostgreSql,2017-02-08</strong></li> <li>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 </li> <li>] postgreSQL good enough</li> </ol> <li><strong>[00:00] NEW task IN ] + = </strong></li> <ol> <li>] mysql V postgresSQL, BB rem </li> </ol></ol>