Qafqaz University lessons (.doc and .ppt)
Posted by Kamran Agayev A. on November 24th, 2008
As I’m a teacher at Qafqaz University, for every lesson I’m preparing Power Point slides and shortened documentation. From the links below, you can download these lessons
Lesson 1 Oracle Database Architecture, Oracle Processes, Physical Database Structure
Lesson 2 Oracle tools, Planning Oracle Database Installation, Installing Oracle Database, Creating an Oracle Database
Lesson 3 Starting up the Database, Shutting down the Database, Oracle Environment, Using Sql*Plus, Tablespaces (Altering, Dropping)
Lesson 4 Managing Control Files (Create, Backup, Drop, Display), Managing RedoLog Files (Create, Rename, Switch, Clear), Managing ArchiveLog Files
Lesson 5 Managing Tables (Create, Load, Alter, Drop), Managing Indexes (Create, Alter, Drop), Managing Views, Sequences, Synonyms (Create, Replace, Update, Alter, Drop)
Lesson 6 PL/SQL Objects, Procedures, Fuctions, Packages, Trigger; Locks – Lock Conflicts, Resolving Lock Conflicts, Deadlocks
Lesson 7 User Management, Granting and Revoking Privileges (Object, System Privileges), Roles, Profiles
Lesson 8 Oracle Database Security, Managing Default User Accounts, Password Security (Profile), Audit Database Activities
Lesson 9 Data Integrity (Constraints) – Unique, NOT NULL, Primary Key, Foreign Key, Check
Lesson 10 Undo Management – Overview, Configuration Undo Retention, Use Undo Advisor
Lesson 11 Backup and Recovery Issues, Categories of Failures, Configuring a Database for Recoverability
December 10th, 2008 at 8:23 am
thanks teacher.
December 10th, 2008 at 10:02 am
You’re welcome cui !
December 10th, 2008 at 8:37 pm
Thank you for everything teacher,I hope we’ll all justify your hopes,I believe that…
December 10th, 2008 at 8:43 pm
I also believe Mr. Shappi
February 11th, 2009 at 2:11 pm
Oooo, tebrikler, tebrikler. Allah davamini getirsin Inshallah. Sag eliniz bizim bashimiza:))
February 11th, 2009 at 3:03 pm
Cox saqol Ehmed
O gun olsun sizlerin de bele birer sertifikalariniz olsun, men de bir melliminiz kimi sizinle fexr edim
February 16th, 2009 at 5:50 pm
Tebrikler Kamran muellim,o gun olsun OCM olasiz,biz de bir telebeniz kimi fexr edek :)))
February 16th, 2009 at 5:52 pm
Saqol Sefi
Eslinde sizlere de guvencim var ve inaniram ki, zaman kecdikce sizlerin de gelecekde yaradacaqi Oracle Blog-larinizda sertifikalarinizi gorub men de sizin bir melliminiz kimi sizinle fexr edecem inshallah
November 17th, 2009 at 3:42 pm
Thanks..Sir.
Regards
Azar
November 3rd, 2012 at 6:08 am
Thank you so much sir
November 13th, 2012 at 3:42 am
Thank you so musch our lovely teacher
June 19th, 2013 at 1:38 am
It’s a very useful one. But I a unable to download the lesson 9, 10 and 11. Is it possible to send a mail or download it any other way?
August 23rd, 2013 at 5:15 am
tks ，but I cann’t download the lesson 9,10,11.can you tell me how to download all? thank you so much!