Courses

SQL I

Course Description

Structured Query Language (SQL) is a standard programming language. Users can:

  • Query data from relational databases
  • Add and update information within databases
  • Create and delete tables which hold the information
  • Control access to the information

Developing SQL skills allows employees to utilize many familiar programming languages designed to work with embedded SQL. Many of these products support SQL with proprietary extensions, but all such products support a common subset of SQL. This course focuses on that common subset of SQL used by more than 100 databases, languages and software applications.

Real-World Application

This course is designed for persons who work in any relational database environment, including Oracle, SQL Server, Access, and many others.

Prerequisites

Windows experience.

Course Objectives

Upon successful completion of the course, participants will be able to:

  • Write Create, Alter and Drop Table statements
  • Write Insert, Update and Delete statements
  • Write SQL Select statements, including Where expressions, sorting, joins, and subqueries

Topics

  • What is a Relational Database
  • Data Definition Language – Create, Alter, and Drop
  • Data Manipulation Language – Insert, Update, and Delete
  • Select Statement
  • Data Control Language – Grant and Revoke

Course Content

  • What is a Relational Database
  • Data Definition Language
    • Create, Alter, or Drop Table
    • Create or Drop Index
  • Data Manipulation Language
    • Insert, Update, and Delete
  • Select Statement
    • Select and Select Distinct
    • Select with Where clause
    • Select with Where clause
    • Select with Order By, Group By, and Having clause
    • Select using a subqueries
    • Select using Two or More Tables
  • Advance Topics
    • Create Table via a Select
    • Insert Into via a Select
    • Create View
  • Data Control Language
    • Grant and Revoke

Schedule

Please call 216.687.6957 or email prodev@csuohio if you are interested.

CEUs:1.4

Fee:  $695

Corporate, CSU Student, Alumni and Organization membership discounts available!

Course Benefits

Competency-Based Professional Development: Our programs increase learner retention through application, which results in a more productive workforce.  Students demonstrate their competence by successfully completing a course assessment.

All Inclusive: Each course delivered at CSU includes materials, pre-test and post-test, coffee, snacks, lunch and convenient, on-site parking.

Educated and Experienced Instructors: Our instructors bring years of real-world, classroom and CPA, CFA, SHRM, PhD and MBA experience. Many hold leadership positions in northeast Ohio organizations and have taught at the graduate and undergraduate levels.

Cost-Effective: The course is designed to minimize travel expenses and time away from work.

Convenient: Flexible schedules are not only an attractive option, but a necessary for busy professionals.

Networking Opportunities: Learn from instructors and colleagues who have a variety of industry experiences to share.

Audit option: Students have the option to audit a course they have already attended at no charge within one academic year. Interested students must notify the ProDev office requesting to audit a course a minimum of 10 business days prior to the course start date to ensure there is enough seating. Audit students are responsible for their own parking and lunches. New materials will not be provided.

Corporate, Custom Availability: Can be custom-tailored to the needs of your organization to provide skills your workforce can apply immediately as a corporate training if requested.

Refund Policy

No refunds will be issued if notification is not received seven business days prior to the first day of class. Registrants who cancel will receive a refund, less a $50 processing fee, if we receive written notification a minimum of seven business days prior to the first day of class.