The word 'title' is in quote marks in the subject heading because I'm thinking of songs that contain the titles of albums in the lyrics but don't share the titles of the albums themselves. A couple of examples:

"Warakurna" by Midnight Oil contains the title of the album Diesel and Dust.
"Young Pilgrims" by The Shins contains the title of the album Chutes Too Narrow.

The Onlookers' Blue And Green And Tangerine is taken from the lyrics of "The People There".
Reggie King's Looking For A Dream is taken from the lyrics of "All Up To Heaven".

The Cars' "Move Like This" is taken from the lyrics of "Too Late."

First one that popped into my head is a kinda sorta: Steely Dan's "Katy Lied" comes from the song "Doctor Wu" - "Katie lies..."

Blue Oyster Cutt......Agents of Fortune in the song E.T.I.

No Security--Rolling Stones (from "One Hit to the Body")
Jagged Little Pill--Alanis Morissette (from "You Learn")
A Lot About Livin' (And a Little 'Bout Love)--Alan Jackson (from "Chattahoochee")
End of the Century--Ramones (from "Do You Remember Rock & Roll Radio?")
Willy and the Poor Boys--CCR (from "Down on the Corner")

Does the album have to have the song on it that it derived its title from?

All Zappa titles

It Can't Happen Here - Freak Out
Willie the Pimp - Hot Rats
Sam With The Showing Scalp Flat Top - Bongo Fury

Nah. It'd be interesting to see examples of album titles that are found in the songs of different albums. But the song title can't be the same as the album title.

Captain Beefheart - Trout Mask Replica in Old Fart At Play.

I give you XTC:

LP - Oranges & Lemons taken from the lyrics of the song "Ballet For A Rainy Day" on the lp Skylarking
LP - Nonsuch taken from the lyrics of of the song "Chalkhills And Children" on the lp Oranges & Lemons
LP - Apple Venus taken from the lyrics of "Then She Appeared" on the lp Nonsuch

Grateful Dead - Wake Of The Flood in Here Comes Sunshine

Talking Heads -Stop Making Sense– from “Girlfriend is Better”
Spin Doctors -Pocket Full of Kryptonite- from “Jimmy Olsen's Blues”
Pixies -Doolittle- from "Mr Grieves"
Wilco -A Ghost Is Born– from “Theologians”
Neil Young -Rust Never Sleeps- from “Hey Hey My My”
Nirvana -Nevermind- from “Smells Like Teen Spirit”
Elliott Smith -From a Basement On A Hill– from “Memory Lane”
Mudhoney -Under a Billion Suns- from “Endless Yesterday”
Sonic Youth -Daydream Nation- from “ Hyperstation”
Simon & Garfunkel -Parsley, Sage, Rosemary and Thyme- from “Scarborough Fair/Canticle”

"Locomotive" on Use Your Illusion II by Guns N' Roses has the line You can use your illusion...

The Kinks........Everybody's In Showbiz in Celluloid Heroes

Pink Floyd.......Dark Side Of The Moon in Brain Damage

We did this before but I can't remember what I posted.

A few I do remember are:

Rush-Hold Your Fire from "Mission"
Pink Floyd-A Momentary Lapse Of Reason from "One Slip"
Van Halen-Fair Warning from "Mean Street"

Midnight Oil song "Brave Faces" contains album title "Place Without a Postcard."

Midnight Oil's song "E-Beat" contains album title "Breathe."

Almost but not quite, the Midnight Oil EP " Species Deceases" has no song with that title, but the song "Pictures" contains the line "Don't wanna be a member of a species that's deceasin'".

"Brave Faces" by Midnight Oil on Place Without a Postcard contains the album title.

Both "The Hounds of Winter" and "Lithium Sunset" on Mercury Falling by Sting contain the album title.