Data Analytics
Curriculum
-
Introduction to Oracle Database :
-
Retrieve Data using the SQL SELECT Statement
-
Learn to Restrict and Sort Data
-
Write queries that contain a WHERE clause to limit the output retrieved
-
Write queries that contain a WHERE clause to limit the output retrieved
-
Describe the rules of precedence for comparison and logical operators
-
Describe the rules of precedence for comparison and logical operators
-
Describe the rules of precedence for comparison and logical operators
-
Sort output in descending and ascending order
-
Sort output in descending and ascending order
-
Invoke Conversion Functions and Conditional Expressions
-
Aggregate Data Using the Group Functions
-
Display Data From Multiple Tables Using Joins
-
Write SELECT statements to access data from more than one table
-
View data that generally does not meet a join condition by using outer joins
-
View data that generally does not meet a join condition by using outer joins
-
Cross Join
-
Equi Join
-
Non Equi Join
-
Outer Join
-
Left outer Join
-
Right Outer Join
-
Right Outer Join
-
Data Manipulation Statements
-
Use of DDL Statements to Create and Manage Tables
-
Control User Access
-
Microsoft Excel (Only for Freshers)
-
Working with Excel’s Conditional Functions
-
Python Training Modules
-
Introduction
-
Data Types & Variables
-
Python Operators
-
Python Strings
-
Python Lists
-
Python Tuples
-
Python Sets
-
Python Dictionary
-
If Else Statement
-
While Loop
-
For Loop
-
Functions
-
Recursions
-
Lambda
-
Object Oriented Programming
-
Inheritance(OOP)
-
Math Functions
-
Python Modules
-
Python Modules
-
File Handling
-
JSON
-
Pandas
-
Numpy
-
Advance OOPS Concept
-
Abstract
-
Polymorphism
-
Encapsulation
-
Database Connectivity Using(Pandas)&(Psycopg)
-
Server side scripting
-
Data Frame
-
Matplotlib
-
SciPy
-
JupyterNote
-
Introduction to Oracle Database :
-
Retrieve Data using the SQL SELECT Statement
-
Learn to Restrict and Sort Data
- Write queries that contain a WHERE clause to limit the output retrieved
- Write queries that contain a WHERE clause to limit the output retrieved
- Describe the rules of precedence for comparison and logical operators
- Describe the rules of precedence for comparison and logical operators
- Describe the rules of precedence for comparison and logical operators
- Sort output in descending and ascending order
-
Sort output in descending and ascending order
-
Invoke Conversion Functions and Conditional Expressions
-
Aggregate Data Using the Group Functions
-
Display Data From Multiple Tables Using Joins
- Write SELECT statements to access data from more than one table
- View data that generally does not meet a join condition by using outer joins
- View data that generally does not meet a join condition by using outer joins
- Cross Join
- Equi Join
- Non Equi Join
- Outer Join
- Left outer Join
- Right Outer Join
- Right Outer Join
-
Data Manipulation Statements
-
Use of DDL Statements to Create and Manage Tables
-
Control User Access
-
Microsoft Excel (Only for Freshers)
-
Working with Excel’s Conditional Functions
-
Python Training Modules
- Introduction
- Data Types & Variables
- Python Operators
- Python Strings
- Python Lists
- Python Tuples
- Python Sets
- Python Dictionary
- If Else Statement
- While Loop
- For Loop
- Functions
- Recursions
- Lambda
- Object Oriented Programming
- Inheritance(OOP)
- Math Functions
- Python Modules
- Python Modules
- File Handling
- JSON
- Pandas
- Numpy
- Advance OOPS Concept
- Abstract
- Polymorphism
- Encapsulation
- Database Connectivity Using(Pandas)&(Psycopg)
- Server side scripting
- Data Frame
- Matplotlib
- SciPy
- JupyterNote
Overview
Certification
Benfits of NSDC certification
- The course content has been vetted and approved by the NSDC, meaning it aligns with industry standards and has a good chance of leading to employment.
- The training center has met certain quality standards, such as having a certain number of trainers and equipment.
- You may be eligible for a loan from the NSDC to pay for the course.
- You may be able to get a certificate recognized by the government and industry.
- You may be able to get placement assistance after completing the course
Certification
Benfits of NSDC certification
- The course content has been vetted and approved by the NSDC, meaning it aligns with industry standards and has a good chance of leading to employment.
- The training center has met certain quality standards, such as having a certain number of trainers and equipment.
- You may be eligible for a loan from the NSDC to pay for the course.
- You may be able to get a certificate recognized by the government and industry.
- You may be able to get placement assistance after completing the course
Instructor
Pass PercentageRELATED COURSES
Courses You May Like
beginner
Business Analytics
Free
expert
Logistics Analytics
Free