Introduction to SQL Programming Training

Focus on Training
Course summary
Next available date: - United Kingdom
Professional Training

Course description

This is an introductory level course which focuses on standard SQL. Whenever features outside of the standard are required, this course covers these features in two of the most commonly used database products, Oracle Database and Microsoft SQL Server. This comprehensive course provides a good foundation for the product specific courses covering Oracle and SQL Server.

What is SQL?

Structured Query Language, or SQL, is the language used by all relational database management systems to build, manipulate and access database contents. The name is somewhat misleading - while "queries" are the most extensive and complex part of the language, SQL is also used for updating and building databases. SQL is standardised through various versions of the ANSI/ISO SQL standard. However, none of the database products follow the standard 100%. They all have dialectic variations to the language. In order to work with a particular database, the programmer will need to be aware of product-specific features for that particular database system, in addition to the common functionality provided in the standard.

Who will benefit from this course?

This course is valuable for a wide range of professionals including:

  • Developers, analysts, administrators, managers, programmers, consultants and others who design and write applications using relational databases
  • Experienced data processing professionals working with traditional database systems (hierarchical or network), who are now moving to relational databases
  • IT managers and project leaders who need a general overview of the features and functionality of SQL

Which database system is used for the course exercises?

The exercises in this course use two database management systems: Oracle Database 12c and Microsoft SQL Server 2014. The examples and exercises in the course will also work on earlier versions of the two products. Attendees have a choice between these two systems for the hands-on exercises. All examples and exercises are designed to work on both systems and the differences between the dialects will be pointed out during class.

About provider

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...

Read more and show all courses with this provider

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here