SQL for Beginners: Zero to Hero By Ashish Gadpayle in Hindi

سرفصل های دوره

Become an expert at SQL

1 - Agenda for Oracle SQL for beginner video session Why learn SQL

1 - Introduction

2 - SQL Basics

2 - Introduction to Oracle SQL Data Database File System DBMS Why RDBMS

3 - Oracle SQL Terminologies field attribute columns tuples SQL datatypes

3 - SQL Command DDL DML DCL TCL DQL

4 - Types of SQL Command DDL DML DCL TCL DQL

5 - DDL Data Definition Language CREATE ALTER DROP TRUNCATE

6 - DQL Data Query Language SELECT Command Oracle SQL Tutorial

7 - DML Data Manipulation Language Insert Delete Update Oracle SQL Tutorial

8 - DCL Data Control Language GRANT REVOKE Create USER DROP USER

9 - TCL Transaction Control Language COMMIT ROLLBACK SAVEPOINT

4 - Type of Oracle SQL Operators Compound Logical Bitwise Comparison O

10 - Type of Oracle SQL Operators Compound Logical Bitwise Comparison

5 - OracleSQL Aggregate Functions COUNT SUM MIN MAX AVG

11 - OracleSQL Aggregate Functions COUNT SUM MIN MAX AVG

6 - OracleSQL Mathematical Numeric Functions ABS SQRT FLOOR

12 - OracleSQL Mathematical Numeric Functions ABS SQRT FLOOR

7 - OracleSQL String Functions LOWER LTRIM CONCATE INITCAP LENGTH

13 - OracleSQL String Functions LOWER LTRIM CONCATE INITCAP LENGTH

8 - OracleSQL Predicates BETWEEN IN LIKE IS NULL

14 - OracleSQL Predicates BETWEEN IN LIKE IS NULL

9 - ORDER BY Clause ORDER BY ASC ORDER BY DESC

15 - ORDER BY Clause ORDER BY ASC ORDER BY DESC

10 - GROUP BY Clause GROUP BY with Aggregate Functions

16 - GROUP BY Clause GROUP BY with Aggregate Functions

17 - SQL Queries Hands on Practice

11 - GROUP BY HAVING Clause HAVING Clause instead WHERE Clause

0 - Type of Oracle SQL Operators Compound Logical Bitwise Comparison

18 - GROUP BY HAVING Clause HAVING Clause instead WHERE Clause

12 - OracleSQL Types of Integrity Constraints Why Integrity Constraints

19 - OracleSQL Types of Integrity Constraints Why Integrity Constraints

20 - NOT NULL Constraint OracleSQL

21 - DEFAULT Constraints

22 - Primary Key Constraint Foreign Key Constraint Primary Key vs Foreign Key

23 - Sql Practice set 1 2

24 - UNIQUE Constraints

25 - CHECK Constraints

26 - INDEX Constraints create INDEX drop INDEX

27 - Joins inner join full outer join left join right join self join

28 - Joins inner join full outer join left join right join self join

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training