minicurso 10 conceitos essenciais SQL - parte 2 de 7 - instalação Oracle no Windows

minicurso 10 conceitos essenciais SQL

#2 - instalação Oracle no Windows

00:00 Intro 00:50 Baixando Oracle XE 02:11 Instalando Oracle XE 06:41 Baixando e instalando DBeaver 09:14 Criando conexão com DBeaver 11:55 O que são tablespaces e datafiles 14:09 Criando um usuário no Oracle

Oracle XE - Windows - devmultitask

Download - https://www.oracle.com/database/technologies/xe-prior-release-downloads.html

Oracle Database 11gR2 Express Edition for Windows x64

https://www.oracle.com/technical-resources/articles/database/sql-11g-xe-quicktour.html

DBeaver

• criar conexáo com SYSTEM

SELECT * FROM v$version

SELECT tablespace_name FROM DBA_TABLESPACES

create user devmultitask identified by devmultitask default tablespace users temporary tablespace temp;

grant connect,resource to devmultitask;

SELECT * FROM session_privs

... https://www.youtube.com/watch?v=cJBbfHHEVbY