Channels ▼
RSS

Embedded Systems

Don't Be Afraid Of Learning SQL


Essential SQL has launched as an entirely free series dedicated to Learning SQL. The brainchild of Kris Wenzel, the site is passionate about helping "non-techie" people to overcome their fear of learning SQL.

Wenzel says he is trying to reach people that don't have a software development background, yet need to work with information.

"I've found over the years there are many tools being used by folks in IT, HR, and finance that rely heavily on databases — yet most users are held captive to pre-canned dashboards and reports that answer 80% of the problem, but don't take them all the way. Yet, if they knew some SQL, they could further tap into their data to achieve their goals," he said.

It is not too bold a suggestion, he says, to think that there might also be some developers that could really use some SQL training as well. He says that although SQL isn't hard to learn, it can be very difficult to know where to start, and the learning curve can be quite steep. "I want to create a community where anyone feels comfortable asking questions and is comfortable spending time on lessons, knowing what they are learning is relevant, not esoteric."

The foundation of this website is a series of lessons that are still developing. One lesson a week is released and the lessons are written in a conversational style and supplemented with approximately 15 minutes of video. Wenzel tries to shoot for three to four segments of 5 minutes each with a conversational style where people are encouraged to ask questions. Right now the lessons mainly focus on basic standard SQL using SQLite (which is simple to install and can run on both Windows and Apple OSx).

Wenzel has a degree in Computer Engineering from the University of Michigan. He had theoretical database training in college, but really didn't get started with SQL until around 1995.

"I have experience designing and developing databases in both Oracle and MS SQL Server. When I'm not working full time as a DB Manager, I'm usually coding in C# or learning more about MS SQL Server," he said.


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Video