0345 4506120

Introduction to SQL Programming Training

Course Details

Name Introduction to SQL Programming Training
Description
URL
Location:
Virtual Classroom
Start Date:
Working Days:
Price:
£1241.00 +vat
Availability:
Exam:
Residential:
Course ID:
448166

Overview

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 optimise 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.

In this training, you learn how to optimise 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.

Learning Objectives

  • 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

Pre-Requisites

Knowledge of relational database at the level of: Relational Database Design, Tools & Techniques

Course Content

SQL Overview

  • Outlining SQL as the cornerstone of database activity
  • Applying the ANSI/ISO standards
  • Describing the fundamental building blocks: tables, columns, primary keys and foreign keys

Building the Database Schema

Creating tables and columns

  • Building tables with CREATE TABLE
  • Modifying table structure with ALTER TABLE
  • Adding columns to an existing table
  • Removing tables with DROP TABLE

Protecting data integrity with constraints

  • Guaranteeing uniqueness with primary key constraints
  • Enforcing integrity with foreign key constraints
  • Imposing business rules with check constraints

Improving performance with indexes

  • Expediting data retrieval with indexes
  • Recommending guidelines for index creation

Manipulating Data

Modifying table contents

  • Adding table rows with INSERT
  • Changing row content with UPDATE
  • Removing rows with DELETE

Applying transactions

  • Controlling transactions with COMMIT and ROLLBACK
  • Deploying BEGIN TRANSACTION in SQL Server

Working with the SELECT Statement

Writing Single Table queries

  • Retrieving data with SELECT
  • Specifying column expressions
  • Sorting the result with ORDER BY
  • Handling NULL values in expressions

Restricting rows with the WHERE filter

  • Testing for equality or inequality
  • Applying wildcard characters
  • Avoiding NULL value pitfalls

Querying Multiple Tables

Applying the ANSI/ISO standard join syntax

  • Matching related rows with INNER JOIN
  • Including nonmatched rows with OUTER JOIN
  • Creating a Cartesian product with CROSS JOIN

Combining results with set operators

  • Stacking results with UNION
  • Identifying matching rows with INTERSECT
  • Utilising EXCEPT to find nonmatching rows

Employing Functions in Data Retrieval

Processing data with row functions

  • Conditional formatting with the CASE expression
  • Utilising the CASE expression to simulate IF tests
  • Dealing with NULL values

Performing analysis with aggregate functions

  • Summarising data using SUM, AVG and COUNT
  • Finding the highest/lowest values with MAX and MIN
  • Defining the summary level with GROUP BY
  • Applying filter conditions with HAVING

Constructing Nested Queries

Applying subqueries in filter conditions

  • Correlated vs. noncorrelated subqueries
  • Testing the existence of rows

Including subqueries in expressions

  • Placing subqueries in the column list
  • Creating complex expressions containing subqueries
  • Handling subqueries that return no rows

Developing In-Line and Stored Views

Breaking down complex problems

  • Selecting data from a query result set
  • Subqueries in the FROM clause

Creating views in a database

  • Building reusable code
  • Updateable vs. non-updateable views

Virtual

Description:

Online AnyWare™ immerses you in a dynamic online training environment where you access and participate in an actual classroom. You interact with both your instructor and your peers—just as if you were together with them in the classroom—as you master the essential knowledge and skills in today's most important IT and management topics.

With AnyWare Online Training, you can...

  • Access your course from any Internet-accessible location
  • Gain scheduling flexibility—choosing from a wide selection of course dates
  • Immerse yourself in an actual classroom experience
  • Benefit from AnyWare's unique real-time interactivity
  • Achieve the same results that you expect from an instructor-led classroom course

Frequently Asked Questions

What are the technological requirements for participating in a live, online course delivered via Online AnyWare?

To participate fully in a virtual AnyWare course, you will need the following:

  • An audio-enabled computer
  • A minimum screen resolution of 1024 x 768
  • An Intel Pentium® 4 computer, or equivalent, with a 2.5 GHz or faster processor; or an Intel Mac
  • A minimum of 1 GB of RAM
  • A reliable high-speed Internet connection, either via cable modem, DSL or corporate LAN (a wired Internet connection is strongly recommended)
  • Internet Explorer 7 or higher; or Mozilla Firefox 2 or higher
  • Support for Java and ActiveX within your browser with the latest version of Java installed
  • Adobe Flash version 8 or higher
  • Access to www.logmein.com
  • Ability to install the LogMeIn ActiveX control, which may require local administrative privileges
  • Learning Tree AnyWare will support a dual-monitor setup, which allows concurrent access to the classroom and the computer used for the hands-on exercises. This setup may enhance your training experience; however, it is not a requirement for full participation in any of our courses.

Do I need to install any special software?

None! All you need is a high-speed, flash-enabled Internet browser—Internet Explorer 7 or higher, Mozilla Firefox 2 or higher, or Safari.

Can I participate in a course via Online AnyWare using any type of operating system?

You can participate in a class on a PC or Mac. However, the hands-on exercise material in Course 2320 and Course 984 is not compatible with the Mac operating system at this time. Please contact our AnyWare support team if you are planning to participate in either of these courses using a Mac operating system.

Do I need my own microphone, earphones and/or headset?

Prior to the course, we will provide a microphone-enabled headset for you to use during the course. The headset is yours to keep after the course.

Is the virtual classroom experience really the same quality when it's delivered over the Internet?

Absolutely! Online AnyWare is designed to provide you with the same experience you would receive in the classroom. You connect to an actual classroom where you participate online in live, instructor-led training that is facilitated either at one of our Education Centres or on site at a client's location. As an online participant, you engage with the instructor and interact with your classmates just as if you were in the actual classroom. And you perform all of the same hands-on exercises, so the knowledge you learn and the skills you gain are no different than if you were taking the course as an in-class participant.

Why is Online AnyWare so much more effective than off-the-shelf, self-paced e-learning programmes?

The most important benefit of live, instructor-led training is the ability to interact with your instructor and fellow classmates. It is through such interaction that real learning takes place. Courses taken via AnyWare offer the same benefits. In fact, over half the time spent in courses is dedicated to interactive activities—where real learning happens! You'll have your specific questions answered on the spot, receive immediate clarification of anything that is confusing, perform hands-on exercises by remotely accessing an in-class PC, and share your experiences in real time with your fellow classmates. Most importantly, you'll receive expert advice on how best to apply what you learn to your own projects.

How is the classroom experience actually delivered?

Adobe Connect is the foundation technology for our AnyWare training delivery solution used to deliver our IT and management courses. You'll acquire new skills in a safe environment—your computer's files and applications are never engaged, so there is no risk of damage. A hard copy of the course materials and a microphone-enabled headset will be shipped to you prior to the course.

Using your Internet browser, you remotely access a dedicated in-class PC so that you can participate in hands-on exercises and develop new skills just as if you were in the actual classroom where your instructor is coaching in real time.

How do I connect to the classroom?

One week prior to the class start date, you will receive a "Getting Ready" e-mail with a URL and your login credentials. We'll ask you to complete a three-step validation process prior to the class start date to test your system, two-way audio connection, and Internet connection to the classroom and to your dedicated, in-class PC on which you'll be performing your hands-on exercises.

A few days before your class starts, you'll also receive a call from one of our customer service representatives who will answer any questions you may have. When it's time for the course to begin, just log in—from anywhere—and join your classmates, live in the classroom. During your course, our AnyWare support technicians are available to assist you as needed. It's that easy!

What are the course hours?

Start and end times vary for each individual course. Please confirm the start and end times during registration, as your course may be delivered from a different time zone than your own. On the first day of class, plan to log in to your classroom 30 minutes prior to the start of the class.

For the hands-on exercises, the course environment allows the students to choose between working with PostgreSQL database product or Microsoft SQL Server.

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.

Our Customers Include