Wheeled base 2 sets

TekSlate’s syndicate of online trainers are experienced experts in knowledge transfer. The best place for learning, if you are aiming to learn the crux of any technology Base SAS Online Training Course Content: 1. SAS Introduction 2. Accessing Data 3. Creating Data Sets 4. Managing Data 5. Generating Reports 6. Handling Errors 7. Accessing Data Using SQL 8. Macro Processing 9. Advanced Programming Techniques

Catalog Name: *Stylish Attractive Alloy Women's Jewellery Sets* Base Metal: Alloy Plating: Silver Plated Sizing: Adjustable Multipack: 1 Type: Necklace and Earrings Dispatch: 2 - 3 Days Designs: 5 Easy Returns Available In Case Of Any Issue

BASE SAS MODULES Day 1: Introduction to the SAS System Components of Base SAS Software Output Produced by the SAS System Ways to Run SAS Programs Running Programs in the SAS Windowing Environment Introduction to DATA Step Processing The SAS Data Set introduction How the DATA Step Works: A Basic Introduction Supplying Information to Create a SAS Data Set Introduction to Raw Data Examine the Structure of the Raw Data: Factors to Consider Reading Unaligned Data Reading Data That Is Aligned in Columns Reading Data That Requires Special Instructions Reading Unaligned Data with More Flexibility Mixing Styles of Input Day 2: Introduction to Beyond the Basics with Raw Data Using INFILE statement and various options. Testing a Condition before Creating an Observation Creating Multiple Observations from a Single Record Reading Multiple Records to Create a Single Observation Problem Solving: When an Input Record Unexpectedly Does Not have enough values Day 3: Introduction to Starting with SAS Data Sets Understanding the Basics Input SAS Data Set for Examples Reading Selected Observations Reading Selected Variables Creating More Than One Data Set in a Single DATA Step Using the DROP=, KEEP= and WHERE= Data Set Options for Efficiency Introduction to DATA Step Processing Input SAS Data Set for Examples Adding Information to a SAS Data Set Defining Enough Storage Space for Variables Conditionally Deleting an Observation Day 4: Introduction to Working with Numeric Variables About Numeric Variables in SAS Input SAS Data Set for Examples Calculating with Numeric Variables Comparing Numeric Variables Storing Numeric Variables Efficiently Numeric Functions. Day 5: Introduction to Working with Character Variables Input SAS Data Set for Examples Identifying Character Variables and Expressing Character Values Handling Missing Values Creating New Character Values Saving Storage Space by Treating Numbers as Characters Character Functions Day 6: Introduction to Acting on Selected Observations Input SAS Data Set for Examples Selecting Observations Constructing Conditions Comparing Characters Introduction to Creating Subsets of Observations Input SAS Data Set for Examples Selecting Observations for a New SAS Data Set Conditionally Writing Observations to One or More SAS Data Sets Day 7: Introduction to Working with Grouped or Sorted Observations Input SAS Data Set for Examples Working with Grouped Data Working with Sorted Data Introduction to Using More Than One Observation in a Calculation Input File and SAS Data Set for Examples Accumulating a Total for an Entire Data Set Obtaining a Total for Each BY Group Writing to Separate Data Sets Using a Value in a Later Observation Day 8: Introduction to Using More Than One Observation in a Calculation Input File and SAS Data Set for Examples Accumulating a Total for an Entire Data Set Obtaining a Total for Each BY Group Writing to Separate Data Sets Using a Value in a Later Observation Introduction to Working with Dates Understanding How SAS Handles Dates Input File and SAS Data Set for Examples Entering Dates Displaying Dates Using Dates in Calculations Using SAS Date Functions Comparing Durations and SAS Date Values Day 9: Introduction to Combining SAS Data Sets Definition of Concatenating Definition of Interleaving Definition of Merging Definition of Updating Definition of Modifying 237 Comparing Modifying, Merging, and Updating Data Sets Day 10: Introduction to Concatenating SAS Data Sets Concatenating Data Sets with the SET Statement Concatenating Data Sets Using the APPEND Procedure Choosing between the SET Statement and the APPEND Procedure. Introduction to Interleaving SAS Data Sets Understanding BY-Group Processing Concepts Interleaving Data Sets Day 11: Introduction to Merging SAS Data Sets Understanding the MERGE Statement One-to-One Merging Match-Merging Choosing between One-to-One Merging and Match-Merging Introduction to Updating SAS Data Sets Understanding the UPDATE Statement Understanding How to Select BY Variables Updating a Data Set Updating with Incremental Values Understanding the Differences between Updating and Merging Handling Missing Values Day 12: Input SAS Data Set for Examples Modifying a SAS Data Set: The Simplest Case Modifying a Master Data Set with Observations from a Transaction Data Set Understanding How Duplicate BY Variables Affect File Update Handling Missing Values Introduction to Conditional Processing from Multiple SAS Data Sets Input SAS Data Sets for Examples Determining Which Data Set Contributed the Observation Combining Selected Observations from Multiple Data Sets Performing a Calculation Based on the Last Observation Day 13: Introduction to Analysing Your SAS Session with the SAS Log Understanding the SAS Log Locating the SAS Log Understanding the Log Structure Writing to the SAS Log Suppressing Information to the SAS Log Changing the Log’s Appearance Introduction to Directing SAS Output and the SAS Log Input File and SAS Data Set for Examples Routing the Output and the SAS Log with PROC PRINTTO Storing the Output and the SAS Log in the SAS Windowing Environment Redefining the Default Destination in a Batch or Non interactive Environment Introduction to Diagnosing and Avoiding Errors Understanding How the SAS Supervisor Checks a Job Understanding How SAS Processes Errors Distinguishing Types of Errors Diagnosing Errors Using a Quality Control Checklist Day 14: Introduction to Creating Detail and Summary Reports with the REPORT Procedure Understanding How to Construct a Report Input File and SAS Data Set for Examples Creating Simple Reports Creating More Sophisticated Reports Day 15: Introduction to Proc means Deriving descriptive statistics Introduction to Proc univariate and various options Day 16: Introduction to Proc freq Calculating counts using Freq Outputting the counts into a dataset Proc Transpose introduction Using VAR, ID and BY statement efficiently in transpose Reshaping the data with required variables Day 17: Introduction to Producing Charts to Summarize Variables Understanding the Charting Tools Input File and SAS Data Set for Examples Charting Frequencies with the CHART Procedure Customizing Frequency Charts Creating High-Resolution Histograms Day 18: Introduction to Writing Lines to the SAS Log or to an Output File Understanding the PUT Statement Writing Output without Creating a Data Set Writing Simple Text Introduction to the Basics of Understanding and Customizing SAS Output Understanding Output Input SAS Data Set for Examples Locating Procedure Output Making Output Informative Controlling Output Appearance Controlling the Appearance of Pages Representing Missing Values Day 19: Introduction to Customizing SAS Output by Using the Output Delivery System Input Data Set for Examples Understanding ODS Output Formats and Destinations Selecting an Output Format Creating Formatted Output Day 20: Proc Format introduction Creating format catalogue Converting catalogue to dataset Storing formats permanently and finding out formats in a library Accessing a Permanent SAS Data Set with User-Defined Formats ADVANCED SAS MODULES Day 21: Getting Started with the Macro Facility Replacing Text Strings Using Macro Variables Generating SAS Code Using Macros More Advanced Macro Techniques Other Features of the Macro Language Introduction to SAS Programs and Macro Processing How SAS Processes Statements without Macro Activity How SAS Processes Statements with Macro Activity Introduction to Macro Variables Macro Variables Defined by SAS Macro Variables Defined by Users Using Macro Variables Displaying Macro Variable Values Referencing Macro Variables Indirectly Manipulating Macro Variable Values with Macro Functions Introduction to Macro Processing Defining and Calling Macros How the Macro Processor Compiles a Macro Definition How the Macro Processor Executes a Compiled Macro Summary of Macro Processing Day 22: Introduction to the Scopes of Macro Variables Global Macro Variables Local Macro Variables Writing the Contents of Symbol Tables to the SAS Log How Macro Variables Are Assigned and Resolved Introduction to Macro Expressions Defining Arithmetic and Logical Expressions How the Macro Processor Evaluates Arithmetic Expressions Day 23: Introduction to Macro Quoting Deciding When to Use a Macro Quoting Function and Which Function to Use Using Various Macro Functions %STR and %NRSTR Functions etc Using the %BQUOTE and %NRBQUOTE Functions Referring to Already Quoted Variables Deciding How Much Text to Mask with a Macro Quoting Function Using %SUPERQ Summary of Macro Quoting Functions and the Characters They Mask Unquoting Text How Macro Quoting Works Other Functions That Perform Macro Quoting Day 24: Introduction to Storing and Reusing Macros Saving Macros in an Auto call Library Saving Macros Using the Stored Compiled Macro Facility General Macro Debugging Information Troubleshooting Your Macros Debugging Techniques Introduction to Writing Efficient and Portable Macros Keeping Efficiency in Perspective Writing Efficient Macros Writing Portable Macros PROJECT CONTENT COVERED Day Creation of Efficacy tables. Creation of Standard and safety tables. Day 28 Creation of listings Day Creation of Graphs a)Bar Charts b)Scatter plot c)Line plot d)Box plot Day 31 Creation of Analysis datasets/derived datasets Day 32 Introduction to SDTM CRF Annotation (ONLY BASICS) Introduction to mapping specification (ONLY BASICS) Introduction to SDTM dataset Creation (ONLY BASICS) Validation in Open CDISC (ONLY BASICS) Day 33 Introduction to ADAM Standards (ONLY BASICS) Mock interview and providing assistance for interview preparation Contact:

BASE SAS MODULES Day 1: Introduction to the SAS System Components of Base SAS Software Output Produced by the SAS System Ways to Run SAS Programs Running Programs in the SAS Windowing Environment Introduction to DATA Step Processing The SAS Data Set introduction How the DATA Step Works: A Basic Introduction Supplying Information to Create a SAS Data Set Introduction to Raw Data Examine the Structure of the Raw Data: Factors to Consider Reading Unaligned Data Reading Data That Is Aligned in Columns Reading Data That Requires Special Instructions Reading Unaligned Data with More Flexibility Mixing Styles of Input Day 2: Introduction to Beyond the Basics with Raw Data Using INFILE statement and various options. Testing a Condition before Creating an Observation Creating Multiple Observations from a Single Record Reading Multiple Records to Create a Single Observation Problem Solving: When an Input Record Unexpectedly Does Not have enough values Day 3: Introduction to Starting with SAS Data Sets Understanding the Basics Input SAS Data Set for Examples Reading Selected Observations Reading Selected Variables Creating More Than One Data Set in a Single DATA Step Using the DROP=, KEEP= and WHERE= Data Set Options for Efficiency Introduction to DATA Step Processing Input SAS Data Set for Examples Adding Information to a SAS Data Set Defining Enough Storage Space for Variables Conditionally Deleting an Observation Day 4: Introduction to Working with Numeric Variables About Numeric Variables in SAS Input SAS Data Set for Examples Calculating with Numeric Variables Comparing Numeric Variables Storing Numeric Variables Efficiently Numeric Functions. Day 5: Introduction to Working with Character Variables Input SAS Data Set for Examples Identifying Character Variables and Expressing Character Values Handling Missing Values Creating New Character Values Saving Storage Space by Treating Numbers as Characters Character Functions Day 6: Introduction to Acting on Selected Observations Input SAS Data Set for Examples Selecting Observations Constructing Conditions Comparing Characters Introduction to Creating Subsets of Observations Input SAS Data Set for Examples Selecting Observations for a New SAS Data Set Conditionally Writing Observations to One or More SAS Data Sets Day 7: Introduction to Working with Grouped or Sorted Observations Input SAS Data Set for Examples Working with Grouped Data Working with Sorted Data Introduction to Using More Than One Observation in a Calculation Input File and SAS Data Set for Examples Accumulating a Total for an Entire Data Set Obtaining a Total for Each BY Group Writing to Separate Data Sets Using a Value in a Later Observation Day 8: Introduction to Using More Than One Observation in a Calculation Input File and SAS Data Set for Examples Accumulating a Total for an Entire Data Set Obtaining a Total for Each BY Group Writing to Separate Data Sets Using a Value in a Later Observation Introduction to Working with Dates Understanding How SAS Handles Dates Input File and SAS Data Set for Examples Entering Dates Displaying Dates Using Dates in Calculations Using SAS Date Functions Comparing Durations and SAS Date Values Day 9: Introduction to Combining SAS Data Sets Definition of Concatenating Definition of Interleaving Definition of Merging Definition of Updating Definition of Modifying 237 Comparing Modifying, Merging, and Updating Data Sets Day 10: Introduction to Concatenating SAS Data Sets Concatenating Data Sets with the SET Statement Concatenating Data Sets Using the APPEND Procedure Choosing between the SET Statement and the APPEND Procedure. Introduction to Interleaving SAS Data Sets Understanding BY-Group Processing Concepts Interleaving Data Sets Day 11: Introduction to Merging SAS Data Sets Understanding the MERGE Statement One-to-One Merging Match-Merging Choosing between One-to-One Merging and Match-Merging Introduction to Updating SAS Data Sets Understanding the UPDATE Statement Understanding How to Sel

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email at Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Clinical SAS Online Training || 91- Hi Guys, Do you want Clinical SAS Online Training? Here is the right place. We will provide the best online trainings in the training Industry on clinical SAS by expert SAS certified and real time experienced trainers with live data and live examples. List of SAS Clinical Courses: 1.Base SAS 2.Advanced SAS 3.Clinical Domain Knowledge 4.Real Time Scenarios 5.CDISC(SDTM & ADaM) 6.Creating Tables, Listings & Graphs(TLGs or TLFs) 7.Roles and Responsibilities of SAS Programmer at different levels 8.How to Validate Data sets & Reports 9.How to Create ADaM Specification 10.Real time Project Work We also offers/provides: Introduction to Clinical trials ISS/ISE tables 21CFR PART II/ICH guidelines  CRF review  Validations and Edit Checks  Info about e-submissions  Knowledge on documentation part in clinical industry.  Assistance for Base SAS and Advance SAS Certification  Clinical Projects with the real data  Assistance to join in the US consultancies for students  Resume preparation  Conduct mock interviews  On job support Special qualities in our training: Experts in Clinical Domain & SAS Certified Programmer Joining the class on time Share the screen Every day 1 hr -1:15 min class (Moday to Friday US timings) Providing the best material Explaining the topics with best examples Showing the real data Showing the real documents Proper guidance about the Clinical Industry real time work Please see my LinkedIn profile for more information: 91- if you any queries or questions. Regards, Ram SaiArundathi online trainings SAS-Clinical Online Classes Ph: 91-

Ram Clinical SAS Online/Corporate Trainer Ph: 91- Hi Guys, Do you want Clinical SAS Online Training? Here is the right place. We will provide the best online trainings in the training Industry on clinical SAS by expert SAS certified and real time experienced trainers with live data and live examples. List of SAS Clinical Courses: 1.Base SAS 2.Advanced SAS 3.Clinical Domain Knowledge 4.Real Time Scenarios 5.CDISC(SDTM & ADaM) 6.Creating Tables, Listings & Graphs(TLGs or TLFs) 7.Roles and Responsibilities of SAS Programmer at different levels 8.How to Validate Data sets & Reports 9.How to Create ADaM Specification 10.Real time Project Work We also offers/provides: Introduction to Clinical trials ISS/ISE tables 21CFR PART II/ICH guidelines  CRF review  Validations and Edit Checks  Info about e-submissions  Knowledge on documentation part in clinical industry.  Assistance for Base SAS and Advance SAS Certification  Clinical Projects with the real data  Assistance to join in the US consultancies for students  Resume preparation  Conduct mock interviews  On job support Special qualities in our training: Experts in Clinical Domain & SAS Certified Programmer Joining the class on time Share the screen Every day 1 hr -1:15 min class (Moday to Friday US timings) Providing the best material Explaining the topics with best examples Showing the real data Showing the real documents Proper guidance about the Clinical Industry real time work Please 91- if you any queries or questions. Regards, Ram SaiArundathi online trainings SAS-Clinical Online Classes Ph: 91-

CMC-TCS invites Summer Internship & Industrial Training for BE, B.Tech, MCA students in Delhi. Now CMC the real IT giant offers Limited seats for Industrial Project Training & Internship in Delhi. The live Project Training module of our course can make a huge difference to your profile and career prospects. So don’t settle for the second-best. Choose WINNERS i.e. CMC-TCS SUBSIDIARY, The Last Semester Project Training & Summer Training for Btech, MCA & others can be done at CMC. Training at CMC brings you directly in touch with industry experts & sets the right base for leading vendor certification. Our alliance with leading IT corporations such as MICROSOFT, RED HAT, JAVA & ORACLE provides us with valuable input for IT education. Eligibility - MCA / B. Tech./B. C. A /B. E /MSC (IT & CS) /BSC (IT)/Diploma. Period of Training: – 6 weeks, 45 Days, 60 Days, 90 Days and 120 Days, 6 months. Project Training will include: Learning, Training, Case study, Presentations, Problem solving and Live Project Scenario. The Industrial training is offered live in 1.Networks & Networking 2.Dot Net & Microsoft Technologies (ASP, ASPX, VB, C#, etc) 3.Java/J2EE (Advance Java) 4.Linux & Red Hat (RHCE, RHEL) 5.MCITP/ MCSE 6.CCNA, Network Technological Devices/ CCNP 7.ANDROID 8.PHP 9.Embedded Systems & Design 10.Plc scada On successful completion of Project Training, TATA ENTERPRISE will issue Certificate of Completion. The candidates who are eligible and selected for Project Training would be undergoing this training in E&T CENTER OF CMC-A TCS SUBSIDIARY in Delhi/NOIDA/FARIDABAD. SEATS WOULD HAVE TO BE BOOKED NOW For 45 Days, 8 weeks, 2 months, 6 months and 6 Weeks Project training for Btech, MCA, BCA, BSc IT, M.Sc IT, Polytechnic, etc Regards

Industrial training @HCL-CDC NOIDA- - Noida HCL 6 weeks & 6 months Industrial Summer Internship Training in Delhi Now HCL the real Software giant offers Limited seats for project & summer Industrial training in New Delhi. The live project training module of our course can make a huge difference to your profile and career prospects. So don't settle for the second-best. Choose WINNERS ie HCL The Last Semester Project Training for Btech, MCA & others can be done at HCL. Training at HCL brings you directly intouch with industry experts & sets the right base for leading vendor certification. Our alliance with leading IT corporations such as MICROSOFT, RED HAT, JAVA & ORACLE provides us with valuable input for IT education Eligibility - MCA / B. Tech./B.C.A /B.E /MSC (IT & CS). Period of Training:- 6 weeks, 45 Days, 60 Days, 90 Days and 120 Days, 6 months. Project Training will include: Learning, Training, Case study, Presentations, Problem solving and Live Project Scenario. Area of Project Training could beThe Industrial training is offered live in 1. Networks & Networking 2. Dot Net & Microsoft Technologies (ASP, ASPX, VB etc) 3. Java 4. Oracle 5. Linux & Red Hat 6. MCSE 7. CCNA 8. MCITP On successful completion of Project Training, HCL will issue Certificate of Completion The candidates who are eligible and selected for Project Training would be undergoing this training in HCL Career Development Centre, South Extension, NEW DELHI LIMITED SEATS For 45 Days, 8 weeks, 2 months, 6 months and 6 Weeks Project training for Btech, MCA, BCA, BSc IT, MSc IT, Polytechnic, etc Contact shalini: C-124A,Sector-2,Noida

HCL invites Applications for 6 weeks to 6 months Internship & Industrial Training for BE, B.Tech, MCA students in Noida. Now HCL the real IT giant offers Limited seats for Industrial Project Training & Internship. The live Project Training module of our course can make a huge difference to your profile and career prospects. So don’t settle for the second-best. Choose WINNERS i.e. HCL. Training at HCL brings you directly in touch with industry experts & sets the right base for leading vendor certification. Our alliance with leading IT corporations such as MICROSOFT, RED HAT, JAVA & ORACLE provides us with valuable input for IT education. Area of Project Training could be The Industrial training is offered along with Project: 1. Networks & Networking 2. Dot Net & Microsoft Technologies (ASP, ASPX,C#,VB etc) 3. Java(Core & Advance(J2EE)) 4. PHP 5. Android 6. CCNA 7. MCITP 8. Embedded Systems & Technologies Industrial Internship Program with Live Project: HCL imparts qualitative Internship in App Development,.NET, ASP.NET, PHP, PHP++, JAVA, J2EE, WEB DEVELOPMENT and other latest technologies. The Internship is designed for the Candidates who want to speed up their technical skills and proficiencies into real time development environment. Project Implementation Process •Step 1: Typically Candidates undergo training on particular technology platforms of their choice. •Step 2: Thereafter they would be assigned a Team Leader and he/she is expected to execute a live project work under the guidance of a Project manager/analyst. •Step 3: At the end of the program each trainee would need to submit a ‘Project Report’ of the work done. •Step 4: All the Candidates will be provided certificate after training after an evaluation. Eligibility – MCA / B. Tech./B. C. A /B. E /MSC (IT & CS). Period of Training: – 6 weeks to 6 months. sms INFO to 9212577709 for Details || Avail Discounts on Group Enrollments. For Registrations or any query contact us: Anju Contact: 9212577708

Summer Internship | Industrial Training | Project Based Training are going to start by KR Network Cloud. Eligibility for B.Tech/B.E, MCA, BCA, M.SC (IT & CS), B.SC (IT)/ Diploma students in Delhi. We are finding for full of energy Fresher who would like to get assignment which involves a lot of interpersonal skills to work as Summer Trainee Interns in Delhi. The Last Semester Project Training & Summer Training for B.Tech, MCA & others can be done at KR Network Cloud. Training at KR Network Cloud brings you directly be in touch with industry experts & sets the right base for leading vendor certification. Our organization with leading IT corporations such as RED HAT (RHCE), CISCO (CCNA & CCNP), ORACLE, JAVA, PHP provides us with valuable input for IT education. Period of Training: – 6 weeks, 45 Days, 60 Days, 90 Days and 120 Days, 6 months. Project Training will include: Learning, Training, and Case study, Presentations, Problem solving and Live Project Scenario. Training Duration Details 2 Weeks:6 days a week. 3 hours a day 4 Weeks:3 days a week. 4 hours a day 6 Weeks:2 days a week. 4 hours a day 4 to 6 months: exclusively for last semester students seeking project based industrial training. Contact us KR NETWORK CLOUD C-3/207, Second Floor, Kanishak Complex, Near Maharaja Banquet, V3S Mall, Nirman Vihar Metro Station, Delhi-110092

6 months and weeks training in cmc noida /delhi Dear Candidate, CMC Ltd. provides Industrial Training/ Internship for BTech/MCA Final year Students – The projected requirement for trained IT professionals is estimated at about 2.3 million. In alone the IT sector is estimated to have added jobs. CMC Ltd.(A TCS Subsidiary) provides Live Project Training designed to impart both theoretical and practical knowledge in the IT domain. The program empowers you with cutting edge skills in latest software and networking technologies, strong soft skills, appropriate Live project experience and places you ahead of the competition for the best jobs and a bright career. ñ.Net Technologies ñ Advance Java Programming / J2EE With AJAX ñ PHP and PHP+ ñ CCNA and CCNP ñ Android Applications ñ Embedded Systems ñ Oracle 10G ñ MCITP ñ RHCE ñ PLC/SCADA Location: Noida/ Delhi / Faridabad The candidates who are eligible and selected for Project Training would be undergoing this training in ATC CMC LTD Noida/Delhi/Faridabad (A TCS Subsidiary) under the guidance of Corporate Trainer. Industrial Training will include: Learning, Training, Case study, Presentations, Problem solving and Live Project Scenario. Training at CMC brings you directly intouch with industry experts & sets the right base for leading vendor certification. Duration of the training is of 4 ½ to 6 months. Projects are allotted on the technologies dealt with in the first module. One Live project is allotted to a group of 3-5 students. A certificate (Training Letter) is provided to all the participants at the end of the training. Limited seats available. Registration open on shortlisting basis. Eligibility: MCA/ MSC / B.Tech IT / CSE / ECE Final year For more information, contact at: Shalini (Sr. Training Coordinator) ATC CMC Ltd.

Basics about silk thread jewellery making *How to choose the base to make the silk thread beads and jewellery *How to make vibrant and grand aaram sets using silk thread *6 varieties of bangle *demo of 2 types of bangle *How to make silk thread anklets *Creative ideas to make silk thread beads, earrings and other accessories *Tips and tricks of the marketing strategy for your jewellery *How and where to purchase the materials for your jewellery Who should attend Anyone who has a passion in learning a new kind of jewellery and add feather to her cap of creativity.... Pre-requisites Only interest in learning jewellery is the Pre-requisite....Come and enjoy the joy of learning... What you need to bring All the materials needed for the workshop will be provided in the class itself... Key Takeaways *Basic and advanced knowledge in silk thread jewellery *Jewelleries done in the workshop *Marketing strategies to improve your business to next level *Knowledge about the purchase of the materials