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
涵盖的内容
5个视频8篇阅读材料3个作业
显示有关单元内容的信息
5个视频•总计7分钟
Intro to the course•2分钟
Intro to OCI Account Creation, ADB Creation and SQL Worksheet Access•0分钟
Create an Oracle Cloud Infrastructure Account and Log in to your Oracle Cloud•1分钟
Create an Oracle Autonomous AI Database•2分钟
Connect with The SQL Worksheet and run your first query•1分钟
8篇阅读材料•总计40分钟
Introduction to the course•5分钟
Create an Oracle Cloud Infrastructure Account•5分钟
Log in to Oracle Cloud•5分钟
Create an Oracle Autonomous AI Database•5分钟
Choose Autonomous AI Database from the OCI Services Menu•5分钟
Create the Autonomous AI Database Instance•5分钟
Connect with The SQL Worksheet•5分钟
Run scripts in SQL Worksheet•5分钟
3个作业•总计30分钟
Verify your OCI trial creation•10分钟
Verify your Autonomous AI Database instance creation•10分钟
Verify the result of your queries•10分钟
Run Basic Oracle SQL Commands - Part 1
第 2 单元•小时 后完成
单元详情
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
涵盖的内容
1个视频7篇阅读材料6个作业
显示有关单元内容的信息
1个视频•总计4分钟
Run Basic SQL Command - Part 1•4分钟
7篇阅读材料•总计35分钟
Run Basic Oracle SQL Commands - Part 1•5分钟
Creating Tables •5分钟
Creating Triggers•5分钟
Inserting Data•5分钟
Indexing Columns•5分钟
Querying Data•5分钟
Adding Columns•5分钟
6个作业•总计60分钟
Verify the results of Creating Tables•10分钟
Verify the results of Creating triggers•10分钟
Verify the results of Inserting data•10分钟
Verify the results of Indexing Columns•10分钟
Verify the results of Querying Data•10分钟
Verify the results of Adding Columns•10分钟
Run Basic Oracle SQL Commands - Part 2
第 3 单元•小时 后完成
单元详情
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
涵盖的内容
2个视频8篇阅读材料7个作业
显示有关单元内容的信息
2个视频•总计3分钟
Intro to Run Basic Oracle SQL Commands - Part 2•0分钟
Run Basic SQL Command - Part 2•2分钟
8篇阅读材料•总计40分钟
Run Basic Oracle SQL Commands - Part 2•5分钟
Querying the Oracle Data Dictionary•5分钟
Updating Data•5分钟
Aggregate Queries•5分钟
Compressing Data•5分钟
Deleting Data•5分钟
Dropping Tables•5分钟
Un-dropping Tables•5分钟
7个作业•总计70分钟
Verify the results of Querying the Oracle Data Dictionary•10分钟
Verify the results of Updating Data•10分钟
Verify the results of Aggregate Queries•10分钟
Verify the results of Compressing Data•10分钟
Verify the results of Deleting Data•10分钟
Verify the results of Dropping Tables•10分钟
Verify the results of Un-dropping Tables•10分钟
Final Assessment & Additional Content
第 4 单元•小时 后完成
单元详情
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.