Inhalt: In this course, Oracle expert and author Bob Bryla goes beyond the fundamentals of administering an Oracle database, and dives deep into the skills an Oracle power user needs to know. Bob reviews the database architecture and shows how a database administrator (DBA) can more effectively manage and configure an Oracle database. At the same time, he explains the database''s features that enable a business intelligence (BI) developer to effectively write applications using Oracle Database 12c. Umfang: 02:57:22.00
Inhalt: Get up and running with Oracle Database 19c, the latest version of the popular relational database management system (RDBMS), and learn how it can help enhance your database design and deployment process. Throughout this course, instructor Bob Bryla covers the fundamentals of administering Oracle Database 19c. Discover how to install the RDBMS on Linux, manage the database and query tables using the SQLcl command-line tool, and efficiently move data in and out of your database tables using SELECT and DML statements, respectively. Plus, learn how to create, assign, and drop tablespaces, as well as how to create and drop user accounts. Umfang: 02:00:02.00
Inhalt: Mastering SQL is an essential skill for any Oracle Database professional. If you feel like you've got a firm handle on the basics and want to take your skills up a notch, this course is for you. Join Oracle Database administrator Bob Bryla as he covers the advanced features of Oracle SQL in an Oracle 19c Database environment. Bob explains advanced topics like database concurrency and isolation levels, Oracle-specific schema objects, data types, data models, and many more features you need to understand to become an Oracle SQL expert. At the end of this course, if you're still hungry for more, Bob provides a list of resources to help you continue your learning. Umfang: 02:01:34
Inhalt: Mastering SQL is an essential skill for any Oracle professional and the first step in becoming a true Oracle expert. In this course, Bob Bryla covers the basics required to code using SQL in an Oracle 19c Database environment. Bob covers what you need to know to get data in and out of your database tables, as well as how to modify data. He explains how to leverage SELECT statements, filter and sort rows, use both single- and multiple-row functions, and join tables. He delves into the Oracle data dictionary-a set of tables that provide information about a database-and shows how to query it. Plus, he demonstrates how to efficiently delete data using DML statements. Upon wrapping up this course, you'll have the fundamental skills you need to work with SQL in this popular relational database management system. Umfang: 03:28:24.00
Inhalt: Oracle introduced the multitenant architecture in version 12.1.0.2 as an available option, but after 19c, creating a multitenant database is the only option for a new database. In this course, Oracle database administrator Bob Bryla helps DBAs create and effectively utilize resources within multitenant databases. Bob shows how to manage one or more multitenant databases on the same server, how to create the CDB, create a PDB from the seed database, and clone a PDB to the same or another container. The multitenant architecture also has several new options when backing up and recovering databases and individual tables with the existing RMAN utility, so Bob explains new RMAN scenarios and details when to back up just the CDB root, the entire CDB, or individual PDBs. He also covers how to create and manage a special type of PDB called an application PDB, also known as an application container, and shows how to leverage the versioning capabilities included with application containers. Umfang: 01:30:50
Inhalt: PL/SQL is the companion programming language to Oracle Database. Having a modern programming language that integrates with the database itself makes the Oracle Database platform scalable and extensible for more applications. In this course, Bob Bryla reviews the major features of Oracle PL/SQL under Oracle Database 19c. Bob covers key aspects of this procedural language, including looping, conditional statements, and exception handling when something goes wrong. He shows how to more effectively use the built-in procedures of PL/SQL, as well as write your own. Plus, he covers the PL/SQL security model and demonstrates how to run SQL queries and DDL statements from within PL/SQL. Umfang: 01:43:58
Programm Findus Internet-OPAC findus.pl V20.235/8 auf Server windhund2.findus-internet-opac.de,
letztes Datenbankupdate: 09.05.2024, 13:27 Uhr. 964 Zugriffe im Mai 2024. Insgesamt 511.194 Zugriffe seit Januar 2009
Mobil - Impressum - Datenschutz - CO2-Neutral