Intermediate SQL

Provided by:
0/10 stars
based on  0 reviews
Provided by:
Cost $69
Start Date On demand

Course Details

Cost

$69

Upcoming Schedule

  • On demand

Course Provider

Ed2Go online courses
Through personalized instruction and relevant class material, ed2go helps adults continue their education and further their careers with courses from over 2,000 top institutions. For each course that you take, there are a number of convenient resources that aid in your development and strengthen your knowledge on the subject. Understand the goals of a class through course objectives, search through frequently asked questions by students, get recommendations on course-related texts and use ...
Through personalized instruction and relevant class material, ed2go helps adults continue their education and further their careers with courses from over 2,000 top institutions. For each course that you take, there are a number of convenient resources that aid in your development and strengthen your knowledge on the subject. Understand the goals of a class through course objectives, search through frequently asked questions by students, get recommendations on course-related texts and use course-related materials like CDs, books and videos that will help you throughout your online education experience. If you are looking to jumpstart your career or remain current in your field, try one of over 100 online career training programs. Whether healthcare, business, or sustainability, ed2go helps make professional development simple. Learn how to play the guitar through a series of thought- out lessons or put your writing skills to the test with a class on young adult fiction. Not sure where to start? Try out any of the demo lessons to see which online classes may be best suited to you and your goals.

Provider Subject Specialization
Humanities
Business & Management
4 reviews

Course Description

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. First, you'll explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You'll learn to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. In addition, you'll find out how to use text strings within union queries. Next, you'll master advanced techniques for updating various types of data stored in your tables. You'll learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields. And you'll see how to update and set values using an update statement. In addition, you'll... 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. First, you'll explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You'll learn to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. In addition, you'll find out how to use text strings within union queries. Next, you'll master advanced techniques for updating various types of data stored in your tables. You'll learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields. And you'll see how to update and set values using an update statement. In addition, you'll use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables. You'll also see how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set. And finally, you'll 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. 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.
Intermediate SQL course image
Reviews 0/10 stars
0 Reviews for Intermediate SQL

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

No reviews yet. Be the first!

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.