Name: Exam 1Z0-171: Oracle AI Database SQL Associate
Price: 25 GBP
Availability: InStock

Exam 1Z0-171: Oracle AI Database SQL Associate

Become an Oracle AI Database SQL Associate and demonstrate understanding of fundamental SQL concepts needed to interact with database tables and other objects. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Demonstrate a working knowledge of select , insert, update, delete and merge SQL statements as well as some Data Definition Language and Data Control Language statements. Additionally, it demonstrates your knowledge of working with database objects such as tables, indexes, views and sequences. By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language, ER Models and using SQL to create and manipulate tables in an Oracle Database. Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.

Course Prerequisites:

None

What you will learn?

1. Relational Database Concepts

Explain the theoretical and physical aspects of a relational database
Describe how to relate clauses in SQL Select Statement to Components of an ERD
Describe the relationship between a database and SQL

2. Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data

Demonstrate how to use column aliases
Describe using The SQL SELECT statement
Apply knowledge of how to use the concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
Calculate output using Arithmetic expressions and NULL values in the SELECT statement
Demonstrate how to use rules of precedence for operators in an expression
Identify how to limit rows returned in a SQL statement
Recognize how to use Substitution Variables
Describe using the DEFINE and VERIFY commands
Utilize concepts to sort data

3. Using Functions

Apply character functions to manipulate strings in SELECT and WHERE clauses
Show how to use arithmetic with date data
Use the ROUND, TRUNC and MOD functions
Use DATE functions
Apply the NVL, NULLIF, and COALESCE functions to data
Explain implicit and explicit data type conversion
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Describe nesting multiple functions
Show restricting group results
Explain creating groups of data and using group functions

Exam 1Z0-171: Oracle AI Database SQL Associate

What you will learn?

1. Relational Database Concepts

2. Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data

3. Using Functions

4. Displaying Data from Multiple Tables

5. Using Subqueries to Solve Queries

6. Using SET Operators

7. Managing Tables using DML statements

8. Managing Indexes Synonyms and Sequences

9. Use DDL to manage tables and their relationships

10. Controlling User Access

11. Managing Objects with Data Dictionary Views and Data in Different Time Zones

Join us: to stay updated on new courses, discounts, free learning opportunities, and more

Join us toGrow Skills,together!

Get Updates

Exam 1Z0-171: Oracle AI Database SQL Associate

What you will learn?

1. Relational Database Concepts

2. Retrieving Data using the SQL SELECT Statement and Restricting and Sorting Data

3. Using Functions

4. Displaying Data from Multiple Tables

5. Using Subqueries to Solve Queries

6. Using SET Operators

7. Managing Tables using DML statements

8. Managing Indexes Synonyms and Sequences

9. Use DDL to manage tables and their relationships

10. Controlling User Access

11. Managing Objects with Data Dictionary Views and Data in Different Time Zones

Join us to
Grow Skills,
together!