پیشنهاد فرادرس

آموزش Oracle 12c

دسته بندی ها: پایگاه داده ، آموزش های Infinite Skills ، آموزش اوراکل (Oracle)

آموزش-oracle-12c

این دوره آموزشی مباحث مهم مربوط به نصب، راه اندازی و کار با Oracle 12c را آموزش می دهد.

این دوره محصول Infinite Skills می باشد.

سرفصل های دوره آموزشی:

  • معرفی دوره
  • Oracle چیست؟
  • کار با Virtualization
  • کار با Oracle RDBMS
  • آپشن های پایگاه داده Oracle
  • نصب نرم افزار Oracle
  • ایجاد پایگاه داده Planning
  • اجرای NETCA  و  DBCA
  • راه اندازی توسعه دهنده SQL
  • SQL چیست؟
  • Select کردن
  • Delete کردن
  • توابع  Single Row
  • کار با  PL و SQL
  • ادغام داده ها
  • کار با  Block ها
  • کار با Extent ها
  • کار با Segment ها
  • مدیریت Automatic Storage
  • آبجکت های پایگاه داده
  • استفاده از Temporary
  • کار با Indexe های Bitmap
  • کار با Foreign Key
  • کار با  Check Constraint
  • اصلاح پارامترها
  • مدیریت حافظه
  • استفاده از External

لیست سرفصل های دوره آموزشی:

In this Oracle 12c training course, expert author Steve Ries will teach you how to everything you need to know about the newest version of the Oracle database system. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle is needed.

You will start by learning about the Oracle database technology, including learning the database architecture of Oracle and how to install the software on your computer. This video tutorial will cover topics such as how to create an Oracle database, basic SQL and PL/SQL, storage structures, database objects, security, backup and recovery, and Oracle administration tasks. Finally, you will learn about data migration and Oracle networking.

Once you have completed this computer based training course, you will have a fundamental understanding of how an Oracle database functions, and how database concepts apply to the latest version of Oracle.

01. Introduction What You Should Expect From This Course About The Author What is Oracle? 0104 How To Access Your Working Files 02. The Oracle Technology Family Hardware Operating Systems Virtualization Middleware And Java 03. Oracle Database Technology What Is A Database? Oracle RDBMS Oracle Database Server Editions Oracle Database Server Versioning Oracle Database Options Software Documentation SQL Developer 04. Database Architecture 0401 The Oracle RDBMS - Instance And Database 0402 The Instance - Background Memory Processes 0403 The Instance - System Global Area 0404 The Instance - Program Global Area 0405 The Database - Core Datafiles 0406 The Redo Architecture 0407 Real Application Clusters 0408 Container Databases 0409 Pluggable Databases 05. Installing The Oracle Software 0501 Planning An Installation 0502 The Oracle Universal Installer 0503 Installing The Software - Part 1 0504 Installing The Software - Part 2 06. Creating An Oracle Database 0601 Planning Database Creation 0602 Running NETCA And DBCA 0603 Stepping Through Database Creation - Part 1 0604 Stepping Through Database Creation - Part 2 0605 Stepping Through Database Creation - Part 3 0606 Setting Up The SQL Developer 07. Structured Query Language (SQL) 0701 What Is SQL? 0702 Select 0703 Insert 0704 Update 0705 Deletes 0706 Joins 0707 Single Row Functions 0708 Data Aggregation 0709 Optimizer And Execution Plans 0710 Transactions And Concurrency 08. PL And SQL 0801 What Is PL And SQL? 0802 Anonymous Blocks 0803 Procedures 0804 Functions 0805 Packages 0806 Object Types 09. Oracle Storage Structures 0901 Blocks 0902 Extents 0903 Segments 0904 Datafiles 0905 Smallfile Tablespaces 0906 Bigfile Tablespaces 0907 Automatic Storage Management - ASM 10. Database Objects 1001 Tables 1002 Partitions 1003 Temporary Tables 1004 B-tree Indexes 1005 Bitmap Indexes 1006 Index Organized Tables 1007 Function Based Indexes 1008 Views 1009 Primary And Unique Keys 1010 Foreign Keys 1011 Check Constraints 1012 Synonyms 1013 Sequences 11. Database Security 1101 Principles Of Database Security 1102 Oracle Schema Based Approach 1103 Creating And Dropping Users 1104 System Privileges 1105 Object Privileges 1106 Roles 1107 Profiles 1108 Auditing 12. Database Administrative Tasks 1201 Instance Startup 1202 Instance Shutdown 1203 Parameter File 1204 Modifying Parameters 1205 The Data Dictionary 1206 Password File 1207 ADRCI 1208 Alert Log And Trace Files 1209 Memory Management 1210 Monitoring Sessions 1211 Monitoring Space Usage 13. Database Backup And Recovery 1301 Backup And Recovery Concepts 1302 RMAN Backups 1303 RMAN Incremental Backups 1304 RMAN Complete Recovery 1305 RMAN Incomplete Recovery 1306 RMAN Backup Maintenance 14. Data Migration 1401 SQL Loader 1402 External Tables 1403 Data Pump Export 1404 Data Pump Import 15. Oracle Networking 1501 Understanding Oracle Connections 1502 Networking Configuration Files 1503 Listener Control 16. Conclusion

عنوان دوره: InfiniteSkills - Learning Oracle 12c Training Video حجم فایل: 1.04GB

آیا این نوشته را دوست داشتید؟
InfiniteSkills Learning Oracle 12c Training Video

پیشنهاد فرادرس

irani در 1393/04/22 ساعت 16:22

سلام
اگه زیاد خرید کنیم تخفیفم میدین؟