• Enrollment system is currently unavailable. We apologize for the inconvenience.┬áPlease try again later.

SQL Programming Language

Structured Query Language (SQL) is the language used to manipulate data in relational databases. Learn to use SQL to select, update, insert, and delete data from database tables, and acquire hands-on experience with both Oracle and MySQL. Learn how to select data from multiple tables using both inner and outer joins and unions, understand how to create subqueries to develop more complex retrieval capabilities, and use DDL to create your own database and to populate tables. In addition, learn about database design, primary keys, foreign keys, indexes, table relationships, referential integrity, and normalization/denormalization techniques. This course prepares you to work with any relational database, such as Oracle, DB2, SQL Server, Sybase, or MySQL.

More details

You'll Walk Away with

  • Knowledge of SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures
  • The ability to update database content with SQL and transaction handling
  • The skills necessary to retrieve data with filter conditions and from multiple tables using various types of join

Ideal for

  • Those unfamiliar with SQL syntax
  • Students looking for a quick refresher on SQL and important database concepts
NO open sections available for this course at the moment. Please check back next semester.
Toggle

Closed

    • Section

      1
    • Semester

      Fall 2018
    • Date

      Sep 22 - Oct 27
    • Day

      Saturday
    • Time

      9:00AM-1:00PM
      • In-Person
    • Format

      In-Person
      • In-Person
    • Sessions

      6
    • Faculty

      Sultan, Samuel
    • Location

      Washington Square
    Tuition $825