Exclude posts in a category on one page but show those posts on a different page

I resolved this by creating a custom page template for my Blog page to exclude posts of the category Case Studies.

I followed this tutorial more or less and was successful adding the category exclusion code in my original post to exclude the case studies.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)