Announcements All Announcements

ABOUT ORACLE SQL TEACHING

ORACLE SQL TEACHING

On Tuesday, May 22, KMB-305 will be provided with Oracle SQL Training by our Intellica company for our 4th grade students. Up to 50 students will be able to participate in the training. Students who plan to participate in the training should write their names on the list in the department's student affairs by May 17, 2018 and follow the instructions given below with their laptops.

At least 20 students are required to attend the training. For this reason it is important to only print the names of students who are willing to participate.

Instructor: Olgu Karacıoğlu / Intellica Business Intelligence Solution Architecture

Program:

10: 00-10: 20: Opening speech: Intellica informing about our company and our projects

10: 20-11: 00: Business Intelligence, Data Warehousing, Big Data

11: 00-16: 00: Oracle SQL Training

 

About Workshop Media Preparation

 

Friends to join Wokshop

 

1- Oracle XE (with oracle db installed),

 

Oracle XE: http://www.oracle.com/tech network / database / database-tech nologies / express-edition / downlords / index.html

 

Oracle Database Express Edition 11g Release 2 for Windows x64

 

To test the success of the setup; Run with the command line, run the following commands in order.

 

------------------------------ -------------------- ---------- ----------------------

 

cmd

 

sqlplus / nolog

 

conn / as sysdba

 

alter user hr identified by hr account unlock;

 

disconnect

 

conn hr / hr

 

select * from employees;

 

2- It is also necessary to install TOAD (for Oracle) or SQL Developer.

 

SQL Developer: http: //www.orac le.com/technetwork/developer-tools/sql-developer/downloads/index.html