article

COLLECTION - SQL - best-of-2016

[WHAT]

1. ] by Don Sagrott, founder @ sospep.com - a collection of of articles related to learning and using SQL. 

[WHY]

1. ] 

[WHERE] 

1. ] READ THE FULL ARTICLE
1. ] see the EXAMPLE section below - 

[WHEN]

1. ] 2017-04-13

[EXAMPLE]

1. [x] A beginners guide to thinking in SQL
1. ] by - __ - explaining some of the basic of using SQL to query a database for data.
2. [x] Writing more legible SQL 
1. ] by Craig Kerstiens - A number of times in a crowd I’ve asked how many people enjoy writing SQL, and often there’s a person or two. The follow up is how many people enjoy reading other people’s SQL and that’s unanimously 0. The reason for this is that so many people write bad SQL. It’s not that it doesn’t do the job, it’s just that people don’t tend to treat SQL the same as other languages and don’t follow strong code formatting guidelines. So, of course here’s some of my own recommendations on how to make SQL more readable.
3. [2016-10-09] SQL style guide (+257) comments (#146)
1. ] Do's and Dont's for database design, includes db naming convention guidelines for db's, table names, feildnames, etc
4. [2016-04-25] SQL Tricks (+182) comments (#41)
1. ] by Lucas Eder - 10 SQL tricks you didnt think were possible - aka some cool stuff here that is available in most oss RDBMS (except mysql) ] everything is a table, ] data generation with recursive sql, ] running total calculations, ] finding the largest series with no gaps, ] ...
5. [x] Ask HN: What is the best online resource to learn advanced SQL? 
1. *] you can mine the comments section of this post to get a wealth of top notch SQL resources including ... 
2. ] EXAMPLE - http://use-the-index-luke.com/sql/preface 
6. [x] What ORMs have taught me: just learn SQL (2014)
1. ] byGeoff Wozniak -  I've come to the conclusion that, for me, ORMs are more detriment than benefit. In short, they can be used to nicely augment working with SQL in a program, but they should not replace it. 
2. ] I've found myself thinking about the database as just another data type that has an API: the queries.  The queries return values of some type, which are represented as some object in the program. By moving away from thinking of the objects in my application as something to be stored in a database (the raison d'être for ORMs) and instead thinking of the database as a (large and complex) data type, I've found working with a database from an application to be much simpler. And wondering why I didn't see it earlier.
3. ] Regardless of whether I find that stored procedures aren't actually that evil or whether I keep using templated SQL, I do know one thing: I won't fall into the "ORMs make it easy" trap. They are an acceptable way to represent a data definition, but a poor way to write queries and a bad way to store object state. If you're using an RDBMS, bite the bullet and learn SQL.
7. [] We’re pretty happy with SQLite and not urgently interested in a fancier DBMS - 
1. ] by @beets - developer explains why in the case of his application, staying with a simple easy to use flatfile database like SQLite is better than moving to a full fledged RDBMs.
8. [2017-02-11] 7 things developers should know about SQL Server 
1. ] by Brent Ozar - Ozar an industry consultant, offers up a handful of tips for use with msfts mssql rbdms including don't use ORDER BY 

[HOW-TO]

1. ]

[REFERENCE]

1. ] # 7228 - CREATE-article# 5686 (this) 
2. ] SRC = HN.algolia?='sql',  

[RELATED]

Details

ID: 5686

NAME: sql-reference

DESCRIPTION: ] sql reference - article collection of various resources for learning how to create, use, design, ..., better SQL databases

AUTHOR: article.author/s

EDITOR: article.editor/s

PUBLISHER: article.publisher/s

STATUS: Write

PRIORITY: -5

OWNER ID: 75

photos

actions

Email Email-Owner SMS and