Published 7/2024
Created by DBA Training
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 20 Lectures ( 2h 30m ) | Size: 1.44 GB
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 objectivesCreate tablesSelecting data from tablesFiltering dataUsing functions to manipulate dataJoining data from tablesAggregate Functions Analytic Functions Set OperatorsSub Queries and Case StatementDML DCL DDL Language
Password/解压密码www.tbtos.com
转载请注明：0daytown » Learn Practical SQL on Oracle 21c with SQL Server & MySQL