COURSE DISCIPLINE : COURSE NUMBER : COURSE TITLE (FULL) : COURSE TITLE (SHORT) :
CS/IS 234
Introduction to Databases and SQL Intro to Databases
CATALOG DESCRIPTION
CS/IS 234 covers the introduction to Databases and SQL structured Query Language (SQL* Plus) query tool. This course focuses on the design and organization of a specific schema diagram and how to build SQL statements to access the data. This course also focuses on DML (Data
Manipulation), DDL (Data Definition), and DCL (Data Control) and Procedural Language/Structured Query Language (PL/SQL), the programming language that uses SQL.
CATALOG NOTES
Note: This course may not be taken for credit by students who have completed CS/IS 232 and/or CS/IS 233.
Total Lecture Units: 2.00 Total Laboratory Units: 1.00 Total Course Units: 3.00 Total Lecture Hours: 36.00 Total Laboratory Hours: 54.00
Total Laboratory Hours To Be Arranged: 0.00 Total Contact Hours: 90.00
Total Out-of-Class Hours: 72.00
ENTRY STANDARDS
Subject Number Title Description Include
1 CS/IS 101 Introduction To Explain the concept of a network; identify No Computer And hardware and software needed to create a
Information network; compare and contrast wired vs. Systems wireless networks; describe network security
issues; 2 CS/IS 101 Introduction To
Computer And Information Systems
describe the Internet and Internet services; describe the evolution of e-business and understand how to do business on the Internet; identify Web development tool and authoring systems; create a simple Web page using
No
Hypertext Markup Language (HTML), explain organizational implications of the pervasiveness of the Internet;
3 CS/IS 101 Introduction To Computer And Information Systems
demonstrate the importance of the technology infrastructure in an organization; identify major hardware components of a computer system; explain how to evaluate hardware components and what to look for in acquiring computer
No
hardware; understand the interdependence of hardware and software; compare open vs. proprietary platforms;
4 CS/IS 101 Introduction To Computer And Information Systems
describe distinctions between system software and application software; explain common functions of system software; identify types of application software; understand how to evaluate software when planning a system; compare open
No vs. proprietary software; 5 CS/IS 101 Introduction To Computer And Information Systems
describe ethical concerns associated with information systems including privacy, access, reliability, legal, ethical, and accuracy; identify types of computer crime; select, access, and use appropriate sources;
6 CS/IS 101 Introduction To Computer And Information Systems
use a spreadsheet software package to solve common business problems; demonstrate effective spreadsheet design through correct usage of formulas and functions including absolute vs. relative cell addressing; use
No
financial, logical, date and statistical functions; use lists and data management functions; create appropriate charts and printed reports; work with multiple worksheets;
7 CS/IS 101 Introduction To Computer And Information Systems
use a database software package to solve common business problems; design and build a database (define fields and properties, enter records); design and build simple forms, queries and reports;
Yes
8 apply basic computer concepts and
terminology;
No 9 CS/IS 241 Cloud Computing -
Databases Essentials
Describe how SQL and noSQL database web services can be used to store data;
Yes
10 CS/IS 241 Cloud Computing - Databases
Essentials
describe redundancies and their adverse effects;
No
11 CS/IS 241 Cloud Computing - Databases
Essentials
identify operations such as restrict, project, union, intersection, difference, divide, and join.
No
EXIT STANDARDS
1 Explain table structures and data;
2 construct basic SQL statements to query data; 3 use character and number functions;
4 use data and conversion functions; 5 use aggregate functions;
6 compose subqueries; 7 use set operators; 8 use complex joins;
9 manage inserting, updating, and deleting data; 10 create tables, alter tables, and drop tables; 11 create views, indexes, and sequences;
12 explain and query various data dictionary views; 13 apply various levels of security to tables;
STUDENT LEARNING OUTCOMES
1 Create, maintain, and manage databases; 2 apply database security;
3 use SQL Language to create, manipulate, and retrieve data within a database. COURSE CONTENT WITH INSTRUCTIONAL HOURS
Description Lecture Lab Total Hours
1
SQL and Data
• Data, databases, and the definition of SQL • A case study schema diagram
• Referential Integrity and table relationships • The SQL*PLUS environment
3 4 7
2
SQL Basics
• The anatomy of a SELECT statement • Editing a SQL statement
• The WHERE Clause: comparison and logical Operators • The ORDER BY Clause
3 4 7
3
Character and Number Functions • Character functions
• Number functions 2 4 6
4
Date and Conversion Functions
• Converting from one Datatype to another • Applying Date Format Models
• Performing date and time math
2 3 5
5
Aggregate Functions, GROUP BY, and HAVING • Aggregate functions
• The GROUP BY and HAVING clauses 2 4 6
6
Equijoins
• The Two Table Join
• Joining more than Two Tables 2 4 6
7
Subqueries
• Simple subqueries • Correlated subqueries
• ANY, SOME, and ALL operators in subqueries
3 4 7
8
Set Operators
• The power of UNION and UNION ALL
• The MINUS and INTERSECT set operators 2 3 5
9
Complex Joins • Outer Joins
• Self-Joins 2 4 6
10 Insert, Update, and Delete and the Manipulation of Data and Transaction Control 3 4 7
11
Create, Alter, and Drop Tables • Creating and dropping tables
12
Views, Indexes, and Sequences • Creating and modifying views • Indexes
• Sequences
3 4 7
13 Security: Users, Privileges, Roles, and Synonyms 3 4 7
14
Procedural Language/Structured Query Language (SQL) • Procedures vs. functions
• Basic looping techniques • Formatting output 4
3 4 7
90
OUT OF CLASS ASSIGNMENTS
1 hands-on lab assignments (e.g. creating and dropping tables). METHODS OF EVALUATION 1 quizzes; 2 midterm examination; 3 final examination. METHODS OF INSTRUCTION Lecture Laboratory Studio Discussion Multimedia Tutorial Independent Study Collaboratory Learning Demonstration
Field Activities (Trips) Guest Speakers
Presentations TEXTBOOKS
Title Type Publisher Edition Medium Author IBSN Date SQL in 10 Minutes,
Sams Teach Yourself Required Pearson 5 eBook Forta, Ben
978-0-13-