This course provides a step-by-step guide for users on how to create an Oracle Cloud Infrastructure account, provision an Autonomous Database, and connect to the Oracle Autonomous Database using SQL Worksheet. It also introduces users to Structured Query Language (SQL). It provides detailed instructions on creating, updating, and deleting tables that include primary keys, columns, constraints, indexes, and foreign keys, as well as other SQL-related topics.
This module is divided into four lessons: Introduction to the course, Create an Oracle Cloud Infrastructure Account, Provision an Oracle Autonomous AI Database and SQL Worksheet and run your first query
Das ist alles enthalten
5 Videos8 Lektüren3 Aufgaben
Infos zu Modulinhalt anzeigen
5 Videos•Insgesamt 7 Minuten
Intro to the course•2 Minuten
Intro to OCI Account Creation, ADB Creation and SQL Worksheet Access•0 Minuten
Create an Oracle Cloud Infrastructure Account and Log in to your Oracle Cloud•1 Minute
Create an Oracle Autonomous AI Database•2 Minuten
Connect with The SQL Worksheet and run your first query•1 Minute
8 Lektüren•Insgesamt 40 Minuten
Introduction to the course•5 Minuten
Create an Oracle Cloud Infrastructure Account•5 Minuten
Log in to Oracle Cloud•5 Minuten
Create an Oracle Autonomous AI Database•5 Minuten
Choose Autonomous AI Database from the OCI Services Menu•5 Minuten
Create the Autonomous AI Database Instance•5 Minuten
Connect with The SQL Worksheet•5 Minuten
Run scripts in SQL Worksheet•5 Minuten
3 Aufgaben•Insgesamt 30 Minuten
Verify your OCI trial creation•10 Minuten
Verify your Autonomous AI Database instance creation•10 Minuten
Verify the result of your queries•10 Minuten
Run Basic Oracle SQL Commands - Part 1
Modul 2•2 Stunden abzuschließen
Moduldetails
This module is divided into seven lessons: Run Basic Oracle SQL Commands - Part 1, Creating Tables, Creating Triggers, Inserting Data, Indexing Columns, Querying Data and Adding Columns
Das ist alles enthalten
1 Video7 Lektüren6 Aufgaben
Infos zu Modulinhalt anzeigen
1 Video•Insgesamt 4 Minuten
Run Basic SQL Command - Part 1•4 Minuten
7 Lektüren•Insgesamt 35 Minuten
Run Basic Oracle SQL Commands - Part 1•5 Minuten
Creating Tables •5 Minuten
Creating Triggers•5 Minuten
Inserting Data•5 Minuten
Indexing Columns•5 Minuten
Querying Data•5 Minuten
Adding Columns•5 Minuten
6 Aufgaben•Insgesamt 60 Minuten
Verify the results of Creating Tables•10 Minuten
Verify the results of Creating triggers•10 Minuten
Verify the results of Inserting data•10 Minuten
Verify the results of Indexing Columns•10 Minuten
Verify the results of Querying Data•10 Minuten
Verify the results of Adding Columns•10 Minuten
Run Basic Oracle SQL Commands - Part 2
Modul 3•2 Stunden abzuschließen
Moduldetails
This module is divided into eight lessons: Run Basic Oracle SQL Commands - Part 2, Querying the Oracle Data Dictionary, Updating Data, Aggregate Queries, Compressing Data, Deleting Data, Dropping Tables and Un-dropping Tables
Das ist alles enthalten
2 Videos8 Lektüren7 Aufgaben
Infos zu Modulinhalt anzeigen
2 Videos•Insgesamt 3 Minuten
Intro to Run Basic Oracle SQL Commands - Part 2•0 Minuten
Run Basic SQL Command - Part 2•2 Minuten
8 Lektüren•Insgesamt 40 Minuten
Run Basic Oracle SQL Commands - Part 2•5 Minuten
Querying the Oracle Data Dictionary•5 Minuten
Updating Data•5 Minuten
Aggregate Queries•5 Minuten
Compressing Data•5 Minuten
Deleting Data•5 Minuten
Dropping Tables•5 Minuten
Un-dropping Tables•5 Minuten
7 Aufgaben•Insgesamt 70 Minuten
Verify the results of Querying the Oracle Data Dictionary•10 Minuten
Verify the results of Updating Data•10 Minuten
Verify the results of Aggregate Queries•10 Minuten
Verify the results of Compressing Data•10 Minuten
Verify the results of Deleting Data•10 Minuten
Verify the results of Dropping Tables•10 Minuten
Verify the results of Un-dropping Tables•10 Minuten
Final Assessment & Additional Content
Modul 4•1 Stunde abzuschließen
Moduldetails
This module is divided into one lesson: Final Assessment and Materials/Suggested Resources
Data is the fuel AI needs. Oracle AI Database brings AI to your data, making it simple to power app development, and mission critical workloads with AI.
AI for data
Bring AI to your data with built-in AI Vector Search and in-database machine learning; eliminate the complexity and cost of integrating and managing multiple databases—and trying to maintain data consistency.
Benefit from AI at-scale without sacrificing security, availability, and performance.
Use the latest technologies such as retrieval augmented generation (RAG) and enterprise-class LLMs with your own business data for more contextual and relevant results.
Dev for data
Don't let limited data types or programming languages hold you back from innovation; simplify AppDev with support for all modern data types, workloads, and development styles—all within one converged database.
Get the scalability of relational frameworks with the simplicity of document models using JSON relational duality.
Use the built-in APEX platform for faster GenAI-powered, low-code development. Simplify the development and deployment of microservices with containerized, pluggable databases.
Mission critical for data
Improve application response times while reducing the load on database servers with True Cache; no need to rewrite your apps.
Protect databases against SQL injection attacks — including zero-day attacks —with SQL Firewall. Manage data across multiple regions while meeting data residency regulations using Globally Distributed Database with RAFT replication.
Use the same technology whether your data lives on-premises or in Oracle Cloud.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.