Console.john (@consistentfolk) header
Console.john (@consistentfolk) profile picture

Learning JavaScript

Nigeria
Joined March 2025
Replying to @simply_mauve
Guyyyyyyyyyyyy
1
110
The ⁠.concat()⁠ method in JavaScript lets me seamlessly merge two or more arrays without mutating the originals. #JavaScript #webdev
3
46
Mercor is always serving me hot hot! Onto the next sha.
1
2
79
Replying to @MTNNG
@MTNNG router and MiFi chose to be out of service today. Poor network throughout the day.
1
1
193
Inserting Rows in SQL The first way is manually typing out the exact data you want to add to a table using the INSERT…VALUES statement. The second way is using a SELECT statement as a subquery inside the INSERT statement, this copies rows…
Column Attributes in SQL! Attributes like ⁠PRIMARY KEY⁠, ⁠NOT NULL⁠, ⁠AUTO_INCREMENT⁠, and ⁠DEFAULT⁠ act as rules that keep table data clean and consistent automatically.
1
1
1
135
Column Attributes in SQL! Attributes like ⁠PRIMARY KEY⁠, ⁠NOT NULL⁠, ⁠AUTO_INCREMENT⁠, and ⁠DEFAULT⁠ act as rules that keep table data clean and consistent automatically.
UNION Operator in SQL! UNION is used to stack query results vertically. I practiced UNION by using literal label columns to categorize customers points into award tiers as seen in the query below:👇
1
1
3
148
UNION Operator in SQL! UNION is used to stack query results vertically. I practiced UNION by using literal label columns to categorize customers points into award tiers as seen in the query below:👇
The USING Keyword in SQL: It’s a shortcut for joining tables when the column name matches on both sides. I practiced this keyword by linking three tables within the same database to retrieve client names, the amount they paid and the payment method used.
1
3
172
The USING Keyword in SQL: It’s a shortcut for joining tables when the column name matches on both sides. I practiced this keyword by linking three tables within the same database to retrieve client names, the amount they paid and the payment method used.
The Advanced Joins in SQL! The Cross-Database JOIN queries and merges tables located across different databases using dot notation (⁠database.table⁠). The SELF JOIN joins a table with itself using table aliases to model internal relationships like hierarchies.
1
1
5
210
Clauses & Joins in SQL! The LIMIT clause constrains the number of rows returned by a query, useful for pagination and top-result filtering. The INNER JOIN clause combines matching rows from two tables using the ON condition to specify the related columns.
Operators & Clauses in SQL! The IS NULL operator checks if a column contains no value or missing data. The ORDER BY clause sorts the retrieved query results in ascending (⁠ASC⁠) or descending (⁠DESC⁠) order.
1
1
4
196
I’m grateful for the gift of life! 🤲🏻 Happy birthday to me. ☺️
14
3
86
2,231
Replying to @StakeTG
9th birthday is a big one!! Stake: Jonnywonder
6
Replying to @Tuteth_
0x5cd9bc519e0dcdeF0EC15Ad9b6EB322C8e02A868
7
Done Consider me: 0x5cd9bc519e0dcdeF0EC15Ad9b6EB322C8e02A868
24
const milestones = ["Bachelor of Agriculture"]; const nyscCertificate = "NYSC Discharge Certificate"; milestones.push(nyscCertificate); console.log(milestones);
5
4
1
19
798
Replying to @kublinseth
Staying suspicious 🤔
28
Replying to @Wizarab10
This is my most important right now, sir Dickson.
12
Replying to @theberneese
Omo, make I try my luck o!
5
Day one: Data types in JavaScript are either primitive or object. Day two: String, boolean, number, undefined, null, and symbol are examples of primitive data types. Day three: console.log(typeof null) outputs Object 😑
1
1
1
8
5,141
Replying to @FractionAI_xyz
Came in at the stoppage time.
14