An Introduction to the fundamentals of Structured Query Language (SQL) will offered at UCLA Extension. Please check UCLA Extension website for more information.
Course Number & Title: Introduction to SQL
Course Author(s): Richard Patlan
Author(s) Affiliation: dbWebsite.com
Phone: 626-221-8435
Fax:
E-Mail: rpatlan@dbwebsite.com
_________________________________________________________________
Course Catalog Description
This hands on course covers the fundamentals of Structured Query Language (SQL). SQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc. Designed for staff new to SQL, the course begins with an overview of SQL and how SQL statements are used to retrieve and update data in a database. Students will start by creating basic select statments and progress into the more detailed and complex features of SQL. This will include using keywords such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others. In addition, course will cover table joins, sub-queries, if and case statements, cast and covert staments and much more. The queries presented will use Microsoft SQL Server
Date: 6/30/2009
Time: Online
Number of meetings: 10
Prerequisite: This course is for those individuals with little or no SQL experience. Basic knowlodge of windows software is recommended
The Database Design using Structured Query Language (SQL) course will be offered at UCLA Extension. Please check UCLA Extension website for more information.
Course Title: Database Design using SQL
Course Author(s): Richard Patlan
Author(s) Affiliation: dbWebsite.com
Phone: 626-221-8435
Fax:
E-Mail: rpatlan@dbwebsite.com
_________________________________________________________________
Course Catalog Description
Databases offer a convienient and powerful way to organize your information. The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relational databases on all major platforms. It provides a uniform interface to Oracle, SQL Server, Access and other relational databases.
In this course, you'll learn how to design a databases using SQL. This course will cover using SQL to create your database schema, normalizing your database according to commonly accepted design principles, implementing referential integrity, add security to your database and use database keys and transactions. By the end of the course you will have created a complete fully functional database.
Date: Winter 2009
Time: 6:30 - 10 p.m.
Location: Westwood B15 1010 Westwood Center
Number of meetings: 10
Prerequisite: X 414.61 Using Structured Query Language (SQL) Syntax; some experience in SQL; or consent of instructor. This "green" course provides course materials online to minimize paper waste; Internet access required.
The Advanced Structured Query Language (SQL) course will be offered at UCLA Extension. Please check UCLA Extension website for more information.
Course Number & Title: Advanced SQL
Course Author(s): Richard Patlan
Author(s) Affiliation: dbWebsite.com
Phone: 626-221-8435
Fax:
E-Mail: rpatlan@dbwebsite.com
_________________________________________________________________
Course Catalog Description
Structured Query Language (SQL) is an American National Standards Institute (ANSI) standard computer language for accessing and manipulating database systems. It works with such database programs as MS Access, DB2, Informix, MS SQL Server, Oracle, and Sybase.
Designed for those with some knowledge of SQL, this hands-on course covers advanced SQL statements used in inserting, retrieving, and updating data in a database. Students are shown how to use advance features of SQL commands, including using operators such as IN, AND, OR, BETWEEN, LIKE, DISRINCT, AGGREGATE, CONCAT, SUBSTRING, HAVING and others.
In addition, advanced usage of table joins, sub-queries, if and case statements, and cast and covert statements are covered, as well as stored procedures, triggers, functions, and cursors. For example, the course shows how to stream text into a field, retrieve and send results in email, create search function using full text index, and create pivot table with hyperlinks.
Date: 6/30/2009 - 10/1/2009
Time: 6:30 - 10 p.m.
Location: Westwood B15 1010 Westwood Center
Number of meetings: 10
Prerequisite: X 414.61 Using Structured Query Language (SQL) Syntax; some experience in SQL; or consent of instructor. This "green" course provides course materials online to minimize paper waste; Internet access required.