The Oracle Corporation is an American global computer technology corporation, headquartered in Redwood City, California. The company primarily specializes in developing and marketing computer hardware systems and enterprise software products – particularly its own brands of database management systems. In 2011 Oracle was the second-largest software maker by revenue, after Microsoft.
An Oracle database is an ORDBMS, provides open comprehensive integrated approach to information management. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.
Oracle 11g offers the benefits of Grid Computing delivering higher quality of service, lower cost, and greater flexibility. Higher quality of service results from having no single point of failure, a robust security infrastructure, and centralized, policy-driven management.
In this course the candidate will learn the basics of relational data bases and the powerful SQL Programming language.
Details of the course is given below.
|Oracle Data Base 11g-Introduction to SQL 2.0||40||IntroductionRetrieving Data Using the SQL SELECT StatementUsing Single-Row Functions to Customize OutputUsing Conversion Functions and Conditional ExpressionsReporting Aggregated Data Using the Group FunctionsUsing Subqueries to Solve QueriesUsing the Set OperatorsManipulating DataUsing DDL Statements to Create and Manage TablesCreating Other Schema ObjectsControlling User AccessManaging Schema ObjectsManaging Objects with Data Dictionary ViewsManipulating Large Data SetsRetrieving Data by Using SubqueriesRegular Expression Support|