Getting into SQL

Published September 18th, 2014
Category Blog, Code, SQL


Time to dive in! I want to learn something I have very little prior knowledge in, namely SQL. My point of view when it comes to education is the “head below water” principal (or in other words: challenge accepted). There are few better ways of learning for me than to dig in and simply do.

I’m doing this for the simple reason of wanting to understand and broaden my knowledge. I currently have a limited understanding of SQL, though I do have a wide knowledge of languages such as HTML, CSS, Javascript, PHP and jQuery. I am hoping that some of this knowledge can help me understand and learn SQL.

As far as books and resources goes I’m mainly using Learning SQL The Hard Way (based on SQLite3), which so far is a brilliant resource when it comes to my preference in education. Tasks are split into practical segments where you gradually learn the language, after each exercise you’re also introduced to optional questions. Solving these optional questions is definitely recommended as you get an even better understanding of why each exercise is done.

SQL is widely accepted and used in big data storage. It is a language that is used in systems to store, manipulate and query large amounts of data in a simple manner, essentially it is purely a database language.

SQL (/ˈɛs kjuː ˈɛl/,[4] or /ˈskwəl/; Structured Query Language[5][6][7][8]) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS).

Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The scope of SQL includes data insert, query, update and delete, schemacreation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements.

From http://en.wikipedia.org/wiki/SQL

Feel free to add comments, ask questions and share your experiences with SQL. However big or small the advice, question, or discussion is I will partake in whatever way I can and hopefully we can get better together!

 

Resources (link opens in new tab)



  • I’ve gone through the first two exercises in LSQLTHW, thought I’d share some start up quirks.

    Windows users (I use Win7): You’ll want to bring up Windows command line and “cd” into the directory containing the SQLite3 executable. Enter “sqlite3 test.db” from there, this will then bring you into sqlite. To my experience creating new databases is best done by entering “.open name.db” where name is your chosen name (while being inside sqlite in the command line).