Captain Picard's journey, in order
To watch Captain Picard's story in order, start with The Next Generation: Season 1, then The Next Generation: Season 2 and The Next Generation: Season 3. That's 14 out so far, about 168 hours, ending with Picard: Season 3.
Patrick Stewart's Jean-Luc Picard leads the Enterprise-D for seven seasons, then the Enterprise-E in four films. Star Trek: Picard catches up with him 20 years later.
Updated
Captain Picard's story in order
The Next Generation: Season 1
Picard takes command of the new Enterprise.
The Next Generation: Season 2
The Next Generation: Season 3
Ends with Picard taken by the Borg.
The Next Generation: Season 4
Picard recovers from the Borg.
The Next Generation: Season 5
The Next Generation: Season 6
The Next Generation: Season 7
Generations
Picard meets Kirk.
First Contact
Picard faces the Borg again.
Insurrection
Picard defies Starfleet to protect a planet's people.
Nemesis
Picard meets a clone of himself, and loses Data.
Picard: Season 1
A retired Picard takes on one more mission.
Picard: Season 2
Q sends Picard into an alternate timeline.
Picard: Season 3
The Next Generation crew together again.
Questions
What order should I watch Captain Picard's story in?
Start with The Next Generation: Season 1, then The Next Generation: Season 2 and The Next Generation: Season 3, and follow the list above: 14 in all, ending with Picard: Season 3.
How long does it take to watch all of Captain Picard's story?
About 168 hours for the 14 out so far.
Do I need to watch The Next Generation before Star Trek: Picard?
It helps a lot, especially for Season 3, which brings the whole crew back. At least watch Nemesis, which Picard follows on from.
Watch Captain Picard's story with Chronologica
Make a plan of just Captain Picard's story, mark them off as you go and always know what's next. No account needed.