SQL Server 2012 - Advanced Level

SQL Server 2012 - Advanced Level

Contents:

• The TOP ClausThe LIKE Operator

• SQL Wildcards

•  The IN Operator

• The BETWEEN Operator

• SQL Alias.

• SQL JOIN

• Different SQL JOINs

• SQL INNER JOIN Keyword

• SQL LEFT JOIN Keyword

• SQL RIGHT JOIN Keyword

• SQL FULL JOIN Keyword

• The SQL UNION Operator

• The SQL SELECT INTOStatement

• SQL SELECT INTO - With aWHERE Clause

• SQL SELECT INTO - JoinedTables

• The CREATE DATABASEStatement

• The CREATE TABLE Statement

• SQL Constraints

• SQL NOT NULL Constraint

• SQL UNIQUE Constraint

• SQL UNIQUE Constraint onCREATE TABLE

• SQL UNIQUE Constraint onALTER TABLE

• To DROP a UNIQUE Constraint

• SQL PRIMARY KEY Constraint

• SQL PRIMARY KEY Constrainton CREATE TABLE

• SQL PRIMARY KEY Constrainton ALTER TABLE

• To DROP a PRIMARY KEYConstraint

• SQL FOREIGN KEY Constraint

• SQL FOREIGN KEY Constrainton CREATE TABLE

• SQL FOREIGN KEY Constrainton ALTER TABLE

• To DROP a FOREIGN KEYConstraint

• SQL CHECK Constraint

• SQL CHECK Constraint onCREATE TABLE

• SQL CHECK Constraint onALTER TABLE

• To DROP a CHECK Constraint

• SQL DEFAULT Constraint .

• SQL DEFAULT Constraint onCREATE TABLE

• SQL DEFAULT Constraint onALTER TABLE.