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.
No comments:
Post a Comment