Providing antioxidants and targeting acetylcholinesterase (AChE) are key strategies in treating neurocognitive dysfunction. In this study, bioactive sturgeon (Acipenser schrenckii) spinal cord peptides (SSCPs) with antioxidant and AChE inhibitory potency were extracted and separated from sturgeon spinal cord by enzymatic hydrolysis and ultrafiltration, and targeted peptide PGGW was screened via computer simulated molecular docking. Further, the molecular dynamic interactions of the PGGW with superoxide dismutase (SOD) and AChE were analyzed, and the protective effect of PGGW on glutamate-induced PC12 cells in vitro was evaluated. The <3 kDa fraction of SSCPs displays the most potent antioxidative efficacy (1 mg/mL, DPPH•: 89.07%, ABTS