Oracle Database 12c: Basic SQL
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to use SQL in an Oracle Database 12c environment. This beginner-level course shows how to query, select, filter, join, and manipulate Oracle data using SQL statements.
Syllabus
Introduction
- Welcome
- What you need to know
- What is SQL?
- Database tables
- Overview of table data types
- SQL query structure
- Downloading the course VM
- Introduction to Oracle SQL Developer
- Creating a connection to the database
- Managing existing connections
- Exploring database objects
- Filtering specific objects
- Using SQL Developer tabs
- Viewing query output
- Case sensitivity of SQL commands
- Viewing SQL execution history
- Query output as grid or script
- Writing your first SELECT query
- Selecting only specific columns
- Using WHERE to filter specific rows
- Using multiple WHERE conditions
- Using WHERE to filter partial strings
- Using WHERE to filter numeric ranges
- Using WHERE IN and NOT IN for strings
- Using WHERE IN and NOT IN for numbers
- Using WHERE to filter dates
- Using WHERE to filter exact strings
- Using DISTINCT to eliminate duplicates
- Performing basic numeric calculations
- Using column aliases
- Describe the structure of a table
- Using ORDER BY
- Introduction to functions
- Using SUBSTRING, LENGTH, and CONCAT
- Using LENGTH
- Using CONCAT
- Using LOWER and UPPER
- Using INSTR
- Using RPAD and LPAD
- Using TO_CHAR to convert numbers
- Using TO_CHAR to format DATE values
- Using TO_CHAR to filter DATE values
- The special Oracle DUAL table
- Using ROUND
- Using TRUNC
- Using SYSDATE
- Using SYSTIMESTAMP
- Using MONTHS_BETWEEN
- Using ADD_MONTHS
- Introduction to SQL joins
- Joining data from tables
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
- Joins with table aliases
- Oracle join syntax vs. ANSI syntax
- Introduction to DML and DDL commands
- Creating a simple table
- Inserting a new row to a table
- COMMIT and ROLLBACK
- Introduction to transactions
- Deleting rows for a table
- Updating values
- Multiple-statement transactions
- Truncating all data from a table
- Adding and dropping columns from a table
- Introduction to aggregate functions
- Using aggregate functions
- Using GROUP BY
- Using GROUP BY with MAX, MIN, and AVG
- Using HAVING
- Primary keys
- NOT NULL constraints
- Check constraints
- Foreign key constraints
- Subqueries
- Next steps
Taught by
David Yahalom
Related Courses
Come liberarsi dei database legacy (Italiano) | Break Free of Legacy Databases (Italian)Amazon Web Services via AWS Skill Builder Migrating from Oracle to Amazon Aurora
Amazon Web Services via Coursera Migrating from Oracle to Amazon RDS
Amazon Web Services via Coursera Oracle Performance: Exadata, Enterprise Manager Mastery
Coursera Instructor Network via Coursera The Oracle Database Multitenant Administration Course
Packt via Coursera