SQL Series

SQL Series

48 Course Hrs
  • Details
  • Syllabus
  • Requirements

Details

The SQL Series will help you gain a full understanding of this universal programming language. You'll start by learning key concepts and move on to more advanced topics as you progress through the lessons. By the end of the series, you'll have a solid working knowledge of SQL.

Start with the key concepts of SQL as you learn about the basic structure of relational databases and how to write simple and complex SQL statements. You'll learn to write queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; gather significant statistics from data stored in a database; and more. 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.

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 09 | Jan 13 | Feb 10 | Mar 17
*Choose start date in cart
$199.00 USD

Syllabus

Lesson 1: Introduction to Database Design and SQL

Lesson 2: SQL Server

Lesson 3: Retrieving Data Result-Sets

Lesson 4: Sorting Data

Lesson 5: Designing SQL Data Tables

Lesson 6: Designing Data Rows

Lesson 7: Getting Data From Two Tables

Lesson 8: Retrieving Data From Multiple Tables

Lesson 9: Keeping the Database Up to Date

Lesson 10: Aggregate Functions

Lesson 11: SQL Views

Lesson 12: Maximize Database Integrity and Performance

 

Lesson 1: SQL Review

Lesson 2: Joining Multiple Tables

Lesson 3: Filtering Rows

Lesson 4: Grouping and Summarizing Rows

Lesson 5: Subqueries

Lesson 6: Tables and Data Maintenance

Lesson 7: Unions and Other Joins

Lesson 8: Using String and Date Functions

Lesson 9: Stored Procedures

Lesson 10: Indexes and Views

Lesson 11: Triggers

Lesson 12: SQL Server Management Studio

Requirements

Hardware Requirements:

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

Software Requirements:

  • Windows 8 or newer.
  • 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 Acrobat Reader. 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