A company’s success hinges on responsible and accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers, to setting financial goals. Data professionals like analysts, developers, and architects are tasked with creating, optimizing, managing, and analyzing data from databases, with little room for error. When databases aren’t built or maintained correctly, it’s easy to mishandle or lose valuable data.

This course explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work is ANSI SQL compliant and should work with SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Join us for this 2-day remote live teaching course to further advance your SQL skills to manipulate and index business data.

 

Training: Next Level SQL | Intermediate to Advanced SQL Programming

Date: December 14 & 15 | 9 am – 4 pm each day

Location: VirtualYour remote workspace

Instructor: Global Knowledge

Cost: $1000  through grant support, techfrederick is able to offer this class for $70 to techfrederick members and $90 to non-members

NOTE: This class is limited to 15 seats, preference will be given to techfrederick members in the event of a waitlist

This class is intended for:

  • Experienced end users, Data Scientists, Business and Data Analysts, Developers, and Database Administrators

The course has a 50% hands-on labs to 50% lecture ratio with engaging instruction, demos, group discussions, labs, and project work covering: 

  • Advanced Query Techniques
  • Manipulating Table Data Using SQL’s Data Manipulation Language (DML)
  • User-Defined Functions
  • Stored Procedures
  • Triggers

Prerequisites:

You should have basic SQL experience before attending this course

** As this training is funded by State of MD EARN Grant funding, the information requested throughout the registration and participation process is REQUIRED by the State of Maryland for their tracking and statistical purposes. All information collected is confidential**

Questions? Contact Brooke Warburton bwarburton@techfrederick.org.