SQL Level III

Advanced SQL Courses in NYC

  • tag-solid $425
  • clock-solid 8 Hours
  • display-solid PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
All SQL Courses SQL Level III

Become a master of all things SQL in SQL Level 3. Export data to external applications, like Access and Excel, automate workflow with triggers, and protect live data by using temporary tables. At the end of the course, you’ll have the option to explore data conversion functions and Schema binding.

Advanced SQL Classes in Midtown NYC

At the start of the course, you’ll receive a personal course workbook where you can add personal notes and tips to help you remember each exercise. After the course, use the workbook as a reference manual. Bring it with you on the job to review SQL concepts anytime you face a challenge.

NYC's Top SQL Bootcamp in Manhattan

Need a refresher before jumping into SQL Level 3? Sign up for SQL Bootcamp and receive a 15% discount on SQL Level 1, SQL Level 2, and SQL Level 3. Take our intensive bootcamp scheduled over three consecutive days or spread the course over a few weekends.

Students can take the course a second time within 6 months absolutely free of charge.

Class Notes

  • SQL can be used with a variety of programs. This course uses Microsoft SQL Server.
  • Prerequisites: SQL Level 2 or  knowledge equivalent to the previous level
     

Upcoming Class Dates

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com phone-handset-solid 212 • 684 • 5151 file-group-solid Download Syllabus

Course Overview

  • Create Databases and Tables
  • Insert, update and delete data through importing and coding techniques
  • Export data to other applications
  • Create constraints, indexes and referential integrity
  • Create database diagrams
  • Use Stored Procedures and Triggers for the creation of parameterized queries and automation of workflow processes
  • Protect Live Data with Temporary Tables

Full Course Syllabus

file-group-solid Download PDF Outline

Importing and Exporting Data

1) Creating a Database and Tables in SQL

2) Importing and Exporting Data from and to Excel

3) Importing and Exporting Data from and to Access

4) Importing, Updating and Deleting Data via Code

Building Control Structures

5) Creating Primary Keys, Indexes and Constraints

6) Setting up Referential Integrity

7) Creating Database Diagrams

Temporary Tables

8) Low Level Security Overview

9) Local Temp Tables

10) Global Temp Tables

Stored Procedures

11) Parameter Queries using Variables through Views

12) Automation of Workflow Processes

13) Triggers to Create Workflow Events

Optional

Protect Views with Schema binding

Data Conversion Functions

  • String Functions
  • Cast Function
  • Convert Function
  • Rounding Functions