What is a view in SQL? Explain its purpose, how it is created, and the benefits it provides in database management. Include examples of scenarios where views can simplify complex queries or enhance security.
Focus on defining views, their syntax, and practical applications in real-world database scenarios. Discuss performance implications and when to use them effectively.