Udemy

Platform

English

Language

Databases

Category

Databases & SQL - Introduction Course for Oracle SQL

Theoretical aspects about Databases and SQL programming language

5.00 (4 reviews)

Students

2.5 hours

Content

Mar 2021

Last Update
Regular Price

EXCLUSIVE SKILLSHARE OFFER
Exclusive SkillShare Offer
Unlimited access to 30 000 Premium SkillShare courses
40%OFF ANNUAL MEMBERSHIP

What you will learn

Database theory

Fundamentals: data types, operators, SQL commands

Queries and Joins

Single-row and group functions

Views and Triggers

Functions and Going through hierarchical structures


Description

The course is intended for students and employees who want to start working in the field of Database Development, Data Analysis and Business Intelligence. This course will show you the basic theoretical concepts of databases, but also explain the SQL language concepts one by one.


I graduated from the Faculty of Economic Informatics and the Master of Business Support Databases from the Bucharest Academy of Economic Studies and I have over 4 years of professional experience in this field, so I know several database technologies, but for this course I decided to focus on the Oracle technology.


I will talk about the theoretical aspects, the conceptual scheme of databases, queries, DDL and DML language, functions, operators and other database objects (views, triggers, etc.). All these concepts represent the foundation of a database developer, and if you master them, it will be very easy for you to learn other technologies and other functionalities.


Throughout the course I will propose some practical exercises, so that at the end of the course you will be able to design, develop, query and maintain an Oracle database, regardless of its size. I have also included some files with exercises that you can do on your own. The exercises have a low difficulty and are meant to prepare you for the next advanced SQL courses.


Screenshots

Databases & SQL - Introduction Course for Oracle SQL
Databases & SQL - Introduction Course for Oracle SQL
Databases & SQL - Introduction Course for Oracle SQL
Databases & SQL - Introduction Course for Oracle SQL

Content

Theoretical aspects about Databases

What does a database represent?

The stages of creating a database

Restriction types

The design of a database

Fundamentals

Data types

Operators

SQL commands

Oracle SQL Developer installation tutorial

Creating & populating the tables

SQL Programming Language

Data Definition Language

Data Manipulation Language

Exercises

DDL & DML quiz

Queries

Querying tables

Joins

Exercises with simple SELECTs

Exercises with JOINs

Querying quiz

Predefined Functions

Single-row functions

Group functions

Exercises

Queries and Functions practice

Other database objects

Views

Triggers

Indexes & Sequences

Exercises

Advanced concepts

UNION, INTERSECT & MINUS operators

DECODE & CASE

Going through hierarchical structures

Advanced concepts quiz

SQL Injections

Outro


3885412

Udemy ID

3/2/2021

Course created date

4/11/2021

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram