Oracle 11g Tutorial Video. And Oracle database 11g tutorial for beginners will show how. Free Online Oracle Tutorial Videos in Bangla for the students of.

1. Oracle 11g Create Database Example

This tutorial is designed for the beginner. This training will teach you the basics of what it means to administer an Oracle Database. Throughout the training, you will be able to better understand the path you can continue on from here, whether that is to become a DBA, developer or administrator of Oracle Databases.

You will learn about processes and architectural concepts of a database. This video training also covers topics such as storage, data modelling, basic SQL, database tasks, and how all of these apply specifically to Oracle Databases. Release Name: InfiniteSkills – Learning Oracle 11g Training Video-P2P Size: 983 MB Content: 01. Introduction 0101 What Is Oracle 0102 What You Should Expect From This Course 0103 Download And Install Oracle 02. The Technology - OS, Middleware, And Hardware 0201 Operating Systems 0202 Middleware 0203 Hardware 03. The Technology - Database 0301 What Is A Database? 0302 What Are The Types Of Database?

0303 MySQL 0304 TimesTen 0305 BerkleyDB 0306 NoSQL 0307 Oracle Database Server 0308 Oracle Database Server Editions 0309 Documentation And Software 04. Database Architecture 0401 Operating Systems Supported 0402 Database Server 0403 The Database 0404 Database Instance 0405 Background Memory Processes 0406 User Memory Processes 0407 System Global Area 0408 Program Global Area 0409 Networking 0410 Oracle Net Listener 0411 Real Application Clusters 05.

Storage 0501 Blocks 0502 Extents 0503 Segments 0504 Tablespaces 0505 Data Files 0506 Control Files 0507 Redo Log Files 0508 Parameter File 0509 Password File 0510 Fast Recovery Area 0511 Alert Logs 0512 Trace Files 0513 ASM, Grid And Cloud 06. Database Structures 0601 The Data Dictionary 0602 Schemas And Users 0603 Tables 0604 Partitions 0605 Temp Tables 0606 B-tree Indexes 0607 Index Organized Tables (IOT) 0608 Bitmap Indexes 0609 Function Based Indexes 0610 Views 0611 Primary And Unique Keys 0612 Foreign Keys 0613 Check Constraints 0614 Synonyms 0615 Table Clusters 0616 Sequences 0617 Object Statistics 0618 Performance Views 07. Oracle IDEs 0701 Oracle SQL Plus 0702 SQL Developer 0703 Oracle Universal Installer (OUI) 0704 Oracle Enterprise Manager (OEM) 0705 Oracle Database Configuration Assistant (ODCA) 08.

Oracle 11g Create Database Example

Structured Query Language (SQL) 0801 What Is SQL 0802 Select 0803 Insert 0804 Update 0805 Joins 0806 Deletes 0807 Merge 0808 Aggregates 0809 SQL Analytics 0810 Optimizer And Explain Plan 0811 Transactions And Concurrency 09. PL/SQL 0901 What Is PL/SQL 0902 Anonymous Blocks 0903 Procedures 0904 Functions 0905 Packages 0906 Object Types 0907 Dynamic SQL 0908 Application Express (ApEx) 10. XML 1001 What Is XML 1002 What Is XMLDB 1003 XMLType 1004 SQL/XML 1005 XQuery 1006 XML Repository 1007 XML Storage Models 11.Analysis Tasks With Oracle Data Modeler 1101 Data Modelling 1102 The Conceptual Model 1103 The Logical Model 1104 The Physical Model 1105 Deploying A Data Model 1106 Reverse Engineering 12. Database Tasks 1201 Backup And Recovery 1202 Startup And Shutdown An Instance 1203 The Listener 1204 Create And Remove Users 1205 Monitor Sessions 1206 Monitor Resources 1207 Monitoring Space Usage 1208 Adding Space 1209 Freeing Space 1210 Replication And Streams 1211 Database Scheduling 13.Data Import/Export 1301 SQL Loader 1302 External Tables 1303 Data Pump 1304 SQL Plus 1305 SQL Developer 1306 ETL Tools 14. Database Security 1401 Database Security 1402 Data Control Language (DCL) 1403 System And Object Privileges 1404 Roles 1405 DBA And Developer Access 1406 Virtual Private Database (VPD) 1407 Fine Grained Auditing (FGA) 1408 Transparent Data Encryption (TDE) 1409 SQL Injection 15. Very Large Databases (VLDB) 1501 VLDB 1502 OLAP 1503 Data Mining.

This series is for everyone. There are a few gems in these tutorials for everyone. I'm glad to finally have discovered how to encapsulate data and hide details within packages.

Learned how to create private data members, private functions and  private procedures within a package. I'll share the "secret": Just leave those items out of the package specification. Put them in the package body only. The interface is not bad, but I wonder if it's easy to author and publish presentations using this tool. Is that an Oracle technology? Well done, A.