Tutorials > From Excel To Sql! 2023

From Excel To Sql! 2023


Date: 21 January 2023 | Posted by: voska89
From Excel To Sql! 2023
Published 1/2023
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.77 GB | Duration: 5h 26m
SQL, Excel, Snowflake, Cloud Datawarehouse.


What you'll learn
SQL
Snowflake
Access and manage database
Switch from excel to database using SQL.
Requirements
No programming experience is needed, all the concepts will be taught from the basics and this course is purely for the beginners.
Description
This course is to learn SQL (Structured Query Language). Those who have been using excel to save their data and wants to move from excel to database and wants to understand how to interact with the database and how to write a SQL to get the data from the database, this course is for you. Most of the SQL concepts are shown with the reference to excel concepts which would make it easy to understand how things are work.Snowflake has been used in this course as a database. There are multiple reasons to use snowflake as a database, mainly because we get 200 USD worth free usage and also snowflake provides free trial for 30 days. Setup to start our database on snowflake is very quick and easy, it takes less than 5 mins to setup everything. And if we take the course with good dedication, we can finish this course well within 30 days of trial period. Even if you do not finish the course in 30 days, you always have a chance to create a another free trial account with snowflake and continue. We have tried our best to teach all the concepts properly and with good examples. We hope that this course will really help you to understand SQL and how to interact with the databases.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Logging to snowflake
Lecture 3 Preparation
Section 2: Basic
Lecture 4 Select ALL
Lecture 5 Select specific columns
Lecture 6 Select specific Rows :- Where Clause
Lecture 7 Multiple Filters :- AND, OR, IN, Between, Not In, Not Between
Lecture 8 Aggregation :- SUM, MIN, MAX, COUNT, AVG
Lecture 9 Select unique values :- DISTINCT & Group By
Lecture 10 Filters on Aggregated Data :- Having Clause
Lecture 11 Column Alias :- Use cases ( AS )
Lecture 12 Conditional Logic :- CASE, IFF
Lecture 13 Limiting records :- TOP, Limit, Sample
Lecture 14 Intro to NULL, finding NULL values, replace NULL with Coalease, NULLIFZERO
Lecture 15 Sorting the output :- ORDER BY
Lecture 16 Subquery
Section 3: Joins
Lecture 17 Join Concept
Lecture 18 Inner JOIN
Lecture 19 Left JOIN
Lecture 20 Right JOIN
Lecture 21 Full Outer JOIN
Lecture 22 CROSS JOIN
Section 4: SET Operators
Lecture 23 Set Operator - Concept
Lecture 24 UNION ALL
Lecture 25 UNION
Lecture 26 MINUS / Except
Lecture 27 INTERSECT
Section 5: DML
Lecture 28 Insert Into the table :- 1 row, multiple rows at a time (Manual)
Lecture 29 Insert Into the table :- From other tables
Lecture 30 Handling NOT NULL columns :- Default Values
Lecture 31 Update a specific value
Lecture 32 Update using other tables
Lecture 33 Delete Specific row in table
Lecture 34 Delete based upon reference table
Lecture 35 Truncate
Lecture 36 Merge
Section 6: DDL
Lecture 37 Data Types
Lecture 38 Create Table, Primary Key, Not Null
Lecture 39 Create Table with Like and Clone
Lecture 40 Alter Table :- Add a column
Lecture 41 Alter Table :- Drop a column
Lecture 42 Alter Table :- Rename a column
Lecture 43 Drop Table
Lecture 44 Create View
Lecture 45 Create Materialized View
Section 7: Type Casting
Lecture 46 Number to String :- to_char/to_varchar
Lecture 47 String to Number :- To_Number
Lecture 48 String to Date :- To_Date
Section 8: Advanced SQL
Lecture 49 Pivot
Lecture 50 Unpivot
Lecture 51 Aggregate with LISTAGG
Lecture 52 Table Functions
Lecture 53 Hierarchy
Lecture 54 Hierarchy using Connect By
Lecture 55 Recursive SQL
Lecture 56 Common Table Expression :- CTE
Section 9: Window Functions
Lecture 57 Windows Functions + Rank
Lecture 58 Row_Number
Lecture 59 NTILE
Lecture 60 Dense_Rank
Lecture 61 LAG & LEAD
Lecture 62 First_Value, Last_Value, NTH_Value
Lecture 63 Cumulative Sum
Lecture 64 Handling Duplicates
Section 10: String Functions
Lecture 65 Concat
Lecture 66 Len
Lecture 67 Substr
Lecture 68 Position
Lecture 69 Upper case, Lower case & proper case
Lecture 70 Trim
Lecture 71 Replace
Lecture 72 Reverse
Lecture 73 Contains
Lecture 74 ARRAY_AGG
Lecture 75 Translate
Section 11: Number Functions
Lecture 76 SUM, Count, Min, Max, AVG, ABS
Lecture 77 Arithmetic Operations
Lecture 78 Convert String to Number
Section 12: Date Functions
Lecture 79 Get Number of Day/Month/Year between 2 dates, DATEDIFF, TIMEDIFF
Section 13: Regular Expression
Lecture 80 REGEXP
Lecture 81 REGEXP_LIKE
Lecture 82 REGEXP_SUBSTR & REGEXP_SUBSTR_ALL
Lecture 83 REGEXP_Count
Lecture 84 REGEXP_REPLACE
Lecture 85 REGEXP_INSTR
Section 14: Bonus Sessions
Lecture 86 SQL:- Standards & Tips
Lecture 87 Performance Tunning
Section 15: Practice Session
Lecture 88 Practice Session 1
Lecture 89 Practice Session 2
Lecture 90 Practice Session 3
Lecture 91 Practice Session 4
Lecture 92 Practice Session 5
Lecture 93 Practice Session 6
Lecture 94 Practice Session 7
Lecture 95 Practice Session 8
Lecture 96 Practice Session 9
Learners who wants to explore SQL,,Learners who wants to start using database,,Learners who wants to explore Snowflake,,Learners who wants to switch from excel to database.

Homepage
https://www.udemy.com/course/from-excel-to-sql/




DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article