" SQL Developer"

"Introduction Case Study Part 1 CREATE Exercise 1: Create DB and Table Installation and getting started INSERT Import data from File Exercise 2: Inserting and Importing Case Study : Demo SELECT statement SELECT DISTINCT WHERE Logical Operators Exercise 3: SELECT & WHERE UPDATE DELETE ALTER Exercise 4: Updating Table Fundamental SQL statements Exercise 5: Restore and Back-up Restore and Back-up IN BETWEEN LIKE Exercise 6: In, Like & Between Selection commands: Filtering Side Lecture: Commenting in SQL ORDER BY LIMIT Exercise 7: Sorting Selection commands: Ordering AS Aggregate Commands COUNT SUM AVERAGE MIN & MAX Exercise 8: Aggregate functions Group By Commands GROUP BY HAVING Exercise 9: Group By Conditional Statement CASE WHEN JOINS Introduction to Joins Inner Join Left Join Right Join Full Outer Join Cross Join Except Union Exercise 10: Joins Subqueries Exercise 11: Subqueries Views and Indexes VIEWS Exercise 12: Views String Functions LENGTH UPPER LOWER REPLACE TRIM, LTRIM, RTRIM CONCATENATION SUBSTRING LIST AGGREGATION Exercise 13: String Functions Mathematical Functions CEIL & FLOOR RANDOM SETSEED ROUND POWER Exercise 14: Mathematical Functions Date-Time Functions CURRENT DATE & TIME AGE EXTRACT Exercise 15: Date-time functions PATTERN (STRING) MATCHING PATTERN MATCHING BASICS Exercise 16: Pattern Matching Data Type conversion functions Converting Numbers/ Date to String Converting String to Numbers/ Date User Access Control Functions User Access Control Bonus Section: Nail that Interview! Tablespace PRIMARY KEY & FOREIGN KEY ACID compliance Truncate Performance tuning tips TIP 2 TIP 3 TIP 4 (VACCUM) TIP 5 TIP 6 (STRING FUNCTIONS) TIP 7 (JOINS) TIP 8 (SCHEMAS) Bonus Section : Database Basics What is SQL Tables and DBMS Types of SQL commands PostgreSQL"