Learn Practical SQL on Oracle 21c with SQL Server & MySQL

Learn SQL on Oracle 21c DB along with Comparison of Commands for MySQL and SQL Server (T-SQL). Hands-On for Oracle 21c


What you'll learn
Use SQL to query a database using DML , DDL , DCL Language
Use SQL to perform data analysis
Learn to perform GROUP BY statements
Compare SQL Syntax for Oracle , MySQL & T-SQL (SQL Server)

Requirements
No previous technical knowledge required

Description
Go from SQL Beginner to Expert in Managing SQL on Oracle 21c Database along with Comparison of Commands for MySQL and SQL Server (T-SQL). Hands-on will be covered with Oracle 21c SQL Developer.
Mastering the SQL language is an essential skill for any Oracle professional and is the first step in becoming a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, we covers the basics required to code with SQL in an Oracle Database 21c environment. Learn how to select and filter data, and manipulate data using functions. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions.
Note: This training course is appropriate for beginning database developers , Data Scientist , Data Analyst , Students , Anyone with no prior experience with SQL or Oracle.
Learning objectives
Create tables
Selecting data from tables
Filtering data
Using functions to manipulate data
Joining data from tables
Aggregate Functions
Analytic Functions
Set Operators
Sub Queries and Case Statement
DML DCL DDL Language
Who this course is for:
SQL Course is helpful for Data Analysis for Data Scientist , Developers , Students using Oracle SQL , MySQL , SQL Server

More Info