SQL Series

SQL Series

48 Course Hrs
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

When it comes to query language for relational database management systems, SQL is the industry benchmark. This hands-on course will help you advance your knowledge and keep pace with today’s SQL standards. You will practice designing, writing, and testing complex SQL queries to execute on a practice database using SQL Server Express.

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*Dec 11 | Jan 15 | Feb 12 | Mar 18
*Choose start date in cart
$199.00

Requirements

Hardware Requirements: 

  • This course must be taken on a PC. A Mac is not compatible.

Software Requirements: 

  • Windows 8 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Any Database Management System (DBMS) (not included in enrollment) that you are familiar with that supports the execution of Structured Query Language (SQL), such as:
    • Microsoft Access
    • Microsoft SQL Server
    • Oracle
    • MySQL
    • Sybase
    • PostgreSQL
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Software must be installed and fully operational before the course begins.

Other:

  • Email capabilities and access to a personal email account.

 

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:

The instructional materials required for this course are included in enrollment and will be available online.

SQL Server Express
SQL Server Management