SQL FULL COURSE BASIC TO ADVANCE

Focused View

Bushigampala Maraiah

7:43:50

5 View

1 - Introduction

1 - Class-Notes-1.txt

1 - Data-Types.txt

1 - INTRODUCTION TO DATABASES AND SQL STATEMENTS 1.mp4

38:16

1 - SQL-COMMANDS.txt

1 - table1.zip

1 - table-2.zip

1 - task.zip

2 - INTRODUCTION TO DATABASES AND SQL STATEMENTS 2.mp4

07:37

3 - Class-Notes-2.txt

3 - FILTERING AND SORTING 1.mp4

28:44

3 - FILTERING-AND-SORTING.txt

3 - table.zip

3 - table-q.zip

4 - FILTERING AND SORTING 2.mp4

14:32

5 - CLASS-NOTES-3.txt

5 - STRING FUNCTIONS 1.mp4

35:11

5 - STRING-FUNCTIONS.txt

5 - q.zip

5 - q1.zip

5 - q2.zip

5 - table.zip

5 - table-2.zip

6 - STRING FUNCTIONS 2.mp4

18:22

7 - CLASS-NOTE-4.txt

7 - NUMBER AND DATE FUNCTIONS 1.mp4

35:21

7 - NUMBER-AND-DATE-FUNCTIONS.txt

7 - q.zip

7 - q2.zip

7 - table.zip

7 - table-2.zip

8 - NUMBER AND DATE FUNCTIONS 2.mp4

25:38

9 - CLASS-NOTES-5.txt

9 - CTAS SET OPERATORS.mp4

11:26

9 - CTAS-SET-OPERATORS.txt

9 - q.zip

9 - table-1.zip

9 - table-2.zip

10 - NULL HANDLING CASE AND DECODE 1.mp4

37:15

10 - case-and-decode.zip

10 - nulls.zip

10 - q.zip

10 - table.zip

11 - NULL HANDLING CASE AND DECODE 2.mp4

15:32

12 - Aggregate functions ANALYTICAL FUNCTIONS 1.mp4

36:25

12 - CLASS-NOTES-7.txt

12 - aggregate-functions.zip

12 - analytical-functions.zip

12 - q1.zip

12 - q2.zip

12 - q3.zip

12 - q4.zip

12 - table.zip

13 - Aggregate functions ANALYTICAL FUNCTIONS 2.mp4

15:32

14 - Aggregate functions ANALYTICAL FUNCTIONS 3.mp4

04:17

15 - CLASS-NOTES-8.txt

15 - CONSTRAINTS.txt

15 - CONSTRAINTS JOINS 1.mp4

28:44

15 - JOINS.txt

15 - questions.zip

15 - table-1.zip

15 - table-2.zip

16 - CONSTRAINTS JOINS 2.mp4

31:13

17 - CLASS-NOTES-9.txt

17 - PIVOT AND UNPIVOT SUBQUERIES 1.mp4

38:36

17 - PIVOT-AND-UNPIVOT.txt

17 - SUBQUERIES.txt

18 - PIVOT AND UNPIVOT SUBQUERIES 2.mp4

03:08

19 - PIVOT AND UNPIVOT SUBQUERIES 3.mp4

04:37

20 - INDEXES.mp4

06:02

20 - INDEXES.txt

21 - VIEWS.mp4

22:40

21 - VIEWS.txt

22 - PERFORMANCE TUNING.mp4

04:42

22 - PERFORMANCE-TUNING.txt

Description

DATABASE BASICS AND SQL STATEMENTS 1

What You'll Learn?

SQL required to work on any On-premise or Cloud Database like Snowflake, Oracle, Teradata, My SQL
SQL required to work on Visualization or Reporting tools like Power BI, Tableau
SQL required to work on ETL or Integration tools like Informatica, Talend, Azure Data Factory
SQL required to work as a Data Analyst
CLEARING SQL DEVLOPER INTERVIEWS

Who is this for?

THIS COURSE USE FOR SNOWFLAKE DEVELOPERS AND PYTHON DEVELOPER AND DATASCIENCE AND DATA ANALYTICS

What You Need to Know?

NO NEED ANY SKILLS BEFORE YOU START THIS YOU CAN WATCH HERE LEARN IT

More details

Description
SQL => DATABASE CONCEPTS

DATABASE
DBMS
DATA MODELS
RDBMS
SQL

WHAT IS DATABASE ?

=> THE PLACE WE CAN STORE THE RELATED DATA AND LATER RETRIVE THE DATA IS KNOWN AS DATABASE

DBMS => DATABASE MANAGEMENT SYSTEMS

=> SOFTWATE THAT STORES DATA IN DATABASES IN AN ORGANIZED WAY TO MAKE IT EASIER TO CREATE, RETRIVE, UPDATE ETC.

DATA MODELS =>

Hierachical Model
Network Model
Entity-Relationship Data Model
Relational Data Model

RDBMS =>

DBMS using Relational Data Models are known as RDBMS

Here is the list of the top 10 most popular RDBMSs are:

SQL =>

Programming lanugage for Relational DATABASE

Stands for Structured Query Language

SQL(Structured Query Language) is a database computer language designed for managing
data in relational database management systems (RDBMS).

SQL (SEQUEL), is a standardized computer
language that was originally developed by in 1970 for querying,
altering and defining relational databases, using declarative statements.

1.SQL COMMANDS AND STATEMENTS
2.FILTERING AND SORTING
3.STRING FUNCTIONS
4.NUMBER FUNCTIONS
DATE FUNCTIONS
6.CTAS
7.SET OPEERATORS
8.NULLS
9.AGGRATE FUNCTIONS
10.ANALTICAL FUNCTIONS
11.CONSTARINAS
12.JOINS
13.SUBQURIES
14.PIVOT AND UNPIVOT
15.INDEXS
16.VIEWS
17.PERFORMANCE TUNING.

STATEMENTS:

Types of SQL Commands

Data Definition Language (DDL)

Data Manipulation Language (DML)

Transaction Control Language (TCL)

Data Query(Retrieval) Language (DQL)

Data Control Language (DCL)

DDL - CREATE
Â Â Â ALTER
Â Â Â DROP
Â Â Â TRUNCATE

DML - INSERT
Â Â Â UPDATE
Â Â Â DELETE
Â Â Â MERGE

TCL - COMMIT
Â Â Â ROLLBACK

DQL(DRL) - SELECT

DCL - GRANT
Â Â Â REVOKE

Data Definition Language (DDL)

=> DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.
=> All the command of DDL are auto-committed that means it permanently save all the changes in the database.

Who this course is for:
THIS COURSE USE FOR SNOWFLAKE DEVELOPERS AND PYTHON DEVELOPER AND DATASCIENCE AND DATA ANALYTICS

User Reviews

Rating

average 0

Total votes0

Focused display

I AM SQL AND SNOWFLAKE INDIVIDUL TRAINER AND I WILL GIVE TRAINGN AND I WILL CONDUCT MOCK INTERVIEW FOR STUDENTS AND I WILL PREPARE END TO END INTERVIEW QUESTIONS AND I WILL GIVE TASKS FOR STUDENTS FOR CLEARING INTERVIEW QUESTIONS AND I WILL GIVE ASSIGNMETS AND I HAVE DONE A LOT OF PROJECTS

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.