Coding with Typo: Structured Query Language: (SQL) Part 2: Getting the Essentials

Structured Query Language: (SQL) Part 2: Getting the Essentials

Coding with Typo: Structured Query Language: (SQL) Part 2: Getting the Essentials

Hi

Message:

I said quite a while ago I needed a break, and it looks like that break is over, because here I am. I dont want to ramble on unnecessary things that doesn't need explanation. I needed time off to sort something out irl, and i'll be returning slowly but surely now.

now to the SQL

Getting the Essentials:

Many of you have been very excited this series, and despite the wait for the second part, I am now going to inform you on the things you need to know before we'll officially be doing the SQL coding.

First you'll need a place to practice your coding skills. Now, you have a few opportunites here. Because I know several places you can practice, and all of them have their own advantages, and dis-advantages.

1. You can download Notepad ++ which is an open source software, and it's basically the mother of Notepad built into every computer. It has every programming language available for you to code in, and it's free. A simple google search will show you there.

THE ADVANTAGES

  • You can code in a completely free software, which requires no internet access! (in case you should encounter an electricity problem)
  • It's easy to use and you can easily save your coding in any programming language you please. (assuming you've written the code in the given language)

DIS-ADVANTAGES

  • You can't see your progress live. What I mean here is, you wont be able to see if what your writing ís correct or in-correct. Which is why I wont recommend this option.

Because since this is a learning process, seeing your mistakes in order to fix them are crucial.

2. Sign up for Khan Academy. It's a free website where you can create your own template for SQL, and see your actual coding live as you're writing them. It's very easy and I have used it myself, and it is very effective. This I recommend indeed.

3. This is the most complicated one, and again doesn't provide you the option to see your coding live. You can sign up for a hosting provider, where you can then create an actual database.

I don't recommend this one though.

What I'll Be Covering:

I will show you the basic commands

SELECT
JOIN
WHERE
IF
OR
AND
CASE
DROP
ORDER BY
HAVING

and I might go over the more complex ones such as:

UPDATE
DELETE
UNION

My Thoughts on SQL:

I also want to give you my take on this programming language. Given the fact that I know several, and among the ones I know, I dont find SQL that difficult to use. I'll provide you with a reason for that.

I know the languages: SQL, HTML/CSS, Python and little C++ If you in the future want a HTML/CSS tutorial, i'll be willing to do that also, just let me know.

Reason

If you have seen how a coding script in SQL looks like, you'll see the complexity of SQL, and C++ for example, are very different. SQL is more, either this or that. Meaning your creativity within SQL are limited. But in C++ it's much more 'open' it is capable of understanding a more complicated code, and you're able to type more freely.

Also, because I know 4 programming languages, I can definitely vouche for that SQL in my opinion is easier to overcome.

I'll see you in the next tutorial where i'll be doing actual SQL coding

5 Comments

We're glad to have you back.

-Phoenix750

Maybe you can do the tutorial on MySQL? It's free and open source I guess. It will provide all the features. But it can get a little complex to install on a Linux system, telling from experience.

I'd recommend MySQL, rest is of course, up to you.
Good luck with the series.

Amazing Tutorial! You're awesome!

Share Your Thoughts

  • Hot
  • Latest