Modernize with Azure Migrate
https://azure.microsoft.com/blog/modernize-with-azure-migrate/With the pandemic mostly behind us, several large economies have opened in some shape or form. This, despite the uneven...
Month: July 2022
Choosing the best indexes for PostgreSQL query optimization
PostgreSQL is extremely popular these days, and we decided to share a few tips on choosing the best indexes...
UNION QUERY WITH NULL VALUES
Having a hard time with a union query - hoping once of you fine ladies or gents can offer up...
autoincrement primary key in a table whose rows get deleted often?
SOLVED, THANKS EVERYONE Hello guys, I am still pretty much a newbie in sql as I started learning 2 months...
Database Names and Spaces
Is it possible to restrict the creation a databases to prevent spaces in the name? If so, how? Thanks! submitted...
I’m stumped on making a query
Hello! I am having trouble figuring out a query. This is the schema: entries: id, int, autoinc, primary key ename,...
May I ask your advice on changing jobs
Hey all! I have a few questions. I am a bit torn here. Quick background, because it's important. I worked...
Is there a place is can find all the sql commands?
im trying to find all the commands so i can have a better idea of what im looking for submitted...
Computing moving average with some NULL values
I'm trying to compute the moving average of weight records, where some of the records are NULL. When the weight...
Is there any course/tutorial that consist ONLY of first presenting the db contents (3 – 5 tables) and then proceeds to write, describe and perform a lot, and I mean really a lot of complicated queries?
Hi, I am looking for some course/tutorial/source that has pretty much only 2 things. First, simple presentation of the DB...
