SQL for Data Analytics on Oracle with SQL Server & MySQL

Focused View

DBA Training

2:30:22

0 View

1. Introduction

1. Introduction to Course.mp4

01:30

2. Introduction.mp4

01:25

2. SQL Language Part 1

1. 02 Table and Data Types.mp4

03:31

2. 03 Constraints.mp4

02:28

3. 04 SQL - DDL DML DCL.mp4

01:09

4. 05 Create Table Hands ON.mp4

07:45

5. 06 Table Clone.mp4

03:28

6. 07 Drop Truncate Modify Table.mp4

05:15

7. 08 DML Practical.mp4

10:27

8. 09 Select Data Part 1.mp4

04:45

9. 10 Select Data Part 2.mp4

10:49

10. 11 Select Data Part 3.mp4

12:24

11. 12 DCL Practical.mp4

06:48

3. SQL Language Part 2

1. 13 Aggregate Functions.mp4

14:04

2. 14 Oracle Functions.mp4

17:59

3. 15 SET Operators.mp4

07:32

4. 16 Sub Queries and Case Statement.mp4

09:09

5. 17 Joins Part 1.mp4

14:35

6. 18 Joins Part 2.mp4

06:49

7. 19 Analytic Functions.mp4

08:30

Description

Coupon : SQLCOURSE092024 | Comparison of Commands of Oracle with MySQL and SQL Server (T-SQL). Hands-On for Oracle 21c

What You'll Learn?

Use SQL to perform data analysis
Learn Aggregate Functions , SET Operators , Joins , Analytic Functions
Compare SQL Syntax for Oracle , MySQL & T-SQL (SQL Server)
Use SQL to query a database using DML , DDL , DCL Language

Who is this for?

SQL Course is helpful for Data Analysis for Data Scientist , Developers , Students using Oracle SQL , MySQL , SQL Server

What You Need to Know?

No previous technical knowledge required

More details

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

Use Coupon CodeÂ SQLCOURSEJULAUG
Who this course is for:
SQL Course is helpful for Data Analysis for Data Scientist , Developers , Students using Oracle SQL , MySQL , SQL Server

User Reviews

Rating

average 0

Total votes0

Focused display

We have more than 10 years experience in IT Sector , We will share practical experience via course , so that you can learn the Technology in no time , please join us in Courses like Oracle , SQL Server , MYSQL , POSTGRESQL , Python , Trading Courses and many more continues. Feel free to checkout our courses regularly

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.