ANSI SQL
Course Overview
SQL is one of the most in-demand skills for business analysts, data scientists, and anyone who finds themselves working with data. Associates will learn how to read and write complex queries to a database, perform data analysis, learn to perform multiple functions like GROUP BY, Joins, Having etc. The course also allows the associate to learn how to slice the database in order to have different types of views.
Faculty Details
Course Instructors
Learning Objectives
Associates undergoing this course will:
- Learn how to read and write complex queries to a database
- Understand how to perform data analysis
- Learn to perform multiple functions like GROUP BY, Joins, Having etc
Course Coverage
1. The different types of databases and their
(Duration: 120 minutes)
2. Different categories of commands
(Duration: 60 minutes)
3. DDL, DML, DQL, TCL, DCL
(Duration: 240 minutes)
4. Different types of functions
(Duration: 60 minutes)
5. String, Date and Time, Numeric function
(Duration: 120 minutes)
6. Joins
(Duration: 180 minutes)
7. GROUP BY, Having
(Duration: 120 minutes)
8. Sub-queries
(Duration: 120 minutes)
9. Views and Indices
(Duration: 60 minutes)
About the Faculty
