Introduction to SQL

COM SCI X 414.61

Structured Query Language (SQL) is a standard computer language for accessing and manipulating database systems. For those with little or no experience, this hands-on course covers basic SQL syntax for updating a database.

View Course Options

What you can learn.

Learn how to use basic Structured Query Language to write and execute queries
Master SQL Data Manipulation syntax
Understand how to write SQL Data Definition syntax to create database objects

About this course:

Structured Query Language (SQL) is an American National Standards Institute (ANSI) standard computer language for accessing and manipulating database systems. SQL works with database programs such as Microsoft Access and SQL Server, DB2, Informix, Oracle and Sybase. This hands-on course covers basic SQL syntax for individuals with little to no SQL experience. Instruction presents an overview of SQL and how to use SQL statements to retrieve and update data in a database. Students begin by creating basic select statements, which include using keywords such as SELECT, UPDATE, DELETE, INSERT, WHERE, HAVING and others. The course also covers intermediate topics, such as table joins, sub-queries, aggregate functions, stored procedures, triggers, cursors and transactional processing and much more.

Prerequisites

Basic knowledge of Windows is recommended.

Fall 2024 Schedule

September 23 - November 25

Monday 6:00PM - 9:30PM PT

Future Offering (Opens July 29, 2024 12:00:00 AM)

See Details

Instructor: Ricardo Patlan

399572

Fee:

$1,095.00

Live Online

Location: UCLA

Updating...

See Details

Notes

Enrollment limited. Enrollment deadline: October 7, 2024. Internet access required. Materials required.

Refund Deadline

No refunds after October 06, 2024

Course Requirements

SQL in 10 Minutes, Sams Teach Yourself (4th Edition)

ISBN 0672336073

Internet access required to retrieve course materials.

Schedule

Type

Date

Time

Location

Discussion

Mon Sep 23, 2024

6:00PM PT - 9:30PM PT