Learn how to rename SQL Server tables, change the table owner, determine if a table has a primary key, change columns from NULL to NOT NULL and other table-related questions.
Learn the differences between CHAR and VARCHAR, between NCHAR and NVARCHAR, between CHAR and NCHAR, between VARCHAR and NVARCHAR, between NUMERIC and DECIMAL, between FLOAT and REAL, between SMALLDATETIME and DATETIME, between SMALLMONEY and MONEY and between TINYINT, SMALLINT, INT and BIGINT data types an learn when to use each data type.
Learn how to add and subtracts days in a date, extract the time, day, month or year part of a DateTime column, get the difference in days between two dates, determine if it is a leap year, display the date in different date formats, and much, much more DateTime and SmallDateTime related questions
Learn how to use UNION or UNION ALL in a view, create a view that combines the rows from two tables that have different number of columns and learn if an object is a view or a table.
Learn how to identify duplicate rows in a table, return rows from one table that either exist or does not exist on another table, split a column containing a full name into a last name and a first name, and other SELECT related questions.