Loading...

Course Description

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.

Course Outline

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.

Course Outline

  1. Students will know basic Structured Query Language to write and execute queries

  2. Students will know how to write SQL Data Manipulation syntax

  • Used to SELECT data

  • Used to UPDATE data

  • Used to INSERT data

  • Used to DELETE data

  • Used to filter data using WHERE clause

  • Used to filter data using operators

  • Used to JOIN tables

  • Used to write sub queries

Students will know how to write SQL Data Definition syntax to create database objects:

  • Used to create databases

  • Used to create tables

  • Used to create stored procedures

  • Used to create triggers

  • Used to create cursors

  • Used to create constraints

  • Used to create Views

Notes

Contact:

dt@uclaextension.edu

310-825-3656

Prerequisites

Basic knowledge of Windows is recommended.

Applies Towards the Following Certificates

Loading...
Review Sections
Section Title
Introduction to SQL
Type
Online
Dates
Jun 24, 2024 to Sep 02, 2024
Contact Hours
36.0
Delivery Options
Online  
Course Fee(s)
Standard credit (4 units) $1,095.00
Available for Credit
4 units
Refund Request Deadline
Jun 28, 2024
Transfer Request Deadline
Jun 28, 2024
Withdrawal Request Deadline
Jun 24, 2024 to Sep 01, 2024
Instructors
Section Notes
Enrollment limited. Enrollment deadline: June 30, 2024. Internet access required. Materials required.
Section Materials
  • (Mandatory) SQL in 10 Minutes, Sams Teach Yourself (4th Edition) ISBN 0672336073
  • (Mandatory) Internet access required to retrieve course materials.
Section Title
Introduction to SQL
Section Schedule
Jun 24, 2024 to Aug 26, 2024
Type
Discussion
Days
M
Time
6:00PM to 9:30PM
Dates
Jun 24, 2024 to Aug 19, 2024
Type
Discussion
Dates
Jun 24, 2024 to Aug 26, 2024
Schedule and Location
View Details
Contact Hours
36.0
Location
  • UCLA
Delivery Options
Hybrid  
Course Fee(s)
Standard credit (4 units) $1,095.00
Available for Credit
4 units
Refund Request Deadline
Jul 07, 2024
Transfer Request Deadline
Jul 07, 2024
Withdrawal Request Deadline
Jun 24, 2024 to Aug 25, 2024
Instructors
  • Ricardo Patlan
Section Notes
Enrollment limited. Enrollment deadline: June 30, 2024. Internet access required. Materials required.
Section Materials
  • (Mandatory) SQL in 10 Minutes, Sams Teach Yourself (4th Edition) ISBN 0672336073
  • (Mandatory) Internet access required to retrieve course materials.
Required fields are indicated by .