SQL Series

SQL Series

SHARE
  • Details
  • Requirements

Details

Introduction to SQL

Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.

In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.

Intermediate SQL

In this course, you'll learn advanced techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. By the end of this course, you'll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Enrollment Options:
Instructor-Led
Course Code: B8510
Start Dates*Oct 16 | Nov 13 | Dec 11 | Jan 15
*Choose start date in cart
$290.00

Requirements

  • Internet access
  • Email
  • One of the following browsers:
  • - Mozilla Firefox
    - Microsoft Internet Explorer (9.0 or above)
    - Google Chrome
    - Safari
  • Adobe PDF plug-in (a free download obtained at Adobe.com .)

For Introduction to SQL: Any type of computer with a Windows Operating System, and any desktop (standalone, not required to run over a server) or client/server (required to run over a server) Database Management System (DBMS) that you are familiar with that supports the execution of Structured Query Language (SQL). Examples include Microsoft Access, Microsoft SQL Server, Oracle, MySQL, Sybase, PostgreSQL.

Downloads and instructions for Microsoft Access and SQL Server are available in the course.

For Intermediate SQL: Microsoft Access 2003 or later (software must be installed and fully operational shortly before the course begins). Microsoft Access is bundled with Microsoft Office at the following web site: https://products.office.com/en/try. Depending on your operating system, you may be required to install additional service packs, which are available at the Microsoft Download Center:  https://www.microsoft.com/en-us/download.

NOTE: This course is not suitable for Macintosh users.