Course Syllabus: Introduction to SQL

no certificate
with CEU Certificate*
Course Description
Structured query language (SQL) is the language of databases. Whether you run reports or provide a dynamic website, you need to know SQL to add, delete, edit and view records. Databases organize and collect your data, and the SQL language is the liaison between you and the data. The role of database administrator includes several functions that you should know. You should know how to create and design tables, manipulate your data and run reports, create small programs (stored procedures) and use more advanced concepts such as transactional support and cursors.
This course provides a step-by-step overview and instructions that help you get started with the SQL language. We use MSSQL, but you can use this course to get started with understanding data structures and techniques for all SQL engines including Access, Oracle and MySQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT. Then, we show you how to create and design tables. We show you how to create stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.
Whether you're new to database administration or want to create customized, personal reports for your online business, this course shows you how to get started and helps you understand the SQL language from the ground up.
Course Requirements
Course Topics
Lesson 1: Introduction to SQL
Lesson 2: Retrieving Data
Lesson 3: Updating Data
Lesson 4: Inserting Data
Lesson 5: Deleting Data
Lesson 6: Sorting and Filtering Data
Lesson 7: Advanced Filtering
Lesson 8: Summarizing Data
Lesson 9: Grouping Data
Lesson 10: Using Subqueries
Lesson 11: Joining Tables
Lesson 12: Managing Tables
Lesson 13: Using Views
Lesson 14: Stored Procedures
Lesson 15: Using Cursors
Lesson 16: Using Transactions
Course Materials
Grading Policy
A brief 10 pt. quiz will follow each lesson. Students will successfully complete this course by mastering all learning outcomes with 70% or higher overall grade.
Learning Outcomes
- Demonstrate retrieving data.
- Demonstrate updating data.
- Demonstrate inserting data.
- Demonstrate deleting data.
- Demonstrate sorting and filtering data.
- Demonstrate summarizing data.
- Demonstrate grouping data.
- Demonstrate using sub-queries.
- Demonstrate joining tables.
- Demonstrate using views.
- Demonstrate using stored procedures, cursors, and transactions, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
Assessment Guide
Lesson 1 Exam | 9 |
Lesson 2 Exam | 10 |
Lesson 3 Exam | 8 |
Lesson 4 Exam | 9 |
Lesson 5 Exam | 10 |
Lesson 6 Exam | 10 |
Lesson 7 Exam | 10 |
Lesson 8 Exam | 10 |
Lesson 9 Exam | 8 |
Lesson 10 Exam | 8 |
Lesson 11 Exam | 9 |
Lesson 12 Exam | 9 |
Lesson 13 Exam | 10 |
Lesson 14 Exam | 10 |
Lesson 15 Exam | 10 |
Lesson 16 Exam | 10 |
Final Exam | 73 |
Total Points: | 223 |
Related Articles
- How to Use Cursors in SQL
- Using the SELECT Statement in SQL
- Using the IN, NOT, and LIKE Operators in SQL
- Using the GROUP BY Operator in SQL
- How to Use Subqueries in SQL
- How to Style CSS Lists
- A Real World Example Using jQuery
- Adobe Premiere: Importing and Using Media
- Understanding Advanced MySQL Concepts
- Adobe Premiere: Using the Source Monitor
- jQuery Methods for Creating Advanced Animation
- How to Paint in Adobe Photoshop
- Adobe After Effects: Working with Masks and Animated Layers
- Getting Started with Adobe Captivate
- Manipulating and Working with MS Publisher 2016 Templates