Want inspiration and special offers for your development? Sign up to our email alerts here!
Introduction to SQL Programming TrainingFocus on Training
Introduction to SQL Programming Training
All available course dates
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.
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...
Find out more about this Introduction to SQL Programming Training course - simply fill out your details: