دانلود Lynda Oracle Database 12c Tutorial Series - آموزش پایگاه داده اوراکل 12c

Topics include:
- Design methodology and tools
- SQL query basics
- Advanced data manipulation
- Modifying and creating a database object
- Database architecture
- DBA configuration tools
- Managing tablespaces and disk space
- Table compression
- Manage system-related tablespaces
- Database monitoring

Oracle 12c Database: Administration
David covers the Oracle database architecture in detail, including the shared pool, buffer cache, and physical and logical storage structures. He also discusses concepts such as tablespaces, data files, and redo logs. He then moves onto installation and configuration of the database itself, reviewing the Oracle CLI and GUI administration and development tools and typical administration tasks, including backup and recovery.

After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.

Topics include:
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management

Oracle Database 12c: Backup and Recovery
Learn how human errors, hardware failures, and even storage loss can affect your database, and how you can leverage the technologies and features built into Oracle 12c to ensure you will never suffer any data loss. Discover how to use various Oracle tools and technologies, including RMAN, Data Pump, Flashback, and hot and cold backups, to protect your database from the inevitable crash.

Learn how human errors, hardware failures, and even storage loss can affect your database, and how you can leverage the technologies and features built into Oracle 12c to ensure you will never suffer any data loss. Discover how to use various Oracle tools and technologies, including RMAN, Data Pump, Flashback, and hot and cold backups, to protect your database from the inevitable crash.

Topics include:
- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points

Oracle Database 12c: Security
Database security is one of the hottest topics for Oracle DBAs, and one of the most important aspects of their role. With the increasing risks of cyberattacks, database hacks, and data leaks, knowing how to fully enable and leverage all of the Oracle 12c security features is essential. In this course, Oracle instructor and consultant David Yahalom covers this vitally important and in-demand skill.

Learn how to identify the major risks and security threats, and review general best practices for properly protecting and "hardening" any production database. Then, dive into hands-on demos that show how to set up user accounts, the connection between users and schemas, database object and system permissions, and roles in a multitenant environment, as well as encrypt data, audit user actions, and access to sensitive information. Plus, find out how to enable data-at-rest security via the Oracle Transparent Data Encryption and backup encryption options.

Topics include:
- Core concepts of Oracle database security
- Potential threats to Oracle database security
- Authentication and authorization
- Auditing access
- Data encryption
- Users and permissions
- Database roles

Oracle Database 12c: Basic SQL
Mastering the SQL language is an essential skill for any Oracle professional and is the first step in becoming a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, Oracle instructor and consultant David Yahalom covers the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions. David also provides an overview of advanced concepts, such as constraints and subqueries.

Topics include:
- Using Oracle SQL*Developer, the free development environment
- Selecting data from tables
- Filtering data
- Using functions to manipulate data
- Joining data from tables
- Creating tables
- Updating values
- Truncating data
- Grouping and ordering result sets
- Working with primary keys
- Checking constraints