Microsoft SQL Server Development for Everyone - Advanced Select Queries

This video tutorial covers advanced SQL select statements, including using the editor to generate queries, understanding fully qualified table names, and filtering data with conditions and wildcards. It also explains how to create custom columns by concatenating strings and demonstrates filtering on numerical values. The tutorial provides practical examples using a school database and courses table.

What is the purpose of the 'SELECT' statement in SQL?

Explain the significance of the 'TOP' keyword in a SQL query.

What does a fully qualified table name consist of in SQL?

How can you filter records in SQL using the 'WHERE' clause?

What is the purpose of using wildcards in SQL queries?

Explain how to use the 'LIKE' operator in SQL for pattern matching.

Describe how to concatenate strings in SQL to create a full name.

What are the different comparison operators you can use in SQL for numerical values?

How would you retrieve all courses with more than two credits from a courses table?

What is the difference between 'greater than' and 'greater than or equal to' in SQL?