• Courses
    • Graduate College
    • Professional Certificates & Courses
    • Corporate Learning
    • Executive Education
    • Online Courses
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • Atlanta Galleria Center
    • Intensive English Program
    Our Catalog
    OLLI Catalog Winter 2020
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Catalog
    • Career Development Resources
    • Financial Aid
    • KSU Discounts
    • Scholarships
    • Frequently Asked Questions
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login to Moodle

College of Professional EducationCollege of Professional Education
  • Courses
    • Graduate College
    • Professional Certificates & Courses
    • Corporate Learning
    • Executive Education
    • Online Courses
    • 50+ OLLI Program
    • Personal Enrichment Classes
    • Summer Camps
    • Atlanta Galleria Center
    • Intensive English Program
    Our Catalog
    OLLI Catalog Winter 2020
  • Events
    • Open House
    • Webinars
    • Graduation
    • Book an Event
  • Student Resources
    • Catalog
    • Career Development Resources
    • Financial Aid
    • KSU Discounts
    • Scholarships
    • Frequently Asked Questions
  • About
    • About Us
    • Blog
    • Contact
    • Instructor Application
    • Give to CPE
  • Login
    • Login to Register
    • Login to Moodle
  • Professional

    • Home
    • All courses
    • Professional
    • SQL Intermediate – Online

    SQL Intermediate – Online

    Monthly Online
    $159
    More Info / Register
    • Overview
    • More Details

    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. You’ll explore how to write and implement complex queries on multiple tables simultaneously, and you’ll discover advanced filtering, update, and insertion techniques. You’ll also find out how to create queries that accept input from users and queries that perform complicated searches on strings and dates. 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.

     

    Prerequisite: SQL Introduction (or equivalent experience)

    Learning Objectives:

    • Review basic concepts of SQL.
    • Review the basics of subqueries and learn to write and implement complex subqueries.
    • Learn how to create advanced joins to query multiple tables simultaneously.
    • Learn advanced filtering techniques that implement the LIKE operator.
    • Learn how to use string functions to manipulate strings.
    • Create and implement parameter queries.

    This course is part of the Advanced Web Design & Development Certificate.

    View a course syllabus

    For our online course refund policy, click here.

    Requirements: Internet access, e-mail, Firefox or Internet Explorer web browser, and Microsoft Access 2003 or later. Software is not included in course fee.

    You will need to create a login for your online classroom. Go to www.ed2go.com/ksuconed. Find your course by browsing the catalog or using the search bar. Click the ‘Add to Cart’ button. Select your start date and then create a Username and Password. You must make an 80 or higher on the final exam (online) to successfully complete the course. You may only take the exam once.

    If you have questions about this course, please contact the online coordinator at 470-578-6693 or online@kennesaw.edu.

    Financial Aid Options

    • WIOA

    Course Details

    • Start Date 02/10/2021
    • End Date 04/02/2021
    • Delivery Online
    • Total Hours 24
    • Class Sessions 12
    • CEUs 2.4
    • Fee $159

    No extra information available at this moment.

    • Overview
    • More Details
    $159
    More Info / Register
    • Share:

    Related Courses

    Brain Health Certificate – Online Read More
    Rodrigo

    Brain Health Certificate - Online

    Certificate Monthly Online
    0
    0
    $79
    Homeschool With Success – Online Read More
    Rodrigo

    Homeschool With Success - Online

    Monthly Online
    0
    0
    $149
    Certified Healthcare and Eldercare Mediator Certificate – Online Read More
    Rodrigo

    Certified Healthcare and Eldercare Mediator Certificate - Online

    Certificate Online Start-Anytime
    0
    0
    $3,895
    Understanding Closing Statements – Online Read More
    Rodrigo

    Understanding Closing Statements - Online

    Online Start-Anytime
    0
    0
    $99
    Wow- What a Great Event – Online Read More
    Rodrigo

    Wow- What a Great Event - Online

    Monthly Online
    0
    0
    $159
    CompTIA A+ Certification Preparation Intermediate – Online Read More
    Rodrigo

    CompTIA A+ Certification Preparation Intermediate - Online

    Monthly Online
    0
    0
    $179

    Categories

    • Professional
      • • Architecture & Construction
      • • Business
      • • Culinary & Hospitality
      • • Educators
      • • Entrepreneurship
      • • Finance
      • • Healthcare
      • • Languages & Translation
      • • Legal
      • • Real Estate
      • • Technology
      • • Test Prep
    • Personal Enrichment
      • • Art
      • • Cooking
      • • Finance & Investment
      • • Health & Fitness
      • • Languages
      • • Lifestyle
      • • Photography
      • • Writing
    • 50+ OLLI
      • • Art & Music
      • • Events & Travel
      • • Health & Wellness
      • • History
      • • Languages & Writing
      • • Leisure
      • • OLLI Scholar Computer Certificate
      • • OLLI Scholar Spanish Certificate
      • • Personal Finance
      • • Technology & Computers
    CPE Logo

    Kennesaw - KSU Center

    3333 Busbee Drive, #3301
    Kennesaw, Georgia 30144

    (470) 578-6765

    • Facebook
    • Twitter
    • Instagram
    • Linkedin
    • YouTube
    • Blog

    Courses

    • Graduate College
    • All Courses
    • Professional Certificates & Courses
    • Online Courses
    • Personal Enrichment Classes

    For Students

    • Career Development Resources
    • Catalog
    • Financial Aid
    • Military Education Benefits

    Quick Links

    • Blog
    • Contact
    • Corporate Learning
    • Open House

    © 2020 Kennesaw State University College of Professional Education

    • Privacy
    • Policies
    • Sitemap
    • Text Only