SQL Series

SQL Series

Gain a solid working knowledge of the most powerful and widely used database programming language in the world. This Structured Query Language (SQL) series help you master the fundamentals of SQL and more advanced topics through hands-on practice and programming exercises. You will even learn several real-world applications for SQL and gain valuable skills to enhance your resume.

48 Course Hrs
  • Details
  • Syllabus
  • Requirements
  • Instructor
$230.00
imc-icon
Instructor-Moderated
48 Course Hrs
Study online with Instructor moderated discussion boards.
Select a start date for each course below:
$230.00
Instructor-Moderated

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.

Syllabus

  1. Section 1
    1. Introduction to Database Design and SQL
    2. SQL Server
    3. Retrieving Data Result-Sets
    4. Sorting Data
    5. Designing SQL Data Tables
    6. Designing Data Rows
    7. Getting Data From Two Tables
    8. Retrieving Data From Multiple Tables
    9. Keeping the Database Up to Date
    10. Aggregate Functions
    11. SQL Views
    12. Maximize Database Integrity and Performance
  2. Section 2
    1. SQL Review
    2. Joining Multiple Tables
    3. Filtering Rows
    4. Grouping and Summarizing Rows
    5. Subqueries
    6. Tables and Data Maintenance
    7. Unions and Other Joins
    8. Using String and Date Functions
    9. Stored Procedures
    10. Indexes and Views
    11. Triggers
    12. SQL Server Management Studio

Requirements

Prerequisites:

There are no prerequisites to take this course.


Requirements:

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.
  • Dual monitors are helpful but are not required.

Software Requirements:

  • PC: Windows 8 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins. Student will install the required software in the course.

Other:

  • Email capabilities and access to a personal email account.
  • Necessary rights (local administrative rights) to install programs on the computer.

Instructional Material Requirements:

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

  • SQL Server Express
  • SQL Server Management Studio

Instructor

Mava Wilson

Mava Wilson, Ph.D., is a professor with more than 28 years of teaching experience. While she specializes in Information Systems (IS), she has taught several computer science topics, including basic computer literacy, programming, database design, and SQL. She holds a Ph.D. and master's degree in computing technology from Nova Southeastern University, as well as a bachelor's in administrative systems from Radford University.

Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.

Instructor-Moderated Course Code: B8510