Null

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

DESCRIPTION This is a luxury heavy weight metal pen from Iran and the pen is touched with roza of hazrat imam Hussain A.S If someone would like to buy it for barkat he could buy Null, Lahroe, Lahore, Punjab, Pakistan