In this introductory SQL Programming training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. It will describe the standard language, but also identify deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. In this SQL training, you will choose between working with the PostgreSQL database product or Microsoft SQL Server as you practice these skills with the hands-on exercises. The ability to write the SQL language - the cornerstone of all relational database operations - is essential for anyone who develops database applications. Attend the three-day instructor-led course and learn to leverage all that the SQL language has to offer.
View the SQL Learning Path to determine your learning journey ›
You Will Learn How To:
- Write SQL code based on ANSI/ISO standards to build database structures
- Update database content with SQL and transaction handling
- Retrieve data with filter conditions and from multiple tables using various types of join
- Process data with row and aggregate functions
-
SQL Programming Course Description
In this training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This course describes the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. For the hands-on exercises, the course environment allows the students to choose between working with the PostgreSQL database product or Microsoft SQL Server. This SQL Class includes 17 hours of Instructor-Led Training (ILT) or Virtual Instructor-Led Training (VILT) presented by a real-world SQL expert instructor.
-
Recommended Experience
- Knowledge of relational database at the level of:
- Course 382, Relational Database Design, Tools & Techniques
- Knowledge of relational database at the level of:
-
Software
For the hands-on exercises, the course environment allows the students to choose between working with PostgreSQL database product or Microsoft SQL Server.
-
Industry Credits & Certification
This course offers you the opportunity to earn the following industry credits and certifications
- 17 NASBA Credits (live, in-class attendance required)
-
After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.