Complete Introduction to SQL

Learn SQL — Essential Training

About The Course

What you'll learn

  • Will have clear understanding of word SQL
  • Able to create or delete table
  • How to create view
  • How we can extract our required data from tables
  • Correct writing approach of SQL query
  • How to do Debugging of your query
  • How to write Query efficiently
  • How we can get data from multiple tables using join

This course includes:

  • 6 hours on-demand video
  • 10 articles
  • 10 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

What is SQL?

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.

Course Header with 12 words

It allows users to store, retrieve, update, and delete data efficiently from RDBMS.

The Course Curriculum

- 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

Instructor Image

SONU PANDAY

Microsoft Certified Trainer - 1 Million+ Students

4.6 Instructor Rating
579,498 Reviews
1,823,172 Students
26 Courses

Summary:

  • Over 16 years of extensive experience in Data Analysis, Data Visualization, MIS Reporting, and developing macro systems across multiple tools.
  • Certified Tableau Developer with more than 9 years of expertise in Tableau Desktop and Tableau Site Admin.
  • Coordination at various levels to ensure timely project delivery.
  • Proven track record of initiating and implementing process improvement initiatives to enhance related processes.
  • Possess strong critical thinking abilities and communication skills, with proficiency in quickly grasping and utilizing new concepts effectively.

Overall Career Overview:

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.

Certificate of Recognition:

  • Received SPOT Recognition Award for exceptional performance in project delivery.
  • Recognized with Certificate of Recognition for demonstrating cooperative and collaborative behavior.
  • Received a Thank-You Letter from the Head of Department for dedication, technical expertise, and successful implementation of new initiatives.
  • Peer Recognition for Outstanding Teamwork Contributing to our success.
  • Recognized by Peers as a valuable colleague.
  • Appreciated for Developing Macro Systems to streamline processes and increase efficiency.
  • Consistently praised by higher management for achieving 100% accuracy in dashboards and ad-hoc reports.

Areas of Expertise:

Data Analytics MIS Data Visualization Excel Power Query Power Pivot VBA Macros Python Tableau Power BI SQL

Professional Experience:

  • ScatterPie Analytics Pvt. Ltd. – Delhi, India
  • Ericsson Global India Ltd. – Noida, India
  • OTSi Pvt. Ltd. – Noida, India
  • Future Retail Pvt. Ltd. – Gurgaon, India
  • Overseas Outsourcing Solutions Pvt. Ltd. – Gurgaon, India
  • Salient Business Solution Pvt. Ltd. – Gurgaon, India
  • Tech Mahindra – Noida, U.P.

Professional Experience in Diverse Industries:

Retail (Apparels/Food Chain/FMCG/Footwear), E-Commerce, NBFC, Electric Vehicle (EV) Industry, Manufacturing.

Academic Credentials:

The highest educational qualifications include a Master of Computer Application (MCA) and a Master's degree in English Literature (MA).

Student Reviews

5.0

Total 3 Ratings

  • 5
    3 Ratings
  • 4
    0 Rating
  • 3
    0 Rating
  • 2
    0 Rating
  • 1
    0 Rating

A
Anonymous
1 year ago

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.

A
Anonymous
5 years ago

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

Course Information

₹ 5000
  • Course level:
    Intermediate
  • Instructor:
    Sonu Pandey
  • Lesson: 10
  • Duration: 5 h
  • Last Updated:
    Nov 17, 2024

Material Includes

  • Videos
  • Articles
  • Downloadable Resources

Requirements

  • Basic computer skills
  • Interest in VBA

Tags

  • Excel
  • Advance Excel
  • VBA

Target Audience

  • Beginners/Intermediate in VBA
2024 © All Rights Reserved | Designed and Developed by NewAceAnalytics