Konsultasiya almaq
Training Center MUKКурсыOracleDatabaseOracle Database 11g: Основы SQL – I

Oracle Database 11g: SQL Fundamentals I

Kursun kodu
OD11gSQL
Müddət
3 Gün, 24 Saat
Kursun təsviri
Məqsədlər
Tələblər
Kursun proqramı
Kursun təsviri

Course overview

This Oracle Database 11g: SQL Fundamentals I – Self-Study Coursec is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology. Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated.

Məqsədlər

Course objectives

  • To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting
  • To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return value
  • To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE
  • To recognize the steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries
Tələblər

Audience

  • Administrator
  • Architect
  • Database Administrator
  • Developer
Kursun proqramı

Course Topics

1.Oracle Database 11g: Using SQL to Query Your Database

  • Using SQL in Oracle Database 11g
  • Retrieving, Restricting and Sorting Data
  • Using Single-Row Functions

2. Oracle Database 11g: Conversion Functions, Group Functions, and Joins

  • Conversion Functions and Conditional Expressions
  • Group Functions and Joins

3. Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation

  • Using Subqueries and Set Operators
  • Manipulating Data

4. Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
Ən yaxın kurs üçün qeydiyyat
Oracle Database 11g: SQL Fundamentals I
Kursun kodu:
OD11gSQL
Müddət:
3 Gün, 24 Saat
Qeydiyyatan keç
Konsultasiya almaq
Свяжитесь со мной
Konsultasiya almaq
Отправить заявку
Vebinara qeydiyyat
Отправить заявку
Müraciətiniz qəbul olundu!
Yaxın zamanda sizinlə əlaqə saxlanılacaq.