6:06
1.How to Install SQL developer in your Local system l Installation l SQL l SQL Developer
Cognitive Hub
4:08
2.How to Create a Database Connection in SQL Developer l Database Connection l SQL l SQL Developer
9:54
3.What are Data Definition Statements in SQL l DDL Statements l SQL l SQL Developer
9:19
4.How to write queries for ALTER Command in SQL l DDL Statements l SQL l SQL Developer
5:42
5.How to insert data into database table using INSERT command l DML Statements l SQL l SQL Developer
6:22
6.How to delete records from table using DELETE Command l DML Statments l SQL l SQL Developer
5:27
7.How to Update records in Database Tables using UPDATE Command in SQL l DML Statements l SQL
5:51
8.How to Retrive Data from Database Tables using SELECT Command l DML Statements l SQL Developer
4:38
9.How to use Arithmetic Operators in Table Columns l SQL l SQL Developer
6:42
10.How to use Logical Operators in Table Columns l SQL l SQL Developer
5:26
11.How to use Relational Operators in Table Columns l SQL l SQL Developer
7:52
12.How to assign Check Constraint to a column l CHECK Constraint l SQL l SQL Developer
8:22
13.How to use UNIQUE Constraint on Columns in SQL l UNIQUE Constraint l SQL l SQL Developer
5:53
14.How to apply NOT NULL Constraint on Table Columns in SQL l NOT NULL l SQL l SQL Developer
5:19
15.How to Apply Primary Key Constraint on Table Columns in SQL l PRIMARY KEY l SQL l SQL Developer
10:28
16.How to Apply Foreign Key Constraint on Table Columns in SQL l FOREIGN KEY l SQL l SQL Developer
7:59
17.How to write Query for Inner Join in SQL l INNER JOIN l SQL l SQL Developer
5:40
18.How to write Query for Left Outer Join in SQL l LEFT OUTER JOIN l SQL l SQL Developer
6:36
19.How to write query for Right Outer Join in SQL l RIGHT OUTER JOIN l SQL l SQL Developer
20.How to write Query for Self Join in SQL l SELF JOIN l SQL l SQL Developer
7:06
21.How to write Query for Full Outer Join in SQL l FULL OUTER JOIN l SQL l SQL Developer
5:56
22.How to do Sorting using Order By in SQL l ORDER BY l SQL l SQL Developer
8:19
23.Aggregating Functions in SQL l Count l Max l Avg l Min l Sum l SQL l SQL Developer
3:44
24.How to Remove Duplicates in SQL using Distinct Keyword l DISTINCT l SQL l SQL Developer
9:04
25.How to write Query for doing Group By Operation in SQL l GROUP BY l SQL l SQL Developer
4:41
26.How to Populate Data into Another Table using Insert Into in SQL l INSERT INTO l SQL Developer
8:30
27.How to Create a View in SQL l VIEWS l SQL l SQL Developer
6:14
28.How to create an Index on Table in SQL l INDEX l SQL l SQL Developer
8:54
29.How to write Query for In & Not In Operator in SQL l IN & NOT IN l SQL l SQL Developer
6:08
30.How to write Query for Between Operator in SQL l BETWEEN l SQL l SQL Developer
7:36
31.How to write Query for Any Operator in SQL l ANY Operator l SQL l SQL Developer
6:41
32.How to Write Query to illustrate All Operator in SQL l ALL Operator l SQL l SQL Developer
7:51
33.How to write query to illustrate Like Operator with Wildcards in SQL l LIKE l SQL l SQL Developer
