Free seminar certified java

Free Seminar on Apr 26, 2020 at 12:00 PM In our Java & Spring Framework Developer course students will learn to develop Java applications and services using Spring Framework and related technologies such as Spring Boot, Spring JPA / Hibernate & Spring Cloud. The course starts with introduction to Java & OOP in Java and moves on to Spring Framework, Inversion of Control (IoC), Dependency Injection (DI) and Java Beans. The course also covers enterprise level web application development using Spring MVC and database programming using Hibernate. The course further covers Webservices & Microservices development using Spring Boot & Spring Cloud which can be used as backend for modern web and mobile applications. Brief Contents Introduction to Java & Fundamentals of Java Programming Defining Classes, Methods, Constructors & Access Modifiers Method Overloading, Recursion, Native Methods & Packages Composition, Inheritance, Abstract Classes & Polymorphism Interfaces, Anonymous Classes, Nested Classes, Enumeration Exceptions, Types of Exceptions & Custom Exceptions Exception object & Dealing with Exceptions Understanding Streams, Input & Output Streams Accessing File & Directories using NIO Reading & Writing Files; Serialization & Deserialization of Objects Generics, Lambda & Collections (Set, Sequence, Map, Hashing) Strings Mutable and Immutable, Date & Times & Regular Expression Understanding & Managing Threads; Synchronization & Deadlocks Thread Priorities & Communication b/w threads (Wait & NotifyAll) Creating Responsive Web Design using HTML5, CSS3, JavaScript & Angular Spring Overview & Setting Up Your Spring Development Environment Spring Configuration with Java Annotations, XML Configuration & Java Code Spring Inversion of Control (IoC) & Spring Dependency Injection Bean Scopes and Lifecycle Management Spring MVC - Building Spring Web Apps Spring MVC - Creating Controllers and Views Spring MVC - Request Params and Request Mappings Spring MVC - Form Tags and Data Binding Spring MVC Form Validation - Applying Built-In Validation Rules Spring MVC Form Validation - Validating Number Ranges and Regular Expressions Spring MVC Form Validation - Creating Custom Validation Rules Introduction to Hibernate Setting Up Hibernate Development Environment Hibernate Configuration with Annotations Hibernate CRUD Features: Create, Read, Update and Delete Hibernate Advanced Mappings Hibernate Advanced Mappings - @OneToOne Hibernate Advanced Mappings - @OneToMany Spring MVC and Hibernate Project - Part 1 (Environment + Database Setup) Spring MVC and Hibernate Project - Part 2 (Entity + JSP Page + CSS) Spring MVC and Hibernate Project - Part 3 (Mapping + Service Layer) Spring MVC and Hibernate Project - Part 4 (Form + Add Button + Save Part) Spring MVC and Hibernate Project - Part 5 (Form + Edit Button + Update Part) Spring MVC and Hibernate Project - Part 6 (Delete Button + Delete part) Introduction To Web Services and Microservices Introduction to Spring Boot SOAP Web Services with Spring and Spring Boot RESTful Web Services with Spring and Spring Boot Introduction to JPA in 10 Steps Connecting RESTful Web Service to JPA RESTful Web Services - Best Practices Training Methodology Lectures & Demos by experts from industry Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for student’s evaluation Audience Students and graduates of Computer Science and Software Engineering People looking for career in software development People willing to learn Java Programming & Spring Framework People willing to learn Webservices & Microservices using Spring Boot Course Project Participants of the course are required to demonstrate their skills by developing commercial level Java applications and services using Spring Framework and related technologies such as Spring Boot, Spring JPA & Spring Cloud. Certificate EVS Certified Java Programmer EVS Certified Spring Framework Developer Duration & Frequency 4 Month (16 weeks; with 3 training sessions of 1.5 hours a week) Views: 3

Free Seminar on Apr 26, 2020 at 12:00 PM In our Java & Spring Framework Developer course students will learn to develop Java applications and services using Spring Framework and related technologies such as Spring Boot, Spring JPA / Hibernate & Spring Cloud. The course starts with introduction to Java & OOP in Java and moves on to Spring Framework, Inversion of Control (IoC), Dependency Injection (DI) and Java Beans. The course also covers enterprise level web application development using Spring MVC and database programming using Hibernate. The course further covers Webservices & Microservices development using Spring Boot & Spring Cloud which can be used as backend for modern web and mobile applications. Brief Contents Introduction to Java & Fundamentals of Java Programming Defining Classes, Methods, Constructors & Access Modifiers Method Overloading, Recursion, Native Methods & Packages Composition, Inheritance, Abstract Classes & Polymorphism Interfaces, Anonymous Classes, Nested Classes, Enumeration Exceptions, Types of Exceptions & Custom Exceptions Exception object & Dealing with Exceptions Understanding Streams, Input & Output Streams Accessing File & Directories using NIO Reading & Writing Files; Serialization & Deserialization of Objects Generics, Lambda & Collections (Set, Sequence, Map, Hashing) Strings Mutable and Immutable, Date & Times & Regular Expression Understanding & Managing Threads; Synchronization & Deadlocks Thread Priorities & Communication b/w threads (Wait & NotifyAll) Creating Responsive Web Design using HTML5, CSS3, JavaScript & Angular Spring Overview & Setting Up Your Spring Development Environment Spring Configuration with Java Annotations, XML Configuration & Java Code Spring Inversion of Control (IoC) & Spring Dependency Injection Bean Scopes and Lifecycle Management Spring MVC - Building Spring Web Apps Spring MVC - Creating Controllers and Views Spring MVC - Request Params and Request Mappings Spring MVC - Form Tags and Data Binding Spring MVC Form Validation - Applying Built-In Validation Rules Spring MVC Form Validation - Validating Number Ranges and Regular Expressions Spring MVC Form Validation - Creating Custom Validation Rules Introduction to Hibernate Setting Up Hibernate Development Environment Hibernate Configuration with Annotations Hibernate CRUD Features: Create, Read, Update and Delete Hibernate Advanced Mappings Hibernate Advanced Mappings - @OneToOne Hibernate Advanced Mappings - @OneToMany Spring MVC and Hibernate Project - Part 1 (Environment + Database Setup) Spring MVC and Hibernate Project - Part 2 (Entity + JSP Page + CSS) Spring MVC and Hibernate Project - Part 3 (Mapping + Service Layer) Spring MVC and Hibernate Project - Part 4 (Form + Add Button + Save Part) Spring MVC and Hibernate Project - Part 5 (Form + Edit Button + Update Part) Spring MVC and Hibernate Project - Part 6 (Delete Button + Delete part) Introduction To Web Services and Microservices Introduction to Spring Boot SOAP Web Services with Spring and Spring Boot RESTful Web Services with Spring and Spring Boot Introduction to JPA in 10 Steps Connecting RESTful Web Service to JPA RESTful Web Services - Best Practices Training Methodology Lectures & Demos by experts from industry Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for student’s evaluation Audience Students and graduates of Computer Science and Software Engineering People looking for career in software development People willing to learn Java Programming & Spring Framework People willing to learn Webservices & Microservices using Spring Boot Course Project Participants of the course are required to demonstrate their skills by developing commercial level Java applications and services using Spring Framework and related technologies such as Spring Boot, Spring JPA & Spring Cloud. Certificate EVS Certified Java Programmer EVS Certified Spring Framework Developer Duration & Frequency 4 Month (16 weeks; with 3 training sessions of 1.5 hours a week) Date Apr 26th

FREE Orientation Seminar Jan 14, 2017 Classes Start from Jan 21, 2017 For further details call 0300-4102039 or 042-111 685 822 Lahore Center 349 Main Ferozepur Road , Block-M Gulberg III, Lahore Phone: 042-35831311-12 UAN: 042-111-685-222 Cell: 0300-4102039 Rawalpindi Center 92-A, 6th Road, Satellite Town, Rawalpindi Phone: 051-4933205 UAN: 051-111-685-222 Cell: 0333 888 5779 Faisalabad Center ST Plaza, Koh-e-Noor Chowk, Madina Town, Faisalabad Phone: 041-8502032-33 UAN: 042-111-685-222 Cell: 0333-4900907

Free Seminar on Feb 15, 2020 at 07:30 PM This free course is for EVS students of Front-End Web Development course. In this 4 week course students will learn to develop and deploy commercial level Websites using WordPress. Brief Contents Training Methodology Audience Course Project Certificate EVS Certified WordPress Web Developer Duration & Frequency 3 Month (12 weeks; with 3 training sessions of 1.5 hours a week) Views: 5

Free Seminar on Feb 05, 2020 at 06:00 PM This course is designed to develop a strong foundation of the students for developing powerful visual communications. Students will learn to visualize the concepts, techniques of graphics and design and application of software like Adobe Illustrator / CorelDraw, Photoshop and InDesign for creating effective designs for print media, outdoor advertisement and the web. The course will also cover Web designing using HTML5, CSS3 and Dreamweaver. Brief Contents Essentials of graphics, design and color theory Working with Illustrator documents Drawing and transforming objects Managing color and transparency Typography and using type in Illustrator Controlling effects, appearances, and graphic style Building graphic objects and working with images Preparing graphics for web or screen display Photoshop Intro, working with selections and layers Using masks and channels Working with type and vector tools Adjusting and processing photographs Retouching and manipulating images Working in Adobe Camera Raw Painting and filtering an image Generating Output for Print media and the web Creating web pages using HTML and XHTML Controlling page styles and layout with CSS Adding graphics and multimedia in web pages Using Dreamweaver for rapid web development Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for student’s evaluation Audience Students and graduates of any discipline People looking for career in graphics and web designing People willing to learn graphic designing and animation Course Project As a project of the course students have to develop a design theme according given requirements of a company. Student will also create logo, stationary, brochure, posters, banners, billboard and website of the company according to designed theme. Certificate Certified Graphics and Web Designer by EVS Duration & Frequency 3 Month (12 weeks; with 3 training sessions of 1.5 hours a week)

Free Seminar on Mar 30, 2020 at 07:30 PM Microsoft SQL Server 2016 provides a robust architecture for enterprise level data management, developer’s productivity and business intelligence. This hands-on course is designed to provide necessary knowledge and hands-on experience for installation and configuration and administration of SQL Server 2016; designing and implementing SQL Server databases, querying and manipulating data from SQL Server and implementing a Data Warehouse with SQL Server 2016. Brief Contents Introduction to SQL Server, Its Installation & Configuration Introduction to Database Designing & Entity Relationship Diagram (ERD) Database Design Theory Concepts & Rules for Normalization Working with Tables, Schemas, Columns & Built-In Data Types Working with Primary Keys, Foreign Keys & Identity Column Working with SQL Server Management Studio Ensuring Data Integrity through Constraints Introduction to T-SQL & Writing Basic Select Statements Eliminating Duplicates with DISTINCT & Using Column and Table Aliases Writing Queries that Filter Data using a WHERE Clause Writing Queries that Sort Data Using an ORDER BY Clause Writing Queries that Filter Data Using the TOP Option Write Queries that filter data using the OFFSET-FETCH Querying Multiple Tables & Understanding Joins Inner Joins, Self Joins, Outer Joins & Cross Joins Indexing & Designing Optimized Indexing Strategies Using Conversion Functions, Logical Functions & Function to work with NULL Writing Queries using GROUP BY Clause & Aggregate Functions Writing Queries that Filter Groups with the HAVING Clause Using Self-Contained Subqueries, Scalar Subqueries & Multi-Result Subqueries Writing Queries That Use Correlated Subqueries and EXISTS Clause Writing Queries with UNION, EXCEPT, INTERSECT & APPLY Designing & Implementing Views & Performance Consideration for Views Inserting, Updating & Deleting Data using Data Manipulation Language (DML) Designing and Implementing Stored Procedures Creating & using user defined Table-Valued Functions (TVFs) Creating & using user defined Common Table Expressions (CTEs) Programming with T-SQL: T-SQL Programming Elements Programming with T-SQL: Controlling Program Flow Programming with T-SQL: Implementing T-SQL error handling Programming with T-SQL: Implementing structured exception handling Programming with T-SQL: Controlling database transactions Responding to Data Manipulation via Triggers Storing and Querying XML & Spatial Data in SQL Server Storing and Querying BLOBs and Text Documents in SQL Server Performance Optimization, Monitoring & Concurrency in SQL Server Training Methodology Audience Course Project Participants of the course will complete hands-on labs and project assignments with help of their trainers. Certificate EVS Certified SQL Server Developer MCP: Querying Data with Transact-SQL MCP: Developing SQL Database Duration & Frequency 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week) Views: 2

Free Seminar on Mar 30, 2020 at 07:30 PM Microsoft SQL Server 2016 provides a robust architecture for enterprise level data management, developer’s productivity and business intelligence. This hands-on course is designed to provide necessary knowledge and hands-on experience for installation and configuration and administration of SQL Server 2016; designing and implementing SQL Server databases, querying and manipulating data from SQL Server and implementing a Data Warehouse with SQL Server 2016. Brief Contents Introduction to SQL Server, Its Installation & Configuration Introduction to Database Designing & Entity Relationship Diagram (ERD) Database Design Theory Concepts & Rules for Normalization Working with Tables, Schemas, Columns & Built-In Data Types Working with Primary Keys, Foreign Keys & Identity Column Working with SQL Server Management Studio Ensuring Data Integrity through Constraints Introduction to T-SQL & Writing Basic Select Statements Eliminating Duplicates with DISTINCT & Using Column and Table Aliases Writing Queries that Filter Data using a WHERE Clause Writing Queries that Sort Data Using an ORDER BY Clause Writing Queries that Filter Data Using the TOP Option Write Queries that filter data using the OFFSET-FETCH Querying Multiple Tables & Understanding Joins Inner Joins, Self Joins, Outer Joins & Cross Joins Indexing & Designing Optimized Indexing Strategies Using Conversion Functions, Logical Functions & Function to work with NULL Writing Queries using GROUP BY Clause & Aggregate Functions Writing Queries that Filter Groups with the HAVING Clause Using Self-Contained Subqueries, Scalar Subqueries & Multi-Result Subqueries Writing Queries That Use Correlated Subqueries and EXISTS Clause Writing Queries with UNION, EXCEPT, INTERSECT & APPLY Designing & Implementing Views & Performance Consideration for Views Inserting, Updating & Deleting Data using Data Manipulation Language (DML) Designing and Implementing Stored Procedures Creating & using user defined Table-Valued Functions (TVFs) Creating & using user defined Common Table Expressions (CTEs) Programming with T-SQL: T-SQL Programming Elements Programming with T-SQL: Controlling Program Flow Programming with T-SQL: Implementing T-SQL error handling Programming with T-SQL: Implementing structured exception handling Programming with T-SQL: Controlling database transactions Responding to Data Manipulation via Triggers Storing and Querying XML & Spatial Data in SQL Server Storing and Querying BLOBs and Text Documents in SQL Server Performance Optimization, Monitoring & Concurrency in SQL Server Training Methodology Audience Course Project Participants of the course will complete hands-on labs and project assignments with help of their trainers. Certificate EVS Certified SQL Server Developer MCP: Querying Data with Transact-SQL MCP: Developing SQL Database Duration & Frequency 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week) Date Mar 30th

Free Seminar on Feb 15, 2020 at 06:00 PM This hands-on training covers mobile app development using C#, Xamarin and Visual Studio 2019. It includes Mobile UI Development using Xamarin Forms; Storing and accessing local data using SQLite; Storing and accessing server data using REST APIs, JSON and XML. The course also cover deployment of Xamarin Mobile Apps to Mobile devices. Brief Contents Developing Xamarin Forms Mobile Apps using Visual Studio 2019 Setting Xamarin Mobile App Development Environment Developing understanding of Asynchronous Programming in.NET Building Xamarin Forms Mobile UI/UX using XAML & C# Layout Managers: Stack Layout, Grid Layout & Flex Layout Views-1: Entry, Label, Image, Button, Image Button, Frame & Box View Views-2: DatePicker, TimePicker, Picker, Slider & Stepper & Switch Views-3: ListView, WebView, ScrollView, ProgressBar & SearchBar Creating & using Custom Views in Xamarin Forms Mobile Apps Creating Single Page & Multiple Page Xamarin Forms Mobile Apps Modal Pages to Display Contents & Take User Input in Mobile Apps Developing understanding of Services Oriented Architecture (SOA) Creating Mobile Apps using Stack Navigation & Tab Navigation Creating Master Details scenario in Xamarin Forms Mobile Apps Creating and Using Resources & Styles for consistent Mobile UI Using Mobile Device Features in Xamarin Forms Mobile Apps Store & Access Local Data using SQLite in Xamarin Forms Mobile Apps Serialization & Deserialization of JSON and XML Data in Mobile Apps Store & Access Server Data using REST Services, JSON & XML Debugging, Testing & Deployment of Xamarin Form Mobile Apps Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for participant’s evaluation Audience Programmers, Software Developer, Web Developers Software Analysts, Software Designers and Software Architects Any other person willing to learn software development using.NET Core Course Project Certificate Certificate of participation by EVS Duration & Frequency 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week) Views: 3

Free Seminar on Feb 10, 2020 at 06:00 PM It is one of the best Oracle Database Development / Oracle Database Administration courses in Lahore, Rawalpindi & Islamabad. It covers database development and administration using Oracle 12c. It includes understanding database concept; creating databases using Oracle 12c ; querying and manipulating data using PL / SQL and taking advantage of Oracle’s Multitenant-Architecture for cloud computing. The course not only teaches the skills required to Oracle DBA for performing his routine operations but also teaches him the skills required to become a top-performing Oracle DBA. It includes deployment of backup and recovery and its cloud computing strategies. Brief Contents What is Database, Type of Databases, Data Types Difference between Liner & Non Liner Databases What is No SQL Database, What is ATL32-U Database, Object Oriented Database How to Setup Virtual Machine, How to Install Database on Windows Environment How to Install Database on Linux Environment, How to Test Database after installation Trouble Shooting of Database During Installation Introduction of Data Structure, Introduction of Table Structure Select Statement, Database Keys, Distinct Statement, Joining of Tables Null Values, NVL Values, Table Alias Identification of Data, Identification of Primary & Foreign Key Arithmetic Expressions, Add Running Total, Add Union Intersections Null If Function, Data Sorting, To Date & Automatic Date Calculations Formulas Introduction of Sub Query, Return Single Row from Sub Query, Return Multiple Row from Sub Query, Where Claus in Sub Query , Inner Joins, Outer Joins, Conversion of Data, Conversion of Data Num To Char, Conversion of Dates What is Aggregation Rule, What is Group by & Having Functions Applying Aggregation Rules, Applying Group by Functions, Apply Having Function Use Multiple Tables in Group By Function, Conversion of Data, Conversion of Data Num To Char, Sorting of Data, Order By of Data Introduction of Tables, Creation of Tables, Update Table Columns, Drop Table Columns How to Define Primary Key, How to Define Foreign Key What is Star Schema, How to Build Star Schema, How to Drop Table, Update of Data in Tables, Insert of Data in Tables, Introduction of Sequences How to Build Auto Incremental Columns, How to Build Sequence in Table Columns What is Loop Functionality, How to Insert Data in Tables through Loop Functionality How to Update Data in Tables Through Loop, How to Delete Data from Tables How to Clone Tables, How to Fetch Query from Multiple Databases Tables How to Display all Tables in User, How to Check Table Space, How Count Rows of Tables, Rownum Function in Tables, Introduction of Functions Type of Functions, How to Build Function in Database, How to Run Function in Database How to use Data Types in Functions, Method to Create Function, Method to Alter Functions Purpose of Functions, Method to Call Function in Database Query How to Optimize Query Through Functions Introduction of Data Views, De-Normalize Table Data in Views, Hierarchy of Views Method to Create Data Views, Method to Alter Data Views, What is Procedure, Why we use Procedures, How to Build Procedure Insert, Update & Delete Data Through Procedure Alteration of Procedure, Drop Procedures What is Package, How to Build Package, Purpose to Build Package How to Send E-Mail Through Database Package List of Major Architecture Components of Database, Explain the Memory Structures Describe the Background Process, Correlate the Logical and Physical Storage Structures What are Database Management Tools, How to Use Database Management Tools How to Install Database Management Tools, Start & Shut Down Database Services Difference Between Immediate Start/Shutdown & Immediate Start/Shutdown Services View Database Logs, What is Network Environment, How to Configure Network Environment What is TNS Listener, How to Configure TNS Listener, Trouble Shooting of TNS Listener Services How to Configure Network Side Configurations What is Table Space, What is Table Partition, How to Manage Table Spaces What is Undo Data, How to Apply Patches on Database, Difference Between Undo & Redo Data, Space Management of Databases Managing Database Roles, Changing Database Privilege Database Compressions, Describing the Locking Mode, Unlocking of Data Release of Expired Users, Database Backup Description, How to Backup Database How to Restore Database Through Dumps, Backup Database without shutting it down Generate Database Alerts, Small Briefing of Database Auditing What is Database Patch, How to Download & Apply Database Patches What is Database Scheduler, Create Schedule of Database Jobs, Use Task Manager for Database Scheduler, Cloning of Database, Duplication of Database Move Database From One Server to Another Server Introduction of RMAN, How to Use RMAN from SQL Plus, How to Connect Database with RMAN, Use SQL in RMAN What is Recovery Catalog, How to Configure Recovery Catalog in RMAN How to Generate Scripts for Recovery Catalog in RMAN, Export & Import Recovery Catalog What is Data backup Through RMAN, Create Backup Plan Strategy using RMAN Database Backup Configuring Fast Recovery Data, How to Use Incremental Backup Manage Backups, Backup Database on No Archive & Archive Mode How to Backup Non-Database Files, Secure Backup Cloning of Database Using RMAN, Duplication Database using RMAN, CDB & PDB Database Management, What is Flash Recovery of Database Use Flashback Query, Use Flashback Table Operations, Recover Table Data From Flashback Recovery, Recover Columns Data from Flashback Recovery Restore Table from Recycle Bin, Manage Pluggable & Container Database Manage Security of Database Through RMAN Database Audit Concepts, Database Security Auditing Generate Database Documentation From Database Tools Auditing of User Privileges, Checking of Login Audits, Checking of Unused Spaces Audit of Unused Memory , Query Optimization & runtime Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for participant’s evaluation Audience Programmers, Software Developer, Web Developers Software Analysts, Software Designers and Software Architects Graduates & Students of Computer Science, Software Engineering etc. Course Project Participants of the course will develop a commercial level database during the course Oracle Database 12c. They will also demonstrate their proficiency in common DBA tasks by performing them under the supervision of the course trainers. Certificate On successful completion of the course participants will be awarded participation certificate from EVS. Exam-1: Oracle Database SQL: 1Z0-071 Exam-2: Oracle Database 12c Administration: 1Z0-062 Exam-3: Oracle Database 12c: Advanced Administration: 1Z0-063 Duration & Frequency Total Duration of the course is 3 months (12 Weeks, with 3 classes of 1.5 hours in a week).

Free Seminar on Feb 10, 2020 at 06:00 PM It is one of the best Oracle Database Development / Oracle Database Administration courses in Lahore, Rawalpindi & Islamabad. It covers database development and administration using Oracle 12c. It includes understanding database concept; creating databases using Oracle 12c; querying and manipulating data using PL / SQL and taking advantage of Oracle’s Multitenant-Architecture for cloud computing. The course not only teaches the skills required to Oracle DBA for performing his routine operations but also teaches him the skills required to become a top-performing Oracle DBA. It includes deployment of backup and recovery and its cloud computing strategies. Brief Contents What is Database, Type of Databases, Data Types Difference between Liner & Non Liner Databases What is No SQL Database, What is ATL32-U Database, Object Oriented Database How to Setup Virtual Machine, How to Install Database on Windows Environment How to Install Database on Linux Environment, How to Test Database after installation Trouble Shooting of Database During Installation Introduction of Data Structure, Introduction of Table Structure Select Statement, Database Keys, Distinct Statement, Joining of Tables Null Values, NVL Values, Table Alias Identification of Data, Identification of Primary & Foreign Key Arithmetic Expressions, Add Running Total, Add Union Intersections Null If Function, Data Sorting, To Date & Automatic Date Calculations Formulas Introduction of Sub Query, Return Single Row from Sub Query, Return Multiple Row from Sub Query, Where Claus in Sub Query, Inner Joins, Outer Joins, Conversion of Data, Conversion of Data Num To Char, Conversion of Dates What is Aggregation Rule, What is Group by & Having Functions Applying Aggregation Rules, Applying Group by Functions, Apply Having Function Use Multiple Tables in Group By Function, Conversion of Data, Conversion of Data Num To Char, Sorting of Data, Order By of Data Introduction of Tables, Creation of Tables, Update Table Columns, Drop Table Columns How to Define Primary Key, How to Define Foreign Key What is Star Schema, How to Build Star Schema, How to Drop Table, Update of Data in Tables, Insert of Data in Tables, Introduction of Sequences How to Build Auto Incremental Columns, How to Build Sequence in Table Columns What is Loop Functionality, How to Insert Data in Tables through Loop Functionality How to Update Data in Tables Through Loop, How to Delete Data from Tables How to Clone Tables, How to Fetch Query from Multiple Databases Tables How to Display all Tables in User, How to Check Table Space, How Count Rows of Tables, Rownum Function in Tables, Introduction of Functions Type of Functions, How to Build Function in Database, How to Run Function in Database How to use Data Types in Functions, Method to Create Function, Method to Alter Functions Purpose of Functions, Method to Call Function in Database Query How to Optimize Query Through Functions Introduction of Data Views, De-Normalize Table Data in Views, Hierarchy of Views Method to Create Data Views, Method to Alter Data Views, What is Procedure, Why we use Procedures, How to Build Procedure Insert, Update & Delete Data Through Procedure Alteration of Procedure, Drop Procedures What is Package, How to Build Package, Purpose to Build Package How to Send E-Mail Through Database Package List of Major Architecture Components of Database, Explain the Memory Structures Describe the Background Process, Correlate the Logical and Physical Storage Structures What are Database Management Tools, How to Use Database Management Tools How to Install Database Management Tools, Start & Shut Down Database Services Difference Between Immediate Start/Shutdown & Immediate Start/Shutdown Services View Database Logs, What is Network Environment, How to Configure Network Environment What is TNS Listener, How to Configure TNS Listener, Trouble Shooting of TNS Listener Services How to Configure Network Side Configurations What is Table Space, What is Table Partition, How to Manage Table Spaces What is Undo Data, How to Apply Patches on Database, Difference Between Undo & Redo Data, Space Management of Databases Managing Database Roles, Changing Database Privilege Database Compressions, Describing the Locking Mode, Unlocking of Data Release of Expired Users, Database Backup Description, How to Backup Database How to Restore Database Through Dumps, Backup Database without shutting it down Generate Database Alerts, Small Briefing of Database Auditing What is Database Patch, How to Download & Apply Database Patches What is Database Scheduler, Create Schedule of Database Jobs, Use Task Manager for Database Scheduler, Cloning of Database, Duplication of Database Move Database From One Server to Another Server Introduction of RMAN, How to Use RMAN from SQL Plus, How to Connect Database with RMAN, Use SQL in RMAN What is Recovery Catalog, How to Configure Recovery Catalog in RMAN How to Generate Scripts for Recovery Catalog in RMAN, Export & Import Recovery Catalog What is Data backup Through RMAN, Create Backup Plan Strategy using RMAN Database Backup Configuring Fast Recovery Data, How to Use Incremental Backup Manage Backups, Backup Database on No Archive & Archive Mode How to Backup Non-Database Files, Secure Backup Cloning of Database Using RMAN, Duplication Database using RMAN, CDB & PDB Database Management, What is Flash Recovery of Database Use Flashback Query, Use Flashback Table Operations, Recover Table Data From Flashback Recovery, Recover Columns Data from Flashback Recovery Restore Table from Recycle Bin, Manage Pluggable & Container Database Manage Security of Database Through RMAN Database Audit Concepts, Database Security Auditing Generate Database Documentation From Database Tools Auditing of User Privileges, Checking of Login Audits, Checking of Unused Spaces Audit of Unused Memory, Query Optimization & runtime Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for participant’s evaluation Audience Programmers, Software Developer, Web Developers Software Analysts, Software Designers and Software Architects Graduates & Students of Computer Science, Software Engineering etc. Course Project Participants of the course will develop a commercial level database during the course Oracle Database 12c. They will also demonstrate their proficiency in common DBA tasks by performing them under the supervision of the course trainers. Certificate On successful completion of the course participants will be awarded participation certificate from EVS. Exam-1: Oracle Database SQL: 1Z0-071 Exam-2: Oracle Database 12c Administration: 1Z0-062 Exam-3: Oracle Database 12c: Advanced Administration: 1Z0-063 Duration & Frequency Total Duration of the course is 3 months (12 Weeks, with 3 classes of 1.5 hours in a week). Date Feb 12th

Free Seminar on Feb 22, 2020 at 06:00 PM This extensive course is designed to provide good understanding of Android mobile app development using latest versions of Java SE, Android SDK, Android Studio and FireBase. Participants of the course will learn essentials of Java programming for Android, creating rich UI for Android app development, Storing and accessing data from internal or external storage of a mobile and to the cloud using RESTful services and usage of device resources such as camera & location sensor in Android apps. It also covers Publishing Android Mobile Apps to Google Play store. Brief Contents Introduction to Java & Android Mobile App Development Fundamentals of Java Programming using Java 8 Object Oriented Programming using Java Exceptions & Collections & Generics Installation & Configuration of Android SDK & Android Studio Android Mobile App Development Architecture & Application Life Cycle Android Views, Layouts, Activities, Fragments, List View & View Pages Activities, Intents, Services, Content Providers & Broadcast Receivers Android Resources, Styles, Themes & Material Design Integrating Social Media in Mobile Apps for Android Dialogs, Toasts, Menus, Context Menus, Popup Menus & Web View Store/Retrieve Data in/from Shared Preference & Files (Internal & SD Card) Store/Retrieve Data in/from SQLite Database & Content Providers Using FireBase for storing and retrieving data from cloud Using FireBase to authenticate users in your Mobile App Sending/Receiving Data to/from RESTful services using JSON & XML Working with Android Alerts, Notifications, Status Bar & System Bar Explore Android APIs for Locations, Maps, Media, Camera & Connectivity Testing & Debugging Android Apps on AVD & Actual Android Devices Deploying Android Application to Google Play store Application Analytics & Application Search Optimization (ASO) Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for student’s evaluation Audience Students of software engineering, computer science & IT Programmers, Software Developer, Web Developers Software Analysts , Software Designers and Software Architects Any other person willing to learn Android application development Course Project Participants of the course have to develop a business application for Android. Preferably the application should have multipage user interface and store data to a SQLite database or connect with a RESTful service on the internet to send and receive data. Certificate EVS Certified Android App Developer Duration & Frequency 4 Month (16 weeks; with 3 training sessions of 1.5 hours a week)

Free Seminar on Feb 22, 2020 at 06:00 PM This extensive course is designed to provide good understanding of Android mobile app development using latest versions of Java SE, Android SDK, Android Studio and FireBase. Participants of the course will learn essentials of Java programming for Android, creating rich UI for Android app development, Storing and accessing data from internal or external storage of a mobile and to the cloud using RESTful services and usage of device resources such as camera & location sensor in Android apps. It also covers Publishing Android Mobile Apps to Google Play store. Brief Contents Introduction to Java & Android Mobile App Development Fundamentals of Java Programming using Java 8 Object Oriented Programming using Java Exceptions & Collections & Generics Installation & Configuration of Android SDK & Android Studio Android Mobile App Development Architecture & Application Life Cycle Android Views, Layouts, Activities, Fragments, List View & View Pages Activities, Intents, Services, Content Providers & Broadcast Receivers Android Resources, Styles, Themes & Material Design Integrating Social Media in Mobile Apps for Android Dialogs, Toasts, Menus, Context Menus, Popup Menus & Web View Store/Retrieve Data in/from Shared Preference & Files (Internal & SD Card) Store/Retrieve Data in/from SQLite Database & Content Providers Using FireBase for storing and retrieving data from cloud Using FireBase to authenticate users in your Mobile App Sending/Receiving Data to/from RESTful services using JSON & XML Working with Android Alerts, Notifications, Status Bar & System Bar Explore Android APIs for Locations, Maps, Media, Camera & Connectivity Testing & Debugging Android Apps on AVD & Actual Android Devices Deploying Android Application to Google Play store Application Analytics & Application Search Optimization (ASO) Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for student’s evaluation Audience Students of software engineering, computer science & IT Programmers, Software Developer, Web Developers Software Analysts, Software Designers and Software Architects Any other person willing to learn Android application development Course Project Participants of the course have to develop a business application for Android. Preferably the application should have multipage user interface and store data to a SQLite database or connect with a RESTful service on the internet to send and receive data. Certificate EVS Certified Android App Developer Duration & Frequency 4 Month (16 weeks; with 3 training sessions of 1.5 hours a week) Date Feb 23rd

Free Seminar on Feb 07, 2020 at 07:30 PM In this project based course you will learn to develop interactive and responsive websites and front-end web development of a enterprise application. It includes HTML5 and CSS3 for creating beautiful web pages; JavaScript & jQuery for more interactive and rich Web UI; BootStrap for developing responsive and elegant websites; AJAX & JSON for consuming REST Services. The course also covers essentials of Angular for front-end web development. Brief Contents Introduction Web Development, HTML, HTML5 & IDEs Basics of HTML & CSS and HTML Headings, Paragraphs & Images HTML Text Formatting, Links, Entities and Inline vs Block Level Elements HTML Lists: Unordered List, Ordered List and Description List iframe to Display Web-Pages from other Websites on your Website Detailed Overview of HTML5 and HTML5 Semantic Elements Using Audios and Videos on Websites using HTML5 Elements Creating Forms to Collect Data from Users using HTML5 & CSS3 Creating and Using CSS Styles: Inline CSS, Internal CSS & External CSS Using CSS3 Styles with div, p, span etc. for Creating Beautiful Web Pages CSS3 Box-Model: Padding, Margin, Outline, Border, Background CSS3 Floating, Positioning, Overflow, Image-Opacity and Image-Sprites CSS3 Media Queries in Detail & Creating fully Responsive Web Pages Introduction to BootStrap 4 and BootStrap 4 Grid System in Detail BootStrap 4 Typography, Tables, Images, Thumbnails and Buttons BootStrap 4 for Creating Elegant Forms for Collecting User Data BootStrap 4 Jumbotron, Tooltips, Popovers, Alerts, Spinners & Badges BootStrap 4: Navs, Navbars, Menus, Tabs, Dropdown and Collapse BootStrap 4 Pagination, Modals, Cards, Image Carousel and Scrollspy JavaScript Statements, Expressions, Conditions and Loops JavaScript Objects, Functions, Arrays and Events Working with Numbers, Strings, and Dates in JavaScript Testing and Debug a JavaScript Applications Create object-oriented JavaScript applications Using Regular Expressions, Handling Exceptions and Validating Data Events, Images, and Timers, Closures, Callbacks and Recursion JavaScript Object Notation (JSON) in JavaScript Applications Selecting and Manipulating DOM Elements with jQuery Using jQuery for Event Handling, Basic Animations and Effects jQuery AJAX Calls ( load(), get(), post(), ajax(), getJSON(), getScript() ) Handling Responses of AJAX Call in Plain Text, HTML and JSON format Consuming REST Services / REST API using AJAX and JSON Essentials of Angular for Creating Modern Web Applications Testing, Debugging & Publishing Website to a Commercial Server Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies &industry practices Projects, assignments & quizzes for student’s evaluation Audience Students & Graduates of Computer Science & Information Technology Students & Graduates of any other discipline looking for future in IT Web Designers interested in learning Website Development Any other person willing to learn Website Development Course Project Participants of the course should develop a commercial level website using HTML5, CSS3, JavaScript, jQuery and BootStrap 4. Course instructor and lab trainers will help you in completing this project. Certificate EVS Certified Front-End Web Developer MCP : Programming in HTML5 with JavaScript &CSS3 Duration & Frequency 3 Month (12 weeks; with 3 training sessions of 1.5 hours a week)

Log (n) Academy welcomes you to get involve and foster your learning abilities. Beyond all geographical barriers, Log(n) Academy gives you platform where you can indulge yourself in exploring mobile application flavor at any time on your own pace. Step forward and embrace this online training opportunity. Training Course: Android Application Development Course Material: Presentations Duration: 2 to 3 months Mode of Training: Online Offline(on request and availability) About Instructors: Our all instructors are CERTIFIED. We also offer training in Mobile Application Development, Java Frameworks, Java, Linux Certifications and Web Service. For further details visit our website www.lognacademy.com. You may choose to take a free demo before enrolling yourself with Log(n) Academy. For further details please email us at info At lognacademy.com. You will get the reply within 2 business days. Contact Details: Skypeid: lognacademy Website: www.lognacademy.com Email address: info@lognacademy.com Mobile Number: 0336-1239784

Oracle University – Authorized Training Center would like to inform you that the Comprehensive Training and Certification Program on Oracle 11g Database is scheduled to commence from Monday, May 04, 2015. The professionals and students are invited to join the six months training program on first come first register basis. Oracle Database 11g: Training & Certification (Six Months Comprehensive Program): • Oracle Database 11g: SQL Fundamentals I (1Z0-051) • Oracle Database 11g: Program with PL/SQL (1Z0-144) • Oracle Forms: Build Internet Applications (1Z0-141) • Oracle Database 11g: Administration I (1Z0-052) • Oracle Database 11g: Administration II (1Z0-053) Fee For Both Tracks Oracle 11g Developer’s & DBA Duration: Six months (3 alternate days a week) Days: Mon., Wed., Fri. Evening Hours: 6:30.p.m. To 8:30p.m. Class Commencement : Monday, May 04, 2015 Lead Trainer : Senior Oracle Certified Trainer for SAGE region. Benefits of the Program : The participants will get Original Courseware, Exam Dumps for Online Exams, Exam Prep. Material for Certifications, and Hands On Course Who Can Attend This Training: 1. Graduates and Students of BS (Computer Science/Software Engineering), BCS, B-Com/M-Com. 2. Database Professionals 3. Fresh-graduates seeking career in Oracle Database Technologies 4. Executives of Finance Department Private and/or Public Sector Please feel free to contact OU for timely registration and details. Best regards Technology Education Academy Suite D-4, Fourth Floor, Osif Centre, Block 13-A, Gulshan-e-Iqbal, University Road, Karachi-75300 Email: info@aazam.edu.pk 0321-8202003 Technology Education Academy is the official Training, HR Development, and Testing Partner to the leading I.T. vendors of the world: 1. Authorized Prometric Test Center (APTC) 2. Microsoft I.T. Academy - Program Member (Advanced Level) 3. Cisco Networking Academy 4. Sun Microsystem (MySQL, Sun Solaris, JAVA) 5. Oracle University 6. Linux Professional Institute (LPI) - Exclusive and Comprehensive Training and Testing Partner in Pakistan 7. Red Hat Linux: Academic, Training and Testing Partner 8. Novell Suse Linux: Academic Training and Testing Partner