SQL Tutorial: How to Write Better Queries

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 
In this tutorial, you will learn about anti-patterns, execution plans, time complexity, query tuning, and optimization in SQL. First off, you’ll start with a short overview of the importance of learning SQL for jobs in data science, and next, you’ll first learn more about how SQL query processing and execution so that you can adequately understand the importance of writing qualitative queries: more specifically, you’ll see that the query is parsed, rewritten, optimized and finally evaluated. You’ll also learn more about the set-based versus the procedural approach to querying. You’ll briefly go more into time complexity and the big O notation to get an idea about the time complexity of an execution plan before you execute your query; Lastly, You'll briefly get some pointers on how you can tune your query further.

Terms for use of this information can be found at:https://www.datacamp.com/terms-of-use

Authoring Person(s) Name: 
Karlijn Willems
Authoring Organization(s) Name: 
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
More info about
Keywords - short phrases describing what the learning resource is about: 
Computer Science
Data access methods
Data conversion
Data management
Data skills education
Structured Query Language (SQL)
Published / Broadcast: 
Thursday, January 17, 2019
Publisher - organization credited with publishing or broadcasting the learning resource: 
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Interactive Resource - requires a user to take action or make a request in order for the content to be understood, executed or experienced.
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management or data skills.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Lesson - detailed description of an element of instruction in a course, [could be] contained in a unit of one or more lessons, and used by a teacher to guide class instruction. Example: presentation slides on a topic.
Target Audience - intended audience for which the learning resource was created: 
Citizen scientist
Data professional
Graduate student
Mid-career research scientist
Software engineer
Technology expert group
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
Up to 1 hour