SQL

Course Content

 INTRODUCTION

 Syntax

 Select

 Select Distinct

 Where

 And, Or, Not

 Order By

 Insert Into

 Null Values

 Update

 Delete

 Select Top

 Min and Max

 Count, Avg, Sum

 Like

 Wildcards

 In

 Between

 Aliases

 Joins

 Inner Join

 Left Join

 Right Join

 Full Join

 Self Join

 Union

 Group By

 Having

 Exists

 Any, All

 Select Into

 Insert Into Select

 Case

 Null Functions

 Stored Procedures

 Comments

 Operators

Database

 Create DB

 Drop DB

 Backup DB

 Create Table

 Drop Table

 Alter Table

 Constraints

 Not Null

 Unique

 Primary Key

 Foreign Key

 Check

 Default

 Index

 Auto Increment

 Dates

 Views

 Injection

 Hosting

 Data Types