Smart Bit is a 18 Years old Government Recognised Training Institute with over 20 Year’s Excellence In a Computer Education . Smart Bit is known for its quality Computer Education and is recognised as a leader in providing IT training.
Asp.Net MVC 6 Course Overview
Prior .NET web application development experience and familiarity with Object-Oriented Programming concepts is assumed. Some experience with HTML and JavaScript is also expected. Experience developing ASP.NET applications with Web Forms would be beneficial.
Asp.Net MVC 6 Training Course Objective
ASP.NET MVC gives you a powerful, patterns-based way to build dynamic websites that enables a clean separation of concerns and that gives you full control over markup for enjoyable, agile development. ASP.NET MVC includes many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards.
Asp.Net MVC 6 Training Course Overview
Introduction to ASP.NET MVC 6
Getting started with MVC Core
Controllers
Views (Razor)
LayoutViews
Partial Views
Models
Entity Framework in MVC
Scaffold Templates in MVC
HTML Helpers
Action Filters
Bundles and Minification
Validations
Data Annotations
jQuery in MVC
jQuery AJAX in MVC
Web API
Security in MVC
What’s new in MVC Core
Repository Layer and Service Layer
Dependency Injection
Consuming WCF in MVC
Database – First approach in MVC
Areas in MVC
Mobile Web Apps using MVC
Angular JS Integration
Single Page Application (SPA)
| Interface | VLOOKUP |
| Tabs and Ribbons | VLOOKUP Exact Match |
| Document Windows | HLOOKUP |
| Navigation Tips | HLOOKUP Exact Match |
| Office Button and Save | IF Statement |
| Entering Data | Nested IF |
| Fonts, Fills, and Alignment | AND |
| Cut, Copy, and Paste | OR |
| Paste Special | NOT |
| Undo and Redo | SUMIF |
| Moving, Finding, and Replacing a Value | COUNTIF |
| Cell Styles | Case Formulas |
| Comments | Chart Types |
| Currency Format | Instant Chart |
| Format Painter | Update Chart |
| Formatting Dates | Column Chart |
| Custom and Special Formats | Picture Fill |
| Naming and Moving Worksheets | Adjust Chart Size |
| Copying Worksheets | Line Chart |
| Adding, Deleting and Hiding Worksheets | Chart Styles |
| Grouping Worksheets | Chart Layouts |
| Moving, Copying, Deleting and Hiding Grouped Worksheets | Add Labels |
| Inserting and Deleting Columns and Rows | Axis Options |
| Inserting & Deleting Cells | Chart Title |
| Inserting Multiple Columns & Rows | Legends |
| Modifying Cell Width and Height | Data Labels |
| Hiding and Unhiding Rows and Columns | Insert Pictures |
| Using Operations | Modifying Pictures |
| Creating Formulas | Insert Shapes |
| AutoSum | Insert SmartArt |
| Common Formulas | Apply Themes |
| Searching for Formulas | Group and Ungroup |
| Copying Formulas | Sort Data |
| Using Relative and Absolute References | Sort Multiple Levels |
| Workbook Views | Filter Data |
| Show/Hide | Advanced Filter |
| Zoom Features | Conditional Sorting and Filtering |
| Freeze Panes | Sorting with Custom Lists |
| Split Windows | Subtotal |
| Viewing Multiple Windows | Creating PivotTables |
| Minimize The Ribbon | Choosing Fields |
| Worksheet Backgrounds | PivotTable Layout |
| AutoFill a Series | Filtering PivotTables |
| AutoFill Non-Adjacent Cells | Modifying PivotTable Data |
| Highlight Cells Rules | PivotCharts |
| Top/Bottom Rules | Workbook Passwords |
| Data Bars | Protecting Workbooks |
| Color Scales | Document Properties |
| Custom Formatting Rule | Inserting Hyperlinks |
| Insert a Table and Style Options | Page Orientation |
| Add Rows and Columns | Page Breaks |
| Perform a Function in a Table | Print Area |
| Summarise With Pivot Table | Margins |
| Data Validation | Print Titles |
| Removing Duplicates | Headers and Footers |
| Text To Columns | Scaling |
| Goal Seek | Save As Previous Version |
| Scenario Manager | Save As PDF |
| Multiple Sheet References | Save As Web Page |
| Trace the Precedents and Dependents | Macro-Enabled Workbook |
| Cell Names | Recording a Macro |
| Named Ranges | Assign a Macro to a Button or Shape |
| Formulas with Cell Names | Run a Macro upon Opening a Workbook |
| Date Formulas | How to Inspect and Modify a Macro |
Skills: Creating Group, Entry of Registration Fees, Activation of Service Tax, Provision and Depreciation Entries, Pass the Transaction, Create Units of Measure, Activation of Interest Calculation, Activation of CST, Multiple level pricing, Interest Calculation, Simple Interest, Set up and Configuration
Outputs: Balance Sheet, Credit sales Entry, Create Sales Excise Voucher, Ledger Creation, Create Stock Go-down, Checking Order, Create Stock Item, Voucher Creation, Cost Centre Creation
Blue Prism Course Overview
Blue Prism is one of the tools of the Robotic Process Automation (RPA) that can fetch high for the organization with less effort. The Blue Prism technology can be used by both IT and business industry people with various kind of application user interfaces. Smart Bit makes the aspirant to learn all the concepts from basic level to the advanced level of Blue Prism Technology with an ease
Blue Prism Training Objectives
Pre-requisites of the Course
Who should do the course?
Blue Prism Training Content
Introduction to Blue Prism
Process Studio
Process Flow
Inputs and Outputs
Business Objects
Object Studio
Overview of Error and Case Management
Error Management
Case Management
Additional Features
Consolidation Exercise
Advanced Features
International level certification by MKCL & MSBTE
About C-Language Training
C is an basic building block for every languages. It is a general Purpose Language. To develop the programming skills ‘C’ is the only platform for to develop programming techniques for any type languages. It is an Mid-level programming language for systems programming very widely used, relatively low-level, weakly typed, systems programming language associated with Unix and through that with Linux and the open source movement Performance becomes somewhat portable. Many Applications Like System Software, Application Software, Embedded Systems, Cool Games, Mobile applications, Device Drivers Programming etc of the World applications written in C and the List continues…C Designed and implemented by Dennis Ritchie 1972.
C Training Course Objective
This Course main objective for the student to develop primary programming skills upto the higher end in order solve the different programming logics. The student can able write different type of logics at the end of the sessions. After learning the C course the student can able get all the fundamental knowledge in all the languages. After Completion the student can able to attend any MNC Company interview and can solve the technical rounds both theoretically and Practically. We Provide lot of logical examples to make as good as.
Why This Course is Required
One thing we can speak without C Knowledge there is no Programming Logics to learn any language. There is no interviews for a Fresher without C language. To learn Java, .Net, Databases the list continues so many we require “C” Knowledge for a student Finally to tell many languages are internally Programmed by only C Language.
C Training Course Overview
Introduction to ‘C’ language
Data Types
Operators
Selections
Iteration
Arrays
String Manipulation
Functions
Storage class Specifiers
Structures, unions, enum
Pointers
Dynamic Memory Allocation
Files
Graphics
Data Structures is a concept a means of storing a collection of data. Computer Science is a concern with study of methods for effectively using a computer to solve problems. These can be solve by algorithms and data structures. Data Structures tells you what way the data as to store in computer memory and how to access the data efficiently. Many Applications are designed by data structures stack applications like page visited history in a web-browser, chain of method calls in the Java virtual machine or C++ Run-time environment etc Queue Application Like Waiting Lines, Multi-programming etc For many applications the choice of proper data structure is the only major decision involving the implementation. Majorly the database designing and internal implementation is done only by using Data Structures techniques.
This Course main objective for the student to understand Analysis and Designing of the Algorithms and how the different data structures are used for efficient accessing of the data and Manipulation of the data at the end of the session we can able to Know different Kinds of data structures and we can able to provide different algorithms for time and space complexity.
C++ Training Overview
C++ is general Purpose Programming language which supports Object Oriented Concepts., generally C++ is a Super Set of C Language Every C application can be upgraded in C++ with Object Oriented Concepts There are many application like Operating Systems.
Unix, Windows, Linux, NoCrysis Warhead and Other Cool games, No Photoshop, No FireFox, No VLC, No FL Studio, No Playstation, No XBOX and the list continue. 90% of the applications in the world are written in C and C++.
C++ Training Course Objective
The main objective student can able to implement the applications can develop the Programs with classes and objects. The developed application of C can change into with classes and can add all the Object Oriented Concepts. Developing in C++ the application is more optimized and efficient than C.
C++ Training Content
Basic In C++
Control Structures
Functions
Oops Concepts
Classes and Objects
Constructors and Destructors
Operator Overloading
Inheritance
Advanced Class Concepts
Polymorphism and Virtual Functions
Templates
Exception Handling
Streams
Files
Graphics
Advanced Java Training Course Objective
Smart Bit teach the fundamentals of JDBC and using the different interfaces in the JDBC API. Learn how to use Java servlets in the role of Web application control. Identify the options to state management in a Java Web application and understand the pros/cons of each. Understand how JSPs can help to separate Web logic and functionality from page layout. Explore how to make JSPs smaller and more powerful with JSTL, custom tags and expression language. Explore strategies in the exchange of data between Web pages (views) and business processing (model). Learn the meaning and importance of MVC
Advanced Java Training Course Content Overview
JDBC
Servlets
JSP
Mini Project Based On Web Application
IOT Syllabus
| SQL - Overview |
| What is SQL? |
| MySQL With DBMS & RDBMS, |
| Oracle using PL/SQL, |
| MS Access version of SQL. |
| Why SQL? |
| A Brief History of SQL |
| SQL Process |
| Query Dispatcher |
| Optimization Engines |
| Classic Query Engine |
| SQL Query Engine, etc. |
| SQL Commands |
| DDL - Data Definition Language |
| Command & Description |
| Creates a new table, a view of a table. |
| Modifies an existing database object, such as a table. |
| Deletes an entire table,other objects in the database. |
| DML - Data Manipulation Language |
| Command & Description |
| Retrieves certain records from one or more tables. |
| Creates a record. |
| Modifies records. |
| Deletes records. |
| DCL - Data Control Language |
| Command & Description |
| Gives a privilege to user. |
| Takes back privileges granted from user. |
| SQL - RDBMS Concepts |
| What is RDBMS? |
| What is a table? |
| What is a field? |
| What is a Record or a Row? |
| What is a column? |
| What is a NULL value? |
| SQL Constraints |
| NOT NULL Constraint |
| DEFAULT Constraint |
| UNIQUE Constraint |
| PRIMARY Key |
| FOREIGN Key |
| CHECK Constraint |
| Dropping Constraints |
| Integrity Constraints |
| Data Integrity |
| Entity Integrity |
| Domain Integrity |
| Referential integrity |
| User-Defined Integrity integrity. |
| Database Normalization |
| Eliminating redundant data. |
| Ensuring data dependencies make sense. |
| First Normal Form (1NF) |
| Second Normal Form (2NF) |
| Third Normal Form (3NF) |
| RDBMS Databases |
| Concurrency |
| Read Consistency |
| Locking Mechanisms |
| Quiesce Database |
| Portability |
| Self-managing database |
| SQL*Plus |
| ASM |
| Scheduler |
| Resource Manager |
| Data Warehousing |
| Materialized views |
| Bitmap indexes |
| Table compression |
| Parallel Execution |
| Analytic SQL |
| Data mining |
| Partitioning |
| SQL - Syntax |
| SQL SELECT Statement |
| SQL - SORTING Results |
| SQL DISTINCT Clause |
| SQL WHERE Clause |
| SQL AND/OR Clause |
| SQL IN Clause |
| SQL BETWEEN Clause |
| SQL LIKE Clause |
| SQL ORDER BY Clause |
| SQL GROUP BY Clause |
| SQL COUNT Clause |
| SQL HAVING Clause |
| SQL CREATE TABLE Statement |
| SQL DROP TABLE Statement |
| SQL CREATE INDEX Statement |
| SQL DROP INDEX Statement |
| SQL DESC Statement |
| SQL TRUNCATE TABLE Statement |
| SQL ALTER TABLE Statement |
| SQL ALTER TABLE Statement (Rename) |
| SQL INSERT INTO Statement |
| SQL UPDATE Statement |
| SQL DELETE Statement |
| SQL CREATE DATABASE Statement |
| SQL DROP DATABASE Statement |
| SQL USE Statement |
| SQL COMMIT Statement |
| SQL ROLLBACK Statement |
| DATA TYPES |
| bigint |
| int |
| smallint |
| tinyint |
| bit |
| decimal |
| numeric |
| money |
| smallmoney |
| float |
| real |
| datetime |
| smalldatetime |
| date |
| time |
| char |
| varchar |
| varchar(max) |
| text |
| nchar |
| nvarchar |
| nvarchar(max) |
| ntext |
| binary |
| varbinary |
| varbinary(max) |
| image |
| sql_variant |
| timestamp |
| uniqueidentifier |
| xml |
| cursor |
| table |
| SQL - Operators |
| What is an Operator in SQL |
| SQL Arithmetic Operators |
| + (Addition) |
| - (Subtraction) |
| * (Multiplication) |
| / (Division) |
| % (Modulus) |
| SQL Comparison Operators |
| = |
| != |
| <> |
| > |
| < |
| >= |
| <= |
| !< |
| !> |
| SQL Logical Operators |
| ALL |
| AND |
| ANY |
| BETWEEN |
| EXISTS |
| IN |
| LIKE |
| NOT |
| OR |
| IS NULL |
| UNIQUE |
| SQL - Expressions |
| Boolean |
| Numeric |
| Date |
| SQL - Using Joins |
| INNER JOIN |
| LEFT JOIN |
| RIGHT JOIN |
| FULL JOIN |
| SELF JOIN |
| CARTESIAN JOIN |
| SQL - UNIONS CLAUSE |
| The same number of columns selected |
| The same number of column expressions |
| The same data type and |
| Have them in the same order |
| SQL - NULL Values |
| SQL - Alias Syntax |
| SQL - Indexes |
| SQL - Using Views |
| Structure data in a way that users find intuitive. |
| Restrict access to the data. |
| Summarize data from various tables. |
| SQL - Transactions |
| Atomicity |
| Consistency |
| Isolatio |
| Durability |
| SQL - Wildcard Operators |
| The percent sign (%) |
| The underscore (_) |
| SQL - Date Functions |
| ADDDATE() |
| Adds dates |
| ADDTIME() |
| Adds time |
| CONVERT_TZ() |
| CURDATE() |
| Returns the current date |
| CURRENT_DATE(), CURRENT_DATE |
| Synonyms for CURDATE() |
| CURRENT_TIME(), CURRENT_TIME |
| Synonyms for CURTIME() |
| CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP |
| Synonyms for NOW() |
| CURTIME() |
| DATE_ADD() |
| Adds two dates |
| DATE_FORMAT() |
| Formats date as specified |
| DATE_SUB() |
| Subtracts two dates |
| DATE() |
| DATEDIFF() |
| DAY() |
| Synonym for DAYOFMONTH() |
| DAYNAME() |
| DAYOFMONTH() |
| Returns the day of the month (1-31) |
| DAYOFWEEK() |
| DAYOFYEAR() |
| Returns the day of the year (1-366) |
| EXTRACT |
| Extracts part of a date |
| FROM_DAYS() |
| FROM_UNIXTIME() |
| HOUR() |
| Extracts the hour |
| LAST_DAY |
| LOCALTIME(), LOCALTIME |
| Synonym for NOW() |
| LOCALTIMESTAMP, LOCALTIMESTAMP() |
| Synonym for NOW() |
| MAKEDATE() |
| MAKETIME |
| MAKETIME() |
| MICROSECOND() |
| MINUTE() |
| MONTH() |
| MONTHNAME() |
| NOW() |
| PERIOD_ADD() |
| PERIOD_DIFF() |
| QUARTER() |
| SEC_TO_TIME() |
| SECOND() |
| STR_TO_DATE() |
| SUBDATE() |
| SUBTIME() |
| SYSDATE() |
| TIME_FORMAT() |
| Formats as time |
| TIME_TO_SEC() |
| TIME() |
| TIMEDIFF() |
| TIMESTAMP() |
| TIMESTAMPADD() |
| TIMESTAMPDIFF() |
| TO_DAYS() |
| UNIX_TIMESTAMP() |
| UTC_DATE() |
| UTC_TIME() |
| UTC_TIMESTAMP() |
| WEEK() |
| WEEKDAY() |
| WEEKOFYEAR() |
| YEAR() |
| YEARWEEK() |
| Unit Values |
| MICROSECOND |
| SECOND |
| MINUTE |
| HOUR |
| DAY |
| WEEK |
| MONTH |
| QUARTER |
| YEAR |
| SECOND_MICROSECOND |
| MINUTE_MICROSECOND |
| MINUTE_SECOND |
| HOUR_MICROSECOND |
| HOUR_SECOND |
| HOUR_MINUTE |
| DAY_MICROSECOND |
| DAY_SECOND |
| DAY_MINUTE |
| DAY_HOUR |
| YEAR_MONTH |
| TIMESTAMPADD |
| FRAC_SECOND |
| SECOND, MINUTE |
| HOUR, DAY |
| WEEK |
| MONTH |
| QUARTER or |
| YEAR |
| SQL - Temporary Tables |
| Inserting Temporary Tables |
| Dropping Temporary Tables |
| SQL - Clone Tables |
| SQL - Sub Queries |
| Subqueries must be enclosed within parentheses. |
| A subquery can have only one column in the SELECT clause. |
| The GROUP BY command can be used. |
| Subqueries that return more than one row. |
| The SELECT evaluate to a BLOB, ARRAY, CLOB, or NCLOB. |
| A subquery cannot be immediately enclosed in a set function. |
| The BETWEEN operator cannot be used with a subquery. |
| SQL - Using Sequences |
| Using AUTO_INCREMENT column |
| Obtain AUTO_INCREMENT Values |
| Renumbering an Existing Sequence |
| Starting a Sequence at a Particular Value |
| SQL - Handling Duplicates |
| SQL - Injection |
| SQL - Database Tunning |
Power BI Introduction
? Data Visualization, Reporting
? Business Intelligence (BI), Traditional BI, Self-Serviced BI
? Cloud Based BI, On Premise BI
? Power BI Products
? Power BI Desktop (Power Query, Power Pivot, Power View)
? Flow of Work in Power BI Desktop
? Power BI Report Server, Power BI Service, Power BI Mobile Flow
? of Work in Power BI / Power BI Architecture
? A Brief History of Power BI
Power Query
? Data Transformation, Benefits of Data Transformation
? Shape or Transform Data using Power Query
? Overview of Power Query / Query Editor, Query Editor User Interface The
? Ribbon (Home, Transform, Add Column, View Tabs)
? The Queries Pane, The Data View / Results Pane, The Query Settings Pane, FormulaBar
? Saving the Work
? Datatypes, Changing the Datatype of a Column Filter
? in Power Query
? Auto Filter / Basic Filtering
? Filter a Column using Text Filters
? Filter a Column using Number Filters
? Filter a Column using Date Filters
? Filter Multiple Columns
? Remove Columns / Remove Other Columns
? Name / Rename a Column
? Reorder Columns or Sort Columns
? Add Column / Custom Column Split
? Columns
? Merge Columns
? PIVOT, UNPIVOT Columns
? Transpose Columns
? Header Row or Use First Row as Headers
? Keep Top Rows, Keep Bottom Rows Keep
? Range of Rows
? Keep Duplicates, Keep Errors
? Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
? Remove Duplicates, Remove Blank Rows, Remove Errors
? Group Rows / Group By
M Language
? IF..ELSE Conditions, Transform Column () Types
? Remove Columns (), Split Columns (),Replace Value()
? Table. Distinct Options and GROUP BY Options Table. ? Group (), Table. Sort () with Type Conversions PIVOT
? Operation and Table. Pivot(). List Functions Using
? Parameters with M Language
Data Modeling
? Data Modeling Introduction
? Relationship, Need of Relationship
? Relationship Types / Cardinality in General
? One-to-One, One-to-Many (or Many-to-One), Many-to-Many
? AutoDetect the relationship, Create a new relationship, Edit existing relationships
? Make Relationship Active or Inactive
? Delete a relationship
DAX
? What is DAX, Calculated Column, Measures
? DAX Table and Column Name Syntax
? Creating Calculated Columns, Creating Measures Calculated
? Columns Vs Measures
? DAX Syntax & Operators
? DAX Operators
? Types of Operators
? Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical
? Operators
DAX Functions Types
? Date and Time Functions
? Text Functions
? Logical Functions
? Math & Statistical Functions
? Filter Functions
Time Intelligence Functions
Date and Time Functions
? YEAR, MONTH, DAY
? WEEKDAY, WEEKNUM
? FORMAT (Text Function) à Month Name, Weekday Name
? DATE, TODAY, NOW
? HOUR, MINUTE, SECOND, TIME
? DATEDIFF, CALENDAR
? Creating Date Dimension Table
Text Functions
? LEN, CONCATENATE (&)
? LEFT, RIGHT, MID UPPER,
? LOWER
? TRIM, SUBSTITUTE, BLANK
Logical Functions
? IF
? TRUE, FALSE NOT, ? OR, IN, AND
? IFERROR SWITCH
Math & Statistical Functions
? INT
? ROUND, ROUNDUP, ROUNDDOWN
? DIVIDE
? EVEN, ODD
? POWER, SIGN
? SQRT, FACT
? SUM, SUMX
? MIN, MINX
? MAX, MAXX
? COUNT, COUNTX
? AVERAGE, AVERAGEX
? COUNTROWS, COUNTBLANK
Filter Functions
? CALCULATE
? ALL
? RELATED
? Report View
Report View User Interface
? Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas Visual
? Interactions
? Interaction Type (Filter, Highlight, None)
? Visual Interactions Default Behavior, Changing the Interaction
Grouping and Binning Introduction
? Using grouping, Creating Groups on Text Columns
? Using binning, Creating Bins on Number Column and Date Columns
? Sorting Data in Visuals
? Changing the Sort Column, Changing the Sort Order
? Sort using column that is not used in the Visualization
? Sort using the Sort by Column button
? Hierarchy Introduction, Default Date Hierarchy
? Creating Hierarchy, Creating Custom Date Hierarchy
? Change Hierarchy Levels
? Drill-Up and Drill-Down Reports
? Data Actions, Drill Down, Drill Up, Show Next Leve
Visualizations
? Visualizing Data, Why Visualizations
? Visualization types, Create and Format Bar and Column Charts
? Create and Format Stacked Bar Chart Stacked Column Chart Create
? and Format Clustered Bar Chart, Clustered Column Chart
? Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart Createand
? Format Pie and Donut Charts
? Create and Format Scatter Charts
? Create and Format Table Visual, Matrix Visualization
? Line and Area Charts
? Create and Format Line Chart, Area Chart, Stacked Area Chart
? Combo Charts
? Create and Format Line and Stacked Column Chart, Line and Clustered ColumnChart
? Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart
Power BI Service
? Power BI Service Introduction, Power BI Cloud Architecture
? Creating Power BI Service Account, SIGN IN to Power BI Service Account
? Publishing Reports to the Power BI service, Import / Getting the Report to PBI ServiceMy
? Workspace / App Workspaces Tabs
? DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
? Working with Datasets, Creating Reports in Cloud using Published Datasets
Creating Dashboards
? Pin Visuals and Pin LIVE Report Pages to Dashboard
? Advantages of Dashboards
? Interacting with Dashboards
? Formatting Dashboard
? Sharing Dashboard
Database programming with MsÂAcess using ADODB
To become a complete PHP Professional.
Fundamentals
• Introduction to PL/SQL
• Benefits of PL/SQL
• Creating PL/SQL Blocks
Defining Variables and Datatypes
• Using Variables in PL/SQL
• Recognizing PL/SQL Lexical Units
• Recognizing Data Types
• Using Scalar Data Types
• Writing PL/SQL Executable Statements
• Nested Blocks and Variable Scope
• Good Programming Practices
Using SQL in PL/SQL
• Review of SQL DML
• Retrieving Data in PL/SQL
• Manipulating Data in PL/SQL
• Using Transaction Control Statements
Program Structures to Control Execution Flow
• Conditional Control: IF Statements
• Conditional Control: CASE Statements
• Iterative Control: Basic Loops
• Iterative Control: WHILE and FOR Loops
• Iterative Control: Nested Loops
Using Composite Datatypes
• User-Defined Records
• Indexing Tables of Records
Using Cursors and Parameters
• Introduction to Explicit Cursors
• Using Explicit Cursor Attributes
• Cursor FOR Loops
• Cursors with Parameters
• Using Cursors for UPDATE
• Using Multiple Cursors
Exception Handling
• Handling Exceptions
• Trapping Oracle Server Exceptions
• Trapping User-Defined Exceptions
• Recognizing the Scope of Exceptions
Using and Managing Procedures
• Creating Procedures
• Using Parameters in Procedures
• Passing Parameters
Using and Managing Functions
• Creating Functions
• Using Functions in SQL Statements
• Review of the Data Dictionary
• Managing Procedures and Functions
• Review of Object Privileges
Using Invoker's Rights and Autonomous Transactions
Using and Managing Packages
• Creating Packages
• Managing Package Concepts
• Advanced Package Concepts
Getting the Best out of Packages
• Persistent State of Package Variables
• Using Oracle-Supplied Packages
Improving PL/SQL Performance
• Using Dynamic SQL
• Improving PL/SQL Performance
Using and Managing Triggers
• Introduction To Triggers
• Creating DML Triggers, Part I
• Creating DML Triggers, Part II
• Creating DDL and Database Event Triggers
• Managing Triggers
Recognizing and Managing Dependencies
• Introduction to Dependencies
• Understanding Remote Dependencies
Using the PL/SQL Compiler
• Using PL/SQL Initialization Parameters
• Displaying Compiler Warning Messages
• Using Conditional Compilation
• Hiding Your Source Code
Visual Basic .NET and the .NET Framework.
Introduction to .net framework –Features
Common Language Runtime (CLR)
Framework Class Library(FCL).
Visual Studio.Net – IDE,
Languages Supported,
Components.Visual Programming,
VB.net- Features,
IDE- Menu System,
Toolbars,
Code Designer,
Solution Explorer,
Object Browser,
Toolbox,
Class View Window,
Properties Window,Server Explorer,
Task List,
Output Window,
Command Window.
Elements of Visual Basic .net
Properties,
Events and Methods of Form,
Label,
TextBox,
ListBox,
Combo Box,
RadioButton,
Button,
Check Box,
Progress Bar,
Date Time Picker,
Calendar,
Picture Box,
HScrollbar,
VScrollBar,
Group Box,
ToolTip,Timer.
Programming in Visual basic .net
Data Types,
Keywords,
Declaring Variables and Constants,
Operators,Understanding Scope and accessibility of variables,
Conditional Statements- If- Then,
If-Then-Else,
Nested If,
Select Case,
Looping Statement- Do loop,
For Loop,For Each-Next Loop,
While Loop,
Arrays- Static and Dynamic.
Functions, Built-In Dialog Boxes, Menus and Toolbar
Menus and toolbars- Menu Strip,
Tool Strip,
Status Strip,
Built-In Dialog Boxes –Open File Dialogs,
Save File Dialogs,
Font Dialogs,
Color Dialogs,
Print Dialogs,
InputBox,
Msg Box,
Interfacing With End user- Creating MDI Parent and Child,
Functionsand Procedures- Built-In Functions- Mathematical and String Functions,
User DefinedFunctions and Procedures.
Advanced Concepts in VB.Net
Object Oriented Programming-
Creating Classes ,
Objects,
Fields,
Properties,Methods,
Events ,
Constructors and destructors,
Exception Handling-
Models,Statements,
File Handling- Using File Stream Class,
File Mode,
File Share,
FileAccess Enumerations,
Opening or Creating Files with File Stream Class,
Reading andWriting Text using StreamReader and StreamWriter Classes,
Data Access withADO.Net – What are Databases?,
Data Access with ServerExplorer,
Data Adapter andDataSets,
ADO.NET Objects and Basic SQL..
Mini Project Using ADO.NET
Mini Project Using ADODB/OLEDB Using a Basic SQL.
Syllabus
Detailed Syllabus
Introduction to Android
About Android and Android Apps
Fundamentals of Android Studio
Introduction to Java
Java Setup and Program structure
Variables and Datatypes
Control Statements and Program flow
Object-Oriented Programming in Java
Inheritance and Exception
Handling Events
Debugging
Classifying the Activities
Working with UI Elements
Introduction to Classes
Shared Preference
Introduction to Internal Storage
Recalling Basic Applications
Classifying various layout and Animation
Media Functions
Advanced Android Features
Processing with JSON Data
Using Maps and Geolocation
Permanent Data Storage
SQLite and WebView
The Extras
Wear OS
Creating Custom User Interface
Advanced example of Android
Case Study: Near By Places App
Case Study: Visitor Management App
Case Study: Online YouTube Player
Case Study: Chatting App
Case Study: Art Interest App
Case Study: Salon App
Case Study: Grocery Store Online Shopping App
Case Study: Hotel Booking App
Submitting Apps in Play Store
Kotlin
About Testing Tools Training
Software Testing Tools program is designed for any graduate with any stream. It is process oriented in Software Development Life Cycle. Through Software Testing Life Cycle, a Quality Analyst, analyze the software and providing assurance to client/end user.
STLC mainly focuses on Understanding Requirements, Test Planning, Test Design (Scenarios and Test Cases), Test Execution, Result Analysis, Defect Tracking and Reporting and etc. In Contemporary IT industry Quality is playing a major role.
In Testing Industry Test Automation Tools are playing major role, with the help of third party tools tester can able to perform retesting and regression testing. There are several popular tools in QA Industry like UFT, QTP, Quality Center, LoadRunner, SoapUI, Selenium etc…
Testing Tools Training Course Prerequisite
Testing Tools Training Course Objective
Testing Tools Training by Software Testing Professional from Smart Bit i Technologies with live projects and job placement assistance. The Real reward is making Smart Bit i Technologies Students Happy by providing best hands on Software Testing Training. The real world competition pushes Smart Bit i Technologies to innovate new methods and processes in Quality Assurance (QA) towards training improvements. It keeps us focused on delivering only the best knowledgeable student in multiple skills in QA Testing to compete with others to successfully find a job. Competition drives Smart bit i Technologies to lead the way with forward thinking green initiatives.
Testing Tools Training Course Content Overview
Manual Testing Life Cycle Implementation
SDLC Implementation
Software Development Models
Kinds of Testing
Methods of Testing
Static Testing
Dynamic Testing
Software Project Environments
Software Testing Life Cycle and Implementation with Real Time Project
Black Box Test Design Techniques
White Box Testing Techniques
What is Use Case?
Test Case Design
Test Data Setup
Test Execution
Result Analysis
Defect Tracking
Defect Reporting
Test Measurement Techniques and Metric Collection
Test Closure Activity
User Acceptance Testing
Different Testing Techniques in Live Environments
HP-Quality Center-11.00
Overview on Test Management
Quality Center – Introduction
Architecture of TD/QC Tool
Main Objectives of QC
Site Administration
Customization of Quality Center
Release and Cycle creation
Test Requirements
Test Cases Creation and management
Test Sets and Test Execution
Defect Tracking
Reporting and Analysis
Bug Tracking Tools
Automation Life Cycle Implementation Using
HP-QuickTest Professional-11.00
Introduction to Automation Testing
Introduction to QuickTest
Record and Playback
Introduction to VB Script
Introduction to VBScript
Comments
VB Script Variables
VB Script Data Types
VB Script Operators
Input/Output Operations
Constants
Conditional Statements
Loop through Code
Other Statements
Procedures
Error Handling
Built-In Functions
Debugging
Regular Expressions
Methods
Objects
Introduction to Objects
Properties
Classes
Keywords
Working with Test Objects and Object Repositories
Synchronization
Checkpoints
Output values
Actions
Parameterization Tests and Data Driven Tests
Working with DataTables
Regular Expressions
Functions
Recovery Scenarios
Virtual Objects
Mapping User-Defined Test Object Classes
Debugging in QuickTest
Library Files
Working with Databases
Working with Flat Files
Utility Objects
QTP Automation Object Model
HTML DOM
Working with Web Tables
Working with MS Excel and MS Word
Descriptive Programming
Implementing Test Automation Frame Works in Real Time Project
Performance Test Automation with
LOADRUNNER 11.00
Introduction
Performance Test Process
Load Runner Components
Load testing process
Browser Automation Testing Tool
SELENIUM-1.10.0
Introduction
Introduction to Selenium
Selenium Components
Resume Preparation
| SQL - Overview |
| What is SQL? |
| MySQL With DBMS & RDBMS, |
| Oracle using PL/SQL, |
| MS Access version of SQL. |
| Why SQL? |
| A Brief History of SQL |
| SQL Process |
| Query Dispatcher |
| Optimization Engines |
| Classic Query Engine |
| SQL Query Engine, etc. |
| SQL Commands |
| DDL - Data Definition Language |
| Command & Description |
| Creates a new table, a view of a table. |
| Modifies an existing database object, such as a table. |
| Deletes an entire table,other objects in the database. |
| DML - Data Manipulation Language |
| Command & Description |
| Retrieves certain records from one or more tables. |
| Creates a record. |
| Modifies records. |
| Deletes records. |
| DCL - Data Control Language |
| Command & Description |
| Gives a privilege to user. |
| Takes back privileges granted from user. |
| SQL - RDBMS Concepts |
| What is RDBMS? |
| What is a table? |
| What is a field? |
| What is a Record or a Row? |
| What is a column? |
| What is a NULL value? |
| SQL Constraints |
| NOT NULL Constraint |
| DEFAULT Constraint |
| UNIQUE Constraint |
| PRIMARY Key |
| FOREIGN Key |
| CHECK Constraint |
| Dropping Constraints |
| Integrity Constraints |
| Data Integrity |
| Entity Integrity |
| Domain Integrity |
| Referential integrity |
| User-Defined Integrity integrity. |
| Database Normalization |
| Eliminating redundant data. |
| Ensuring data dependencies make sense. |
| First Normal Form (1NF) |
| Second Normal Form (2NF) |
| Third Normal Form (3NF) |
| RDBMS Databases |
| Concurrency |
| Read Consistency |
| Locking Mechanisms |
| Quiesce Database |
| Portability |
| Self-managing database |
| SQL*Plus |
| ASM |
| Scheduler |
| Resource Manager |
| Data Warehousing |
| Materialized views |
| Bitmap indexes |
| Table compression |
| Parallel Execution |
| Analytic SQL |
| Data mining |
| Partitioning |
| SQL - Syntax |
| SQL SELECT Statement |
| SQL - SORTING Results |
| SQL DISTINCT Clause |
| SQL WHERE Clause |
| SQL AND/OR Clause |
| SQL IN Clause |
| SQL BETWEEN Clause |
| SQL LIKE Clause |
| SQL ORDER BY Clause |
| SQL GROUP BY Clause |
| SQL COUNT Clause |
| SQL HAVING Clause |
| SQL CREATE TABLE Statement |
| SQL DROP TABLE Statement |
| SQL CREATE INDEX Statement |
| SQL DROP INDEX Statement |
| SQL DESC Statement |
| SQL TRUNCATE TABLE Statement |
| SQL ALTER TABLE Statement |
| SQL ALTER TABLE Statement (Rename) |
| SQL INSERT INTO Statement |
| SQL UPDATE Statement |
| SQL DELETE Statement |
| SQL CREATE DATABASE Statement |
| SQL DROP DATABASE Statement |
| SQL USE Statement |
| SQL COMMIT Statement |
| SQL ROLLBACK Statement |
| DATA TYPES |
| bigint |
| int |
| smallint |
| tinyint |
| bit |
| decimal |
| numeric |
| money |
| smallmoney |
| float |
| real |
| datetime |
| smalldatetime |
| date |
| time |
| char |
| varchar |
| varchar(max) |
| text |
| nchar |
| nvarchar |
| nvarchar(max) |
| ntext |
| binary |
| varbinary |
| varbinary(max) |
| image |
| sql_variant |
| timestamp |
| uniqueidentifier |
| xml |
| cursor |
| table |
| SQL - Operators |
| What is an Operator in SQL |
| SQL Arithmetic Operators |
| + (Addition) |
| - (Subtraction) |
| * (Multiplication) |
| / (Division) |
| % (Modulus) |
| SQL Comparison Operators |
| = |
| != |
| <> |
| > |
| < |
| >= |
| <= |
| !< |
| !> |
| SQL Logical Operators |
| ALL |
| AND |
| ANY |
| BETWEEN |
| EXISTS |
| IN |
| LIKE |
| NOT |
| OR |
| IS NULL |
| UNIQUE |
| SQL - Expressions |
| Boolean |
| Numeric |
| Date |
| SQL - Using Joins |
| INNER JOIN |
| LEFT JOIN |
| RIGHT JOIN |
| FULL JOIN |
| SELF JOIN |
| CARTESIAN JOIN |
| SQL - UNIONS CLAUSE |
| The same number of columns selected |
| The same number of column expressions |
| The same data type and |
| Have them in the same order |
| SQL - NULL Values |
| SQL - Alias Syntax |
| SQL - Indexes |
| SQL - Using Views |
| Structure data in a way that users find intuitive. |
| Restrict access to the data. |
| Summarize data from various tables. |
| SQL - Transactions |
| Atomicity |
| Consistency |
| Isolatio |
| Durability |
| SQL - Wildcard Operators |
| The percent sign (%) |
| The underscore (_) |
| SQL - Date Functions |
| ADDDATE() |
| Adds dates |
| ADDTIME() |
| Adds time |
| CONVERT_TZ() |
| CURDATE() |
| Returns the current date |
| CURRENT_DATE(), CURRENT_DATE |
| Synonyms for CURDATE() |
| CURRENT_TIME(), CURRENT_TIME |
| Synonyms for CURTIME() |
| CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP |
| Synonyms for NOW() |
| CURTIME() |
| DATE_ADD() |
| Adds two dates |
| DATE_FORMAT() |
| Formats date as specified |
| DATE_SUB() |
| Subtracts two dates |
| DATE() |
| DATEDIFF() |
| DAY() |
| Synonym for DAYOFMONTH() |
| DAYNAME() |
| DAYOFMONTH() |
| Returns the day of the month (1-31) |
| DAYOFWEEK() |
| DAYOFYEAR() |
| Returns the day of the year (1-366) |
| EXTRACT |
| Extracts part of a date |
| FROM_DAYS() |
| FROM_UNIXTIME() |
| HOUR() |
| Extracts the hour |
| LAST_DAY |
| LOCALTIME(), LOCALTIME |
| Synonym for NOW() |
| LOCALTIMESTAMP, LOCALTIMESTAMP() |
| Synonym for NOW() |
| MAKEDATE() |
| MAKETIME |
| MAKETIME() |
| MICROSECOND() |
| MINUTE() |
| MONTH() |
| MONTHNAME() |
| NOW() |
| PERIOD_ADD() |
| PERIOD_DIFF() |
| QUARTER() |
| SEC_TO_TIME() |
| SECOND() |
| STR_TO_DATE() |
| SUBDATE() |
| SUBTIME() |
| SYSDATE() |
| TIME_FORMAT() |
| Formats as time |
| TIME_TO_SEC() |
| TIME() |
| TIMEDIFF() |
| TIMESTAMP() |
| TIMESTAMPADD() |
| TIMESTAMPDIFF() |
| TO_DAYS() |
| UNIX_TIMESTAMP() |
| UTC_DATE() |
| UTC_TIME() |
| UTC_TIMESTAMP() |
| WEEK() |
| WEEKDAY() |
| WEEKOFYEAR() |
| YEAR() |
| YEARWEEK() |
| Unit Values |
| MICROSECOND |
| SECOND |
| MINUTE |
| HOUR |
| DAY |
| WEEK |
| MONTH |
| QUARTER |
| YEAR |
| SECOND_MICROSECOND |
| MINUTE_MICROSECOND |
| MINUTE_SECOND |
| HOUR_MICROSECOND |
| HOUR_SECOND |
| HOUR_MINUTE |
| DAY_MICROSECOND |
| DAY_SECOND |
| DAY_MINUTE |
| DAY_HOUR |
| YEAR_MONTH |
| TIMESTAMPADD |
| FRAC_SECOND |
| SECOND, MINUTE |
| HOUR, DAY |
| WEEK |
| MONTH |
| QUARTER or |
| YEAR |
| SQL - Temporary Tables |
| Inserting Temporary Tables |
| Dropping Temporary Tables |
| SQL - Clone Tables |
| SQL - Sub Queries |
| Subqueries must be enclosed within parentheses. |
| A subquery can have only one column in the SELECT clause. |
| The GROUP BY command can be used. |
| Subqueries that return more than one row. |
| The SELECT evaluate to a BLOB, ARRAY, CLOB, or NCLOB. |
| A subquery cannot be immediately enclosed in a set function. |
| The BETWEEN operator cannot be used with a subquery. |
| SQL - Using Sequences |
| Using AUTO_INCREMENT column |
| Obtain AUTO_INCREMENT Values |
| Renumbering an Existing Sequence |
| Starting a Sequence at a Particular Value |
| SQL - Handling Duplicates |
| SQL - Injection |
| SQL - Database Tunning |
Work with commands.
1) What can you do to display a list of all available toolbars?
2) What are three ways that you can start a command?
3) What other key can you use to end or repeat a command in addition to ENTER
4) What should you to do cancel a command?
Change views.
1) What ZOOM option should you use to fit your entire drawing into a drawing area?
2) What is a fast way to redisplay the previous view?
3) What command smooths the display of curves & removes stray pixels?
Drawing setup.
1) What is it important to start a drawing from a drawing template file?
2) What is the difference between choosing drawing Units & Setting the drawing Unit format?
3) What is the difference between the Model tab & Layout Tab?
4) What are several benefits to creating a drawing with layers?
Draw objects.
1) What is the result of setting the colour of an object to Bylayer?
2) What is the fastest way to change the current layer to a different one?
3) What would you to do access a complete list of the properties of an object?
4) What command is recommended for creating parallel lines and curves?
5) What type object is composed of series of connected segments?
Precision drawings.
1) How to you turn off the grid dots in your drawing area?
2) The term origin refers to what coordinate values?
3) Pressing SHIFT while you right-click displays what shortcut menu?
4) What button can you turn on to ensure that the line you are drawing exactly vertical?
5) What is the meant by direct distance entry?
Make modifications.
1) What is the difference between a crossing selection & window selection!
2) What is the fastest way to create several parallel lines?
3) What is the easiest way to create an arc that is tangent to two other objects?
4) When creating or modifying an object, what do you to do display the object snap menu?
5) What is an easiest way to find the distance between two points in a drawing area'
Add symbols & hatches. What is a block? What is a block library? How can you use object snaps with blocks? What are three ways to hatch an area in a drawing?
Add text to a drawing.
1) What is fastest way to open the in-place Text Editor when you need to change existing text?
2) What are some advantages to creating additional text styles?
3) How do you decide whether to create text in paper space or in a model space?
4) What text height should you use in model space if the desired text height in pape space is 2.5 mm & the display scale of the layout view port is 1/50 (0.002)?
Add dimensions.
1) What is the behavior of associative leaders & associative dimensions?
2) Why should you lock layout view ports?
3) To ensure that dimensions are scaled according to the layout view port scale, whi dimension variable should be set to 0?
4) What is the easiest way to modify the location of a dimension feature such as the dimension line or dimension text?
Create layouts & plots.
1) What types of objects are commonly found on a layout tab?
2) How do you specify the scale layout view port?
3) How do you turn of the display of layout view port borders?
4) How can you use a plot style table?
5) What is fastest way to save plot setting by name?
© Copyright 2019 Smart Bit All rights reserved.