SQL – (Structured Query Language) - Training Classes, Individual Instruction, Project Assistance, Project Staffing, Instructor Rental, and Distance Learning Classes in Cleveland and the Northeast Ohio Area.
Located in Beachwood off I-271, DeVore serves the Northeast Ohio Area, including Akron - Canton, Warren – Youngstown and Erie, Pa.
SQL, Structured Query Language, is the fundamental of querying and manipulating data in today’s relational databases.
While not a simple afternoon read, it is extremely powerful, and a necessary fundamental for anyone working with data, reporting and business intelligence.
ANSI SQL is the standard that all SQL enhancements build upon. Most database vendors will add their own proprietary enhancements to SQL to assist in optimizing results under certain conditions. In Microsoft SQL Server, they call it T-SQL, in Oracle they call it PL-SQL. These proprietary extension are just that, additions to the ANSI SQL base.
Most individuals will benefit from understanding the SQL foundation, before working with vendor-specific extensions. For perspective, the Microsoft official T-SQL “introduction” class is five days in duration. It is challenging to go to that depth with no prior experience.
DeVore offers a two day Introduction to SQL class and a two day Advanced SQL class.
These classes are an ideal starting point for individuals moving to a report development role, or who currently use tools like Crystal Reports, and need to enhance their ability to acquire and manipulate information.
DeVore also offers custom SQL classes to assist with your organization’s reporting needs.
The standard Public classes are:
SQL - Basics of Writing SQL Queries and Stored Procedures View SQL Course Outline
SQL Beyond the Basics – Necessary Knowledge for Working With Data - Coming Winter 2014
DeVore has a 20 year history of training and software development, and is ideally positioned to assist you with SQL needs, report writing, and providing people to assist with projects.
References to SQL resources are difficult as there are so many, and they become very specialized very quickly.
For obtaining books, ebooks and video tutorials, the O’Reilly site is a good choice, offering a wide selection across all vendors - http://oreilly.com/
If you are working on a computer there is some merit in the .PDF ebook version. It is truly useful to have a referece on your machine that you can quickly search when encountering an issue (Ctrl-F).
For pure SQL, any book by C.J. Date will lead you to a host of other in-depth resources.
Books by C.J. Date
If you work primarily in the Microsoft world, Itzik Ben-Gan is a leading practitioner and instructor in Microsoft T-SQL. http://tsql.solidq.com/