Fresh2Refresh is one of the online programming website which explains SQL concepts, C programming and Java programming to the software application developers with simple examples and output in tutorial format.
Let's discuss about SQL language in this course.
SQL – INTRODUCTION
SQL – DDL, DML & DCL SQL – Data types SQL – select SQL – insert into SQL – update SQL – delete
SQL – CLAUSES & OPERATORS:
SQL – distinct/unique SQL – where SQL – LIKE & wildcard operators SQL – Order by SQL – AND, OR SQL – IN, NOT IN SQL – IS NULL & IS NOT NULL SQL – BETWEEN…AND & NOT BETWEEN…AND SQL – Select…into SQL – Top SQL – Alias
SQL – JOINS
SQL – Inner Join SQL – Left Join SQL – Right Join SQL – Full Join SQL – Self Join SQL – Cartesian Join or Cross join SQL – UNION & UNION ALL SQL – INTERSECT & EXCEPT
SQL – FUNCTIONS
SQL – Aggregate Functions SQL – Scalar Functions SQL – Group by function SQL – Having function
SQL – DATABASE & TABLES
SQL – Create DB, table & index SQL – Modify DB, table & index SQL – Drop DB, table & index SQL – Truncate SQL – Constraints SQL – Not null SQL – Unique SQL – Primary & composite key SQL – Foreign key SQL – Auto Increment SQL – Default SQL – Check SQL – Views