Sharing my experiences and initial impression on learning SQL.
Even though, it was my first time learning SQL and its actual Queries (the first two classes were introductory classes and thus were boring for me), it convinced me enough that learning SQL isn’t too hard for newbies compared to general purpose programming languages like C/C++, Java, etc.
My conviction was further increased when I read about it on the internet. So, I am going to highlight the reasons on why learning SQL seem easy to me.
My experience with learning SQL
I came to this conclusion for the following reasons:
1) Separation of church and state
RDBMS is separated from SQL; you do not need to learn about the inner details of RDBMS in order to learn SQL. Most SQL code is portable across different RDBMS.
2) Writing SQL queries is similar to writing pseudo-code
SQL is very declarative unlike most procedural programming languages (C/C++, Java, etc.). You can just throw a bunch of keywords and expect good things to happen! Consider the following SQL query:
SELECT * FROM Customers
It’s pretty obvious from the code that we are asking for a table with name of Customers who lives in America.
3) Tables are ubiquitous
You can play with predefined tables; you do not need to learn about tables / schemas and their different formats. Most RDBMS also supports reading / writing Microsoft Excel files.
Overall, I find SQL very easy to learn because of its eloquent syntax, although I felt a bit lack of intuition in its syntax considering it was initially developed in the 70s. I will be updating on my journey to learn SQL, so stay tuned!