Advance AI With Datascience v3 Nov24
Advance AI With Datascience v3 Nov24
COM
AnISO9001:2015 Certified Advanced Software Development Training
Company Registered with Ministry Of Corporate Affairs Government of
India 2nd, Floor ACT Chambers, Mkk Nair Road, Palarivattom
Ernakulam, Kerala India, Pin code-682025 (Office:(0484)4850512, Mobile:
(+91)70342 56363,62387 43273)
***Regular Course***
Django:
Introduction to Django, MVC-MVT Pattern, Project Creation, Project Structure, Setting
Up and Running the Project, Launch Preparation, Admin Interface, Simple views.py,
settings.py Configuration, Creating Views, Using Templates, Database Setup, Models
and SQL Generation, Working with the API, Updating models.py, Creating an Admin
User, and Modifying the Poll App in the Admin Interface.
What are views, Adding views, Update the URL pattern in module/urls.py, Question list
in views.py, What is template, Django url for home page to template, Django Template
language, Render function, Django cookies, setting cookies view.py example code,
Urls.py code, Sample code modifying a cookie, Change in the urls.py, deleting cookie,
Django session, JSON Response in Django,Asynchronous JavaScript And XML, Data
Visualization, Static Folder, RESTful API CRUD, Serializers, Postman
Numpy:
Introduction to NumPy & Operations, Understanding Arrays and ndarray, Array
Dimension and Shape, Creating and Manipulating ndarray, NumPy Data Types and
Data Type Objects (dtype), Reshaping and Modifying Arrays, Indexing and Slicing,
Array Operations, Broadcasting, Iterating Over Arrays, Identity Matrices, Loading Data
from Files, Array Attributes and Memory Order, Numerical Ranges and Array Creation
Routines, Random Operations, Mathematical Functions, Exponential and Logarithmic
Functions, Aggregate Functions, String Operations, and Bitwise Operations.
Pandas:
Overview of Pandas, Data Analysis Process, Types of Analysis, Key Features of
Pandas, Installing Pandas, Data Structures (Series and DataFrame), Creating Series
(from ndarray, dictionary, scalar), Creating DataFrames (from lists, dictionaries),
Managing DataFrames (rows, columns, indices), Selecting Elements, Filtering, Handling
NaN Values, Operations between Series, Basic DataFrame Functionality, Descriptive
Statistics, Function Application, Reindexing, Renaming, Dropping Data, Working with
Text Data, Iteration, Sorting, Indexing and Selecting Data (.loc() and iloc()), Arithmetic
Operations between DataFrames, Reshaping Data (Melt & Pivot), Concatenation, and
Python Data File Formats (CSV, JSON)
Snowflake+Airflow:
Snowflake, Snowflake Architecture, How it works, Key Layers of Snowflake, Cloud
environment, CREATE WAREHOUSE, Use Warehouse, Loading Bulk Data into
snowflake, Snowflake Basics, Data preprocessing before loading to Snowflake, Pushing
preprocessed data to Snowflake, Commands to update to snowflake warehouse,
Loading data from bronze table to gold table, Visualization Using snowflake,
Visualization using Dashboards, Querying data with python, Snowflake automation,
Creating a refresh task for gold table, Snowflake in AWS, Integration of snowflake with
S3, IAM trust relationship policy, Automation in s3 to snowflake using snowpip,airflow
snowflake integration.
Databricks:
Aws Databricks, Course Topics, Why DataBricks?, Databricks Pricing, Databricks setup,
Pricing calculation, Databricks UI and Cluster Setup, Dataset, ETL goals and
Visualizations to be achieved, Import Data to Databricks using UI, Creating Code repos,
Processing using Spark in Databricks, Visualization in Databricks, External Data Access
and BI, PowerBI queries through Compute Cluster, PowerBI queries through Databricks
SQL Warehouse
Below are Add-on courses which needs to be purchased separately,
Please contact Councillor for fee details
AddOn Courses-: