1Z0-071 "Oracle Database SQL Certified Associate" Beynəlxalq Sertifikatına Hazırlıq

Kurs Haqqında

• Relational Database concepts
  • 1 Explaining the theoretical and physical aspects of a relational database
  • 2 Relating clauses in SQL Select Statement to Components of an ERD
  • 3 Explaining the relationship between a database and SQL
• Retrieving Data using the SQL SELECT Statement
  • 1 Using Column aliases
  • 2 Using The SQL SELECT statement
  • 3 Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • 4 Using Arithmetic expressions and NULL values in the SELECT statement
• Restricting and Sorting Data
  • 1 Applying Rules of precedence for operators in an expression
  • 2 Limiting Rows Returned in a SQL Statement
  • 3 Using Substitution Variables
  • 4 Using the DEFINE and VERIFY commands
  • 5 Sorting Data
• Using Single-Row Functions to Customize Output
  • 1 Manipulating strings with character functions in SQL SELECT and WHERE clauses
  • 2 Performing arithmetic with date data
  • 3 Manipulating numbers with the ROUND, TRUNC and MOD functions
  • 4 Manipulating dates with the date function
• Praktiki imtahan
• Using Conversion Functions and Conditional Expressions
  • 1 Applying the NVL, NULLIF, and COALESCE functions to data
  • 2 Understanding implicit and explicit data type conversion
  • 3 Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • 4 Nesting multiple function
• Reporting Aggregated Data Using Group Functions
  • 1 Restricting Group Results
  • 2 Creating Groups of Data
  • 3 Using Group Functions
• Displaying Data from Multiple Tables
  • 1 Using Self-joins
  • 2 Using Various Types of Joins
  • 3 Using Non equijoins
  • 4 Using OUTER joins
  • 5 Understanding and Using Cartesian Products
• Using Subqueries to Solve Queries
  • 1 Using Single Row Subqueries
  • 2 Using Multiple Row Subqueries
  • 3 Update and delete rows using correlated subqueries
• Using SET Operators
  • 1 Matching the SELECT statements
  • 2 Using the ORDER BY clause in set operations
  • 3 Using The INTERSECT operator
  • 4 Using The MINUS operator
  • 5 Using The UNION and UNION ALL operators
• Praktiki imtahan
• Managing Tables using DML statements
  • 1 Managing Database Transactions
  • 2 Controlling transactions
  • 3 Perform Insert, Update and Delete operations
  • 4 Performing multi table Inserts
  • 5 Performing Merge statements
• Managing Indexes Synonyms and Sequences
  • 1 Managing Indexes
  • 2 Managing Synonyms
  • 3 Managing Sequences
• Use DDL to manage tables and their relationships
  • 1 Describing and Working with Tables
  • 2 Describing and Working with Columns and Data Types
  • 3 Creating tables
  • 4 Dropping columns and setting column UNUSED
  • 5 Truncating tables
  • 6 Creating and using Temporary Tables
  • 7 Creating and using external tables
  • 8 Managing Constraints
• Managing Views; Controlling User Access; Managing Objects with Data Dictionary Views; Managing Data in Different Time Zones
  • 1 Differentiating system privileges from object privileges
  • 2 Granting privileges on tables
  • 3 Distinguishing between granting privileges and roles
  • 4 Using data dictionary view
  • 5 Working with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
  • 6 Working with INTERVAL data types