Loading…
Title

Oracle database 12c sql – 1z0--71 duration - martinsburg ...

Description
This course covers the basic concepts of relational databases and the sql programming ... o use the list, append, and change sql*plus editing commands.
/0
Full Text
Martinsburg College Course OutlineCourse Code: CIS318Course Name: Oracle Database 12c AdministratorCertification: Oracle Database 12c SQL – 1Z0--71Duration:Tuition:Course OverviewThis course covers the basic concepts of relational databases and the SQL programminglanguage. The course reviews the essential knowledge and skills to write queries andsubqueries against single and multiple tables, and covers how to manipulate data in tables andcreate database objects. You will discover how to use basic SELECT statements, conversionfunctions, and conditional expressions. The course covers how to display data from multipletables, how to use SET operators, how to manage objects with data dictionary views, and howto manage Schema objects. You will examine the Data Definition Language (DDL) and willreview the features of SQL and SQL * Plus. You will discover how to restrict and sort data, andhow to report aggregated data using the group functions. You will review how to usesubqueries to solve que...