SQL PROGRAMMING COURSE
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 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 is widely used in data analysis-related positions.
TOPICS OF THIS 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 Statement I
- Using SQL to Generate SQL Statement II
WHO SHOULD TAKE THIS COURSE?
This course is designed for data analysts, reporting analysts, data scientists, statisticians, mathematicians, computer programmers and application developers.
WHO IS THE INSTRUCTOR OF THIS COURSE?
Dr. Tareq Jaber is the instructor of this course. He received his PhD in computer science from Queen’s University, Belfast, UK in 2008. From Sep 2009 – Jul 2017, Dr. Jaber worked as an assistant professor in Computer Science at Al-Ahliyya Amman University and University of Jeddah, Amman, Jordan. Recently he started working in other research areas such as online business creation, big data, social networks Analysis and Web Semantic.
Since November 2017, Mr. Jaber has been a lead instructor at Metro College of Technology, Toronto – Canada, teaching data science courses for the Data Science and Application program. In recent years while teaching at Metro College he created and has been running a successful Amazon- based online store.
Credential: College certificate
Hours: 40
Location of course delivery: Toronto, Ontario, Canada