Oracle SQL for development and database management Treningskurs

  1. Database Trening
  2. Oracle Trening
  3. Oracle SQL for development and database management Treningskurs

Last updated

Kurskode

osqldevdm

Varighet

35 timer (vanligvis 5 dag inkludert pauser)

Oversikt

Dette 5-dagers kurset demonstrerer hvordan du bruker Oracle SQL til databaseutvikling og databasestyring.

Machine Translated

Kursplan

Database Development

  • Recapping the basic principles behind relational databases
    • Concepts and terminology     
  • Retrieving data using the SELECT statement
  • Using simple and more complex JOINS to retrieve data from multiple tables
    • SELF, INNER and OUTER joins
  • Restricting and sorting data, conditional expressions
    • Single row functions: string, date and time manipulation
    • IF-THEN-ELSE statements
  • Conversion of data between types
  • Creating aggregated reports
  • Using correlated and uncorrelated subqueries in SELECT statements
  • Retrieving and manipulating data using subqueries
  • Running Data Manipulation Statements in Oracle to manage database transactions
  • Query optimisation and efficiency

Database Management

  • The Oracle Data Dictionary: introduction and usage
  • Creating views, indexes, constraints and synonyms
  • Controlling and revoking user access to schema objects (tables, views)
  • Managing indexes and constraints

Testimonials

★★★★★
★★★★★

Related Categories

Oracle OpplæringskursOracle
SQL OpplæringskursSQL

Relaterte kurs

Developing Applications with Oracle Application Express (APEX)SQL FundamentalsSQL Advanced in MySQLAdvanced SQL, Stored Procedures and Triggers for Microsoft SQL ServerSQL in SQL ServerSQL in Microsoft AccessORACLE PL/SQL FundamentalsORACLE SQL FundamentalsTransact SQL BasicTransact SQL AdvancedSQL in MySQLOracle SQL for beginnersOracle SQL AdvancedOracle SQL IntermediateOracle SQL Intermediate - Data Extraction

Kursrabatter

Microsoft Cognitive Toolkit 2.x

2022-05-23 09:30
21 timer

Natural Language Processing with Python

2022-06-07 09:30
28 timer

Data Science with KNIME Analytics Platform

2022-06-29 09:30
21 timer

Systems Security Certified Practitioner

2022-08-03 09:30
35 timer

OCEB Certified Expert in BPM - Technical Intermediate Exam Preparation

2022-08-18 09:30
14 timer
See All

Kursrabatter Nyhetsbrev

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Norway!

As a Business Development Manager you will:

  • expand business in Norway
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions