Yelp Facebook LinkedIn YouTube Twitter Instagram

SQL Level III

Advanced SQL Classes in NYC

SQL level III guides students through advanced techniques in order to effectively create and maintain a highly efficient database. In SQL level III, you'll build a database that you'll use throughout the course to practice and refine your database management skills, including exporting data from external sources, creating temporary tables in lieu of unnecessary filtering, incorporating security measures to protect your data, and implementing stored procedures to maximize consistency and efficiency.

By mastering the skills taught in SQL III, you'll be able to confidently add advanced SQL to your portfolio of skills in web development, and you'll even be prepared to launch a career in database management!

SQL Level III is taught at our affiliate school, NYIM Training, in Midtown Manhattan.

  • 8 Hours
  • Small classes
  • PC only
  • Free retake

Register for this class

$425

185 Madison Ave, NYC

This course is offered at our affiliate business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on our affiliate's website.

What You’ll Learn

  • Create a database and tables
  • Import data from Microsoft Access and Microsoft Excel
  • Write code to import, edit, and delete data
  • Use security features to protect data integrity
  • Develop database diagrams
  • Make local and global temporary tables
  • Implement stored procedures to automate workflows
View full syllabus

SQL Level III Class Syllabus

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

Learn from Industry Experts to Build and Manage Databases like a Pro

Through our highly-developed curriculum, you'll engage with practical examples and hands-on activities to master database management using SQL. Our expert instructors have tailor-made this course to provide you with everything you need to know to be an effective database manager. 

Advanced Instruction Drawn from Expert Experience

Our curriculum has been codified by industry experts to include the most relevant and pressing subject material required to master database management and SQL. Our instructors apply their real-world experience to provide students with highly-applicable skills, techniques, and tools of the trade. 

Expert instructor teaching SQL

Centralized Location with State-of-the-Art Classrooms

SQL classes take place at our Centralized Midtown Manhattan training center. Classrooms are equipped with all of the technology and amenities that you'll need to have a pleasant and productive day of learning! 

Student learning SQL in class

Register for this class

$425

185 Madison Ave, NYC

This course is offered at our affiliate business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on our affiliate's website.