Search the Community

Published 7/2024 Created by DBA Training MP4 | Video: h264, 1280x720 | 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 Who this course is for: SQL Course is helpful for Data Analysis for Data Scientist , Developers , Students using Oracle SQL , MySQL , SQL Server Homepage