khajeddin.comPostgreSQL - TABLE OperationsIntro Lets review all of the Table-related functions in one place. Create tables in the database Top create a table in your database use the CREATE TABLE command. Here, we define the schema of a table. We create users table which has two attributes/f...Feb 1, 2024·6 min read
khajeddin.comSQL (Structured Query Language) IntroductionIn order to become familiar with SQL and SQL-based platforms, one have to gain basic knowledge about some of the basic concepts. Here I will list what seems to be to be important to know before jumping to learn any SQL-based platform. These concepts ...Jan 23, 2024·2 min read
khajeddin.comPostgreSQL BasicsInstall PostgreSQL on your system. you can find the installers for various platforms in this link. Difference between PSQL and SQL commands First of all, lets differentiate between PostgreSQL and SQL commands: Any command starting with backslash \ i...Jan 23, 2024·9 min read
khajeddin.comSimple notes to consider when creating a visualizationRecently I finished a specialization named "Data Visualization with Tableau Specialization" in Coursera, and I believe it was a very comprehensive review of what a person needs to know to start to work with Tableau and also design principles a person...Sep 4, 2023·3 min read
khajeddin.comSQL (Structured Query Language) Basic CommandsIn order to use SQL-based databases, one needs to become familiar with SQL clauses, keywords and queries. In this post we are going through some of the most basic SQL clauses and keywords using simple examples. SQL Comments: You can write comments in...Jun 11, 2023·2 min read
