(212) 684-5151

Advanced SQL
Advanced SQL

Price: $425.00

Course Code: SE | Hours: 8

SQL: Level 3 Training Overview

SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and then shown to your seat with a computer that is fully equipped with SQL. The instructor computer is attached to an overhead projector so you can easily follow their instructions. The class is taught in a very hands-on way, with the instructor teaching a concept and then the class doing exercises to enforce it. The maximum class size is 10 so you don't have to worry about getting lost in the crowd.

Advanced SQL Course Outline

What You'll Learn in this Class:

  • 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

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Related Classes:

See Also:

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Related Classes:

See Also:

Advanced SQL Course Overview

Importing and Exporting Data

• Creating a Database and Tables in SQL
• Importing and Exporting Data from and to Excel
• Importing and Exporting Data from and to Access
• Importing, Updating and Deleting Data via Code

Building Control Structures

• Creating Primary Keys, Indexes and Constraints
• Setting up Referential Integrity
• Creating Database Diagrams

Temporary Tables

• Low Level Security Overview
• Local Temp Tables
• Global Temp Tables

Stored Procedures

• Parameter Queries using Variables through Views
• Automation of Workflow Processes
• Triggers to Create Workflow Events