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

Relaterte kurs

Kursrabatter

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