Oracle SQL online training | Oracle SQL certificationLead Online Training - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

Oracle SQL online training | Oracle SQL certificationLead Online Training

Description:

It is due to SQL that we've innumerous strong sites online as information source and SQL primarily manages the information of those sites makes it possible the intricate control of them.oracle SQL provides a lot of versatility to the customers. The information source can be run at a specified time on several pc systems. It's now a question language standard, relaxing in the reasons to get a variety of data that is well established source programs on the Online today. SQL can be used in both- sectors and instructors, thus SQL server training in singapur,australiya& usa,Hyderabad software are becoming more and more popular. Also SQL based programs are fairly cost-effective for the frequent user. – PowerPoint PPT presentation

Number of Views:98

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Oracle SQL online training | Oracle SQL certificationLead Online Training


1
s Online Training
  • By
  • SMART MIND ONLINE TRAINING

Website http//smartmindonlinetraining.com/
2
OUR Course Content
  • Installation of Virtual workstation?
    Installation of Operating system
  • Assigning static ip to Ethernet
  • Login to the OS
  • Installing Virtual tools
  • Sharing of Folders from host OS to virtual OS
  • ?Cloning of OS in virtual workstation

3
OUR Course Content
  •  SQLPLUS tool
  • Verify database name
  • Verify database status
  • Verify control file location
  • Verify data files location
  • Verify redo log files location
  • Shut database
  • Startup database

4
Data Definition language
Create Alter Drop Truncate Rename

5
  • Data Manipulation Language
  • ? Insert
  • ? Update
  • ? Delete
  • Data Retrieval LanguageORACLE SQL Online
    Training
  • ? Select
  • Transaction Control Language
  • ? Commit
  • ? Rollback
  • ? Save point
  • Data control Language
  • ? Grant
  • ? Revoke

6
Functions
  • ? Single row function
  • ? Group functions
  • ? Numeric functions
  • ? String functions
  • ? Date functions
  • ? Miscellaneous functions
  • ? Conversion functions

7
Constraints
  • ? Domain integrity constraints
  • ? Not null
  • ? Check
  • ? Entity integrity constraints
  • ? Unique
  • ? Primary key
  • ? Referential integrity constraints
  • ? Foreign key
  • Case and default
  • ? Case
  • ? Default
  • Data using append procedure to add date values
    in existing dataset
  • Using the update statement to update data in
    existing dataset.
  • Using the MODIFY statements to update and
    modify data in place
  • Merging concepts
  • Data transformation
  • Concatenation concept in merging
  • Interleaving concept and merging
  • Different kind of match merging using MERGE
    statement using the contribution (IN) option in
    merge concept

8
Why Only Smart Minds
Smart Mind Online Training is one altogether the
leading IT work Institutions, established in
Hyderabad with the target of providing Training
services for various requirements in IT business.
We deliver company Trainings as per the scholar
requirements colonize and ground breaker of
worldwide e Learning solutions and providing
technology enabled Online Training for
individuals and company educators.
9
Contact Us
Website http//smartmindonlinetraining.com/
About PowerShow.com