• Home
  • Courses
    • Microsoft Technical
      • Microsoft Azure
      • Microsoft Exchange Server
      • Microsoft SQL Server
      • Microsoft SharePoint
      • Microsoft Office 365
      • Microsoft Teams
      • Microsoft Virtualization
      • Microsoft Visual Studio
      • Microsoft Windows Server
      • Microsoft Windows Client
    • Microsoft Office
      • Microsoft Excel-Advanced
      • Microsoft Excel-Basic
      • Microsoft Word-Advanced
      • Microsoft Word-Basic
      • Microsoft Power BI
      • Microsoft Access
      • Microsoft PowerPoint
      • Microsoft Project
      • Microsoft Publisher
      • Microsoft Visio
    • Security
      • CCSA – Check Point Certified Admin
      • CND-Certified Network Defender
      • CSCU – Certified Secure Computer User
      • CEH-Certified Ethical Hacker v11
      • CAST 611-Advanced Penetration Testing
      • CISM – Certified Information Security Manager
      • CISA-Certified Information Systems Auditor
      • CISSP – Certified Information Systems Security Professional
    • AWS
    • Blockchain
    • Digital Marketing
    • Cisco
    • Oracle
    • Linux
      • LPI
      • Red Hat
    • Adobe
      • Photoshop-Basic
      • Photoshop-Advanced
      • Illustrator
      • InDesign
      • Dreamweaver
      • Flash
      • Premiere Pro
    • Autodesk
    • Project Management
    • Service Management
    • SPSS
    • Web Design
    • VMware
  • Certifications
    • Microsoft Technical
      • Microsoft Certified: Azure Administrator Associate
      • Microsoft 365 Certified: Enterprise Administrator Expert
      • Microsoft Certified: Data Analyst Associate
      • Microsoft Certified: Azure Developer Associate
    • Microsoft Office
      • MOS: Associate (Office 365 and Office 2019)
      • MOS: Expert (Office 365 and Office 2019)
      • MOS-Microsoft Office Specialist
      • Microsoft 365 Certified
    • Security Specialist
      • CND-Certified Network Defender
      • CSCU
      • CEH – Certified Ethical Hacker v11
      • CAST 611 – Advanced Penetration Testing
      • CISA – Certified Information Systems Auditor
      • CISM – Certified Information Security Manager
      • CISCO SECURITY
    • Cisco
      • CCNA – Cisco Certified Network Associate
    • Certified Blockchain Professional
    • Certified Digital Marketer (CDM)
    • ECDL Standard
    • Linux
      • Linux Professional Institute
    • Oracle
      • OCA – Oracle Certified Associate: PL/SQL Developer
      • OCA – Oracle Certified Associate: Database 11g Administrator
      • OCA – Oracle Certified Associate: Database 12c Administrator
    • VMware
    • Project Management Professional ( PMP )
    • Service Management
    • Pearson Vue
  • Solutions
    • For Business
    • For Individuals
    • Training Options
  • Contact
  • More
    • About Us
    • Request Info
    • Become a Trainer
    • News & Events
    Tel: (+357) 22.81.81.01
    Tel: (+357) 25.37.38.00
    sales@aktina.com.cy
    AKTINA – IT Training Center
    • Home
    • Courses
      • Microsoft Technical
        • Microsoft Azure
        • Microsoft Exchange Server
        • Microsoft SQL Server
        • Microsoft SharePoint
        • Microsoft Office 365
        • Microsoft Teams
        • Microsoft Virtualization
        • Microsoft Visual Studio
        • Microsoft Windows Server
        • Microsoft Windows Client
      • Microsoft Office
        • Microsoft Excel-Advanced
        • Microsoft Excel-Basic
        • Microsoft Word-Advanced
        • Microsoft Word-Basic
        • Microsoft Power BI
        • Microsoft Access
        • Microsoft PowerPoint
        • Microsoft Project
        • Microsoft Publisher
        • Microsoft Visio
      • Security
        • CCSA – Check Point Certified Admin
        • CND-Certified Network Defender
        • CSCU – Certified Secure Computer User
        • CEH-Certified Ethical Hacker v11
        • CAST 611-Advanced Penetration Testing
        • CISM – Certified Information Security Manager
        • CISA-Certified Information Systems Auditor
        • CISSP – Certified Information Systems Security Professional
      • AWS
      • Blockchain
      • Digital Marketing
      • Cisco
      • Oracle
      • Linux
        • LPI
        • Red Hat
      • Adobe
        • Photoshop-Basic
        • Photoshop-Advanced
        • Illustrator
        • InDesign
        • Dreamweaver
        • Flash
        • Premiere Pro
      • Autodesk
      • Project Management
      • Service Management
      • SPSS
      • Web Design
      • VMware
    • Certifications
      • Microsoft Technical
        • Microsoft Certified: Azure Administrator Associate
        • Microsoft 365 Certified: Enterprise Administrator Expert
        • Microsoft Certified: Data Analyst Associate
        • Microsoft Certified: Azure Developer Associate
      • Microsoft Office
        • MOS: Associate (Office 365 and Office 2019)
        • MOS: Expert (Office 365 and Office 2019)
        • MOS-Microsoft Office Specialist
        • Microsoft 365 Certified
      • Security Specialist
        • CND-Certified Network Defender
        • CSCU
        • CEH – Certified Ethical Hacker v11
        • CAST 611 – Advanced Penetration Testing
        • CISA – Certified Information Systems Auditor
        • CISM – Certified Information Security Manager
        • CISCO SECURITY
      • Cisco
        • CCNA – Cisco Certified Network Associate
      • Certified Blockchain Professional
      • Certified Digital Marketer (CDM)
      • ECDL Standard
      • Linux
        • Linux Professional Institute
      • Oracle
        • OCA – Oracle Certified Associate: PL/SQL Developer
        • OCA – Oracle Certified Associate: Database 11g Administrator
        • OCA – Oracle Certified Associate: Database 12c Administrator
      • VMware
      • Project Management Professional ( PMP )
      • Service Management
      • Pearson Vue
    • Solutions
      • For Business
      • For Individuals
      • Training Options
    • Contact
    • More
      • About Us
      • Request Info
      • Become a Trainer
      • News & Events

      Oracle

      • Home
      • All courses
      • Oracle
      • Oracle Database 11g: SQL Fundamentals

      Oracle Database 11g: SQL Fundamentals

      User Avatar
      aktina
      Oracle
      Free
      oracle
      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Introduction

      This SQL Fundamentals training teaches you how to write SQL queries to access data stored in an Oracle Database schema. Learn to manipulate data and use various types of functions for customizing data output. It introduces you to the fundamentals of SQL using Oracle Database technology and you will Learn the concepts of relational databases and the powerful SQL programming language. You will also learn essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

      Participants learn to use single row functions to customize output, use conversion functions and conditional expressions. In addition, the usage of group functions to report aggregated data is also dealt with. Demonstrations and hands-on practice reinforce the fundamental concepts. This SQL Fundamentals training teaches you how to write SQL queries to access data stored in an Oracle Database schema. Learn to manipulate data and use various types of functions for customizing data output.Use Oracle SQL Developer as the main tool and SQL*Plus is available as an optional tool.

      Audience
      • Application Developers
      • Forms Developer
      • PL/SQL Developer
      • Reports Developer
      • Technical Consultant
      • Portal Developer
      • Functional Implementer
      • End Users
      At Course Completion

      You will learn to:

      • Retrieve row and column data from tables with the SELECT statement.
      • Create reports of sorted data.
      • Display data from multiple tables.
      • Use DML statements to manage data.
      • Use DDL statements to manage database objects.
      • Create reports of restricted data.

      Benefits To You:

      Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.

      Prerequisites

      Familiarity with data processing concepts and techniques.

      Professional Exam(s)
      Exam 1Z0-051: Oracle Database 11g – SQL Fundamentals I
      CoursesOracleOracle Database 11g: SQL Fundamentals
      • MODULES
        12
        • Lecture1.1
          Introduction 30 min
        • Lecture1.2
          Retrieve Data Using the SQL SELECT Statement 30 min
        • Lecture1.3
          Restrict and Sort Data 30 min
        • Lecture1.4
          Use Single-Row Functions to Customize Output 30 min
        • Lecture1.5
          Conversion Functions and Conditional Expressions 30 min
        • Lecture1.6
          Aggregated Data Using Group Functions 30 min
        • Lecture1.7
          Display Data From Multiple Tables Using Joins 30 min
        • Lecture1.8
          Use Sub-queries to Solve Queries 30 min
        • Lecture1.9
          SET Operators 30 min
        • Lecture1.10
          Data Manipulation 30 min
        • Lecture1.11
          Use DDL Statements to Create and Manage Tables 30 min
        • Lecture1.12
          Other Schema Objects 30 min
      City
      Nicosia
      Dates and Times
      Duration (Hours)
      40
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      Duration (Hours)
      40
      Location
      22 Griva Digeni Avenue, 3106 Agios Nikolaos
      (200 m. from the roundabout, near Agios Nikolaos church)

      ParticipationCourse Manual(s)Exam(s)
      CourseOracle Press1Z0-051
      Amount€400,00€60,00€109,00
      VAT *€476,00€71,40-

      • Course Overview
      • Course Outline
      • Course Arrangements
      • Costs
      Free
      • Share:

      You May Like

      Oracle Database 12c: Performance Management and Tuning – Official Oracle Course Read More
      aktina

      Oracle Database 12c: Performance Management and Tuning – Official Oracle Course

      0
      Free
      Exadata Database Machine: 12c Administration Workshop – Official Oracle Course Read More
      aktina

      Exadata Database Machine: 12c Administration Workshop – Official Oracle Course

      0
      Free
      Oracle SQL Tuning for Developers Workshop – Official Oracle Course Read More
      aktina

      Oracle SQL Tuning for Developers Workshop – Official Oracle Course

      0
      Free
      Oracle Database: Backup and Recovery Workshop – Official Oracle Course Read More
      aktina

      Oracle Database: Backup and Recovery Workshop – Official Oracle Course

      0
      Free
      Oracle Database: Administration Workshop Read More
      aktina

      Oracle Database: Administration Workshop

      0
      Free

      LEMESOS (LIMASSOL)

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church)

      LEFKOSIA (NICOSIA)

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools)

      Popular Courses

      Digital Marketing e-course

      Digital Marketing e-course

      Blockchain Professional e-course

      Blockchain Professional e-course

      Implementing and Administering Cisco Solutions (CCNA)

      Implementing and Administering Cisco Solutions (CCNA)

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      20740: Installation, Storage and Compute with Windows Server 2016 – Official Microsoft Course

      More Courses

      Limassol Training Center

      22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos (200 m. from the roundabout, near Agios Nikolaos church) Lemesos (Limassol), Cyprus

      (+357) 25.37.38.00

       

      Nicosia Training Center

      20 Louki Akrita street, 2064 Strovolos (behind Kykko secondary schools) PO Box 25252, CY-1308 Lefkosia (Nicosia), Cyprus

      (+357) 22 81.81.01

       

      TOP COURSES

      • 20740: Windows Server 2016
      • 20461: Querying Microsoft SQL
      • 20483: Programming in C#
      • 20461: Microsoft SQL Server
      • 20480: HTML5 ,JavaScript…
      • VMware vSphere
      • Oracle Database: Backup and Recover

      Recommended

      • Security
      • Microsoft
      • Oracle
      • Cisco
      • Linux
      • Adobe

      Contact

      sales@aktina.com.cy

      Developed by AKTINA . IT Training organisation in Cyprus.

      • COURSES
      • CERTIFICATIONS
      • SOLUTIONS
      • CONTACT

      BECOME A TRAINER

      Join our team of trainers and earn money hassle free!

      Get Started Now
      Modal title

      Message modal