Introduction to SQL Programming Training is unfortunately unavailable

Thankfully we have 4 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

Questions about this class?
Get help now from a knowledge expert!

Introduction to SQL Programming Training

at Learning Tree International - Downtown, Washington, D.C.

Course Details
Price:
$1,950
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Downtown, Washington, D.C.
1110 Vermont Ave NW Ste 700
Btwn L NW & M NW Streets
Washington, District of Columbia 20005
(Map)
Share:
Important:
Course 925
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 16

What you'll learn in this sql class:

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:
  • Choose from blended on-demand and instructor-led learning options
  • Exclusive LinkedIn group membership for peer and SME community support
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
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, 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)

Course Outline
  • SQL Overview
  • Building the Database Schema
  • Manipulating Data
  • Working with the SELECT Statement
  • Querying Multiple Tables
  • Employing Functions in Data Retrieval
  • Constructing Nested Queries
  • Developing In-Line and Stored Views

Still have questions? Ask the community.

Refund Policy
If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to two weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

If a customer transfers to another course prior to two weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.

If a customer needs to cancel an enrollment two weeks prior to the start of the class or within seven days of registration, we will refund 100% of any prepaid course tuition for that enrollment.

If a customer does need to transfer or cancel a course within two weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances. Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

Map

Google Map

Learning Tree International

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 19500 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: Learning Tree International

Learning Tree International

Established in 1974, Learning Tree International is a leading provider of IT training and management training to business and government organizations worldwide. In addition, Learning Tree provides IT Workforce Optimization Solutions – a modern approach that improves the adoption of skills, and accelerates...

Read more about Learning Tree International

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DC educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

4 Top Choices

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

SQL Bootcamp

at General Assembly - Penn Quarter 509 7th St NW 3rd Fl, Washington, District of Columbia 20004

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways  -...

Saturday Dec 14th, 10am - 5pm

SQL Querying: Advanced

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle...

Wednesday Dec 18th, 10am - 5pm

SQL Querying: Basic

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but...

Monday Dec 16th, 10am - 5pm

  (2 sessions)
$990

2 sessions