Robert Dannelly Jr - Passionate Software Engineer Blog - Dannelly Solutions
This blog is about my history as a software engineer utilizing technologies C#, Java, React, JavaScript, .NET Core, SQL Server , Oracle, GIT, GitHub, Jira, Azure, AWS and HTML5. “I have not failed. I've just found 10,000 ways that won't work.” Thomas A. Edison. Please click on all my ADVERTISING links to help support this blog. Thank you.
Wednesday, June 25, 2025
Sunday, June 22, 2025
Wednesday, June 18, 2025
Monday, June 16, 2025
Saturday, June 07, 2025
Wednesday, June 04, 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.