Introduction to SQL Programming
Learn how to use the Structured Query Language (SQL) to create, manipulate, and create reports from database tables. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types.
Single and multiple table queries will be created with simple and compound conditions using SQL operators such as:
Basic and complex reports will be created based on data in a table or view. Database Administration features of SQL will be discussed.
Course typically offered: Online, quarterly.
Prerequisites: Familiarity with data processing concepts and techniques.
Software: This course will use Microsoft SQL Server and Microsoft SQL Server Management Studio (SSMS). SQL Server will run natively on Windows and Linux. You can also run a SQL Server container image with Docker.
Next Steps: Upon completion of this class, consider enrolling in other required coursework in the Business Intelligence Analysis Certificate Program.
More Information: For more information about this course, please contact firstname.lastname@example.org.
Course Number: CSE-40933
Credit: 3.00 unit(s)
Related Certificate Programs: Business Intelligence Analysis, Database Management, Geographic Information Systems
+ Expand All
6/28/2021 - 8/27/2021
9/20/2021 - 11/19/2021