CS301 - Introduction to SQL

Course Description

This course introduces SQL using Microsoft SQL Server to demonstrate generic SQL commands that can be used with a variety of client/server database systems. Learn how to do ad-hoc queries on a database to select the information you need. Understand how to write select statements and use wildcards, logical operators, and calculated columns. Learn to eliminate duplicates and work with date data. Learn how to aggregate data as well as group data, order data, and generate totals. Topics include SQL syntax, data definition language, and data manipulation language.

In this course, you will learn to: 

• Gain a basic understanding SQL features and standards, as well as general database terminology. 

• Create basic queries using the SELECT statement. 

• Specify criteria for your queries, using the WHERE clause and wildcards. 

• Sort the data in your queries, using the ORDER BY clause. 

• Combine criteria using the AND and OR operators. 

• Statistically summarize data using aggregate functions, such as SUM and COUNT. 

• Combine aggregate data and line-item values using GROUP BY and HAVING. 

• Learn to use all of these commands on the three most basic types of data: Character, Numeric and Date. 

Applies Towards the Following Certificates

• Data Analysis Certificate : Core Courses
• Database Technology Certificate : Core Courses
• Programming Certificate : Required Courses
• Python Data Analysis Certificate : Electives