SQL Fundamentals
overview
Topics
Prerequisites
Objectives
What Next?
overview
View a newer version of this course Its important for developers to understand the basic concepts of relational databases. This course helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn To: Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects. Manage schema objects. Manage objects with data dictionary views. Retrieve row and column data from tables.
Topics
Prerequisites
Objectives
What Next?
-
Modules
- Introduction
- Retrieve Data using the SQL SELECT Statement
- Restricting and Sorting Data
- Using Single-Row Functions to Customize Output
- Using Conversion Functions and Conditional Expressions
- Reporting Aggregated Data
- Using the Group Functions
- Displaying Data From Multiple Tables
- Using Joins
- Using Subqueries to Solve Queries
- Using the SET Operators s
- Managing Tables
- using DML statements
- Introduction to Data Definition Language
- Introduction to Data Dictionary Views
- Creating Sequences, Synonyms, Indexes
- Creating Views
- Managing Schema Objects
- Retrieving Data by Using Subqueries
- Manipulating Data by Using Subqueries
- Controlling User Access
- Manipulating Data
- Managing Data in Different Time Zone
Solo
