Spoken English Syllabus

What are Soft Skills?
Soft Skills are a valuable set of skills needed to accomplish the various job requirements that may not be taken care of just by mastering hard skills. These skills strengthen your job profile and personality quotient. Being an employee, you may have the hard skill to crunch numbers and manage balance sheets. But your ability to gel with others, work in teams, communicate effectively with your business partners and manage things is termed as soft skills. Spoken English Classes has a motto that anyone can speak good English. We think English speaking is an extremely learnable skill and with the right guidance support, The term concerning a professional signifies that he/ she is a team player and has an inquiring mind, innovative spirit, and interpersonal communication skills, and a successful professional is expected to be a fine blend of soft and hard skills.

What is the difference between Soft Skills and Hard Skills?
Hard Skills are the skills you acquire during your academics, for example, you’re IT Skills, Language Skills, Technical Knowledge, confined in nature to your respective domains. Every job you get with technical knowledge needs a set of soft skills for handling it effectively and boosting your career. One needs to walk the extra mile to identify and acquire soft skills as they are the toughest to learn and master. Unfortunately, there is a disconnect between hard skills and soft skills at the level of formal education, as no technical degree teaches specifically how to handle people and crises at the workplace, analyze a problem and arrive at apt solutions, show leadership, and entrepreneurial capabilities and communicate with empathy. Spoken English Training trains you to speak correct English with a great deal of confidence and superior vocabulary.

Spoken English Training
Our aim is to help our students speak English confidently, fluently, and effectively. We have limited the maximum student strength to in a batch, so we can give personal attention to each and every student.

Our training methodology is such that we do not just focus on Grammar. We believe that just being good at Grammar does not guarantee fluency. So, we maintain a good balance between Grammar and conversation practice which enables the student to actually be able to speak fluent English. So go for the best Spoken English Training in India that will quench your thirst of speaking fluently
Why is training in Soft Skills required?
Presently we have two incredible virtues as a nation: one, the youngest population in the world and second, the vibrant emerging knowledge economy. To build upon this strength, we need a workforce suitably trained in soft skills. Several pieces of research unequivocally support that people and their soft skills are essential to sustain or making a business successful. It helps form a good impression and an impact to gain professional development. Soft skills relate to how you work with others, so it helps in interpersonal relations. Employers value soft skills because they enable people to function and thrive in teams and organizations as a whole. which results in maintaining a productive and healthy work environment.

Why training in Soft Skills at Spoken English Classes?
we have a clear objective to identify the needs of every individual and empower them with the right set of skills to make them employable. We have one major program on soft skills with three levels Basic, Intermediate, and Advanced. But, we understand that some individuals have their preferences, in such cases, we inculcate Modular Courses.
One of our primary key features of soft skills training is a strategic division of topics under various sections:
Interpersonal skills (Communication, listening, flexibility and adaptability, public speaking)
Life Skills (Self-awareness, empathy, creative thinking, coping with emotions)
Etiquette (General etiquette, office etiquette, telephonic etiquette)
Employability skills (Resume building, interview techniques, PI)
Career Skills (Professionalism, networking, time management, leadership)
Management Skills (Team management, critical thinking, stress management, anger management)
Self-analysis strategies which include:
Topic review
Direct questions
Self-assessment questionnaire

Self-analysis strategies which include:
Topic review
Direct questions
Self-assessment questionnaire

Instructional resources and visual learning:
A&V Training
Handouts
Use of effective tools for writing:
Mind Map
Brainstorming
KWL Chart

Online Classes

Want to be fluent in English speaking?

We supply adaptable sessions that are held for individual or group pupils in a convenient time for an hour each. Students can gain confidence after attending the sessions for corrections in their Spoken English. You may join online classes to learn from anywhere. You can pick weekdays or weekend courses as per your convenience. We cater to the particular needs of these individuals. We assist the students rectify their speech, accent, rhythm, and intonation and cut back the native language influence. We are tutors trying to deliver quality education with our Online Spoken English courses. We build faith for one to update and enhance oneself, feel optimistic and progress together with accuracy.We concentrate on building your vocabulary and allow you to form perfect paragraphs with all the day to day situations that one may encounter in their lifetime. In the current world, good command over English helps you not only to express yourself but also to gain the confidence of others like customers, interviewers, etc. Our Online Spoken English Classes will enhance your skills in reading, writing, listening and speaking. Our Online Spoken English is designed to improve your listening skills for improved communication too. You will receive training on pronunciation, usage of expressions, vocabulary and free speech. With this training, you may build a good basis of the English language and can easily crack the interviews to get the desired task that needs good communication abilities.

Course Eligibility

Freshers
Students
Bachelors & Graduates
Any professional person
Abroad studying students and professionals
Candidates willing to learn something new.

Spoken English Syllabus

Basic

Introduction, Parts of Speech – Noun- Types – Pronouns- Types, Activity – Be form, Have form, Do form – Adjectives and Verbs – Simple Present Tense, Activity – Simple Past Tense, Past experience sharing – Simple Future Tense, Activity – Present Continuous Tense, Past Continuous Tense – Future Continuous Tense, Activity – Adverbs- Types – Prepositions – Conjunctions, interjections – Conditional sentences, Activity – Present Perfect Tense – Past Perfect Tense – Future Perfect Tense – Present Perfect Continuous Tense – Past Perfect Continuous Tense –

Articles – Modal Auxiliary Verbs – Active and

Passive Voice Exercises

Intermediate

– Group Discussion – Deabate – Roleplays – Presentation – Ex-tempore – Body language (Gestures, posture, eye contact, Facial Expressions) – Proverbs, Idioms and Phrases – SWOT Analysis – General Etiquettes

Advanced

Time Management – Interview Skills (Before, During, After Interview) – Email Writing – Resume writing – Telephone etiquettes, Role plays – Phrasal Verbs – Presentations – Mock Interviews

C Program

C Language is one of the first programming languages that someone learns. Although developed decades ago, C Language is widely used as a system programming language to write an operating system or for compiler development. Infact, C Language has formed the basis for many other languages including C++, C, C#, Objective-C, BitC, C-shell, D, Java, JavaScript, Go, Rust, & many

Learning can be beneficial for an individual as many other advanced languages, and other computer subjects such as Computer Networks, Compiler Designing, Computer Architecture, Operating Systems are based on C programming language. Also in the modern high level languages, the machine level details are hidden from the user, so in order to work with CPU cache, memory, network adapters, learning C programming is a must. So it is a skill that can only add to your educational arsenal.

This C Programming self paced course will help you master the basics, learn about Variables and Data Types, Functions, Flow Control, and all other important concepts of C that are required for you. After the basics, you can also practice advanced concepts of C programming language with the help of practice problems curated by experts.

Get ready to thrive in the world of coding, one language at a time!

What you will learn

How to solve intense coding problems with ease
Building your base with industry experts
Variables and Data Types
Structures and Unions
Basics to introduction of advanced topics of C language

Course Content

1.C Basics

Introduction to C Language including the global standards, terminologies, implementation etc.

2.Variables and Data Types

All about Variables and Data Types in C including Range, Global and Static Variables, Const, Literals etc and many Practice Problems.

3.Input and Output in C

All about Format Specifiers along with I/O statements in C, Practice Problems etc.

Operators

Different types of Operators in C with Practice Problems.

Flow Control

Explaining the types of Flow Controls in C along with Games and Practice Problems.

Function in C

Explaining the various concepts of Functions in C and its application in solving Problems.

Loops

All the types of Loop Statements in C with its practical application in Practice Problem

Array

Arrays and its various types with Applications through Problem Solving.

Pointers

All about Pointers in C showcasing how it is different from Array and its practical applications through Practice Problems.

Dynamic Memory Allocation

Memory Structure of a Program
malloc(), calloc() and free()
Memory Leak

String in C

Strings, Substrings and its comparison along with implementation through Practice Problems.

Multi Dimensional Array in C

Various implementation of Multidimensional Arrays in C.

Structure and Union

Structures, Unions, its application and implementation through Practice Problems.

Advanced

Advanced Concepts in C with Practice Problems

C++ Course

Course Overview

The Standard Template Library (STL) is a set of C++ template classes to provide common programming data structures and functions such as lists, stacks, etc. In essence, STL is a library of container classes, algorithms, and iterators that help you in writing clean and efficient code.

In this course, you will cover the basics of C++ and get an in-depth explanations to all C++ STL containers, iterators, and more along with video explanations of a few problems. You will also learn to use STL inbuilt classes and functions that help you implement complex data structures with ease.

A lot of companies look for programmers who can write clean and efficient code. And C++ STL can so help you in cracking your coding interviews by teaching you the skill of writing clean code that can save a lot of time. Anyone with a knowledge of basic data structures and C++ fundamentals can join the course and take their programming skills to the next level.

Looking to level-up further in your professional career? Have a look at our advanced LIVE Classroom programsto enhance your skills.

What you will learn

The basics of C++ and brush up on all the industry-required topics
All the important C++ STL containers, iterators and functions with the help of an in-depth explanation
How to implement STL functions during coding interviews in order to save a lot of time
Learn about many inbuilt functions and built-in containers which help to implement complex Data Structures easily and efficiently

Course Content

Introduction,Basic Input Output,Errors,Operators and much more

Introduction,Variables and Concepts

First C++ Program,Comments in C++,Data Types in C++,Variables in C++ and much more

Flow Control, Function & Loops

If Else Syntax in C++,Nested If Else with Example,Functions in C++ and much more

Arrays, String, Pointers & Reference

Declaring and Initializing Arrays,Array Traversal in C++ and much more

Strucutre and Union

Struct vs Class in C++,Union in C++,Complex Number Addition Using Structure and much more

C++ OOPS

Object Oriented Programming,This Pointer,Virtual Functions and much more

Advanced

Exception Handling in C++,Try Throw and Catch in C++,Function Pointers and much more

STL Overview

Iterators in C++,Templates in C++,Function Templates in C++ STL and much more

Pairs

Pair in C++ STL,Sort an array according to another array and much more

Vectors

Vector in C++,Vectors Introduction,Sample Problem: Vector and much more

forward_list and List

Forward List in C++ STL,List in C++ STL and much more

Dequeue

Deque in C++ STL, Sliding Window Maximum and much more

Stack

Stack in C++ STL,Reverse Items using Stack,Balanced Parenthesis and much more

Queue

Queue in C++ STL,Generate numbers using given digits,Reverse first K items in a Queue and much more

Priority Queue

Priority Queue in C++,K largest elements in an array,Find K most frequent elements and much more

Set & Multiset

Set in C++ STL,Ceiling on right,Multiset in C++ STL and much more

Map & Multimap

Map in C++ STL,Multimap in C++ STL,Design a DS for Prices with Duplicates allowed and much more

Unordered Set

Print Distinct Elements of Array,Intersection of two unsorted Arrays and much more

Unordered Map

Unordered Map in Cpp STL,Design a DS for storing user balance and much more

Non Mutating STL Algorithms

Find in Cpp STL,Lower Bound/Upper Bound in C++STL,is_permutation() in C++ STL and much more

Mutating STL Algorithms

sort(): The thief problem,make_heap() in C++ STL,merge() in C++ STL and much more

Miscellaneous

Strings in C++,Pattern Searching and Returning floating point of number and much more

Miscellaneous

Strings in C++,Pattern Searching and Returning floating point of number and much more

PHP Course

PHP Course Overview

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

PHP can generate dynamic page content
PHP can create, open, read, write, and close files on the server
PHP can collect form data
PHP can send and receive cookies
PHP can add, delete, modify data in your database
PHP can restrict users to access some pages on your website
PHP can encrypt data

With PHP you are not limited to output HTML. You can output images, PDF files, and even Flash movies. You can also output any text, such as XHTML and XML.

PHP Training Course Prerequisite

HTML
CSS
Javascript

Objectives of the Course

PHP runs on different platforms (Windows, Linux, Unix, Mac OS X, etc.)
PHP is compatible with almost all servers used today (Apache, IIS, etc.)
PHP has support for a wide range of databases
PHP is free. Download it from the official PHP resource: www.php.net
PHP is easy to learn and runs efficiently on the server side

PHP Training Course Overview

An Introduction to PHP

History of PHP

Versions and Differences between them
Practicality
Power
Installation and configuring Apache and PHP

PHP Basics

Default Syntax

Styles of PHP Tags
Comments in PHP
Output functions in PHP
Datatypes in PHP
Configuration Settings
Error Types

Variables in PHP

Variable Declarations
Variable Scope
PHP’s Superglobal Variables
Variable Variables

Constants in PHP

Magic Constants
Standard Pre-defined Constants
Core Pre-defined Languages
User-defined Constants

Control Structures

Execution Control Statements

Conditional Statements
Looping Statements with Real-time Examples

Functions

Creating Functions
Passing Arguments by Value and Reference
Recursive Functions

Arrays

What is an Array?
How to create an Array
Traversing Arrays
Array Functions

Include Functions

Include, Include_once
Require, Require_once

Regular Expressions

Validating text boxes,emails,phone number,etc
Creating custom regular expressions

Object-Oriented Programming in PHP

Classes, Objects, Fields, Properties, _set(), Constants, Methods
Encapsulation
Inheritance and types
Polymorphism
Constructor and Destructor
Static Class Members, Instance of Keyword, Helper Functions
Object Cloning and Copy
Reflections

PHP with MySQL

What is MySQL
Integration with MySQL
MySQL functions
Gmail Data Grid options
SQL Injection
Uploading and downloading images in Database
Registration and Login forms with validations
Pagging, Sorting,…..

Strings and Regular Expressions

Declarations styles of String Variables
Heredoc style
String Functions
Regular Expression Stntax(POSIX)
PHP’s Regular Expression Functions(POSIX Extended)

Working with the Files and Operating System

File Functions
Open, Create and Delete files
Create Directories and Manipulate them
Information about Hard Disk
Directory Functions
Calculating File, Directory and Disk Sizes

Error and Exception Handling

Error Logging
Configuration Directives
PHP’s Exception Class
Throw New Exception
Custom Exceptions

Date and Time Functions

Authentication

HTTP Authentication
PHP Authentication
Authentication Methodologies

Cookies

Why Cookies
Types of Cookies
How to Create and Access Cookies

Sessions

Session Variables
Creating and Destroying a Session
Retrieving and Setting the Session ID
Encoding and Decoding Session Data
Auto-Login
Recently Viewed Document Index

Web Services

Why Web Services
RSS Syntax
SOAP
How to Access Web Services

XML Integration

What is XML
Create a XML file from PHP with Database records
Reading Information from XML File

MySQL Concepts

Introduction
Storage Engines
Functions
Operators
Constraints
DDL commands
DML Commands
DCL Command
TCL Commands
Views
Joins

Cursors
Indexing
Stored Procedures
Mysql with PHP Programming
Mysql with Sqlserver(Optional)

SPECIAL DELIVERY

Protocols
HTTP Headers and types
Sending Mails using PHP
Email with Attachment
File Uploading and Downloading using Headers
Implementing Chating Applications using PHP
and Ajax
SMS Gateways and sending SMS to Mobiles
Payments gateways and How to Integrate them

With Complete

MVC Architecture
DRUPAL
JOOMLA
Word Press
AJAX
CSS
JQUERY (Introduction and few plugins only)

Java Course – Basic to Advance

Course Overview

Kick-start your programming journey with this self-paced course designed for All who are looking to build a strong foundation and master the basic and advance concepts of JAVA from Programming to Collections and beyond. Curated by our CEO Mr. Sandeep Jain & other industry experts with years of experience, this course will help you dive deep into learning Java Basics, Data Types, Operators, Loops, Strings, OOPS, Java Collections and Frameworks including Streams, Lists, Set, Map & much more.

Key Highlights:

20+ hours of Basic Content
25+ hours of Advanced Content
150+ Industry Oriented Coding Problems
300+ MCQs for Placement Assistance
Short and Curated Notes for Quick Revision for exams
Doubt Assistance in every Topic and Problem
Live Community Sessions
All about Java Basics, Advanced, OOPS, Collections, and Advanced Algorithms

What you will learn

Background of Java and Programming Languages
How to write your First Program
Basic Concepts – Variables, Data Types, I/O, Operators, Loops, Functions, and much more
Java OOPs – Classes, Objects, Encapsulation, Polymorphism, and much more
Java Collections – Streams, Lambda Expressions, ArrayList, LinkedList, HashSet, TreeMap, and much more
Advanced Algorithms – Array Class, Collections Class, Sorting and much more
Solving coding questions easily and efficiently in the most optimized manner.

Course Content

01.Java Basics

Background of Java
Why do we need Programming Languages
Writing the first program in Java

02.Variables and Data Types

Learn about variables in Java, Non-Primitive Types
Swap two Variables, Wrapper Classes in Java.
Autoboxing and Unboxing in Java and Type Conversion in Java

Input and Output in Java

Input and Output in Java
Escape Sequences in Java

Operators in Java

Operators in Java
Sum of N Natural Numbers, Find Last Digit of A Number, and other Practice Problems

Flow Control in Java

If Else Statements and Switch Statement
Even Odd Numbers, Largest of Three Numbers, Leap Year, Calculator

Loops in Java

Loop Statements: While Loop, Do While Loop, Break and Continue
Count Digits, Table of a Number, Patterns, Triangular Pattern, Inverted Triangle, Square Pattern and other problems

Functions in Java

Functions and applications of Functions
Command Line Arguments in Java
First Digit of a Number and Prime Factorization

Arrays in Java

Arrays in Java introduction
[ ]a vs a[ ] in Java, Array Working and Types
Check If Array is Sorted, Count Distinct Elements, Maximum in an Array, Sum of an Array and Finding Average

String in Java

String Introduction and String Operations
StringBuilder and StringBuffer
Sample Problems like Pangram Checking in Java, Pattern Searching, Find one extra character in Java, and many more

Classes and Objects in Java

Class and Objects, Constructors, This Reference
Class Members and Access Specifiers, Static Members and Final Keyword

Advanced Concepts in Java

BigInteger Introduction and Method References in Java
Exception Handling, Method Call Stack and Exceptions
Multithreading in Java, File Handling and many more concepts.

Introduction to Collections

Java Collection Framework. Collection Hieratchy, Generics in Java
Wildcard, Collection Interface, Iterator in Java
toArray() methods, Collection operator methods and Iterating through Collections

Streams & Lambda Expressions

Lambda Expressions and its Syntax, Method References in Java
Streams in Java including its applications, hierarchy and methods with examples

Lists and Stack

List Interface and iterator, ArrayList with its working, methods and traversals
Linked List in Java, Josephus Problem and other problems
Stack in Java Collections, Stock span problem, Next Greater elements and other problems

Queue, Deque and Priority Queue

Queue in Java, Reverse first K item, Generate numbers with given digits in Java
Deque, ArrayDeque in Java, design a data structure with min/max operations and other problems
PriorityQueue in Java , K largest elements, K most frequent elements and other problems

Set Interface, HashSet, LinkedHashSet and related problems
TreeSet, Ceiling on right problem in Java

Map Interface in Java and its methods, HashMap, Linked HashMap with example problems
TreeMap in Java, Design A DS For item prices, Count Greater Elements and other problems

String

String in Java, StringBuilder and StringBuffer and its methods
Panagram Checking, Pattern Searching, Check for Anagram and other problems

Algorithms

Comparable Interface, Comparator Interface, methods and examples
Arrays Class in Java, fill function, Binary Search, equals, miismatch, compare and other methods
Collections Class in Java, fill, reverse and other methods
Sorting in Java, sort method for Arrays and Collection, Sort element by frequency, Meeting Maximum Guests and other problems

Softwear Development

About Software Development

Software is a bunch of suggestions that tell a computer what to do. Software development is the procedure of building a piece of software designed to perform a particular task. It includes the entire software development life cycle. Software development comprises all the actions required for software design, deployment, maintenance, and support. Each mobile app, video game, and work-related computer program you’ve ever used goes through this process. Software development begins by working with users and other stakeholders. It helps to determine what the software needs to do. SevenMentor is a beneficial institute. It has designed the best Software Development Course . It’s a valuable institute, so it has developed the best Software Development Training in India.

Why should you learn Software Development?
Opportunity to Travel
Travelling is a huge part of the job for software developers. They have to work away from the office. Meetings are often a crucial part of software development. Here, leading companies like to promote their newest innovations and products. So, maybe Your company, pay for you to attend these conferences all over the country as a software developer. So, you can understand more and network with others.

Impressive salary
A huge Salary is a huge reason why people become software developers. In India, The average salary for a software engineer is Rs. 42,790per month. It can improve if you expand your software and build a credible reputation within your industry. So, our Software Development Training is valuable for you.

Beneficial to Work individually and in a team
Functioning as a software developer can provide you the chance to work on a team and your own. They may break the overall project into small elements while developing software. Then Developers take on individual tasks. It suggests that software developers can spend time working on their own. They can also get together with a team. They discuss how their part fits into the overall project. Therefore, if you want to work with others or on your own, you will find time to do both as a software developer. At our Best Software Development Training institute, you can work with a team or work as an individual.

Chance for learning new things
Continuing your education is a crucial part of being a software developer. There are constantly new devices to develop and better ways of developing software. Therefore, it compels Software developers to spend a significant amount of time keeping up to date with the latest news and developments in their industry. Therefore, they can build the best possible products. Software Development is beneficial for those who want to learn new things. If you are someone like them, this can be a rewarding field. It will help you learn new programming languages, new ways to use old languages, and new tools to make development easier. With software development, you can learn new things about the industry. Our Software Development Training in Nagpur is the perfect place to learn new things.

Online Classes

Online Software Development Training is the most effective way accessible for knowledge. Institute gives an essential understanding of Software Development through practical assistance. Our trainers have vast experience in real-time projects in several businesses and have constructed a thorough program. So, they will help you to develop and implement new software programs. You can maintain and enhance the performance of prevailing software. You can also learn to Deploy software tools, processes, and metrics. Our trainers will help you in developing quality assurance techniques. An incredible element of the Software Development Course is the personality of trainers. So, it improves the students in assessing the topic, expands interest, and ultimately achieves proficiency in the area. Our trainers improve the students in every component of learning. So, they will assist you with the doubt clearing sessions, assistance in project completion.

Course Eligibility

Freshers
Students
Bachelors & Graduates
Any professional person
Abroad studying students and professionals Candidates are willing to learn something new.

Syllabus of Software Development

1. HTML 4 and HTML 5
Introduction of HTML
Tag, Elements and Attributes
Basics syntax
Table
List
Forms
Structure of HTML4 and HTML5
Semantic and non-semantic tags
HTML 5 Features
New Input type Forms Attribute
SVG
Canvas
Audio, Video Tag
2. CSS
Attributes (ID, Class, Style, Title )
CSS Types (Inline, Internal, External)
Box-model
Display Property (Block, Inline, None)
Visibility-Hidden
Position Property(Static, Relative, Absolute, Fixed )
Z-index Property
Combinators ( Child Selector,Adjacent Sibling Selector
Descendant Selector, General Sibling Selector)
CSS Pseudo-classes ( Visited, Hover,Link,,Active)
CSS Pseudo-elements ( Selection,First Letter,First Line, Before After)
K. Static Web Page
Viewport Meta tag
3. CSS 3
Background, Multiple Backgrounds
Font Related Features (online fonts)
Text-Effect and Box-Effect
Gradients-Line a and Radial
Transition
Transformation
Animation
Media Queries
4. JavaScript
Introduction of JavaScript
Use of JavaScript
Variables
Keywords
Data Type (Primitive, non-primitive)
JS Conditions (if, if-else)
Conditional operators & logical operators
Loops (for, while, do-while)
Switch Case
Functions
SetTimeout and set Interval Function
HTML DOM
object to access and manipulate HTML using the document
Changing HTML Elements
Adding and Deleting Elements
Array
Objects
way to access Objects ( bracket Notation,Dot Notation)
way to create Object (, Literal Way,Empty Object Constructor Way)
Prototype
Validations
Events
5. jQuery
jQuery – Basics
String
Numbers
Boolean
Objects
Arrays
Functions
Arguments
Scope
Built-in Functions
jQuery – Selectors
jQuery – CSS Element Selector and ID Selector
jQuery – CSS Element Universal Selector AND Class Selector
jQuery – CSS Multiple Elements like E, F, G Selector
jQuery Callback Functions
jQuery – DOM Attributes
Get Attribute Value
Set Attribute Value
jQuery – DOM Traversing
Find Elements by index
Filtering out Elements
Locating Descendent Elements
JQuery DOM Traversing Methods
JQuery – CSS Methods
Apply CSS Properties and Multiple CSS Properties
Setting Element Width & Height
JQuery CSS Methods
jQuery – Effects
JQuery Effect Methods, Hide and Show
jQuery Toggle
jQuery Slide – slideDown, slideUp, slideToggle
jQuery Fade – fadeIn, fadeOut, fadeTo
jQuery Custom Animation
jQuery – chaining
jQuery – AJAX
load()
get()
post()
ajax()
jQuery – JSON
getJSON()
6. Bootstrap
What is Bootstrap Framework?
Why Bootstrap?
History of Bootstrap
Advantages of Bootstrap Framework
What is Responsive web page?
Major Features of Bootstrap?
What is Mobile-First Strategy?
Setting up Environment
How to apply Bootstrap to Applications
Ways to display images in various styles
Way to display text like warning and muted?
Regarding Carets Classes?
How to show or hide the text in Bootstrap
Bootstrap Grid
What is Bootstrap Grid?
How to apply Bootstrap Grid
What is Container?
What is Offset Column?
How to Reordering Columns?
Advantages of Bootstrap Grid?
How to Display responsive Images?
How to change class properties?
How to use readymade themes?
What is Bootstrap Typography?
How to use Typography?
What is Bootstrap Tables?
What is Bootstrap Form Layout?
What is Bootstrap Button?
Bootstrap Components
What is Components of Bootstrap ?
Need of Bootstrap Components?
Benifits of Bootstrap Components
Types of Bootstrap Components
Glyphicons Component
Process to use Glyphicons Component?
Bootstrap Dropdown Menu Component?
What is Button Toolbar and Button Groups ?
Way to use Button Toolbar and Button Groups ?
Different Input Groups Components
What is Tabs Components & Navigation Pills?
How to use Tabs Components and Navigation Pills ?
Navbar Component
Process to build a Responsive Navbar?
How to controls to Navbar and other Add Forms ?
How to Fix the position of navbar?
What is Breadcrumb Component?
What is Pagination Component?
How to apply Pagination in Application?
What is Labels / Badge Components?
What is Jumbotron / Page Header Components?
What is Thumbnail Component?
What is Alerts & Dismissible Alerts?
How to Create Progress Bar?
What is Media Objects Component?
Why Media Objects Component?
How to use Media Objects Component?
What is Bootstrap List Group Component?
What is Bootstrap Panel Component?

Bootstrap Plug-Ins
What is Bootstrap Plug-Ins
Why Bootstrap Plug-Ins?
How to use Bootstrap Plug-Ins
What is Transition Plug-in?
What Modal Dialog Box?
What are the different Properties, Methods and Events of
Modal Dialog Box?
What is Scrollspy Plug-In?
What is Tab Plug-in?
How to use Tab Plug-in?
What is Drop down Plug-in?
What is Tooltip Plug-in?
How to use Button Plug-in?
What are the different methods and events of Tooltip Plug-in?
What is Popover Plug-in?
What is alert and Button Plug-ins?
What is Collapse Plug-in?
Types of Methods ,Properties and Events of Collapse Plug-in?
What is Carousel Plug-in?
What is Affix Plug-in?
7. Photoshop
Black & White to Colour
Day To Night
Restoration
Image Manipulsion
Double Exposure
Gradient Effect
Digital Painting
Poster Design
Advanced Compositing
Social Media Post
Typography
Matte Painting
GIF
Logo
Workspace overview of Adobe Illustrator
8. Illustrations
Masking and wrapingr
Working with text ( Typography)
Understanding Effects & Filters (Logo)
Create layouts with using perspectives
Color the illustrations by using flat color and gradients
Logo Designing
Design – Magazine cover
Design – Advertisement -1( News Paper, Branding)
Design – Flyer ( Product Launch)
Printing techniques
9. Adobe XD
IIntroduction to UX
Getting started
What is UI vs UX
The UX brief & persona
Wireframing (low fidelity)
How wide for my website
Free UI Icons
Footer & Lorem Ipsum
New Pages & Artboards
Class Project 01 – Wireframe
Prototyping & Interactivity
Create a Popup Modal
Class Project 02 – Prototype
Groups & Isolation Mode
How to use symbols
Production Video – Left Nav
Navigation Tips and Tricks
Class Project 03 – Symbols
Mocking Up an app
XD App on your phone
iPhone & Android status icons
Fixing the position
Production Video – Login
Sharing wireframes
Recording your interactions
Class Project – Wireframe feedback

9. Figma
Introduction
Overview of Figma Features
What is User Experience Design?
Overview of the Design Process
Getting Started with Figma
Navigating the Figma User Interface
Designing a Web Application
Working with UI Elements and Content
Making a Design Responsive
Exporting the Design
Reusing Design Elements
Creating a Portfolio Project
Managing Requirements
Best Practices for Delivering a Polished Design

Data Science

Overview

This is the first course in the Google Data Analytics Certificate. These courses will equip you with the skills you need to apply to introductory-level data analyst jobs. Organizations of all kinds need data analysts to help them improve their processes, identify opportunities and trends, launch new products, and make thoughtful decisions. In this course, you’ll be introduced to the world of data analytics through hands-on curriculum developed by Google. The material shared covers plenty of key data analytics topics, and it’s designed to give you an overview of what’s to come in the Google Data Analytics Certificate. Current Google data analysts will instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.

Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary.

By the end of this course, you will:
– Gain an understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job.

Learn about key analytical skills (data cleaning, data analysis, data visualization) and tools (spreadsheets, SQL, R programming, Tableau) that you can add to your professional toolbox.
– Discover a wide variety of terms and concepts relevant to the role of a junior data analyst, such as the data life cycle and the data analysis process.
– Evaluate the role of analytics in the data ecosystem.
– Conduct an analytical thinking self-assessment. – Explore job opportunities available to you upon program completion, and learn about best practices in the job search.

Syllabus

Introducing data analytics
- Data helps us make decisions in everyday life and in business. In this first part of the course, you’ll learn how data analysts use data analytics and the tools of their trade to inform those decisions. You’ll also discover more about this course and the overall program expectations.
All about analytical thinking

- Data analysts balance many different roles in their work. In this part of the course, you’ll learn about some of these roles and the key skills used by analysts. You’ll also explore analytical thinking and how it relates to data-driven decision-making.
The wonderful world of data

Data has its own life cycle, and the work of data analysts often intersects with that cycle. In this part of the course, you’ll learn how the data life cycle and data analysts’ work both relate to your progress through this program. You’ll also be introduced to applications used in the data analysis process.

Set up your toolbox
- As you’re learning, spreadsheets, query languages, and data visualization tools are all a big part of a data analyst’s job. In this part of the course, you’ll learn more about the basic concepts involved and explore some examples of how these tools work.

Endless career possibilities
- Businesses of all kinds value the work done by data analysts. In this part of the course, you’ll find out about these businesses and the specific jobs and tasks that analysts perform for them. You’ll also learn how your data analyst certificate will help you meet many of the requirements for a position with these businesses.

The demand for skilled data science practitioners in industry, academia, and government is rapidly growing. The HarvardX Data Science program prepares you with the necessary knowledge base and useful skills to tackle real-world data analysis challenges. The program covers concepts such as probability, inference, regression, and machine learning and helps you develop an essential skill set that includes R programming, data wrangling with dplyr, data visualization with ggplot2, file organization with Unix/Linux, version control with git and GitHub, and reproducible document preparation with RStudio.

In each course, we use motivating case studies, ask specific questions, and learn by answering these through data analysis. Case studies include: Trends in World Health and Economics, US Crime Rates, The Financial Crisis of 2007-2008, Election Forecasting, Building a Baseball Team (inspired by Moneyball), and Movie Recommendation Systems.

Throughout the program, we will be using the R software environment. You will learn R, statistical concepts, and data analysis techniques simultaneously. We believe that you can better retain R knowledge when you learn how to solve a specific problem.

Course 1: Data Science: R Basics

Build a foundation in R and learn how to wrangle, analyze, and visualize data.

Course 2: Data Science: Visualization

Learn basic data visualization principles and how to apply them using ggplot2.

Course 3: Data Science: Probability

Learn probability theory — essential for a data scientist — using a case study on the financial crisis of 2007-2008.

Course 4: Data Science: Inference and Modeling

Learn inference and modeling, two of the most widely used statistical tools in data analysis.

Course 5: Data Science: Productivity Tools

Keep your projects organized and produce reproducible reports using GitHub, git, Unix/Linux, and RStudio.

Course 6: Data Science: Wrangling

Learn to process and convert raw data into formats needed for analysis.

Course 7: Data Science: Linear Regression

Learn how to use R to implement linear regression, one of the most common statistical modeling approaches in data science.
Course 8: Data Science: Machine Learning

Build a movie recommendation system and learn the science behind one of the most popular and successful data science techniques.

Course 9: Data Science: Capstone

Show what you’ve learned from the Professional Certificate Program in Data Science.

Machine Learning

Do you have data and wonder what it can tell you? Do you need a deeper understanding of the core ways in which machine learning can improve your business? Do you want to be able to converse with specialists about anything from regression and classification to deep learning and recommender systems?
In this course, you will get hands-on experience with machine learning from a series of practical case-studies. At the end of the first course you will have studied how to predict house prices based on house-level features, analyze sentiment from user reviews, retrieve documents of interest, recommend products, and search for images. Through hands-on practice with these use cases, you will be able to apply machine learning methods in a wide range of domains.

This first course treats the machine learning method as a black box. Using this abstraction, you will focus on understanding tasks of interest, matching these tasks to machine learning tools, and assessing the quality of the output. In subsequent courses, you will delve into the components of this black box by examining models and algorithms. Together, these pieces form the machine learning pipeline, which you will use in developing intelligent applications.

Learning Outcomes: By the end of this course, you will be able to:
-Identify potential applications of machine learning in practice.
-Describe the core differences in analyses enabled by regression, classification, and clustering.
-Select the appropriate machine learning task for a potential application.
-Apply regression, classification, clustering, retrieval, recommender systems, and deep learning.
-Represent your data as features to serve as input to machine learning models.
-Assess the model quality in terms of relevant error metrics for each task.
-Utilize a dataset to fit a model to analyze new data.
-Build an end-to-end application that uses machine learning at its core. -Implement these techniques in Python.

Syllabus

Welcome
- Machine learning is everywhere, but is often operating behind the scenes.

This introduction to the specialization provides you with insights into the power of machine learning, and the multitude of intelligent applications you personally will be able to develop and deploy upon completion.

We also discuss who we are, how we got here, and our view of the future of intelligent applications.

Regression: Predicting House Prices
- This week you will build your first intelligent application that makes predictions from data.

We will explore this idea within the context of our first case study, predicting house prices, where you will create models that predict a continuous value (price) from input features (square footage, number of bedrooms and bathrooms,…).

This is just one of the many places where regression can be applied.Other applications range from predicting health outcomes in medicine, stock prices in finance, and power usage in high-performance computing, to analyzing which regulators are important for gene expression.

You will also examine how to analyze the performance of your predictive model and implement regression in practice using a Jupyter notebook.

Classification: Analyzing Sentiment
- How do you guess whether a person felt positively or negatively about an experience, just from a short review they wrote?

In our second case study, analyzing sentiment, you will create models that predict a class (positive/negative sentiment) from input features (text of the reviews, user profile information,…).This task is an example of classification, one of the most widely used areas of machine learning, with a broad array of applications, including ad targeting, spam detection, medical diagnosis and image classification.

You will analyze the accuracy of your classifier, implement an actual classifier in a Jupyter notebook, and take a first stab at a core piece of the intelligent application you will build and deploy in your capstone.

Clustering and Similarity: Retrieving Documents
- A reader is interested in a specific news article and you want to find a similar articles to recommend. What is the right notion of similarity? How do I automatically search over documents to find the one that is most similar? How do I quantitatively represent the documents in the first place?

In this third case study, retrieving documents, you will examine various document representations and an algorithm to retrieve the most similar subset. You will also consider structured representations of the documents that automatically group articles by similarity (e.g., document topic).

You will actually build an intelligent document retrieval system for Wikipedia entries in an Jupyter notebook.

Recommending Products
- Ever wonder how Amazon forms its personalized product recommendations? How Netflix suggests movies to watch? How Pandora selects the next song to stream? How Facebook or LinkedIn finds people you might connect with? Underlying all of these technologies for personalized content is something called collaborative filtering.

You will learn how to build such a recommender system using a variety of techniques, and explore their tradeoffs.

One method we examine is matrix factorization, which learns features of users and products to form recommendations. In a Jupyter notebook, you will use these techniques to build a real song recommender system.

Deep Learning: Searching for Images
- You’ve probably heard that Deep Learning is making news across the world as one of the most promising techniques in machine learning. Every industry is dedicating resources to unlock the deep learning potential, including for tasks such as image tagging, object recognition, speech recognition, and text analysis.

In our final case study, searching for images, you will learn how layers of neural networks provide very descriptive (non-linear) features that provide impressive performance in image classification and retrieval tasks. You will then construct deep features, a transfer learning technique that allows you to use deep learning very easily, even when you have little data to train the model.

Using iPhython notebooks, you will build an image classifier and an intelligent image retrieval system with deep learning.

Closing Remarks
- In the conclusion of the course, we will describe the final stage in turning our machine learning tools into a service: deployment.

We will also discuss some open challenges that the field of machine learning still faces, and where we think machine learning is heading. We conclude with an overview of what’s in store for you in the rest of the specialization, and the amazing intelligent applications that are ahead for us as we evolve machine learning.

Machine Learning, often called Artificial Intelligence or AI, is one of the most exciting areas of technology at the moment. We see daily news stories that herald new breakthroughs in facial recognition technology, self driving cars or computers that can have a conversation just like a real person. Machine Learning technology is set to revolutionise almost any area of human life and work, and so will affect all our lives, and so you are likely to want to find out more about it. Machine Learning has a reputation for being one of the most complex areas of computer science, requiring advanced mathematics and engineering skills to understand it. While it is true that working as a Machine Learning engineer does involve a lot of mathematics and programming, we believe that anyone can understand the basic concepts of Machine Learning, and given the importance of this technology, everyone should. The big AI breakthroughs sound like science fiction, but they come down to a simple idea: the use of data to train statistical algorithms. In this course you will learn to understand the basic idea of machine learning, even if you don’t have any background in math or programming. Not only that, you will get hands on and use user friendly tools developed at Goldsmiths, University of London to actually do a machine learning project: training a computer to recognise images. This course is for a lot of different people. It could be a good first step into a technical career in Machine Learning, after all it is always better to start with the high level concepts before the technical details, but it is also great if your role is non-technical. You might be a manager or other non-technical role in a company that is considering using Machine Learning. You really need to understand this technology, and this course is a great place to get that understanding. Or you might just be following the news reports about AI and interested in finding out more about the hottest new technology of the moment. Whoever you are, we are looking forward to guiding you through you first machine learning project.
NB this course is designed to introduce you to Machine Learning without needing any programming. That means that we don’t cover the programming based machine learning tools like python and TensorFlow.

Syllabus

Machine learning
- In this week you will learn about artificial intelligence and machine learning techniques. You will learn about the problems that these techniques address and will have practical experience of training a learning model.
Data Features
- This week you will learn about how data representation affects machine learning and how these representations, called features, can make learning easier.
Machine Learning in Practice
- In this topic you will get ready to do your own machine learning project. You will learn how to test a machine learning project to make sure it works as you want it to. You will also think about some of the opportunities and dangers of machine learning technology.
Your Machine Learning Project
- In this final topic you will do your own machine learning project: collecting a dataset, training a model and testing it.

Mobile Development

If you want to become a mobile developer, this course is a good place to start. You will learn about the day-to-day responsibilities of web and mobile developers and get a general understanding of the core and underlying technologies that power the internet.

You’ll be introduced to core technologies like HTML and CSS, and get opportunities to practice using them.
In this course, you will also discover the unique world of cross-platform mobile applications (apps). Explore the various benefits of using a system like React Native to build mobile apps and get an opportunity to practice the basics.

Syllabus

Mobile Applications
- Learn the basic principles of mobile app development using a cross-platform solution.
Introduction to HTML and CSS
- In this module, you will learn how to construct html documents and add basic styling and layout using CSS.
React and React Native
- Get a working mobile development environment on your local machine and start exploring different tools and modules for React Native.
Course summary and graded assessment
- Practice and reflect on the skills you learned in this course.

Mobile Development -Basics for Beginners

Mobile Development: Learn the basics of app development.

We will start from from scratch, you will learn how to make amaizing apps for this great platform.

I’m going to teach you programming 3 languages: QML, C++ and Javascript

The Class includes:

How to create a Blackberry ID
How to setup the Environment
QML
How to use Javascript in QML
How to insert Buttons, Text, Images
How to frame Layouts and views
Integrate QML with C++
and much more

Syllabus

Introduction to Mobile Application Development using Android

Overview

Have you ever wondered how your favorite mobile applications are developed?

Join us on a gentle journey through the mobile application development landscape, using Android as the platform. Along the way we will learn to use Android Studio, the integrated development environment (IDE) for Android apps. This course is intended for students who have some prior programming experience. The course will introduce you to the basics of the Android platform, Android application components, Activities and their lifecycle, UI design, Multimedia, 2D graphics and networking support in Android.

This course covers the following topics:

Android platform and the Android Studio IDE
Android components, Activities and their lifecycle, Intents
UI Design: Widgets and Layouts, UI Events, Event Listeners
2D graphics: Canvas/Drawing using a view
Multimedia: Audio playback and MediaPlayer
Network support: AsyncTask, HttpURLConnection
Syllabus
Week 1: The Android Platform: Introduction to the Android platform and the Android Studio IDE, Android components, Activities

Week 2: User Interface Design: Intents, Activity lifecycle, UI Design: Widgets and Layouts, UI Events, Event Listeners

Week 3: Graphics Support in Android: Drawables, Basics of Material Design, 2D graphics: Canvas/Drawing using a view

Week 4: Multimedia in Android: Audio playback and MediaPlayer, SoundPool

Week 5: Networking support: Basics of networking in Android, AsyncTask, HttpURLConnection

Computer Science for Game Development

Overview

The video games of the 1970s and 1980s have never lost their appeal. Pong, Super Mario Bros., The Legend of Zelda — these games defined a generation and set the stage for the massive billion-dollar video game industry of today. Even among the current blockbuster action-adventure titles, retro indie games play an important role, but how are these games made? What principles do you need to master to become a game designer and create the next hit title?

These courses will lead you through the most popular undergraduate course at Harvard, CS50, an Introduction to Computer Science. The first course will introduce you to common programming languages, providing a strong foundation to build the skills necessary to design and develop your own game. The second course will introduce you to the fundamentals of game programming itself.

You’ll explore the design of classic games — and newer titles like Angry Birds and Portal — in a quest to understand how video games are built. Through lectures and hands-on projects, you’ll explore the principles of 2D and 3D computer graphics, animation, sound, and collision detection. You’ll learn how to use frameworks like Unity and LÖVE 2D, as well as languages like Lua and C#. Join now to program your own games and gain a thorough understanding of game design and development.

Syllabus

Courses under this program:
Course 1: CS50’s Introduction to Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming.

Course 2: CS50’s Introduction to Game Development

Learn about the development of 2D and 3D interactive games in this hands-on course, as you explore the design of games such as Super Mario Bros., Pokémon, Angry Birds, and more.

Game Development overview

Overview

In a quest to understand how video games themselves are implemented, you’ll explore the design of such childhood games as:

Super Mario Bros.
Pong
Flappy Bird
Breakout
Match 3
Legend of Zelda
Angry Birds
Pokémon
3D Helicopter Game
Dreadhalls
Portal

Overview

Game Design

Games design course empower the learners from the concept of gaming and game to producing games. Learners will be trained in various facets like Game Art and Game Design with the understanding of Game designer as well as the player and the psychology of games. The course will provide essential skillsets and knowledge to design and develop the game. Along with inputs in Animation Fundamentals, Storytelling, Concept Art, Character Design and Vfx , the Game design course will be having multidisciplinary support and inputs right from Design foundation, Graphic, Interface Design & Interaction Design and all aspects of User Experience Design for an ensured qualifications to a learner in getting suitable entrance to this booming employment industry around the worldwide.

Games has evolved over the time, from creating fun to an immersive game. And today, it has evolved as a notable industry, providing many employment opportunities around the globe.The Gaming Industry identified as booster for economy in many countries including India. With the technology advancement in VR and AR and the penetration of mobiles, tablets, consoles and PCs, it has further improved the experiences and provided success to industry as well established. The industry exploding continuously Games and Apps are becoming mobile now.
At Frameboxx, Game Design course in Pune is offered as undergraduate programme and focusing on both Game Art, Design and Production, including programming. Each aspect of Game Design such as Concept Design, Environmental Design, 2D Art, 3D Art, Strategy, Game Psychology, Level Design and programming along with Industry professionals/ experts guidance and support. The program will be well blend of Science, Technology and Art and a learner have complete freedom to take up Interested Game from 2D or 3D. The programme is well designed to give Game enthusiast to produce games and promote to become Independent Designer who can be Game changer and leaders in the Industry.

Artistic Skills:

Foundation in Game Design
Texture Creation
Creating Digital 3D Models for Game
Lighting Techniques
3D Rendering Techniques
3D Model Testing

TOPICS COVERED

Introduction to Digital Design & Painting
Photoshop Fundamentals for Games
Pre Production+Game Theory
Game Designing Fundamentals
Introduction to 3d application
Digital Sculpting
Fundamentals of Texturing
3D Max Animation Showreel
Environment Modeling
Stylized Character modeling
Advance Game Character modeling
Advance Game Props & Vehicle modeling
Rigging and Animation for Games
Game Engine – Integration
Integration of Art Assets
Portfolio Development

Geographical Information System

1.Geographical Information System

In this module, we will cover course expectations, give you a quick overview of GIS and what’s great about it, take a first look at ArcGIS and identify key elements in the interface, and define core geospatial concepts and terminology. In Section 2, we will discuss options for desktop GIS, the history of GIS and how it’s used today, discuss resources and help that you can use, and lay out core skills that are relevant to you as a GIS analyst. We’ll close out by showing you how to get a copy of ArcGIS for this course, and with a tutorial on getting started in ArcGIS.

2.Fundamental of GIS

Define core geospatial concepts, Practice with subset data using selections and feature attributes, Create map books using advanced mapping techniques, Create layer and map packages

3.GIS Data formats and Design and Quality

Design data tables and use separating and joining data in a relational database

Write query strings to subset data Create and work with raster data, Create web maps

4.ARC GIS

In this module, we will explore GIS data using ArcMap and will explore and change properties of GIS layers to change map displays. We will subset data using selections, and explore feature attributes. Finally, we will learn about projections and use that knowledge as we run geoprocessing tools.

5.Making Map with Common Datasets

6. Retrieving and Sharing Data

In this module, we will view and edit metadata in order to create higher quality data. We will retrieve data from the web and share data, discuss workspaces and file formats, and create layer and map packages. We will also use multiple file formats for GIS data and be able to appropriately choose between them based upon project requirements.

7.Geospatial and Environmental analysis

Create 3-dimensional surfaces

Create triangulated irregular networks (TIN) and modify rasters to 3D data

Develop and analyze data for the geospatial analysis project

Design color ramps for your data

8.Imagery, Automation, and Application

Use the imagery in two different common types of analysis: NDVI and trained classification

Practice with tools to support image analysis using Raster Calculation and Spatial Analyst

Develop a large processing workflow in Model Builder

Use products derived from digital elevation models

9.Digitization Territorial Modelling Spatial Elements and Characteristics

first step in digitizing terrain, namely territorial modeling. In this week, we will consider factors such as the scale and theme of interest in order to determine which objects or spatial phenomena should included in the model, and we will also see how the geographic positioning and intrinsic nature (e.g., raster or vector) of these elements factors into how they are characterized in a terrain model.

10.Digitization Geo data capture and Documentation

Digital data acquisition involves various techniques including the direct measurement of primary data, the semi-automated vectorization and digitization of spatial objects, or the georeferencing of digital images. In this week’s module we will begin with a lesson on metadata in which we will discuss the processes and rules for documenting a dataset, which are essential for data sustainability, and we will also introduce a case study on participatory GIS in Senegal and Seychelles.

11.Geo Spatial Analysis Projects

Create a GIS project proposal Develop a hypothesis for a GIS-based question

Complete a data analysis in line with your project objectives Interpret and explain the results you obtained in comparison to your original GIS question and/or hypothesis

Oracle Syllabus

Learn how to use Oracle from beginner level to advanced techniques which is taught by experienced working professionals. With our Oracle Training you’ll learn concepts in expert level with practical manner.

Introduction to Oracle Database

List the features of Oracle Database 11g
Discuss the basic design, theoretical, and physical aspects of a relational database
Categorize the different types of SQL statements
Describe the data set used by the course
Log on to the database using SQL Developer environment
Save queries to files and use script files in SQL Developer Retrieve Data using the SQL SELECT Statement
List the capabilities of SQL SELECT statements
Generate a report of data from the output of a basic SELECT statement
Select All Columns
Select Specific Columns
Use Column Heading Defaults
Use Arithmetic Operators
Understand Operator Precedence
Learn the DESCRIBE command to display the table structure Learn to Restrict and Sort Data
Write queries that contain a WHERE clause to limit the output retrieved
List the comparison operators and logical operators that are used in a WHERE clause
Describe the rules of precedence for comparison and logical operators
Use character string literals in the WHERE clause
Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
Sort output in descending and ascending order Usage of Single-Row Functions to Customize Output
Describe the differences between single row and multiple row functions
Manipulate strings with character function in the SELECT and WHERE clauses
Manipulate numbers with the ROUND, TRUNC, and MOD functions
Perform arithmetic with date data
Manipulate dates with the DATE functions Invoke Conversion Functions and Conditional Expressions
Describe implicit and explicit data type conversion
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nest multiple functions · Apply the NVL, NULLIF, and COALESCE functions to data
Use conditional IF THEN ELSE logic in a SELECT statement Aggregate Data Using the Group Functions
Use the aggregation functions in SELECT statements to produce meaningful reports
Divide the data into groups by using the GROUP BY clause
Exclude groups of date by using the HAVING clause 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
Join a table by using a self-join Use Sub-Queries to Solve Queries
Describe the types of problem that sub-queries can solve
Define sub-queries
List the types of sub-queries
Write single-row and multiple-row sub-queries The SET Operators
Describe the SET operators
Use a SET operator to combine multiple queries into a single query
Control the order of rows returned Data Manipulation Statements
Describe each DML statement
Insert rows into a table
Change rows in a table by the UPDATE statement
Delete rows from a table with the DELETE statement
Save and discard changes with the COMMIT and ROLLBACK statements
Explain read consistency Use of DDL Statements to Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types available for columns
Create a simple table
Decipher how constraints can be created at table creation Describe how schema objects work Other Schema Objects
Create a simple and complex view
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms Control User Access
Differentiate system privileges from object privileges
Create Users
Grant System Privileges
Create and Grant Privileges to a Role
Change Your PasswordGrant Object Privileges
How to pass on privileges?
Revoke Object Privileges Management of Schema Objects
Add, Modify and Drop a Column
Add, Drop and Defer a Constraint
How to enable and Disable a Constraint?
Create and Remove Indexes
Create a Function-Based Index
Perform Flashback Operations
Create an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP
Query External Tables Manage Objects with Data Dictionary Views
Explain the data dictionary
Use the Dictionary Views
USER_OBJECTS and ALL_OBJECTS Views
Table and Column Information
Query the dictionary views for constraint information
Query the dictionary views for view, sequence, index, and synonym information
Add a comment to a table
Query the dictionary views for comment information Manipulate Large Data Sets
Use Subqueries to Manipulate Data
Retrieve Data Using a Subquery as Source
Insert Using a Subquery as a Target
Usage of the WITH CHECK OPTION Keyword on DML Statements
List the types of Multitable INSERT Statements
Use Multitable INSERT Statements
Merge rows in a table
Track Changes in Data over a period of time Data Management in Different Time Zones
Time Zones
CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
Compare Date and Time in a Session’s Time Zone
DBTIMEZONE and SESSIONTIMEZONE
Difference between DATE and TIMESTAMP
INTERVAL Data Types
Use EXTRACT, TZ_OFFSET, and FROM_TZ
Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL Retrieve Data Using Sub-queries
Multiple-Column Subqueries
Pairwise and Nonpairwise Comparison
Scalar Subquery Expressions
Solve problems with Correlated Subqueries
Update and Delete Rows Using Correlated Subqueries
The EXISTS and NOT EXISTS operators
Invoke the WITH clause
The Recursive WITH clause Regular Expression Support
Use the Regular Expressions Functions and Conditions in SQL
Use Meta Characters with Regular Expressions
Perform a Basic Search using the REGEXP_LIKE function
Find patterns using the REGEXP_INSTR functio
Extract Substrings using the REGEXP_SUBSTR function

Replace Patterns Using the REGEXP_REPLACE function
Usage of Sub-Expressions with Regular Expression Support
Implement the REGEXP_COUNT function