SQL Programming Language Introduction

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 Learning Tree 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 databasesExperienced data processing professionals working with traditional database systems (hierarchical or network), who are now moving to relational databasesIT 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...