Database - Oracle (FREE)



Part 01

by Softsmith
Duration: 11:48 mins.
Description: Data, Information, DBMS, RDBMS, Uses of databases

Part 02

by Softsmith
Duration: 08:41 mins.
Description: Sorting of data, filtering data

Part 03

by Softsmith
Duration: 18:18 mins.
Description: Identify data, group data, associate data type and length

Part 04

by Softsmith
Duration: 23:24 mins.
Description: Uniqueness, Relationships, Create Table, Drop Table

Part 05

by Softsmith
Duration: 20:22 mins.
Description: Insert data and its variations, simple select statement

Part 06

by Softsmith
Duration: 24:25 mins.
Description: Primary key, varchar, length, trim, order by clause

Part 07

by Softsmith
Duration: 25:02 mins.
Description: Default clause, where condition, update statement

Part 08

by Softsmith
Duration: 21:20 mins.
Description: Alter table, .sql file, sum, max, min, avg, count

Part 09

by Softsmith
Duration: 23:14 mins.
Description: Group by, Having, Delete, Truncate, Rowid

Part 10

by Softsmith
Duration: 20:01 mins.
Description: to_date, to_char, AND, OR, Between, In

Part 11

by Softsmith
Duration: 37:48 mins.
Description: Like, upper, lower, initcap, inner join

Part 12

by Softsmith
Duration: 23:34 mins.
Description: Outer join, substr, floor, ceil, round, dual

Part 13

by Softsmith
Duration: 25:31 mins.
Description: Foreign Key, user_tables, Theory on Stored Procedures

Part 14

by Softsmith
Duration: 29:44 mins.
Description: Create, replace, drop stored procedures, comment, variables, assignment, for loop, serveroutput, in parameter, execute SP

Part 15

by Softsmith
Duration: 26:13 mins.
Description: If conditions, insert statement in SP, call another SP

Part 16

by Softsmith
Duration: 36:49 mins.
Description: Stored Functions, return values, package header and body

Part 17

by Softsmith
Duration: 22:21 mins.
Description: Select into statement in SP, exception handler in SP

Events
Events hosted by OpenMentor team in various places.

Open Work
Do you want to get your product tested, by our community?

Live Mentoring/Training
Do you want to have live private training/mentoring?





Very Basics of Software |  Application Design |  Database - Oracle |  Database Design  |  Database - MySql |  Datawarehouse and ETL |  CRM |  eCommerce Workflow |  ERP |  HR - Human Resources |  POS - Point of Sale |  SCM - Supply Chain Management |  NPTEL Online Learning Material |  UNIX Basics |  Language - C |  Perl Scripting |  Language - VBScript |  Language - Java |  HTML Builder |  Java Script |  Language - Python |  Language - VB Dot Net |  Language - Cobol |  Code Review Tools |  Project Risk Management |  Project Plan - OpenProj |  Why People Fail at work? |  Report Writers - Telerik Reporting |  Chart Director |  Software Testing Part 1 |  Software Testing Part 2 |  Software Testing Part 3 |  Test Management using QAMonitor |  White Box Testing |  Web Services Testing |  Security Testing |  Interview Expectations in Software Testing |  Compatibility, Interoperability, Usability Testing |  DataBase Testing |  Productivity Improvements in Testing |  Testing as career for freshers |  Neoload Performance Testing |  Test Automation - QTP |  HP Quality Center (QC) |  Test Automation - Silk Test |  HP LoadRunner |  Test Automation - Test Complete |  Performance Testing Concepts |  Live Load Testing |  Bugzilla, BitBucket, SPCG |  IBM Rational Functional Tester |  IBM Rational Performance Tester |  JMeter by Apache |  Test Automation - Selenium |  Load Testing Mobile Apps |  Tools - Microsoft Powerpoint |  Tools - Microsoft Word |  Tools - Visio |  Tools - Visual Source Safe |  Tools - Microsoft Excel |  Web - ExtJS Library |  Web - Java Script |  Tamil Grammar (lectures in Tamil) |  Spoken English - lessons in Tamil |  Critical Points in Coding and Testing  |  IBM Rational Functional Tester 8.5 |  Selenium Advanced |