Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications Autodesk Microsoft QuickBooks Windows Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Test Prep Test Prep Exam Prep Writing Writing Writing and Editing Skill Map Resources Resources About ed2go Externship Programs Financial Assistance Find a School Blog Military


(855) 520-6806

See all results for ""

See All Courses

ed2go Computer Programming Programming Classes Intermediate SQL
Return to Programming Classes

Intermediate SQL

Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language. In this course, you'll learn 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.

6 Weeks / 24 Course Hrs
Currently Enrolling

Offered in Partnership with your Preferred School


Why this school? It's been chosen based on your location or if you've visited this school's website. Change School

Learning Method


Confirm your Start Date in Cart

Starting April 17 | May 15

Intermediate SQL


Details + Objectives

Course Code: ins

What You Will Learn
  • Explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques
  • Learn to create union queries that combine records from multiple queries, and how to use union queries to exclude or include duplicate records
  • Find out how to use text strings within union queries
  • Master advanced techniques for updating various types of data stored in your tables
  • Learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields
  • Learn how to update and set NULL values using an update statement
  • Use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables
  • Learn how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set
  • Discover how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users
How the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each month
  • 2 lessons released each week
  • 24 course hours
How you will benefit
  • Gain skills that will enhance your competitiveness in the technical fields of software development and database administration
  • Learn to use a wide range of advanced SQL techniques with confidence
  • Open the door to new career opportunities as a SQL programmer


Expand All
Week 1

Get a quick review of some of the basic concepts of the SQL language, including commonly used keywords, SQL data types, constraints, logical operators, and comparison operators. Then, discover how to query multiple tables using subqueries.

Week 2

Learn how to use unions to create queries that combine records from multiple queries, enabling you to either exclude or include duplicate records. You also will learn how to order the results from a union query, how to create an alias within a union query, and how to use a text string to display a value in a union query. Then find out how to create joins using SQL-92 and SQL-89 syntax.

Week 3

Learn how to use advanced update techniques to update data stored in your tables. Then, find out how to use advanced insertion techniques to add to your tables.

Week 4

Learn advanced filtering techniques that implement the LIKE operator. Then, see how to create, query, and modify temporary tables.

Week 5

Learn how to handle duplicate values stored in a table and how to limit the results of a result set. Then learn how to use string functions to manipulate strings.

Week 6

Learn how to use the NOW () function to insert the date and time and how to insert a calculated date and time. And you'll learn how to use the YEAR (), MONTH (), MONTHNAME (), WEEKDAY (), and WEEKDAYNAME () functions to extract the year, month, name of the month, week, and name of the week from a date. You'll also learn how to use the FORMAT () function in a subquery to format dates. Finally, learn how to create and implement parameter queries.

View All Sections

Instructors & Support

Dr. Cecelia Allison

Dr. Cecelia Allison is an experienced software tester and technical specialist with more than 15 years of hands-on experience using and teaching SQL. She is also a technical writer, a published author, and a university professor. She holds a Bachelor of Science in finance, a Master of Science in information systems and a Doctor of Business Administration in management information systems.




There are no prerequisites to take this course.


Hardware Requirements: 

  • This course must be taken on a PC. It is not suitable for Mac users.

Software Requirements: 

  • Windows XP or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Microsoft Access 2003 or later. Microsoft Access is bundled with Microsoft Office here (not included in enrollment).
  • Depending on your operating system, you may be required to install additional service packs, which are available at the Microsoft Download Center.
  • 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.


  • Email capabilities and access to a personal email account.
Instructional Materials

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


Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits.

How does it work?

Once a course session starts, two lessons will be released each week for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

The interactive discussion area for each lesson automatically closes two weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The final exam will be released on the same day as the last lesson. Once the final exam has been released, you will have two weeks plus 10 days (24 days total) to complete the final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All