That technique is called a paddidle because it's on the pad of your finger. Old-school types might call it a twirl. The more popular technique is called the "nail delay." It's typically performed on a disc treated with some sort of silicone lubricant. It can be learned on real nails or thimbles, but advanced players wear fake nails since the real ones tend to break or get worn down. Look up frisbee freestyle for instructional videos.