Oracle Database 11g SQL Fundamentals 1 1Z0-051

Total Course Duration: 10:29:23

Course Introduction 00:18:23
In this nugget, we start by defining what Oracle is and how it fits into the concepts of the database, relational database, and relational database management system. Next we perform a deep-dive into the Oracle certification program, learning exactly how the current course maps to the Oracle Certified Associate (OCA) credential. We also provide tips and tricks for getting the most out of the training, and give suggestions on how to pass the 1Z0-051 exam with a minimum of muss or fuss.

About SQL 00:41:33
In this nugget, we set the stage for the rest of the training. Here we formally define the Structured Query Language (SQL), explaining its basic modes of operation, as well as how Oracle's implementation of SQL stacks up to the ANSI/ISO standard as well as other vendors' implementations. We complete this nugget with quick-start tutorials on how to use SQL*Plus as well as Oracle SQL Developer.

Retrieving Data By Using the SELECT Statement 00:38:10
The SELECT statement is the universal workhorse of SQL. In this nugget we discuss both the theory and practice of using SELECT to retrieve query results from Oracle database.

Restricting and Sorting Data 00:37:24
In this nugget we continue our discussion of the SQL SELECT statement, this time learning how to pare down our query results by employing the powerful WHERE clause. We also learn how to sort our query results by leveraging the ORDER BY statement, and finally begin to write more dynamic, interactive SQL by using substitution variables.

Using Single-Row Functions to Customize Output 00:36:51
In this nugget we introduce the concept of the function, both from a general mathematics standpoint, and then with sharper focus on Oracle Database 11g. We spend our time learning to master the basic character, number, and date functions that you'll be expected to understand on the SQL Fundamentals certification exam.

Reporting Aggregated Data Using the Group Functions 00:30:04
In this nugget we apply many of the function-related principles we picked up in the previous nugget. Here we learn how to aggregate data across multiple table rows by employing both grouping functions as well as the GROUP BY SQL statement. We also will understand how to filter grouped rows by using the HAVING clause.

PL/SQL Basics 00:36:03
In this nugget we truly round out our Oracle SQL skills by conducting a survey of PL/SQL, Oracle's procedural programming extensions to the Structured Query Language. By the end of this nugget you will not only understand the basic nomenclature and syntax of PL/SQL, but you'll also be able to write basic PL/SQL blocks, both the anonymous and named varieties.

Displaying Data from Multiple Tables 00:38:11
In this nugget we truly begin to see the great beauty of the relational database model. Here we learn how to query across multiple related tables by using joins. In addition to learning all about the supported join types in Oracle Database, we will also flirt around with the concept of constraints, two of which (primary key and foreign key) are crucial to our understanding of the relational model.

Using Subqueries 00:24:21
In this nugget we broaden and deepen our usage of the SELECT statement by learning how to embed one SELECT inside of another SELECT; this is called a subquery. As we'll learn, subqueries are useful for data load scenarios as well as when we aren't quite sure which row(s) we need to evaluate in a WHERE clause. By the end of this nugget you will not only understand how subqueries work, but you'll be able to write both single-row and multi-row subqueries in either the simple or correlated processing formats.

Using the Set Operators 00:23:51
SQL is a set-oriented database access language. In this nugget we learn various methods of combining multiple result sets. Here we master the use of the UNION, MINUS, and INTERSECT keywords in combining multiple queries into a single result set.

========================================================================

Oracle Database 11g DBA 1 1Z0-052

Total Course Duration: 12:33:06

Course Introduction 00:19:22
What is Oracle? About Oracle Certification. How This Course Works. Tackling the 1Z0-052 Exam. Summary: In this nugget we introduce the series. We describe Oracle Database 11g, learn how Oracle certification works, determine your best path through this training, and finally pick up important metadata concerning the 1Z0-052 test.

Exploring the Oracle Database Architecture 00:57:16
Database Basics. Memory Structures. Process Structures . Storage Structures. Summary: We begin our training my examining the architectural underpinnings of Oracle Database 11g. This theory is important not only for our exam success, but also to give us a framework for later lessons on performance tuning and troubleshooting. Related Exam Objectives: Explain the Memory Structures; Describe the Process Structures; Overview of Storage Structures

Preparing the Database Environment 00:40:29
Planning an Oracle Database Installation. Installing the Oracle software. Summary: In this nugget we learn how to install and configure Oracle Database 11g software. We'll learn that while installation on Windows is far easier than installation on NIX, the basic installation process is the same, thanks to the Oracle Universal Installer (OUI) Java application. Related Exam Objectives: Plan an Oracle Database installation; Install the Oracle software by using Oracle Universal Installer (OUI)

Creating an Oracle Database 00:50:04
Using the Database Configuration Assistant. Oracle Database Administration Tools. Summary: This nugget serves as a nice bookend to what we covered in the previous nugget. Whereas in the previous lesson we learned how to install the Oracle 11g instance (that is, background processes and memory structures), in this nugget we install an actual database by using the Database Configuration Assistant (DBCA) utility. Related Exam Objectives: Identify the tools for Administering an Oracle Database; Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance Part 1 00:49:25
Stages of Database Startup and Shutdown. Database Initialization Parameters. Summary: Now that we have Oracle Database 11g fully set up, we learn how to manage the startup and shutdown processes (these are actually more complex than you might initially think). We also introduce the critical subject of initialization parameters and how they are stored in the server parameter file (SPFILE). Related Exam Objectives: Setting database initialization parameters; Describe the stages of database startup and shutdown

Managing the Oracle Instance Part 2 00:31:32
Alert Log and Trace Files. The Data Dictionary. Dynamic Performance Views. Summary: As we delve deeper into Oracle DBA concepts, we examine the alert and trace logs, both rich sources of diagnostic and performance information. We also formally define the data dictionary and learn to query both data dictionary views and dynamic performance views to gather instance/database metadata. Related Exam Objectives: Using alert log and trace files; Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment 00:47:20
Configuring and Managing the Oracle Network. Using the Oracle Shared Server Architecture. Summary: As you know, Oracle Database 11g is a client/server relational database management system (RDBMS). To that end, in this lesson we learn how to configure the Oracle network environment for maximum reliability, performance, and security. We also differentiate between the dedicated server and shared server process architectures, weighing the relative pros and cons of each approach. Related Exam Objectives: Configure and Manage the Oracle Network; Using the Oracle Shared Server architecture

Managing Database Storage Structures 00:39:54
Reviewing Oracle Data Storage. Understanding Tablespaces and Datafiles. Creating and Managing Tablespaces. Summary: As we know, the physical files are what comprises the Oracle 11g database, proper. To wit, in this nugget we review the relevant terminology: stuff like datafiles, control files, and the logical storage construct known as the tablespace. Related Exam Objectives: Overview of tablespace and datafiles; Create and manage tablespaces; Space management in tablespaces

Administering User Security 00:47:49
Creating and Managing Database User Accounts. Granting and Revoking Privileges. Creating and Managing Roles. Creating and Managing Profiles. Summary: Oracle databases often contain highly sensitive data. Therefore, keeping the database as secure as possible is a chief task of any Oracle DBA. In this lesson we learn how to create and manage user accounts. We then examine how best to grant and revoke permissions by using roles. Finally, we learn how to institute password complexity rules and resource utilization limits by rolling out profiles. Related Exam Objectives: Create and manage database user accounts; Grant and revoke privileges; Create and manage roles; Create and manage profiles

Managing Data and Concurrency 00:40:26
Understanding Transactions. Monitoring and Resolving Locking Conflicts. Summary: Any RDBMS worth its salt will support multiuser access. Oracle 11g is known particularly for its adherence to the ACID properties of database transactions. By concluding this nugget you will understand how to define and manage transactions in Oracle. You will also learn how to diagnose and resolve user process locking problems. Related Exam Objectives: Monitor and resolve locking conflicts; Transactions and undo data

Managing Undo Data 00:29:31
Multiplexing the Redo Log Files. Understanding Undo. Managing Undo. Summary: Undo data in Oracle enables us to restore previous data values if needed as well as provides us with multi-user access to database data. In this nugget we'll learn how to multiplex the redo log files and manage the undo tablespace and datafiles. Related Exam Objectives: Overview of Undo; Transactions and undo data; Managing undo

Implementing Oracle Database Security 00:34:00
Reviewing Database Security Tasks. Using Standard Database Auditing. Summary: Here we revisit the subject of database security (it's a really important concept if you haven't put that together yet). Specifically, here we concentrate on a "laundry list" of security-related DBA tasks. Then we transition into a consideration of standard database auditing. Related Exam Objectives: Database Security and Principle of Least Privilege; Work with Standard Database Auditing

Database Maintenance 00:42:01
Managing Optimizer Statistics. Managing Automatic Workload Repository. Using Advisory Framework. Setting Alerts. Summary: Like a vehicle or most other mechanical possessions, we need to perform regular maintenance to keep those items tuned up. The same thing goes for Oracle Database 11g. In this nugget we get a flying head start on the myriad self-tuning options supported by Oracle Database 11g. Sometimes we might think that Oracle does self-management so well that we can leave the DBA business! Related Exam Objectives: Use and manage optimizer statistics; Use and manage Automatic Workload Repository (AWR); Use advisory framework; Manage Alerts and Thresholds

Performance Management 00:26:20
Using Automatic Memory Management. Using Memory Advisors. Troubleshooting Invalid and Unusable Objects. Summary: While performance tuning is a major subject on the Oracle Certified Professional (OCP) exam, here we cover the basics. We learn to tune memory and then discover and correct invalid/unusable database objects. Related Exam Objectives: Use Automatic Memory Management; Use Memory Advisors; Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements 00:34:50
Using the Enterprise Manager Support Workbench. Managing Patches. Summary: Oracle support is not free, but if you have it you'll doubtless find it very comprehensive and extremely helpful. In this nugget we learn the basic mechanics of how to file issues with Oracle Support. Related Exam Objectives: Use the Enterprise Manager Support Workbench; Managing Patches.

Backup and Recovery Concepts 00:31:41
Identifying Oracle Database Types of Failure. Tuning Instance Recovery. Checkpoints, Redo Log Files, and Archived Log Files. Configuring ARCHIVELOG Mode. Summary: Like performance tuning, backup and recovery is the other "centerpiece" subject on the OCP exams. Here we, again, cover the basic principles of this vast subject. Specifically, here we focus on backup and recovery concepts and the notion of database recovery. Related Exam Objectives: Identify the types of failure that can occur in an Oracle database; Describe ways to tune instance recovery; Identify the importance of checkpoints, redo log files, and archived log files; Overview of flash recovery area; Configure ARCHIVELOG mode

Performing Database Backups Part 1 00:37:23
Creating Consistent Database Backups. Performing a Hot Backup. Creating Incremental Backups. Summary: This is part one of a three-part nugget miniseries on performing Oracle backups and restores. This particular nugget teaches you the "nuts" and bolts of performing backups by using both the RMAN utility as well as Oracle Enterprise Manager (OEM). Related Exam Objectives: Create consistent database backups; Back up your database without shutting it down; Create incremental backups

Performing Database Backups Part 2 00:31:32
Automating Database Backups. Managing Backups. Viewing Backup Reports. Summary: In this nugget we continue our discussion from the previous lesson. Here we examine how to script out/automate database backups and examine backup reports. Related Exam Objectives: Automate database backups; Manage backups, view backup reports and monitor the flash recovery area

Performing Database Recovery 00:29:45
Understanding Data Recovery Advisor. Performing Recovery (Control file, Redo Log File and Data File). Summary: In this nugget we look at the other side of the disaster recovery coin: that is, how to restore all or part of an Oracle 11g database by using RMAN and OEM. Related Exam Objectives: Overview of Data Recovery Advisor; Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

Moving Data 00:32:26
Moving Data (Directory Objects, SQL*Loader, External Tables). Understanding Oracle Data Pump. Using Data Pump Export and Import. Summary: We complete the training by learning to use the built-in Oracle tools for performing data import and export. This supports technologies and scenarios such as data warehousing and Extract-Transform-Load (ETL). Related Exam Objectives: Describe and use methods to move data (Directory objects, SQL*Loader, External Tables); Explain the general architecture of Oracle Data Pump; Use Data Pump Export and Import to move data between Oracle databases

Using DDL Statements to Create and Manage Tables 00:46:29
In this nugget we formally treat the subject of creating, altering, and dropping database objects; this collection of SQL commands is formally called Data Definition Language, or DDL. In this nugget we start with a high-level overview of the major database objects. We then follow up with learning how to design and create tables, and then conclude with a consideration of the importance and use of integrity constraints in database tables and views.

Creating Other Schema Objects Part 1 00:31:43
In this nugget we continue the discussion we opened in the previous nugget on DDL statements in Oracle Database 11g. Here we learn how to design and implement sequences and views.

Creating Other Schema Objects Part 2 00:34:39
Indexes, when properly designed and used, can dramatically speed up query performance in an RDBMS. In this nugget we cover the fundamental points concerning indexes. We also learn just what synonyms are--not in the English grammar context, but instead in the Oracle database nomenclature.

Manipulating Data Part 1 00:30:32
Thus far in the course we have covered the use of SELECT and the DDL command suite. Formally speaking, SELECT is actually one of the Data Manipulation Language (DML) statements in SQL. In this nugget we cover two of the major DML players, namely the INSERT and UPDATE statements.

Manipulating Data Part 2 00:30:34
In this nugget we "book end" our discussion from Nugget #14, wrapping up our consideration of basic DML by investigating the finer points of the DELETE statement. We also define and discuss what database transactions are as well as how to control their operation in Oracle Database 11g.

Basic Oracle Database Security 00:35:14
Relational database security is a huge topic and can constitute a very lucrative career for those who are so talented and interested. In this nugget we survey some of the major principles behind user account security in Oracle Database 11g. In particular, we learn how to create and administer Oracle user accounts. We then delve into access control, learning how to leverage the GRANT and REVOKE statements. We complete this nugget with some best-practice advice on leveraging database roles to make our database security more efficient and effective.

Accessing the Data Dictionary 00:22:19
The data dictionary in Oracle Database 11g is a read-only collection of tables that stores metadata about the database. As such, an understanding of the data dictionary is crucial for anyone who presents himself or herself as an Oracle DBA. By the conclusion of this nugget you will not only be able to intelligently discuss the data dictionary, but you will also know how to query the data dictionary views as an ordinary schema (user) and as a DBA.

Referencing the Oracle Documentation 00:22:24
While Oracle's documentation library is presented to the public at no charge, Oracle keeps much of the "good stuff" behind a paywall for, well, paying Oracle Support customers. The purpose of this nugget is to deeply familiarize you with the free and excellently written/organized corpus of technical documentation in the Oracle Web site. This is a best-kept secret of Oracle, and you should make the official Oracle Documentation a daily read as you build your skill set up and out.

Using Oracle Flashback Query 00:24:57
In the life of the DBA, restoring data that was accidentally or intentionally dropped or deleted can be a fairly regular occurrence. Here we turn to the nifty Flashback technology in Oracle Database 11g to learn first of all how Flashback works, and then how we can leverage Flashback to recover individual rows or entire tables from the ether. We'll also spend some time with the Oracle Recycle Bin.

Query Optimization Basics 00:25:41
In this concluding nugget of the series we apply everything we've learned over the course of this training and pick up some practical advice on how to tune and optimize our SQL queries. To start with we will explain how Oracle parses (interprets) SQL. We will then practice using the EXPLAIN PLAN statement to view the fine details of Oracle's query execution plans. Finally, we finish up with a "laundry list" of strategies for customizing how Oracle builds its execution plans.

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV

Payment mode : Pay on my account ,Buying via ebay or Paypal

Shipping : By Courier through all over India

Shipping charge : Rs 50/- Flat Rate shipping anywhere in India

You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs