(public).sospep.events ~ view task ~ CREATE-list-sql

<h1 style="text-align: center;">CREATE-list# #</h1>
<h2>[previously]</h2>
<ol>
<li>[2017-04-12][00:00] NEW task IN ?</li>
<ol>
<li>] # # - CREATE-article# #&nbsp;</li>
</ol>
<li>[00:00] NEW article IN db-tech-dev/ ?ana ? research&nbsp;</li>
<ol>
<li>] # # - LIST-skills-sql - a listing of frequently used sql skills</li>
</ol>
<li>[00:00] NEW article IN tech-dev-db/research/index&nbsp;</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-&nbsp;<a href="/view/article?id=5686" target="_blank">COLLECTION-SQL-REFERENCE</a>&nbsp;- a collection of articles related to learning and using SQL. &nbsp;- REFERENCE -&nbsp;</li>
</ol>
<li>[00:00] NEW task IN&nbsp;</li>
<ol>
<li>x] # 7266 - CREATE-article# # - postgres overview - listing of articles to use as reference for postgres</li>
</ol>
<li>[2017-04-26]&gt;[00:00] UPDATE article&nbsp;</li>
<ol>
<li>x] # # -&nbsp;<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>] WORKBENCH</li>
<ol>
<li>] CREATE connection&nbsp;</li>
<li>] reverse engineer database schema&nbsp;</li>
<li>] forward engineer database schema</li>
<li>] schema document&nbsp;</li>
</ol>
<li>] DDL</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>] DML&nbsp;</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 -&nbsp;</li>
<li>] SELECT AS -&nbsp;</li>
<li>] SELECT INTO -&nbsp;</li>
<li>] SELECT count(*)</li>
</ol>
<li>] FROM - the name of the table* where the feilds will come from,&nbsp;</li>
<ol>
<li>] *FROM can be a query instead of a table,&nbsp;</li>
<li>] example = FROM employees&nbsp;</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'&nbsp;</li>
</ol>
<li>] JOIN &nbsp;- is the statement you use to connect aka join information from multiple tables into a single table,&nbsp;</li>
<ol>
<li>] example = employees join skills/roles/positions on employee.skillID = skills.ID</li>
</ol>
<li>] HAVING -&nbsp;The HAVING clause was added to SQL because the WHERE keyword could not be used with aggregate functions.</li>
<ol>
<li>] example =&nbsp;HAVING COUNT(ID) &gt; 5;</li>
<li>] REF https://www.w3schools.com/sql/sql_having.asp&nbsp;</li>
</ol>
<li>] GROUP BY&nbsp;</li>
<ol>
<li>]</li>
</ol>
<li>] ORDER BY - order the returned records by the&nbsp;</li>
<ol>
<li>] ORDER by&nbsp;</li>
</ol>
<li>] INSERT INTO table VALUES(v1,v2,...)</li>
<li>] UPDATE fieldnameEXage SET WHERE user_id = 1234&nbsp;</li>
<li>] DELETE&nbsp;</li>
<li>] subqueries</li>
<li>] nested subqueries</li>
<li>] FUNCTIONS-aggregate</li>
<li>] stored procedures</li>
<li>] transactions</li>
<li>] window functions (postgres)&nbsp;</li>
<li>] run(&nbsp;SCRIPT, function)&nbsp;</li>
<li>] VIEWS&nbsp;</li>
<li>]&nbsp;</li>
</ol>
<li>] OTHER</li>
<ol>
<li>] normalization&nbsp;</li>
<li>] relationships&nbsp;</li>
<li>]&nbsp;</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li>&gt;[00:00] NEW task IN&nbsp;</li>
<ol>
<li>] # # - SQL quiz - @w3schools, 25/25, 8 minutes, very basic</li>
<li>] # # - SQL interview questions -, toptal,&nbsp;https://www.toptal.com/sql/interview-questions</li>
<li>] cover letter snippet - quicky/quirky sql test -&nbsp;</li>
</ol>
<li>[00:00] NEW task IN ] hn.aloglia?='sql'&nbsp;] this.year =&nbsp;</li>
<ol>
<li>*] CC article collection # 5686 for top ranking aritcles&nbsp;</li>
</ol>
<li>[00:00] NEW task IN ] hn.aloglia?='sql'&nbsp;]&nbsp;all time</li>
<ol>
<li>x]&nbsp;<a href="http://www.slideshare.net/MarkusWinand/modern-sql" target="_blank">Modern&nbsp;SQL&nbsp;in PostgreSQL</a>&nbsp;(slides, 2015) + SITE =&nbsp;http://modern-sql.com/</li>
<li>]&nbsp;<a href="http://cs-blog.khanacademy.org/2015/05/just-released-full-introductory-sql.html" target="_blank">Learn&nbsp;SQL&nbsp;Interactively on Khan Academy</a>&nbsp;(2015)&nbsp;</li>
<li>]&nbsp;<a href="https://sqlite.org/whentouse.html" target="_blank">Appropriate Uses for&nbsp;SQLite</a>&nbsp;</li>
<li>]&nbsp;<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&nbsp;SQL&nbsp;databases: Part II</a></li>
<li>]&nbsp;<a href="http://rob.conery.io/2015/02/24/embracing-sql-in-postgres/" target="_blank">Embracing&nbsp;SQL&nbsp;in Postgres</a></li>
<li>]&nbsp;<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&nbsp;SQL</a>&nbsp;(link broken)&nbsp;- https://news.ycombinator.com/item?id=6319870</li>
<li>]&nbsp;<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>&nbsp;</li>
</ol>
<li>[00:00] NEW task IN&nbsp;] bohn-review?=sql</li>
<ol>
<li>] 2017-03 - ... - 2016-11, result = 12</li>
<li>x] writing more legible sql,&nbsp;</li>
<li>] SQL server on linux,&nbsp;</li>
<li>] postgresSQL anti patterns,&nbsp;</li>
<li>] postgresSQL inheiritance,</li>
<li>x] best online resource to learn advanced SQL, 2017-01-17</li>
<li>] rethinkDB vs PostgreSql,2017-02-08</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&nbsp;</li>
<li>] &nbsp;postgreSQL good enough</li>
</ol>
<li>[00:00] NEW task IN&nbsp;] + =&nbsp;</li>
<ol>
<li>] mysql V postgresSQL, BB rem&nbsp;</li>
</ol></ol>

~ view task ~ TaskGroup] any-all-db FROM [ Plan] plan IN [ calendars] technology-developer-db