Connecting to Databases in R, Packages Installation, Connect to Database, Execute Queries, Write Data, Disconnect and Error Handling

Advanced Certification in Data Science & Gen AI with Visualizations Tools Connecting to Databases in R, Packages Installation, Connect to Database, Execute Queries, Write Data, Disconnect and Error Handling

Advanced Certification in Data Science & Gen AI with Visualizations Tools

0% Completed

Advanced Excel

Orientation (Introduction to Data Science, Scope of Data Science)

Video - 00:15:04 mins

Python

Introduction to Python, Why Python, Variables, Data Types, Type castings, Strings, Indexing

Video - 00:15:03 mins

Operators and Conditional Statements, Looping Statements and it's Control Statement

Video - 00:00 mins

Lambda Functions, *args, **kwargs, Functions

Video - 00:00 mins

Data Structures - List, Tuple and List Comprehensions

Video - 00:00 mins

Data Structures - Set and Dictionaries

Video - 00:00 mins

Classes, Objects and Constructors, Inheritance

Video - 00:00 mins

Polymorphism, Abstraction and Encapsulation

Video - 00:00 mins

Connecting to Databases, Establishing connections to databases, Executing SQL Queries, ORM (Object-Relational Mapping), Working with NoSQL Databases

Video - 00:00 mins

Introduction of Numpy, and Pandas

Video - 00:00 mins

Introduction of Seaborn and Matplotlib

Video - 00:00 mins

Statistics

Introduction to Statistics, Descriptive Statistics, Sample, Population, Major of Central Tendency, Standard Deviation,

Video - 00:00 mins

Variance, Range, IQR, Outliers, Correlation, Covariance Skewness, Kurtosis, Probability

Video - 00:00 mins

Probability, Probability distributions, Central Limit Theorem, Binomial and Poisson Distribution

Video - 00:00 mins

Normal Distribution, Type I & Type II Error

Video - 00:00 mins

T-test, Z-test, Hypothesis, Testing Interview Questions

Video - 00:00 mins

Machine Learning

Introduction to ML, Types of variables, Encoding, Normalization, Standardization, Types of ML, Linear Regression

Video - 00:00 mins

Linear Regression, Logistic Regression, SVM, KNN, Naïve Bayes, Decision Tree, Random Forest

Video - 00:00 mins

Mean Absolute Error, Mean and Root Mean Square Error, Confusion Matrix, R2 Score, Adjusted R2 Score,F1 Score

Video - 00:00 mins

Classification Report, AUC ROC, Accuracy, Ensemble Techniques, Random Forest, Xgboost

Video - 00:00 mins

Unsupervised Machine Learning, PCA, Clustering, k-Means Clustering and Hierarchical clustering

Video - 00:00 mins

Deep Learning

Introduction to Neural Network, Foreward Propagation, Activation Function

Video - 00:00 mins

Activation Function(Linear, Sigmoid, Relu, Leaky Relu), Optimizers, Gradient Descent, Stochastics Gradient Descent

Video - 00:00 mins

Mini batch Gradient Descent, Adagrad, Padding, Pooling, Convolution

Video - 00:00 mins

Checkpoints and Neural Networks Implementation and Introduction to Time Series Analysis,

Video - 00:00 mins

Various components of the TSA, Decomposition Method (Additive Method and Multiplicative)

Video - 00:00 mins

ARMA and ARIMA

Video - 00:00 mins

R- Programming

Introduction to R, Installing R and RStudio, Basics of RStudio IDE, Writing and executing R scripts, Variables and Data Type in R, Operators

Video - 00:00 mins

Creating vectors, Vector indexing and slicing, Vectorized operations, Creating matrices, Matrix operations, Matrix indexing, Creating lists, Creating data frames, Indexing and manipulating lists and data frames

Video - 00:00 mins

Conditional statements, Loops, Applying functions, Flow Control, Functions in R, Object-Oriented Programming in R, S3 and S4 classes, Methods and inheritance, Creating and using objects

Video - 00:00 mins

Creating and using factors, Working with dates and times, Reading and writing(CSV files and Excel files), Introduction to the readr and readxl packages

Video - 00:00 mins

Introduction to dplyr, Selecting, filtering, and arranging data, Grouping data, Summarizing data with summarize and mutate

Video - 00:00 mins

Data Manipulation in R- dplyr, Data Manipulation & Data Visualization in R- tidyr

Video - 00:00 mins

Introduction to Text Mining, Text Preprocessing, Document-Term Matrix (DTM) and TF-IDF, Exploratory Text Analysis, Sentiment Analysis

Video - 00:00 mins

Install Necessary Packages, Create a New Package, Package Structure, Writing Functions, Documenting Functions, Testing Your Package, Building and Checking and Sharing Your Package

Video - 00:00 mins

Introduction to APIs, Using the 'httr' Package, GET & POST Request, and Authentication, Introduction to Web Scraping, Using the 'rvest' Package, Handling Dynamic Content, Handling Sessions and Cookies

Video - 00:00 mins

Connecting to Databases in R, Packages Installation, Connect to Database, Execute Queries, Write Data, Disconnect and Error Handling

Video - 00:00 mins

Project Session

Video - 00:00 mins

SQL

Basic of Database,Types of Database,Data Types, SQL Operators, Expression, Create, Insert

Video - 00:00 mins

Drop, Truncate, Delete, Alter, Update, Select, Range, Operater, IN,Wildcard, Like, Clause

Video - 00:00 mins

Constraint, Aggregation Function, Group by, Order by, Having

Video - 00:00 mins

Joins, Case, Complex Queries, Doubt Clearing

Video - 00:00 mins

Tableau

Tableau Desktop, Tableau products

Video - 00:00 mins

Data import, Measures, Filters

Video - 00:00 mins

Data transformation, Marks, Dual Axis

Video - 00:00 mins

Manage worksheets, Data visualization, Dashboarding,Project

Video - 00:00 mins

Power BI

Power BI Platform, Process Flow

Video - 00:00 mins

Features, Dataset, Bins

Video - 00:00 mins

Pivoting, Query Group, DAX Function

Video - 00:00 mins

Formula, Charts, Reports, Dashboards

No-SQL

Introduction, SQL vs NoSQL, Data Model, Data types, Object ID, DAta type, Binary Data, Date, Null, Boolean, Integer, String

Video - 00:00 mins

Collection method, queries, CRUD Operation, Insert, Find, Update, Delete, Validate, Bulk write, Delete one

Video - 00:00 mins

Java

Introduction to the Java, Installation, Syntax main()/printIn()/print()/ Variable [String, Int, Boolean, float, char], Datatypes, Operators

Video - 00:00 mins

Conditions, Loop, Methods, Class, File Handling

Video - 00:00 mins

Introduction of BigData & Hadoop

Types of Data, Introduction to Bigdata(History, V's of Bigdata, Advantages & Disadvantages of BigData ), Big Data Applications in Various Sectors, Introduction to Hadoop, Scaling (Horizontal and Vertical), Challenges in Scaling, Parallel Computing, Distributed Computing and Hadoop, Hadoop Tools Overview, Big Data Analytics Lifecycle

Video - 00:00 mins

On Premises Installation Oracle Virtual Box and setup of VM & Ubuntu, Basic Linux command, Download and Installation of Hadoop, Introduction to Hadoop, Core components of Hadoop, Hadoop working, Principle

Video - 00:00 mins

VM creation on Cloud (AZURE), Configuration & Insight to Single Node Hadoop Deployment(bsshrc, hadoop-env, core-site, hdfs-site, mapred-site, yarn-site) , Format HDFS Namenode.

Video - 00:00 mins

HDFS Architecture, Hadoop Commands and Implementation

Video - 00:00 mins

Mapreduce, Mapreduce Implementation

Video - 00:00 mins

Introduction to Hive, Hive Installation, Hive Implementaion

Video - 00:00 mins

Hive Query Language, SQL Opeartions

Video - 00:00 mins

HIVE_SQL Opeartions

Video - 00:00 mins

SPARK

Installation of Spark, PySpark, Introduction to Sqoop, Installation of Sqoop,

Video - 00:00 mins

PySpark Query, Installation of Hbase, Hbase Query

Video - 00:00 mins

PIG Installation and Query

Video - 00:00 mins

PIG Query, Oozie

Video - 00:00 mins

Flume and Doubt Clear

Video - 00:00 mins

Project Session

Video - 00:00 mins

Computer Vision

Introduction to Image Processing, Feature Detection, OpenCV

Video - 00:00 mins

Convolution, Padding, Pooling & its Mechanisms

Video - 00:00 mins

Forward Propagation & Backward Propagation for CNN

Video - 00:00 mins

CNN Architectures like AlexNet, VGGNet, InseptionNet, ResNet, Transfer Learning

Video - 00:00 mins

NLP

Introduction to Text Mining, Text Processing using Python and Introduction to NLTK

Video - 00:00 mins

Sentiment Analysis, Topic Modeling (LDA) and Name- Entity Recognition

Video - 00:00 mins

BERT (Bidirectional Encoder Representations from Transformers), Text Segmentation, Text Mining, Text Classification

Video - 00:00 mins

Automatic Speech Recognition, Introduction to Web Scraping

Video - 00:00 mins

RL Framework, Component of RL Framework, Exampes of Systems

Video - 00:00 mins

RL Framework, Component of RL Framework, Exampes of Systems

Video - 00:00 mins

Types of RL Systems, Q-Learning

Video - 00:00 mins

Project Session

Video - 00:00 mins

Introduction to Gen AI & Huggingface transformers platform

Introduction to AI, Hype vs. Reality, Business Applications, Ethical Considerations, Introduction to Generative AI, From Text Generation to Multimodal Models, Potential and Challenges

Video - 00:00 mins

Introduction to open source Huggingface transformers platform, Review of NLP Basics & Text Pre-processing, Introduction to NLP Concepts: Language Representations, Tokenization, Part-of-Speech Tagging, Text Preprocessing

Video - 00:00 mins

Feature Engineering: Normalization, Stemming, Lemmatization, Stop Word Removal, Understanding key NLP Applications using Huggingface platform

Video - 00:00 mins

Sentiment analysis, Sentence classification, Generating text, Extracting an answer from text

Video - 00:00 mins

Language Models and Transformer Models

Understanding language models, Probability-based language models, Unsupervised learning language representations, Introduction to transformer models, What are transformer models

Video - 00:00 mins

Types of models: encoder –decoder, decoder only, Attention mechanism, Tasks that transformer models can do: translation, text summarization, Q&A, text generation, Zero shot, few shot text classification

Video - 00:00 mins

Large Language Models (LLMs)

Introduction to Large Language Models (LLMs), - Structure of popular models - Types of Models: text to text, text to image, text to video, multimodal

Video - 00:00 mins

Other types of Generative AI algorithms, - GANs ( Generative Adverserial Networks), - Variational Autoencoders (VAEs), Diffusion Models, Mixture of Experts, - Diffferent models available currently for image ( DALLE-2, Midjourney)

Video - 00:00 mins

Hands on practice of NLP tasks using Huggingface library and opensource language models such as Bloom for finetuning a LLM, zero and few shot classification, -Applications of Generative AI in business

Video - 00:00 mins

- Customer Insights & Sentiment Analysis - Personalized Marketing & Content Creation - Chatbots: Automating Customer Service and Support - Document Processing Automation

Video - 00:00 mins

Langchain, AI Application Stack and Ethical Considerations

Langchain, Applied use case for Gen AI – hands on exercise - Designing a custom chatbot - Data analytics using Gen AI model such as OpenAI API

Video - 00:00 mins

AI Application Stack: Infrastructure & foundation layer - Overview of AI infrastructure: cloud platforms, GPU, and distributed computing, - Setting up an AI environment for generative models - Infrastructure considerations for scalable AI applications - Retrieval augmentation generation or RAG

Video - 00:00 mins

Hallucination, Data Privacy, Ethics, and Environmental Impact of AI & future of Work - Importance of data privacy in AI applications - Ethical considerations in AI development and Deployment - Environmental Impact and Sustainability in AI - The Future of Work: How AI Will Reshape Roles and Responsibilities

Video - 00:00 mins

Project Session

Video - 00:00 mins

Announcements Reviews Course Info

Previous Next

Advanced Certification in Data Science & Gen AI with Visualizations Tools Connecting to Databases in R, Packages Installation, Connect to Database, Execute Queries, Write Data, Disconnect and Error Handling

Advanced Certification in Data Science & Gen AI with Visualizations Tools

Finish Course Early?