Oracle Database: Introduction to SQL
This Oracle Database Introduction to SQL training teaches you basic concepts of relational databases and the SQL programming language which is applicable on MSSQL Server, MySQL and many other Relational Database Management Systems. It will help you write select statements, inner and outer joins, scalar & correlated subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. You will also learn how to use single-row and multi-row functions in the statements. Learn this and more through hands-on exercises.
«After many years of school and different courses I have seen my fair share of teachers and instructors. Cuneyt is hands down the best I have ever had. From his knowledge and understanding of the subject to his ability to get me to understand - he was just amazing. No complaints only praise.»
Learn to:
- Understand the basic concepts of relational databases ensure refined code by developers
- Create reports of sorted and restricted data
- Use the data type conversion functions, character manipulation functions, numeric & date related functions
- Implement conditional expressions
- Write queries that retrieved data from multiple tables
- Write scalar and correlated subqueries
- Run data manipulation statements (DML)
- Control database access to specific objects
- Manage schema objects like tables, views, indexes and sequence
- 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
Audience:
- Administrator
- Analyst
- Developer
Prerequisites:
- Familiarity with data processing concepts and techniques
Course objectives:
- Identify the major structural components of the Oracle Database
- 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
- 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
