From Excel To Sql, Master Sql Like A Pro!

Last updated 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.73 GB | Duration: 5h 26m

SQL, Excel, Snowflake, Cloud Datawarehouse.

What you'll learn
Develop a strong foundation in SQL, mastering syntax, database concepts, and querying techniques for efficient data manipulation.
Seamlessly transfer Excel skills to SQL, leveraging familiarity with formulas and functions to perform data analysis effortlessly.
Execute complex SQL queries, extracting and transforming data for advanced analysis, utilizing aggregation, joins, and subqueries.
Generate insightful reports and visualizations in SQL, summarizing data, creating calculated fields, and effectively communicating findings.
Acquire practical knowledge of database management and best practices, ensuring efficient data retrieval, organization, and optimization in 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
Unlock the full potential of your data analysis skills by seamlessly transitioning from Excel to SQL with our comprehensive course, "From Excel to SQL, Master SQL Like a Pro!" Designed specifically for Excel users and beginners in SQL, this course provides a smooth and intuitive learning path to master the world of SQL.Whether you're an Excel power user or rely on spreadsheets for your daily work, this course will empower you to take your data analysis and reporting skills to new heights. You'll discover how to leverage your existing Excel knowledge and apply it directly to SQL, eliminating the learning curve and accelerating your proficiency.Through practical examples and hands-on exercises, you'll learn how to manipulate data, perform complex queries, and generate insightful reports using SQL. We'll guide you through each step, demonstrating how to seamlessly translate Excel tasks and functions into powerful SQL queries. You'll gain a deep understanding of SQL syntax, database management, and best practices for efficient data retrieval and analysis.Key Features:Master SQL effortlessly with an Excel-like approachSeamlessly transition from Excel to SQL with ease and confidenceLearn practical SQL skills for data manipulation, complex queries, and reportingGain a deep understanding of SQL syntax, database management, and best practicesHands-on exercises and real-world examples to reinforce learningExcel-centric teaching approach for practical application of SQL conceptsSuitable for Excel users and beginners in SQL looking to enhance their data analysis skillsUnlock the power of SQL and revolutionize your data analysis workflow. Enroll now in "From Excel to SQL, Master SQL Like a Pro!" and propel your career to new heights by combining Excel's familiarity with the capabilities of SQL.What you can learn from this course,SQLExcelData analysisDatabase managementSQL queriesData manipulationReportingData visualizationExcel formulasData analyticsSQL syntaxData extractionData transformationData aggregationExcel functionsBeginner-friendlyPractical examplesHands-on exercisesExcel-like approachStep-by-step instructions

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

Beginners with no prior IT or SQL background, looking to learn SQL from scratch using Excel as a reference.,Excel users seeking to expand their data analysis capabilities by acquiring SQL skills in a beginner-friendly manner.,Professionals in various roles (finance, marketing, HR, etc.) who rely on Excel and want to enhance their data analysis using SQL.,Individuals interested in data analysis careers, wanting to start with SQL and gain a solid foundation for further learning.,Students or self-learners aiming to acquire practical SQL skills, with a focus on applying them within the context of Excel-based data analysis.

Buy Premium Account From My Download Links & Get Fastest Speed.