IBy learning SQL, you're unlocking the ability to work with data effectively, which is a valuable skill in today's digital world. Moreover, SQL is frequently integrated with various Business Intelligence (BI) tools for accessing structured data efficiently.
It allows users to store, retrieve, update, and delete data efficiently from RDBMS.
- Types of databases (relational, non-relational)
- Data Manipulation Language (DML) vs. Data Definition Language (DDL)
- SQL commands (CREATE, INSERT)
- Understanding SQL statements
- Create database or schema
- Inserting data into tables
- Writing basic SQL queries
- Syntax of the SELECT statement
- Filtering data with WHERE clause
- Limiting results with LIMIT/TOP
- Using comparison operators (>, <,=, etc.)
- Using logical operators (AND, OR, NOT)
- Using compound operators (LIKE, BETWEEN, IN)
- Use of Set Operators (UNION, UNION ALL, INTERSECTS, EXCEPT/MINUS)
- Use of wild cards in query
- Sorting data with ORDER BY
- Using SQL functions (COUNT, SUM, AVG, MIN, MAX)
- Grouping data with GROUP BY
- Filtering grouped data with HAVING
- Updating existing data
- How to ALTER table ?
- Deleting data or table structure
- Types of joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN)
- Using aliases
- Understanding table relationships (one-to-one, one-to-many, many-to-many)
- Understanding subqueries
- Using subqueries in SELECT, WHERE, and FROM clauses
- Correlated subqueries
- Understanding indexes
- Creating indexes
- Using constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE)
- Creating views with CREATE VIEW
- Modifying views with ALTER VIEW
- Dropping views with DROP VIEW
Microsoft Certified Trainer - 1 Million+ Students
Experienced Tableau specialist adept at
converting business requirements into
impactful visualizations. Skilled in Tableau Server administration,
performance optimization, and report publishing. Proficient in SQL queries
across MySQL, SQL Server, and Oracle. Expertise in creating Data Lakes to
centralize offline data management. Strong ability to define data flows and
templates in Excel and MySQL environments. Knowledgeable in implementing
user filters for row-level security (RLS) and proposing suitable
visualization views aligned with KPIs. Proficient in Tableau features like
LOD, Parameter, Sets, and Actions. Experienced in end-to-end automation of
data and dashboard processes. Well-versed in training team members on new
technologies and BI tools. Expertise in converting excel-based reports to BI
visualizations and writing VBA Macros/Python Script for data preparation.
Analyzes data requirements and designs visualization solutions to meet
client needs. Skilled in data analysis and preparing ad-hoc reports.
Additionally, proficient in Python for data manipulation and analysis,
including feature engineering, data mapping, data cleaning, and aggregation.
Skilled in creating online platforms using Python, HTML/CSS, and JQuery for
data file management with LDAP Authentication. Experienced in Exploratory
Data Analysis (EDA) and assisting team members with machine learning
algorithms for predictions. Utilized Python libraries such as Pandas, NumPy,
Sci-Kit, Scikit-learn, OpenPyXL, and ldap3.
Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.
The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).
This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.
This was my first time taking an online course. The content is excellent, and the instructors are also excellent. How much you learn from this course is pretty much what you put into it.
Leave a Comment