Seminar certified android

Certified Android App Developer Omni Certified Android App Developer (OCAAD) course introduces mobile application development using Android platform. Android is a software stack for mobile devices that includes an operating system, middleware and key applications. This course is valuable for programmers and software engineers who are interested in learning to develop mobile application Difficulty Level: beginner Applicable Job Roles: Web programmers, and Desktop application developers, Mobile developer. Students will learn skills for creating and deploying Android applications, with particular emphasis on software engineering topics including software architecture, software process, usability, and deployment. Mobile application development is a skill that pays at a premium rate and has created over 466,000 jobs, but luckily for you there is an educational gap between the demand for these jobs and available developers’ skills. ANDROID History Android is a mobile operating system (OS) currently developed by Google, based on the Linux kernel and designed primarily for touchscreen mobile devices such as smartphones and tablets. Android's user interface is mainly based on direct manipulation, using touch gestures that loosely correspond to real-world actions, such as swiping, tapping and pinching, to manipulate on-screen objects, along with a virtual keyboard for text input. In addition to touchscreen devices, Google has further developed Android TV for televisions, Android Auto for cars, and Android Wear for wrist watches, each with a specialized user interface. Variants of Android are also used on notebooks, game consoles, digital cameras, and other electronics. Android has the largest installed base of all operating systems of any kind. Android has been the bestselling OS on tablets since 2013, and on smartphones it is dominant by any metric. Initially developed by Android, Inc., which Google bought in 2005. Course Outline 1: Introduction to App Inventor 2: Installing App Inventor 3: Understanding the User Interface 4: Building Your First App 5: Getting Your Phone Ready for Development 6: Getting Your App to the Market 7: Working with the Basic Components 8: Working with Advanced Components 9: Spice up Your Apps 10: How to Do Everything Else 11: Building your second App Course Benefits • Omni Certified Android Developer • Live Projects • Covers Android Technology • Practical Training • Build you Mobile Apps • Learn From Experience Developer • International freelance Job Market • Eart upt 15$/hours@Odesk, GetJobs Course Duration: 2 Months Approx. Regular & Evening Classes • Morning Classes 10:00AM - 12:00PM (MON-TUE) • Evening Classes 06:00PM - 08:00PM (THU-SAT) • Fast Track Course Available for Working Professionals / People travelling abroad. For Details Contact us: 0312.2169 325, 03377222191 PTCL: 34986664| E: info@omni-academy.com I www.omni-academy.com

Certified Android Developer Course Duration : 2 Months Approx Regular & Evening Classes • Morning Classes 10:00AM - 12:00PM (MON-TUE) • Evening Classes 06:00PM - 08:00PM (THU-SAT) • Fast Track Course Available for Working Professionals / People travelling abroad. ANDROID Online Course ADDRESS : A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite : Continental Bakers/ Faysal Bank Call : 0337.7222 191, 0312.2169 325 PTCL: 3498-OMNI (6664) eMail: info@omni-academy.comWeb : www.omni-academy.com OUR PARTNERS:

Android Apps. Developer – Omni Academy Digital Marketing - Mobile App I Certified Android Developer Program is specially designed keeping Digital Marketing needs and modern business needs upfront, join Omni Academy Android Certified Developer program, specially designed to learn android mobile app development step-by-step a best Android training in Karachi for young professionals willing to build career in Mobile App development market. Omni Certified Android App Developer (OCAAD) course introduces mobile application development using Android platform. Android is a software stack for mobile devices that includes an operating system, middleware and key applications. This course is valuable for programmers and software engineers who are interested in learning to develop mobile application Difficulty Level: beginner Applicable Job Roles: Web programmers, and Desktop application developers, Mobile developer. Students will learn skills for creating and deploying Android applications, with particular emphasis on software engineering topics including software architecture, software process, usability, and deployment. Mobile application development is a skill that pays at a premium rate and has created over 466,000 jobs, but luckily for you there is an educational gap between the demand for these jobs and available developers’ skills. ANDROID Development History Android is a mobile operating system (OS) currently developed by Google, based on the Linux kernel and designed primarily for touchscreen mobile devices such as smartphones and tablets. Android's user interface is mainly based on direct manipulation, using touch gestures that loosely correspond to real-world actions, such as swiping, tapping and pinching, to manipulate on-screen objects, along with a virtual keyboard for text input. In addition to touchscreen devices, Google has further developed Android TV for televisions, Android Auto for cars, and Android Wear for wrist watches, each with a specialized user interface. Variants of Android are also used on notebooks, game consoles, digital cameras, and other electronics. Android has the largest installed base of all operating systems of any kind. Android has been the bestselling OS on tablets since 2013, and on smartphones it is dominant by any metric. Initially developed by Android, Inc., which Google bought in 2005. Android Course Outline 1: Introduction to App Inventor 2: Installing App Inventor 3: Understanding the User Interface 4: Building Your First App 5: Getting Your Phone Ready for Development 6: Getting Your App to the Market 7: Working with the Basic Components 8: Working with Advanced Components 9: Spice up Your Apps 10: How to Do Everything Else 11: Building your second App Android Course Benefits • Omni Certified Android Developer • Live Projects • Covers Android Technology • Practical Training • Build you Mobile Apps • Learn From Experience Developer • International freelance Job Market • Eart upt 15$/hours@Odesk, GetJobs Course Duration: 2 Months Approx Regular & Evening Classes • Morning Classes 10:00AM - 12:00PM (MON-TUE) • Evening Classes 06:00PM - 08:00PM (THU-SAT) • Fast Track Course Available for Working Professionals / People travelling abroad. More Digital Marketing Programs Digital Marketing Certified Digital Marketing Pro. Advanced SEO ANDROID Online Course For Details Contact us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: info@omni-academy.com I www.omni-academy.com

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

Certified Linux Professional Develop a good working knowledge of Linux using both the graphical interface and command line interface, Linux powers 94% of the world’s supercomputers, most of the servers powering the Internet, the majority of financial trades worldwide and a billion Android devices. In short, Linux is everywhere. This course explores the various area commonly used by Linux system professionals and end users to achieve their day-to-day work in a Linux environment. It is designed for experienced computer users who have limited or no previous exposure to Linux. SDC CERTIFIED LINUX PROFESSIONALS - 30 CREDIT HOURS Linux Course Key Contents Linux? Why? Linux Installation Linux Session Using Files and Directories Editing Text BASH Environment Who is the Boss Processes Job Control Pipes and Filters File Management Tools File system Access Working in a Network Environment X Window System Case Study / Project Note: Weekdays | Evening | Sat | Sun classes, collect you admission kit for complete details about program. * Upon completion Skill Development Council (Govt. of Pakistan) recognized training Certificate would be awarded to successful students. * Installment Fee Payment Options for deserving students For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: info@omni-academy.com

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 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 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 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 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 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).