PDF Add to WishList
The ability to write the SQL language — the cornerstone of all relational database operations — is essential for anyone who develops database applications. The SQL Language is an ANSI/ISO standard language used by all relational database products. In this training course, 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.
Key Features of This SQL Programming Training:
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.
For the hands-on exercises, the course environment allows the students to choose between working with PostgreSQL database product or Microsoft SQL Server.
Creating tables and columns
Protecting data integrity with constraints
Improving performance with indexes
Modifying table contents
Writing Single Table queries
Restricting rows with the WHERE filter
Applying the ANSI/ISO standard join syntax
Combining results with set operators
Processing data with row functions
Performing analysis with aggregate functions
Applying subqueries in filter conditions
Including subqueries in expressions
Breaking down complex problems
Creating views in a database
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
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.
Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online any time after class.
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
“After taking the SQL Programming Course, I am able to write code myself to retrieve data from our databases. My turn-around time for project completion has been significantly reduced, because I no longer have to wait for the tech team to run scripts for me: I get the specific data I need, how I need it. My efficiency levels have definitely risen, and my managers are aware of the improvement.”
- S. Cope, Compliance Analyst
Depository Trust and Clearing Corp.