SELECT column1, column2, column3, ... INTO new_table FROM source_table WHERE condition;
What is SQL
What is T-SQL
Difference between DBMS and Data Warehouse
Download SQL Server
Install SQL Server
Download SQL Server Management Studio SSMS
SQL Server Management Studio
SQL Database
Download database
Restore database
Backup database
Attach database
Detach database
Create database
Delete database
Rename database
Select database
Database offline
Database online
SQL Commands
SQL Tables
Create table
Truncate table
Delete table
Rename table
Select table
Alter table
SQL Data Types
SQL Comments
SQL Constraints
SQL Joins
SQL inner join
SQL left join
SQL right join
SQL full join
SQL cross join
SQL self join
INSERT INTO SELECT statement
INSERT INTO statement
SQL Clauses
SELECT clause
FROM clause
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
JOIN clause
UNION clause
UNION ALL clause
TOP clause
DISTINCT clause
SQL Operators
SQL Arithmetic operators
SQL Comparison operators
SQL Logical operators
UNION operator
UNION ALL operator
INTERSECT operator
EXCEPT operator
LIKE operator
NOT LIKE operator
IN operator
NOT IN operator
IS NULL operator
IS NOT NULL operator
EXISTS operator
NOT EXISTS operator
BETWEEN operator
NOT BETWEEN operator
SQL Functions
SQL Built-In functions
CHARINDEX function
DATEADD function
CONCAT function
LEN function
REPLACE function
SUBSTRING function
CASE statement
GETDATE function
DATEPART function
DATEDIFF function
CAST function
TRY_CAST function
CONVERT function
TRY_CONVERT function
ISNULL function
NULLIF function
COALESCE function
SQL Window functions
ROW_NUMBER function
RANK function
DENSE_RANK function
IIF function
CHOOSE function
SQL Store Procedure
Store Procedure vs. Function
SQL Subquery
SQL Aliases
Temp table
SQL Error Handling
SQL Variables
SQL Views
SQL Merge
SQL CTE
SQL WITH TIES
Define Transaction in DBMS
ACID properties in DBMS
Types of Triggers in DBMS