Home
Videos uploaded by user “Pravendra Gaur”
SQL TCL commands Commit, Rollback and Savepoint
 
06:18
SQL TCL commands Commit, Rollback, Savepoint www.pravendragaur.com
Views: 8089 Pravendra Gaur
SQL Insert all command
 
02:25
for learn more sign up on www.pravendragaur.com The SQL INSERT ALL statement is used to insert a one or more records in one time into a table.
Views: 90 Pravendra Gaur
SQL Constraints
 
10:54
Learn more on www.pravendragaur.com Constraints are the rules which applied on data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database. Constraints could be column level or table level. Column level constraints are applied only to one column, whereas table level constraints are applied to the whole table. Types of Constraints 1. Unique 2. Not null 3. Primary Key 4. Check 5. Foreign Key
Views: 131 Pravendra Gaur
4 SQL Single row Functions
 
17:19
SQL Single row Functions www.pravendragaur.com https://www.facebook.com/pravendragaur.biz/
Views: 146 Pravendra Gaur
SQL Subquery
 
09:11
For more videos sign up on www.pravendragaur.com In SQL, a subquery is a query within a query. You can create subqueries within your SQL statements.
Views: 71 Pravendra Gaur
Oracle Database11g tutorials 10 || SQL Single Row Function (SQL Functions ) by Pravendra Gaur
 
18:13
Oracle Database11g tutorials 10 || SQL Single Row Function (SQL Functions ) by Pravendra Gaur. Like subscribe my channel Pravendra Gaur , I will teach you how to crack interviews and many other technologies. Like me on facebook https://www.facebook.com/pravendragaur.biz/ Email : [email protected] Oracel single row function. Character functions Upper Lower Initcap Concat Substr Instr Length Lpad Soundex Ltrim Rtrim Replace Regexp_count
Views: 86 Pravendra Gaur
Lesson 2 SQL Basic DQL SELECT
 
29:40
SQL Basic DQL Select oracle sql server
Views: 53 Pravendra Gaur
SQL Group Functions
 
05:29
for more videos login on www.pravendragaur.com Aggregate functions return a single result row based on groups of rows, rather than on single rows. Aggregate functions can appear in select lists and in ORDER BY and HAVING clauses. They are commonly used with the GROUP BY clause in a SELECT statement.
Views: 21 Pravendra Gaur
SQL Joins
 
14:46
A join is a query that extracts data from two or more tables, views or snapshots or we can say A join is a query that combines rows from two or more tables, views, or materialized views. Types of join INNER JOIN 1 Equi join 2 Non Equi join OUTER JOIN 1 Left outer join 2 Right outer join 3 Full outer join SELF JOIN CROSS JOIN Learn more on www.pravendragaur.com like my page https://www.facebook.com/pravendragaur.biz/
Views: 47 Pravendra Gaur
SQL Insert Command
 
04:44
For learn more signup on www.pravendragaur.com The SQL INSERT statement is used to insert a one or more records into a table.
Views: 12 Pravendra Gaur
Introduction to SQL
 
05:53
For more update like my page on facebook on below link https://www.facebook.com/pravendragaur.biz/ For learn different technology sign up on my website www.pravendragaur.com
Views: 26 Pravendra Gaur
SQL Where and Order By Clause
 
09:28
SQL Where and Order By Clause Learn more on www.pravendragaur.com
Views: 13 Pravendra Gaur
SQL Alter Command
 
04:36
For more update sign up on www.pravendragaur.com
Views: 13 Pravendra Gaur
What is Database
 
01:33
What is database by Pravendra gaur from www.pravendragaur.com
Views: 46 Pravendra Gaur
SQL Create Command
 
05:28
For more videos sign up on www.pravendragaur.com
Views: 12 Pravendra Gaur
SQL DROP and TRUNCATE
 
02:59
For more update sign up on www.pravendragaur.com
Views: 23 Pravendra Gaur
SQL Update and Delete Query
 
03:51
For learn more sign up on www.pravendragaur.com The UPDATE statement is used to update existing records in a table. he DELETE statement is used to delete one or more existing records in a table.
Views: 22 Pravendra Gaur