SATA is a connection interface. Most drives use this interface because it's generally cheaper and it's a built in feature of the Chipset. There is also an M.2 connection interface that only uses a card form of a SSD.
M.2 is tricky because there are 2 types. There are the NVMe interface SSD that need an M-Key M.2 slot. These are the extremely fast ones that are 20x faster than a standard Hard Drive. Then you have the ACHI?SATA versions that use a B-Key slot, and these are just as fast as a standard 2.5" SSD that connects through a traditional SATA port.
SSD is a type of Hard Drive.
I think you meant to ask, is a SSD better than a standard spinning Hard Drive. Yes it is. A SSD has better access times, less latency, and the Read Speeds are usually 3x-5x faster than a standard Hard Drive.
It pays to learn the fine details of a laptop. You won't see me buying a laptop that doesn't have an M.2 slot for a NVMe SSD.
A word of warning, I have a PC with a Samsung 960 Pro NVMe drive and yes it loads Windows and programs very, very fast but my other PC with a Crucial 2.5" MX500 SSD only loads Windows a couple seconds slower. You won't see the difference between the 2 versions unless you are loading and recording very large files like huge 4k Videos which are 10gb to 20gb.
It's extremely hard to exceed the rated Write cycles of a modern SSD, and it's even more difficult to bring it to the point of failure because it's been overused. I have a Samsung 830 that I bought in 2012 and it has 32 terrabyte write cycles on it. Some people have claimed to have 5-9 petabyte write cycles on a Samsung drive. Even the offbrands like Mushkin can exceed 1PBwc. Defraging a SSD isn't a very good idea and it's useless but the amount of life it takes off the SSD is a drop in the bucket.
The SSHD drives are a joke and it's best to avoid those. The can be fast but only if you're loading the same program over and over again. That program will get loaded into the SSD cache in the drive. Otherwise, the drive will store the information on the Platters and that isn't any faster than a standard drive. in fact, you would be better off with an Enterprise or Server class drive like the Western Digital Gold line as opposed to a SSHD.