In a previous post i discussed about Database Management Systems, there are very famous commercial and non-commercial DBMS’s available on the internet that you can easily download, and some of those DBMS’s need zero SQL knowledge for working on it. however, if you are a software developer or a Database Administrator then you must have a good knowledge in SQL.
SQL stands for Structured Query Language, and it is easier to learn than any programming languages out there (so remember that SQL is not a general purpose programming language like JAVA,C,PYTHON etc) , there are no syntax’s and even it is not case sensitive( you can type its commands either in simple letters or capital letters- BUT NORMALLY WE WRITE CAPITAL LETTERS). Almost all the commands in SQL are simple English words( Ex: WHERE, CREATE, INSERT, ALTER) which are easy to remember.most importantly SQL is a non procedural query language (you only specify what information you require rather than how to get it).
why you should learn SQL?
Learning SQL is the easiest way to understand all the concepts behind computerized databases, after learning SQL you will have enough knowledge in developing your own database. if you are a learner who is learning about developing Computerized Databases then the best position to start your learning is from SQL. why SQL is that the easiness of its commands and the core structure behind it ( SQL can be used to create almost all the types of databases) , since it is a non-procedural language, even ordinary people who have a basic knowledge in IT can use it.
how to start learning SQL
To learn SQL, you have to create, manipulate and share sample databases in your computer by using SQL statements. So, first you should download a DBMS software package( a simple IDE to run your SQL statements) into your computer.
As a beginner it is better to use PostgreSQL as your first DBMS.
what is PostgreSQL
PostgreSQL is a powerful, open source object-relational database system (RDBMS) that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.
PostgreSQL is not controlled by any single corparation but it has its own online community to develop its core functions, so the source code is available free of charge. PostgreSQL (or simply Postgres) did not support for SQL until 1994, but now it is the most common one for SQL.
without reading too much let’s download and install Postgres into your machine
windows 10 installation
Ubuntu installation
commands for downloading PSQL on Ubuntu
Here we install postgresql package and –contrib package to add additional utilities and functionalities.
sudo apt-get update
sudo apt install postgresql postgresql-contrib unfortunately i am not a Mac user, so all you mac users just feel free to search on the internet how to download and install Postgres on your Mac OS.
in next post, you will learn how to write your first SQL statement on PSQL shell .
Useful links
https://www.techopedia.com/definition/3499/postgresql
https://www.postgresql.org/about/
PostgreSQL community
https://www.postgresql.org/community/
PostgreSQL books
https://www.postgresql.org/docs/books/
Your brain is a database, almost all the experiences that you have got and all the things that you have learnt are stored in this database, you retrieve those things as data and process them in order to memorize something.
logic behind the code 