SQL Programming

This SQL Programming course (SQL Programming for Data Analysis and Data Scientists) teaches the fundamentals of SQL programming and advanced information processing.

Students will learn to query and modify data, create tables, enforce data integrity, and implement advanced data access techniques. Students will be equipped with the skills to utilize the SQL DBMS language to understand and provide data-driven solutions to a wide range of business challenges. The knowledge and skills of SQL programming are widely used in data analysis-related positions.

Topics of the SQL Programming Course:

• Introduction to Query, Expressions, Conditions and Operators

• Functions: Modeling the Data you retrieve

• Clauses in SQL

• The Embedded SELECT Statement

• Manipulating Data

• Creating Views and Indexes

• Controlling Transactions I

• Controlling Transactions II

• Using SQL to Generate SQL Statements

• Using SQL to Generate SQL Statement II