Computer Technology and Information Management

A to Z Course Index

Information Sessions

Certificate Programs

Transcripts

Course Locations

Concurrent Enrollment

Order a Catalog

Courses begin every month. A new edition of our catalog is published three times a year in early April, July and December.

Quick Enroll	Search

HANDS-ON

Managing Data(bases) Using SQL

X401.9 (2 semester units in EECS)

A requirement in the Professional Sequence in Database Management

Get in-depth training of the core Structured Query Language (SQL), with particular focus on Data Query Language (DQL) and Data Manipulation Language (DML). Data Definition (DDL) and Data Control Language (DCL) are covered briefly as well. You learn the concepts of SQL through both lectures and hands-on exercises. Additional class exercises, tests, and projects further enhance your learning experience.

On successful completion of the course, you are able to write and understand complex SQL statements and gain a basic understanding of database operations.

Basic course outline:

• Introduction and overview of SQL, normalization rules
• The SELECT statement with all its clauses
• SQL datatypes, expressions, nulls, and wildcard characters
• Complex filtering of data, intersects, difference and union
• Using multiple tables, inner join, left, right, full outer join, self join
• SQL subqueries
• GROUP BY queries
• Data Manipulation statements (Insert, Delete, Update)
• Data Definition statement (Create, Drop, Alter)
• System privileges, object privileges, grant and Revoke statements

Prerequisite: Introduction to Relational Database Management Systems X409.1, or basic understanding of databases and Introduction to SQL.

There are currently no sections open for enrollment.

---

Sections closed for enrollment

Tues. June 23, San Francisco

MICHAEL KREMER, M.S., Ph.D., named Honored Instructor in 2004, is a computer systems engineer with Lawrence Berkeley National Laboratory, where he supports various Microsoft Access-based and Oracle-based databases. He has more than eight years of experience teaching computer classes and developing various Microsoft Access databases. E-mail: mckremer@lbl.gov

• 10 meetings
• June 23 to Aug. 25: Tues., 6:30-9:30 pm
• San Francisco: Room 814, UC Berkeley Extension Downtown Center, 425 Market St., 8th Floor (enter on Fremont St.)
• $695 (EDP 305235)

Tues. Oct. 6, San Francisco

MICHAEL KREMER, M.S., Ph.D., named Honored Instructor in 2004, is a computer systems engineer with Lawrence Berkeley National Laboratory, where he supports various Microsoft Access-based and Oracle-based databases. He has more than eight years of experience teaching computer classes and developing various Microsoft Access databases. E-mail: mckremer@lbl.gov

• 10 meetings
• Oct. 6 to Dec. 8: Tues., 6:30-9:30 pm
• San Francisco: Room 812, UC Berkeley Extension Downtown Center, 425 Market St., 8th Floor (enter on Fremont St.)
• $699 (EDP 321596)

Quick Enroll	Search