What You Will Learn!
- SQL required to work on any On-premise or Cloud Database like Snowflake, Oracle, Teradata, My SQL
- SQL required to work on ETL or Integration tools like Informatica, Talend, Azure Data Factory
- SQL required to work on Visualization or Reporting tools like Power BI, Tableau
- SQL required to work as a Data Analyst
Description
I have designed this course in such a way like any one without prior knowledge on Data or SQL also can learn easily. I have given huge content and examples that will help for beginners to advanced learners.
I have given PPTs for every concept and lot of examples to practice. I have explained and executed all queries in Live so that anyone can understand it easily.
Below are the topics I have covered.
1.Introduction
2.What is Data, Database?
3.What is SQL
4.DataTypes
5.Types of SQL Statements
6.Operators
7.DDL and DML Commands
8.DQL-SELECT Statement
9.WHERE Clause
10.String Matching
11.Pre-defined Functions
12.Aggregate and Window functions
13.Subqueries
14.Case-Statement and Decode
15.Constraints
16.Null Handling
17.Joins
18.Set Operators
19.CTEs
20.Pivot and Unpivot
21.Indexes
22.Views
23.Access Controls
24.Performance Tuning
25.Advanced SQL Queries
Please go through all Content and let me know if you are looking for any specific SQL query, I can write it for you.
If you can spend daily 2 hours in learning SQL, you can complete this course in 25 days.
Thank you and I wish you a very happy learning.
Janardhan.
Who Should Attend!
- People looking for SQL Basics to Advanced in Telugu
- For Data enthusiasts