• 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: Introduction to SQL

      Oracle Database: Introduction to SQL

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

      This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

      Learn To:
      • Understand the basic concepts of relational databases ensure refined code by developers.
      • Create reports of sorted and restricted data.
      • Run data manipulation statements (DML).
      • Control database access to specific objects.
      • Manage schema objects.
      • Manage objects with data dictionary views.
      • Retrieve row and column data from tables.
      • Control privileges at the object and system level.
      • Create indexes and constraints; alter existing schema objects.
      • Create and query external tables.
      Benefits to You

      Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

      Learn Advanced Features of SQL

      This course will help you understand the advanced features of SQL. Learning 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. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

      Use Development Tools

      The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

      Course Bundle

      Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: SQL Workshop II courses.

      Audience
      • Administrator
      • Analyst
      • Developer
      • Systems Administrator
      Course Objectives
        • Identify the major structural components of the Oracle Database 12c
        • Create reports of aggregated data
        • Write SELECT statements that include queries
        • Retrieve row and column data from tables
        • Run data manipulation statements (DML) in Oracle Database 12c
        • Create tables to store data
        • Utilize views to display data
        • Control database access to specific objects
        • Manage schema objects
        • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
        • Manage objects with data dictionary views
        • Write multiple-column sub-queries
        • Employ SQL functions to retrieve customized data
        • Use scalar and correlated sub-queries
        • Create reports of sorted and restricted data

      Click here for explanations of the new certification OCP – Oracle Certified Professional.

      Professional Exam(s)
      Exam 1z0-082: Oracle Database Administration I
      Certification(s):
      OCP – Oracle Database Administration 2019 Certified Professional
      CoursesOracleOracle Database: Introduction to SQL
      • MODULES
        19
        • Lecture1.1
          Introduction
        • Lecture1.2
          Retrieving Data using the SQL SELECT Statement
        • Lecture1.3
          Restricting and Sorting Data
        • Lecture1.4
          Using Single-Row Functions to Customize Output
        • Lecture1.5
          Reporting Aggregated Data Using the Group Functions
        • Lecture1.6
          Displaying Data from Multiple Tables Using Joins
        • Lecture1.7
          Using Subqueries to Solve Queries
        • Lecture1.8
          Using the SET Operators
        • Lecture1.9
          Managing Tables using DML statements
        • Lecture1.10
          Introduction to Data Definition Language
        • Lecture1.11
          Introduction to Data Dictionary Views
        • Lecture1.12
          Creating Sequences, Synonyms, Indexes
        • Lecture1.13
          Creating Views
        • Lecture1.14
          Managing Schema Objects
        • Lecture1.15
          Retrieving Data by Using Subqueries
        • Lecture1.16
          Manipulating Data by Using Subqueries
        • Lecture1.17
          Controlling User Access
        • Lecture1.18
          Manipulating Data
        • Lecture1.19
          Managing Data in Different Time Zones
      City
      Nicosia
      Dates and Times
      Class A
      1. March 09 8:30 - 15:40
      2. March 10 8:30 - 15:40
      3. March 11 8:30 - 15:40
      4. March 12 8:30 - 15:40
      5. March 13 8:30 - 15:40
      6. March 14 8:30 - 15:40 (review)
      Duration (Hours)
      35
      Location
      20 Louki Akrita street, 2064 Strovolos
      (behind Kykko secondary schools)
      City
      Limassol
      Dates and Times
      Class A
      1. June 22 8:00 - 15:30
      2. June 23 8:00 - 15:30
      3. June 24 8:00 - 15:30
      4. June 25 8:00 - 15:30
      5. June 26 8:00 - 15:30
      6. June 27 8:30 - 13:45 (review)
      Duration (Hours)
      35
      Location
      22 Griva Digeni Avenue, 3106 Agios Nikolaos
      (200 m. from the roundabout, near Agios Nikolaos church)

      For participants eligible for subsidy by the Human Resource Development Authority

      Participation * Course ManualExam
      courseOracle Official Courseware & Labs
      Amount€1.315,00Incl.
      VAT * €362,90Incl.
      * denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy.

      For participants not eligible for subsidy by the Human Resource Development Authority

      Participation Course ManualExam
      CourseOracle Intro.
      Amount€1.910,00Incl.
      VAT €362,90Incl.

      • 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