CIS 4400 Lecture 1: SQL Introduction
23 Feb 2019
School
Department
Course
Professor
1/29/19: Course Introduction
• Purpose of this course is to manipulate the data. Making a db for analytical purposes
• Either follow Kimball (dimensional model) or Inmon (operational data store) in data warehousing
• Follow Kimball’s methodology for the purpose of this course
• 3 assignments, 2 exams, 1 group project
• Heading for HW’s: Your Full Name, Course Number (4400), Section, the name and number of
the assignment and the date
• Database reverse engineering: get the overall map for the database. To see how it works
1/30/19: Review of SQL
• SERVER
o The server is running the database called Oracle 12c. Sitting across the street
o 10.3.2.61 IP address
o 1521 service port
o Pdb2 service name
o Runs Linux. Dell. Oracle runs on it
• CLIENT
o Client is running on SQL Developer. An interface that people can use. Does not store any
data. A piece of software that lets us connect from client to server
o Tableau is another client-tool and connect it to the server
o Pentaho is another set of tools. Doesn’t store data inside it
• Make a connection between client and server. Whatever you type in to SQL developer, it passes
on to the server
Running Oracle SQL Developer:
• Log in to Windows
o Open c driver
o Run sqldeveloper
o Need to make a connection to a server
o Plus sign → new connection
How are we all connected to the same database?
• Server → oracle instance → pluggable DB → with many schemas
• Schema and username is the same thing
• I am the schema
• When you make an application, you make a new schema
• Can create a table, triggers etc in this schema
Grabbing data from other schemas:
• Export and share
• OR we are on the same server, so we can just grab it from the server
• Reaching out from my schema to yours
o SELECT *
o FROM rholowczak.sp500_members
o WHERE ticker = 'AAPL';
• Grant the ability to give students access to the table or certain columns
Document Summary
1/29/19: course introduction: purpose of this course is to manipulate the data. 1/30/19: review of sql: server, the server is running the database called oracle 12c. Sitting across the street: 10. 3. 2. 61 ip address, 1521 service port, pdb2 service name, runs linux. Oracle runs on it: client, client is running on sql developer. A piece of software that lets us connect from client to server: tableau is another client-tool and connect it to the server, pentaho is another set of tools. Doesn"t store data inside it: make a connection between client and server. Whatever you type in to sql developer, it passes on to the server. Running oracle sql developer: log in to windows, open c driver, run sqldeveloper, need to make a connection to a server, plus sign new connection. Running a sql query: need to run this in the server.
