This movie was awesome!!!!!!! I just got it on DVD two days ago from HMV having never seen it before, and I watched it a second time yesterday since I liked it so much!!!!
There isn't much violence, the most violent scene would be when Borat and Azamat wrestle.
There's a lot of sexual content, including some nudity. The movie's most famous scene would be when Borat and Azamat wrestle naked. Their penises are blocked out, but scrotums are set in each other's faces. Borat is shown masturbating outside a lingerie store and even taking a crap in front of Trump Towers. Borat shows pictures of his son's penis (not actually a kid, in real life the actor playing the kid is a gay porn star). Borat makes out with somebody and says afterwards that she is his sister. Borat says that a gay man tried to put a rubber fist in his anus. Loads of other sexual stuff.
Language isn't too much of a main offender, but it is there, with uses of "f--k", "s--t", "p---y", "c--k", "t-ts", and "n---a".
Overall this is a fantastic movie, I loved it a lot, but if you are easily offended you won't like it. Actually when I was at camp last summer my counsellor said that a mom took a bunch of sixth graders to this movie and that her face was really shocked after wards. So definitely check this movie out if you are a fan of mockumentaries or of Sacha Baron Cohen's other movies.