Introduction to 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

Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language. In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure. Next, you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple... Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language. In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure. Next, you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements. We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL. By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database. Course Revised February 2016
Introduction to SQL course image
Reviews 0/10 stars
0 Reviews for Introduction to 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.