Saturday, June 07, 2025

Tuesday, June 03, 2025

Boot.dev Learn SQL

 What can I say, but how awesome Boot.dev is!!!  I just finished their Learn SQL course and although I have been working with databases for 25 years Boots just help solidified my skills and polished them.  I wish I would have took the course one day earlier because one of my recent interview questions was:

How to you limit the results from a read query.   Answer:  limit <integer> at the end of the query.

Example:

SELECT * FROM USERS limit 50;  -- MySQL, PostgreSQL, SQLite

SELECT TOP(50) * FROM USERS;  -- MSSQL

SELECT * FROM USERS FETCH FIRST 50 ROWS ONLY; -- ORACLE

Very good theory training on increasing database speed by way of normalization and indexes.




Friday, May 23, 2025

What is Encapsulation

What is Encapsulation in Object Oriented Programming?

It is the practice of hiding complexity inside a black box so that it is easier to focu on the problem at hand.


Could you please tell me more about Encapsulation in Object-Oriented Programming?

From my current understanding, it's the practice of concealing the intricate details within a self-contained unit, allowing for a clearer focus on the task at hand.

Wednesday, May 21, 2025

Windows 11 WSL 2 with Linux

Adding to my blog the command once you have WSL 2 running in Windows to connect to https://github.com

gh auth login

This will prompt you to go to https://github.com/ and enter the code provided in the WSL Linux Terminal