Oracle Database 11g: SQL Fundamentals I
4.5 /5- Offered byOracle
Oracle Database 11g: SQL Fundamentals I at Oracle Overview
Oracle Database 11g: SQL Fundamentals I
at Oracle
Build a foundation of SQL knowledge on your own time, from anywhere that's convenient for you
Mode of learning | Online |
Schedule type | Self paced |
Official Website | Go to Website  |
Credential | Certificate |
Oracle Database 11g: SQL Fundamentals I at Oracle Highlights
Oracle Database 11g: SQL Fundamentals I
at Oracle
- Develop essential SQL skills that enable developers to write queries against single and multiple tables.
- Manipulate data in tables.
- Create database objects.
- Use single row functions to customize output.
- Work with group functions to report aggregated data.
- Use conversion functions and conditional expressions.
- Manipulate queries to return required data.
- Perform calculations on data.
- Administer database objects.
Read more
Oracle Database 11g: SQL Fundamentals I at Oracle Course details
Oracle Database 11g: SQL Fundamentals I
at Oracle
Who should do this course?
- Administrator
- Architect
- Database Administrator
- Developer
What are the course deliverables?
- To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting
- To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return value
- To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE
- To recognize the steps for creating, defining, and dropping tables, manipulating how their data can be viewed, and using schema objects to generate integers, improve queries
More about this course
- This Oracle Database 11g: SQL Fundamentals I - Self-Study Coursec is designed to teach you the fundamentals of SQL using Oracle Database 11g database technology.
- Using the powerful Structured Query Language (SQL), the data contained within relational databases can be retrieved, managed and manipulated
Oracle Database 11g: SQL Fundamentals I at Oracle Curriculum
Oracle Database 11g: SQL Fundamentals I
at Oracle
Oracle Database 11g: Using SQL to Query Your Database
Using SQL in Oracle Database 11g
Retrieving, Restricting and Sorting Data
Using Single-Row Functions
Oracle Database 11g: Conversion Functions, Group Functions, and Joins
Conversion Functions and Conditional Expressions
Group Functions and Joins
Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
Using Subqueries and Set Operators
Manipulating Data
Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Other courses offered by Oracle
View Other 57 Courses
J
JOYDEEP DAS
Oracle Database 11g: SQL Fundamentals I
Offered by Oracle
4
Learning Experience: Learning experience was good
Faculty: Instructors taught well
Curriculum was relevant and comprehensive
Course Support: Career support was helpful
Reviewed on 25 Mar 2022Read More
View 1 Review
Oracle Database 11g: SQL Fundamentals I
at Oracle
Student Forum
Anything you would want to ask experts?