0(0)

DBA: Introduction to SQL Ed 2

  • by admin
  • Course level: All Levels
  • Categories Oracle
  • Total Enrolled 0
  • Last Update August 30, 2020

Description

This Introduction to SQL training takes to the basic concepts of relational databases and SQL programming language. Through this training you will gain the essential SQL skills to write queries against single and multiple tables and can manipulate data in tables and create database objects.

Topics for this course

73 Lessons

Introduction

Overview of relational database management concepts and terminologies
What is Oracle SQL Developer?
Tables used in the Course
Starting SQL*Plus from Oracle SQL Developer
Introduction to SQL and its development environments
Course Objectives, Course Agenda and Appendixes Used in this Course
The Human Resource (HR) Schema
Overview of Oracle Database 12c and Related Products00:00:00

Working with Oracle Cloud Exadata Express Cloud Service

Retrieving Data using the SQL SELECT Statement

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

Using Conversion Functions and Conditional Expressions

Using Subqueries to Solve Queries

Using the SET Operators

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 Zones

Free

Material Includes

  • Duration: 6 Months
  • 28 hours on-demand video
  • 11 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Requirements

  • No coding experience is necessary to take this course!
  • Any computer and OS will work — Windows, macOS or Linux.
  • A basic understanding of HTML and CSS is a plus.

Target Audience

  • Practice your new skills with coding challenges.
  • Organize and structure your code using software.
  • Get friendly and fast support in the course.