Analytical Edupoint

Adchini, Delhi

Core Java Programming Introduction of Java Introduction to Java; features of JavaComparison with C and C++Download and install JDK/JRE (Environment variables set up)The JDK Directory StructureFirst Java Program through command promptFirst Java Program through Eclipse Data types and Operators Primitive Datatypes, Declarations, RangesVariable Names ConventionsNumeric Literals, Character LiteralsString LiteralsArrays(One dimensional; two- dimensional)Array of Object ReferencesAccessing arrays, manipulating arraysEnumerated Data TypesNon-Primitive DatatypesDefining a class, variable and method in JavaMethod Signature; method calls Expressions in Java; introduction to various operators Assignment OperatorArithmetic OperatorsRelational OperatorsLogical OperatorsConditional OperatorsOperator Precedence Implicit Type ConversionsUpcasting and downcastingStrict typingType conversion Control Flow statements Statements and it's various categories in Javaif, if-else, if-else-ifswitch casefor statement (both flavours traditional and enhanced for)while and do-while loopsThe continue Statement; labelled continue statementThe break Statement; labelled break statementreturn statement OOPS and its application in Java Classes and ObjectsDefining a class;Defining instance variables and methodsCreating objects out of a classMethod calls via object referencesAbstractionInterfaces and Abstract classesAbstract and non-abstract methodsInheritanceextends and implements keywords in JavaSuper class and Sub classthis keyword, super keyword in Java for inheritanceConcrete classes in JavaPolymorphismCompile time polymorphism -- Overloading of methodsRun time polymorphism -- Overriding of methodsMethod Overriding rules and method overloading rules

C++ Language Syllabus Overview:- C++ language is a superset of the C language and was initially known as C with Classes. In "C" operator ++ is used to increment the value by 1. That means to the language C, developers have added some extra features and hence named as C++. C++ is a general purpose programming language and supports object oriented programming features. Course Objectives: Understanding about object oriented programming.Gain knowledge about the capability to store information together in an object.Understand the capability of a class to rely upon another class.Learn how to store one object inside another objectLearn use of one method can be used in variety of different waysUnderstanding the process of exposing the essential data to the outside of the world and hiding the low level dataCreate and process data in files using file I/O functionsUnderstand about constructors which are special type of functionsLearn how to write code in a way that it is independent of any particular type Pre-requisite / Target Audience: Programmers looking for jobsProgrammers wanting to write efficient codeComputer Science students having Data Structures as part of their curriculumNon Computer science students wanting to enter IT industry

C Language Syllabus Introduction and First Program Why ProgrammingHistory of C LanguageHello World Program Variables and Data types Identifiers in CVariables and DataTypesConstants Constants Printf and ScanfUnformatted IO Functions Operators and Expressions Operators and ExpressionsRelational and Logical OperatorsBitwise Operators Control Flow Statements If StatementSwitch StatementUnconditional Branching using goto statementWhile LoopDo While LoopFor LoopBreak and ContinueSpecial Cases

Module 1 What is MarketingWhat is Difference between Conventional Marketing and Digital MarketingIntroduction of Digital MarketingFamous Tools for Digital MarketingPre Requisite of Digital Marketing Module 2 Introduction of Marketing FundamentalsHow to reach Target Audience Module 3 Market ResearchImportance of Market ResearchOnline Survey and Form and CreationSurvey AnalysisQuiz and their Strategy Module 4 Website DesignBuild your websiteWordpress Vs. Wix and WeeblyHow to purchase domainHow to verify WHOIS InformationHow to add Pages, Post, Menus and WidgetWordPress ThemesWordPress Security and With Plugins

GST Course

Tally Course

Taxation Course

Web Designing Course

DCA Computer Course

Module 1 Summary and Introduction of JavaDifference in JRE/JDK/JVMRun time Environment Set Up/ Environmental Variable Set UpData Type, Variable & Constant with examplesOperators is java (+, -, *, /, % and increment and Decrement operator)Conditional statements in java (is, If else & Switch)Control statements in java (For, while, do while and for each) Module 2 Arrays one dimensional, Two dimensional and MultidimensionalClasses and ObjectsIntroduction to OOPsEncapsulation or data hiding (Getters & Setters)Inheritance in JavaAccess Modifiers (Public, Private, Protected & Default) Module 3 Class Modifiers (Static & Final)Abstraction in Java- abstract classInterfaceString HandlingSuper, final, finally and This uses.RecursionVar- Arg MethodException HandlingList- Array list & Linked ListSets- Hast set, Linked Hash setCollection ClassTree set, Map, Hash MapInterview Questions

Part 1: INTRODUCTION OF DBMS AND INSTALLATIONS PROCESS Data, Databases and RDBMS SoftwaresAdvantages of SQL ServerUses, Database Engine Many Component and OLTP DatabasesBI Tool Components & Data Science ComponentsUses of SQL, Real-time Usages, SQL versus Microsoft T-SQL [MSSQL]Instance Name and Server Name, Features, Collation, Admin UsersReal-time Projects Included, Job Responsibilities; Versions and Editions of SQL ServerSQL Server and SSMS Installation, SQL Server - Career OptionsSQL Server Pre-requisites: SQL Server 2019 / 2017/2014/2012 Installations PART 2: BASICS SQL AND SSMS TOOL SSMS, Different Connections (Local and Remote)Sys Databases, Creating Objects with GUIInsertions of data, Limit, Storage capacitySys Files, Commands with script, SelectScanning and Retrieving of data(Basic Level) PART 3: DATABASE CREATIONS AND COMANDS (DDL AND DML) Creating DB, Entitles (Tables)All about SELECTDiff Data types in SQL, Select with simple and where conditions, Different kinds of Operators OR, AND, IN, LIKE, NOT LIKE, Wild cards, IS, IS NOT OPERATORS, TOP AND DISTINCT keywords and Many more.

VBA Macro Programming & Automation Macro Recording and RunningProgramming ConceptDeveloper Tab and MenuRecording a MacroSaving Macro in Different WorkbooksVarious Methods of Running a MacroCommand ButtonDesign ModeRunning Mode & Break ModeModules and ProceduresAbsolute and Relative Reference Introduction to Visual:- Basic EditorProject Explorer and Code WindowModulesFunctions and SubroutinesWorksheet Properties in Property Window Programming Basic Public and Private SubroutinesObjectMethods and PropertiesObject Hierarchy & CollectionCreating a Folder/SubfolderOpening , Saving, Closing New WorkbookOpening a saved WorkbookSelecting/Activating/Renaming/Adding SheetsRange, Cells, Columns & Row PropertiesWriting a Simple Code in VBA

INTRODUCTION TO EXCEL An Overview of Excel ScreenBasic Concept of Spreadsheet and WorkbookCreating, Editing Saving and printing)Excel Terminology: - Rows, Column and CellWorking with functions & FormulasGraphically representing data: Charts and GraphsAnalyzing Data: Data Menu Subtotal, Filtering DataDifference between Excel 2007, 2010, 2013, 2016 and Office 365, its Boundaries & FeaturesFormatting Worksheets, Securing & Protecting SpreadsheetsAll Tabs of Microsoft Excel 2013, 2016, Office 365Simple Data Entry Number, Text, Date, Selecting RangeCut, Copy, Paste, Format Printer and Move Data.Saving Excel Format LOOKUP FUNCTIONS: The LOOKUP function, Date and time functionsAnnotating formulas, Lookup, V-Lookup, H-Lookup, Match, Index, Usage Of Match FunctionHlookup And Index, 2D & 3D Lookup, Mixed LookupVlookup with Iferror, Multiple Vlookup, Vlookup with ChooseReverse VLookup, Index with Double Match DEVELOP THE WORKSHEET: Plan a Worksheet, Row and Column labelsSplit Worksheet/box/bar, copy data and formulasDisplay/Move Toolbars, Enhance worksheet appearanceUse multiple windows: Copy/Paste between worksheetsLink Worksheets, Consolidate worksheetsImportant link from other ApplicationsUse Auto Format: Create, use and modify styles and templatesPrint Features: Create/edit an outline

Introduction to Hadoop HDFS ArchitectureMapReduce Flow ChartCombiner in HadoopHello world jobPartitioner in HadoopWhy we need combiners in HadoopSqoop in Hadoop WhyPartitioner in MapRednce (Hadoop)How to load data into hive table in HadoopDifference between Internal and External Table in HadoopWhat is Oozie in Hadoop Hadoop distributed file system commandsWhat is HIVE in HadoopWhat is Hbase in HadoopMapReduce CodeMapper CodeWhat is Pig in Hadoop_Implementing Hello World Job(DriverCode)How to display Tables from RDBMS MySQL from Sqoop (Hadoop)Why we need Sqoop (Hadoop)How to display Database from RDBMS mysql for Sqoop (Hadoop)How to Import Tables from RDBMS MySQL from HDFS (Hadoop)

SAP Course

MODULE 1 Introduction to Machine LearningWhat is Machine learing?Overview about scikit-learn packageTypes of MLBasic steps of MLML algorithmsMachine learning examples MODULE 2 Data PreprocessingDealing with missing dataIdentifying missing valuesImputing missing valuesDrop samples with missing valuesHandling with categorical dataNominal and Ordinal featuresEncoding class labelsOne hot encodingSplit data into training and testing setsFeature scaling MODULE 3 Machine Learning ClassifiersK-Nearest Neighbors (KNN)Decision treeRandom forestSupport vector machines (SVM)Naive BayesLogistic Regression

Part -1 Core Python Section 1 Getting started with Python programming OverviewIntroductory Remarks about PythonA Brief History of PythonHow python is differ from other languagesPython VersionsInstalling Python and Environment SetupIDLEGetting HelpHow to execute Python programWriting your first Python programHow to work on different Popular IDEs [Pycharm, Jupyter Notebook, Spyder etc.] Section 2 Variables, Keywords and Operators VariablesMemory mapping of variablesKeywords in PythonComments in pythonOperatorsArithmetic OperatorsAssignment OperatorsComparison OperatorsLogical OperatorsMembership OperatorsIdentity OperatorsBitwise OperatorsBasics I/O and Type castingGetting user input Section 3 Data types in PythonNumbersStringsListsTuplesDictionarySets

Tableau Desktop Introduction to Tableau Section 1 Introduction to TableauTableau Installation and SetupConnecting With Different DatabaseLive Vs ExtractData Structure Section 2 Data TypeColumn FormattingSort & GroupingMeasure Name and Values and their usageDiscrete Vs Continuous Data and working on them Section 3 Parameters, Combines and SetsFilters and its typesDrill Down and Hierarchies (system defined and user definedGranularity Section 4 Title and CaptionSize, Color, Label, Shapes, Font, Details and AlignmentShading, Borders and TooltipWorksheet InterfaceManaging Metadata

DATA SCIENCE WITH R PARAMETERS SPECIFICATIONSTools Used RLearning Mode (Classroom Instructor based)Duration 58 52 HoursBatch size 5- 8 StudentsLocation Delhi (Saket)Course includes Live scenarios, Case Studies, Project, Assessments, Mock Interview.Study Material PPTs, Doc, Data, PDFs etc. TARGET AUDIENCE: Any graduate - No prior knowledge of Data Science / Analytics is required. WHAT IS R? R is open source data analysis software: and widely uses by Data scientists, statisticians, Researchers and Data analystsanyone who needs to make sense/insight of data can use R for Statistical Analysis, Data visualization, and Predictive Modeling. R is created by Ross Ihaka and Robert Gentleman at the University of Auckland in New Zealand in the 1990s as a statistical platform for their students, and thus it has been extended over the decades by thousands of user-created libraries/packages. R is a programming language: An object-oriented language created by statisticians, R provides objects, operators, and functions that allow users to explore, model, and visualize data. R is a vector language, so anyone can add functions to a single Vector without putting in a loop. And at the same time R is powerful and faster than other languages, we can easily implement Machine Learning algorithms in a fast and simple way.

Data Science with SASPARAMETERS SPECIFICATIONSTools Used SASLearning Mode (Classroom Instructor based)Duration 48 52 HoursBatch size 5- 8 StudentsLocation Delhi (Saket)Course includes Live scenarios, Case Studies, Project, Assessments, Mock Interview.Study Material PPTs, Doc, Data, PDFs etc. Target Audience:Any graduate - No prior knowledge of Data Science / Analytics is required What is SAS?SAS is licensed based software suite developed by SAS Institute for advanced analytics, Multivariate analyses, Business Intelligence, Data Management, and Predictive analytics. SAS is widely uses by Data scientists, statisticians, Researchers and Data analystsanyone who needs to make sense/insight of data can use SAS for Statistical Analysis, Data visualization, and Predictive Modeling. SAS is a leader in business analytics and No. 1 in Advanced and Predictive Analytics market share. SAS held a 30.5 percent market share for 2016 in the advanced and predictive analytics category.

This course is an introduction to databases through Microsoft Access. It is designed for people who are used to managing data in spreadsheets but wish to understand why and how a database will provide a better solution. The course covers the difference between spreadsheets and databases and takes students through the process of creating a database, from design through to data population. In the second part of the course, students learn the fundamentals of the SQL query language and gain a full understanding of how to write queries in Access for retrieving and updating data. IntroductionWhat is a database?Why use a database? Understanding your DataDesigning a databaseData modelling Overview of AccessComponentsCreating a database Creating TablesAttributesDatatypes Adding/Editing DataManual editingImporting data Filtering/Exporting TablesFiltering/sorting dataExporting data Table RelationshipsTypes of relationshipReferential Integrity SQL the LanguageTypes of queriesThe SELECT statement Query Builder in AccessBuilding queriesExpressions Multipletable QueriesThe JOIN conditionSelf joins Aggregate QueriesGROUP BY clauseAggregate functions Advanced TopicsDatabase configurationAdvanced queries