Columns

If you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like(/,-,space, and user input). we have already discussed how to join texts in Excel in our tutorial. To access the Text to Column shortcut in Excel, use: ALT + A + E How to Convert Text to Column in Exce...

If you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like (/,-,space, and user input). we have already discussed how to join texts in Excel in our tutorial. To access the Text to Column shortcut in Excel, use: ALT + A + E

If you want to separate one cell content into separate columns in Excel, you can use the ‘Convert Text to Columns Wizard’. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like (/,-,space, […]

sadguru technologies 040-40154733​ 27. How many LTS (Logical Table Sources) can a logical table have? Whats the minimum and maximum? 28. How many server instances can coexist in an OBIEE cluster? 29. Whats a dimension only query in OBIEE? 30. Aggregation rules are set on top of …………… columns (Physical Columns or Logical Columns or Both) Lets get to questions that are little more complex in my opinion :) 31. What is alternative drill path? How do you set alternative drill path in OBIEE? 32. What are the pre-requisites for using aggregate persistence wizard? What does aggregate persistence wizard create and what does it help with? 33. Can you import data in multiple sheets from an Excel file? How do you import data from an Excel sheet? (Forget about csv files for now) 34. What are the uses of “Execute Direct SQL” feature in Answers? Is it a good practice to allow this feature for production users? 35. How do you disable “Execute Direct SQL” feature for all the users of your repository?

If you want to separate one cell content into separate columns in Excel, you can use the 'Convert Text to Columns Wizard'. This option is available in Data Tools in the Data tab. Text to Column is an amazing built-in tool in Excel. Using this you can separate texts into columns with characters like (/,-,space, and user input). we have already discussed how to join texts in Excel in our tutorial. To access the Text to Column shortcut in Excel, use: ALT + A + E https://www.basictutorials.in/how-to...

QA Testing Course Content: MANUAL TESTING SDLC 1. What are the different phases of SDLC? 2. How does the process of Software Development Start? 3. Project Initiation 4. Requirement Gathering and Analysis 5. What is Requirement document and what it contains? 6. What is use case document and what it contains? 7. What is Basic path and Alternate Path? 8. Role of Business Analyst 9. Example for explaining each phase 10. Role of technical specification team 11. What is Technical specification document? 12. What is System Design? 13. Role of Design team 14. What is design document? 15. Role of architecture team 16. System development 17. Role of development team 18. Deliverable of Development phase 19. System testing 20. Role of testers and types of testing 21. User acceptance testing 22. System deployment 23. System maintenance 24. Events in the maintenance phase like bug fixes 25. STLC 26. How are the phases of STLC carried out? 27. What is testing? 28. Role of testers 29. Why do we need to test? 30. Activities involved in the testing phase 31. What is test plan and test case document? 32. Steps of test case execution 33. What does test case document contain? 34. How to write test case document? 35. What is required to test any application? TEST CASES 1. What is test case? 2. What does test case document contain? 3. How to write test case document? 4. Different test case techniques TEST PLAN 1. What is Test Plan? 2. How to write test plan document? 3. What does the test plan document contain? 4. Who writes and approves the test plan document? 5. How manage the test case documents? 6. What is the pass/fail criterion? TYPES OF TESTING 1. Different Phases of testing 2. What is unit testing? 3. What is Minimum acceptance testing? 4. What is integration, system and system integration testing? 5. What is User acceptance testing? 6. What is Regression Testing? DEFECT ANALYSIS 1. What is a defect? 2. Various Defect tracking tools 3. How to use the defect tracking tools? 4. How to enter the details of defect in the defect tracking tool? 5. How to identify a defect? What is severity and priority? TRACEABILITY MATRIX 1. What is Traceability Matrix[TM]? 2. Who Prepares the TM document? 3. What is the reference for writing TM? 4. What is the use of TM? 5. What is present in the TM document? 6. Sample TM 7. Tools used for developing TM Various Teams and their Roles 1. Configuration Management Team 2. Role of configuration management team 3. What is Deployment? 4. Deployment Team 5. Role of Deployment team 6. Version Control 7. Various version tools and its usage 8. Difference between QC and QA 9. What is automation testing? 10. Why, what and when to automate? 11. Various tools used for automation testing MANAGEMENT TOOL QUALITY CENTER 1. Introduction to Quality Center 2. What is Quality Center ? 3. Why to use Quality Center 4. Version of Quality Center 5. Overview of quality Center user interface 6. Various tabs in Quality center 7. Requirement Module 8. Requirement Module Overview 9. Creating Requirement tree 10. Creating Parent & Child requirements 11. Understanding the Description tab 12. Understanding the History tab 13. Uploading attachments to requirement 14. A glance at various columns in requirement 15. Types of views in requirement module 16. Requirement grid view 17. Requirement coverage view 18. Test Plan Module 19. Creating folder structure 20. Create test cases 21. Requirement coverage 22. Test Lab Module 23. Overview of Test Lab 24. Detail of various tabs 25. Creating folders 26. Creating Test sets 27. Adding test cases 28. Different columns in Execution Grid 29. Execution Flow tab 30. Scheduling Test runs 31. Test Set Properties tab 32. Linked Defects tab 33. Running Tests manually 34. Running Tests automatically 35. Viewing Test results Quality Center Defects Overview of Defects 1. Creating defects after test execution 2. Adding defects in defect module 3. Creating defects during test execution 4. Linking Defects 5. How to close a defect 6. Closing defects after retest 7. Mailing the defects 8. Quality Center reports & graphs 9. Why Reports & Graphs? 10. How to create reports & graphs for Analysis? AUTOMATION TESTING: QUICK TEST PROFESSIONAL 1. Introduction to QTP 2. What is QTP 3. Prepare Before Automation 4. Application Under Test 5. First look at Add-Ins for QTP 6. Understanding the QTP User Interface Setting up preferences in QTP before recording. 1. Different versions of QTP(Text based) 2. Difference between QTP 9.0 and QTP 8.2. 3. Difference between QTP 9.2 and QTP 9.0 4. Difference between QTP 9.5 and QTP 9.2. • Record and run a script • Record a simple script • Save the script • Run the test script • Understand the result Introduction to Object Repository 1. What is Object Repository 2. Types of Object Repository 3. Object Repository Manager 4. Associating shared Object Repository with test 5. Shared Object Repository 6. Local Object Repository 7. Create a shared Object Repository 8. Add objects to shared Object Repository 9. Save an shared Object Repository 10. Modify the shared Object Repository 11. Comparing Local and Shared Object Repository Synchronization 1. What is Synchronization 2. Synchronization in QTP 3. Add Synchronization Steps for an Object Check Point 1. What is Check Point 2. Using Standard Check Point 3. Using Text Check Point 4. Using Access ability check point 5. Using XML Check Point Database checkpoint 1. What is database checkpoint 2. Writing SQL Query using Microsoft Query 3. Parameterize a database checkpoint 4. Output Values 5. What is Output value 6. Using Standard Output value 7. Using Text Output value 8. Using Database Output value 9. Using XML Output value Data Driven Test 1. What is Data Driven test 2. What is Parameterization http://trainingforu.blogspot.in/ Contact Person: Ashwini (M) 09620914455. Email: ashwini.hbst@gmail.com For More Details: Contact or Consult Our Office Once.

OBIEE Online Training Course Duration - 40hrs Sadguru Technologies-8179736190 Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measuresOBIEE Online Training Course Duration - 40hrs Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. BUILDING THE PHYSICAL LAYER OF A REPOSITORY Defining an ODBC System DSN Setting up connection pool properties Importing data sources ( Physical Schema ) Verifying the import Defining physical keys and joins Creating alias and select tables BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY Creating a new Presentation Catalog Modifying Presentation layer objects

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. BUILDING THE PHYSICAL LAYER OF A REPOSITORY Defining an ODBC System DSN Setting up connection pool properties Importing data sources ( Physical Schema ) Verifying the import Defining physical keys and joins Creating alias and select tables BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF A REPOSITORY Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY Creating a new Presentation Catalog Modifying Presentation layer objects Rename tables

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY Creating a new Presentation Catalog Modifying Presentation layer objects Rename tables

OBI ARCHITECTURE Clients OBI Presentation Services OBI Server OBI Repository (.rpd) Data Sources OBI COMPONENTS OBI Administration Tool OBI Answers Intelligence dashboards REPOSITORY BASICS Oracle Business Analysis Warehouse DAC and Informatica Server Informatica Server ETL Sample Request Processing Using the OracleBI Administration Tool Repository Directory Repository Files ( Initialization files and log files) Informatica Server ETLLoading a repository into Oracle BI Server memory Creating a repository Connection Pool Repository Modes ( ONLINE and OFFLINE ) Physical Layer Business Model & Mapping Layer Presentation Layer Presentation Catalogs, Folders and Columns Error Messages Note: All Training will be on BI Sample Schema. Creating the logical business model Creating the logical tables, columns, and sources Defining logical joins Adding Calculation to a Fact Table

We offer training on STAAD-Pro by realtime trainer. Course details Introduction Problem initiation, unit specification Material Specification Member Specification Listining members, joints etc., Load specification Analysis Specification Selection Specification Finite element information Mesh generation, member property Element load specification for joints Concrete design as per IS-456, Design of beams, columns etc. Design initiation, design commands, take off command Steel design as per IS-800 parameter specification Analysis of plane , truss, simple beam cantilever beam Analysis of plane frame, plane truss, multilevel plane frame etc. For details contact : Arun 9845382820 Location : Techsys,Basaveshwar nagar,near hotel pavitra paradise Bangalore - 79, India

ORACLE DATABASE ADMIN COURSE CONTENT Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in ORACLE DATABASE ADMIN COURSE CONTENT 1: Creating the Database 2: Starting Up and Shutting Down • Viewing the Quiesce State of an Instance • Suspending and Resuming a Database 3: Managing Oracle Database Processes • Terminating Sessions • Identifying Which Session to Terminate • Terminating an Active Session • Terminating an Inactive Session 4: Monitoring the Operation of Your Database • Server-Generated Alerts • Monitoring the Database Using Trace Files and the Alert Log • Monitoring Locks • Monitoring Wait Events • Process and Session Views 5: Oracle Database Structure and Storage • Managing Control Files • Managing the Redo Log • Managing Archived Redo Logs 6: Managing Table spaces Transportable Table spaces 7: Managing Data files and Temp files 8: Managing the Undo Table space undo retention, switching undo table space 9: User management creation of users and roles, assign privileges 10:Automatic Storage Management create ASM instance, create disk groups 11:Managing Schema Objects • Tables, indexes, views, synonyms and sequence generator • Space management • Managing resumable space allocation, reclaiming wasted space • Managing Tables • adding, renaming and dropping of table columns • Managing Indexes • B*tree, bitmap • Managing Partitioned Tables and Indexes • Range, hash,list and composit partitioning • Managing Clusters • creation and altering of clusters • Managing Views, Sequences, and Synonyms • Oracle Network • Listener and tnsnames • Distributed Database Concepts • Utilities • Data pump , SQL*Loader • Backup and Recovery • Rman • Performance Tuning • Data Guard • configuring physical standby database • Miscellaneous Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN Class Room Training, ORACLE DATABASE ADMIN Training in Magarpatta City, ORACLE DATABASE ADMIN Jobs and Placement, ORACLE DATABASE ADMIN Remote Support, ORACLE DATABASE ADMIN Online Help, ORACLE DATABASE ADMIN Videos training, ORACLE DATABASE ADMIN Training by Learning Hub, Fast track classes in ORACLE DATABASE ADMIN, Best ORACLE DATABASE ADMIN Training institutes in Pune, Best Faculty in ORACLE DATABASE ADMIN, Best online Faculty in ORACLE DATABASE ADMIN, Professional classroom training in ORACLE DATABASE ADMIN, Professional online training ORACLE DATABASE ADMIN, ORACLE DATABASE ADMIN Certification , ORACLE DATABASE ADMIN training in Dubai, ORACLE DATABASE ADMINTraining in Melbourne, ORACLE DATABASE ADMIN Training in Dubai, ORACLE DATABASE ADMIN Training, ORACLE DATABASE ADMIN Workflow Training ORACLE DATABASE ADMI Training, ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN certfication and support

JOB ORIENTED SHAREPOINT TRAINING INSTITUTE IN CHENNAI ADYAR Peridot systems proud to introduce the job oriented SharePoint training in Chennai adyar... For more syllabus details you need contact papitha (8056102481)...Our trainers having well experienced in IT Industry... Website: www.peridotsystems.in PERIDOT:  Complete practical training  2 days demo classes  Training Duration : 45 days  Online training classes  Excellent Environment SharePoint Course SYLLABUS: • Creating/updating/propagating • Content types • Creating/updating/propagating • Using Lookups and Calculated Columns For More Syllabus Details contact us, Contact Numbers: 8056102481/9600063484 , 044-42115526 Mail id: Papitha.v@peridotsystems.in Name: papitha TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

SHAREPOINT TRAINING INSTITUTE IN CHENNAI ADYAR “PERIDOT SYSTEMS” 8056102481... Peridot systems is the best software training institute in Chennai adyar with guaranteed placement...For more information about the course details you need contact papitha(8056102481)... Our main goal is to satisfy the student’s needs and expectations... “PERIDOT SYSTEMS PROVIDING REAL TIME TRAINING” Website: www.peridotsystems.in PERIDOT:  We provide complete practical training  We provide 45 days training classes  We offer 2 days free demo classes  We provide complete placement guidance SharePoint Course SYLLABUS: • Creating/updating/propagating • Content types • Creating/updating/propagating • Using Lookups and Calculated Columns • Enforcing Unique values in List For More Syllabus Details contact us, Contact Numbers: 8056102481/9600063484 , 044-42115526 Mail id: Papitha.v@peridotsystems.in Name: papitha TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

SHAREPOINT TRAINING INSTITUTE IN CHENNAI ADYAR 8056102481... Peridot systems proudly introduce the job oriented SharePoint training institute in Chennai adyar with guaranteed jobs...for more information you need about the course syllabus details contact papitha (8056102481).We provide practical training more than theoretical training by real time trainers... Website: www.peridotsystems.in “REAL TIME TRAINING BY WORKING EXPERTS” BENEFITS:  2 days demo classes  45 days training classes  Online, classroom and corporate training classes  Weekdays and weekend batches Course SYLLABUS: • Creating/updating/propagating • Content types • Using Lookups and Calculated Columns • Enforcing Unique values in List Contact details, Mobile No’s: 8056102481/9600063484, 044-42115526 (papitha) Mail id: Papitha.v@peridotsystems.in TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

OBIEE Online Training Course Duration - 40hrs Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures Building presentation layer Objects of presentation layer Properties of the presentation

BEST SHAREPOINT TRAINING INSTITUTE IN CHENNAI WITH 100% PLACEMENT... Peridot systems providing no of software and hardware training courses in Chennai adyar...call to papitha (8056102481) for more information you need about the course content and syllabus details...we provide 70% practical training and 30% theoretical training by well experienced trainers... Our Official Website: www.peridotsystems.in Advantages for students: • Course name: SharePoint • Demo classes: 2 days • Training duration: 45 days • Training types: online, corporate and classroom training classes. SHAREPOINT: • Creating/updating/propagating • Scopes SharePoint 2013 Training • Content types • Creating/updating/propagating • Using Lookups and Calculated Columns • Enforcing Unique values in List Contact Details, Mobile Numbers: 8056102481/9600063484 Land-Line: 044-42115526 Contact Person: papitha Mail id: Papitha.v@peridotsystems.in TAGS: SharePoint 2013 Training in Chennai | Best SharePoint 2013 Training in Chennai| SharePoint 2013 Training institute in Chennai with placement.

OBIEE Online Training Course Duration - 40hrs Sadguru Technologies-8179736190 -040-40154733 Data warehousing overview Basics of Data Warehousing What is OLTP and OLAP? Difference between OLTP and OLAP Advantages of OLAP What is Data Marts and ODS? Dimensional Modeling Overview Introduction to Dimensional Modeling What are Facts and Dimensions? Star schema and Snowflake schema Introduction to Business Intelligence What is Business Intelligence Where BI tools are Used Why the Oracle Business Intelligence Advantages Architecture, Components Clients - Answers, Delivers, Dashboards and Web administration, Servers- Oracle BI server, Presentation, Scheduler server Server Architecture Repository Basics What is Meta data? Creating a Repository using BI Administration Tool Physical, Business Model and Mapping, and presentation layers Properties of repository objects Building Physical Layer of a Repository Objects of Physical Layer DSN for a data sources Build physical layer Building business Model mapping layer Objects of BMM layer Building Business model (creating logical tables, columns, joins) Creating simple measures

Building presentation layer Objects of presentation layer Properties of the presentation layer Build presentation layer Testing and validating Repository Checking repository consistency Checking Global Consistency Inspecting Oracle Answers inspecting SQL Inspecting log files(Nqquery.log,NQSserver.log) Adding multiple sources to dimension De-normalizing tables structures in database design Adding multiple sources to existing logical tables source Adding second table sources Adding calculations to fact Calculation measures on the basis of physical and logical columns Using Calculation wizard Creating dimensional hierarchies and level based measures Creating dimensional hierarchies Use level based measures Create Rank and Share measures

JOB ORIENTED PEOPLESOFT TRAINING INSTITUTE IN CHENNAI... Peridot systems providing real time training to our valuable students. Our trainers having well experienced in leading mnc. For more course syllabus details contact papitha (8056102481). We offer both weekdays and weekend training classes. Website: www.peridotsystems.in Advantages:  Placement guidance  Demo classes  Online & Corporate training classes  45 days training classes. Course syllabus: PROCESS SCHEDULER • Run Control ID • Creating Run Control Page • SQR Introduction • Building your first SQR program • SQR columns, variables and literals Contact details, No’s: 8056102481/9600063484, 044-42115526 (papitha) Mail id: Papitha.v@peridotsystems.in Website: www.peridotsystems.in

Duration: 10.5 hours Size: 1.63 GB 1. Database Basics 1. Oracle Database Introduction & Basics of Tables. 2. Setting Up the SQL Development Environment (Mac & Windows). 3. IMPORTANT Prepare the Data in the Database. 3.1 course_data.txt.txt 2. Single Table Queries (Exercises & Solutions in the Lectures) 1. Oracle Exams and Certification Information.html 2. Retrieving Data Using the SELECT Clause. 3. Using the WHERE Clause in a Query. 4. Using Operators in the WHERE Clause. 5. Combining WHERE, AND & OR with Operators. 6. Query Filtering Continued BETWEEN, IN and NULL. 7. Query Filtering Conditions & Operator Precedence. 8. Ordering, Concatenating & Aliasing Query Results. 3. Single Row Functions (Exercises and Solutions In the Lectures) 1. Single Row Functions (SRF) & Using The Dual Table. 2. Using Functions in WHERE And Character Based SRFs. 3. Numeric and Date Data type SRFs. 4. Conversion SRFs & Date Formatting. 5. Some More Date Functions.html 6. Concluding SRFs & NULL NULLIF Functions. 4. Grouping Functions (Exercises and Solutions In the Lectures) 1. Grouping Functions MIN, MAX, AVG, COUNT etc.. 2. GROUP BY Clause & HAVING Clause. 3. More Practice With The GROUP BY Clause. 5. Multi-Table Queries and Joins (Exercises and Solutions In the Lectures) 1. SELECT within SELECT (Subqueries). 2. Relating Tables Together Using JOINs. 3. Joins Continued INNER & OUTER Joins. 4. Correlated Subqueries with EXISTS & NOT EXIST operators. 6. Creating, Altering, and Updating Objects Using SQL (Exercises in Lectures) 1. Creating Your Own Tables & Design Considerations. 10. Views and Other Objects and Commands (Newly Added). 11. SQL could be tricky, check this out!.html 12. Granting and Revoking Privileges. 2. Inserting Data Into Our Table. 3. Create Table With a Primary Key Constraint. 4. Using ALTER to modify the table structure. 5. Create Table with SELECT + UPDATE Data. 7. DELETE, TRUNCATE, and DROP Commands. 8. Working With Database Indexes. 9. System Tables, Pseudo Columns & Deleting Duplicates (Newly Added). Guides PDF Advanced Oracle PL_SQL Developer’s Guide.pdf Beginning Oracle SQL for Oracle Database 12c, 3 edition.pdf.pdf OCA Oracle Database 12c_ SQL Fundamentals I Exam Guide (Exam 1Z0-061).pdf OCA_ Oracle Database 12c Administrator Certified Associate Study Guide_ Exams 1Z0-061 and 1Z0-062.pdf OCP_ Oracle Database 12c Administrator Certified Professional Study Guide_ Exam 1Z0-063.pdf Oracle 12c SQL.pdf creating_other_schema_objects_questions.pdf e47689.pdf subqueries_to_solve_queries_questions.pdf