Course description
Introduction to SQL (Online)
Structured Query Language (SQL) is the language used to work with databases and the information stored within them. This online, self-paced course provides a working knowledge of the basic forms of SQL, including how to select and update data from common table formats. Learners will create a database and use SQL to manipulate the data within it. (180 days to complete course)
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Training content
- Lesson 1: Introduction to Relational Databases and SQL
- Lesson 2: How to Use the Management Studio
- Lesson 3: Retrieving Data From a Single Table
- Lesson 4: Retrieving Data From Multiple Tables
- Lesson 5: Working With Summary Queries
- Lesson 6: Working With Sub Queries
- Lesson 7: Inserting, Updating and Deleting Data
- Lesson 8: Working With Data Types
- Lesson 9: Working With Functions
- Lesson 10: Designing a Database
- Lesson 11: How to Create a Database and Its Tables
Costs
The cost of this training course includes all course materials.
Certification / Credits
Upon completion, participants will receive a Certificate of Completion with CEUs.
Learner Outcomes
Upon completion, participants will be able to:
- Install the SQL Server demo and explore the basics of relational databases.
- Write SQL SELECT statements to retrieve data from a single data table.
- Write SQL SELECT statements with JOINS to retrieve data from multiple tables.
- Write queries to summarize data using aggregate functions.
- Write queries that contain sub queries.
- Write queries to insert, update and delete data from data tables.
- Write queries to convert and edit data in the database.
- Design and create a database.
Contact this provider
Corporate College, a Division of Cuyahoga Community College
Founded in 2003, Corporate College offers Northeast Ohio businesses and individuals professional training and development, along with state-of-the-art meeting and conference space at Corporate College East in Warrensville Heights and Corporate College West in Westlake. Whether you are engaged with...