Most company data doesn't live in Excel. It sits in a database, and someone has to ask for it. If you can write SQL, that someone is you. Analysts who know SQL pull their own numbers, check them, and build reports without sending a request to IT and waiting two days.
You practise on a sales database with customers, orders, products and employees. Every topic ends with questions like "which 10 customers bought the most last quarter?" that you answer in SQL. Choose the 25-hour course for a full foundation, or the 40-hour package if you also want window functions, query performance, SQL with Power BI and Python, and interview preparation.
SQL comes up in almost every data analyst, MIS and BI interview. The test is usually short: join two tables, group by month, filter the top 5. People who can do this quickly stand out, because many candidates know Excel but have never touched a database.
No coding background needed. If you can use Excel filters and SUM, you can learn SQL. Most of our students start from zero.
Want SQL with Excel and Power BI? The Data Analytics with AI programme covers all three. You can also pair this course with Advanced Excel or Power BI.
Building web apps? Our MongoDB course covers the NoSQL database used with Node.js and React.
Learning C#? Our C# (.NET) course connects C# apps to SQL Server with ADO.NET.
What a relational database is, tables, rows and columns, and why companies use databases instead of spreadsheets. Installing SQL Server Developer Edition and SQL Server Management Studio (SSMS). Creating your first database.
Practice: Set up the course sales database on your laptop.
Data types, CREATE TABLE, ALTER, DROP. INSERT, UPDATE, DELETE and TRUNCATE. Primary keys, foreign keys, UNIQUE, NOT NULL, CHECK and DEFAULT constraints.
Practice: Build Customers, Products and Orders tables with correct keys.
SELECT, WHERE, AND/OR, IN, BETWEEN, LIKE, IS NULL, ORDER BY, TOP, DISTINCT and column aliases.
Practice: 20 questions on the sales data, such as "orders above ₹10,000 from Delhi in March".
String functions (LEN, LEFT, RIGHT, SUBSTRING, REPLACE, CONCAT, TRIM, UPPER, LOWER), date functions (GETDATE, DATEADD, DATEDIFF, DATEPART, FORMAT, EOMONTH), numeric functions, CAST and CONVERT, ISNULL and COALESCE, CASE WHEN.
Practice: Clean customer names and calculate delivery days for every order.
COUNT, SUM, AVG, MIN, MAX. GROUP BY, HAVING, and grouping by month and year.
Practice: Month-wise and region-wise sales summary.
INNER, LEFT, RIGHT, FULL OUTER, CROSS and self joins. Joining 3–4 tables. UNION, UNION ALL, INTERSECT and EXCEPT.
Practice: Product-wise sales with customer city and salesperson name.
Subqueries in WHERE, FROM and SELECT. Correlated subqueries. Common Table Expressions (WITH). Creating and using views.
Project: A sales reporting database with 5 saved views that answer the monthly management questions.
ROW_NUMBER, RANK, DENSE_RANK, NTILE. Running totals and moving averages with SUM() OVER. LAG and LEAD for month-on-month change. PARTITION BY.
Practice: Top 3 products in each region and month-on-month growth.
Stored procedures with input parameters, user-defined functions, IF/ELSE and WHILE in T-SQL, TRY...CATCH error handling, BEGIN TRAN, COMMIT and ROLLBACK, and simple triggers.
Practice: A stored procedure that returns the sales report for any date range.
Clustered and non-clustered indexes, reading an execution plan, why some queries are slow, and simple fixes. Basics of normalisation.
Practice: Speed up a slow report query and compare the before and after time.
Exporting results to Excel, connecting SQL Server to Power BI, running a query from Python with pandas, and using ChatGPT or Copilot to draft and explain queries. How to check an AI-written query before you run it on real data. Common SQL interview questions with practice.
Project: A Power BI report built directly on your SQL Server views, plus a mock SQL interview.
Pay a small amount now to hold your seat. Pay the rest when you join.
Takes about a minute
EMI and No Cost EMI are offered by Bajaj Finance and Payment Gateway Partners. They depend on Bajaj Finance approval, admin approvals, documents and terms.
Data Analyst
SQL Developer
MIS Analyst
BI Analyst
Reporting Analyst
Database Support Executive
Business Analyst
Operations Analyst
Extra 10% off on the spot admission.
Get 50% off on MDA Program
View Details
Learn AI with real projects - Get 40% off on AI Courses
View Details
Become a Tax & Accounting Pro - Extra 10% off on CEA Program
View Details
Start Building for the Web - Extra 10% off on Full Stack Program
View DetailsYes. SQL reads close to plain English: "SELECT name FROM customers WHERE city = 'Delhi'". We start with installation and simple queries, and move on to joins once the basics feel easy.
Package 1 is 25 hours and covers tables, queries, functions, GROUP BY, joins, subqueries, CTEs and views, with one project. Package 2 is 40 hours and adds window functions, stored procedures, query performance, and using SQL with Excel, Power BI, Python and AI tools, plus a mock interview. Choose Package 2 if you are preparing for data analyst or SQL developer interviews.
The basics are the same in both: SELECT, WHERE, JOIN and GROUP BY work almost identically. This course uses Microsoft SQL Server and T-SQL because many Indian companies use it alongside Excel and Power BI. Once you know SQL Server, switching to MySQL or PostgreSQL takes a few days.
No. SQL Server Developer Edition and SQL Server Management Studio are free to download. We help you install both in the first class.
Yes. Classes run in the classroom in Delhi, Gurgaon and Ghaziabad, and live online, with weekday, evening and weekend batches. Call +91 98188 45002 (Ghaziabad: +91 92203 99033) or WhatsApp +91 99903 49899 for the next batch date.
Yes. SQL Server is taught inside Data Analytics with AI, together with Advanced Excel, Power BI and Python, depending on the path you pick. This course covers only SQL, in 25 to 40 hours: tables, SELECT queries, joins, grouping, subqueries, views and CTEs. Take it if you need to pull and check data from a database at work. Take the full course if you also want to build reports and dashboards.
2,800+ student ratings on Google, Justdial & UrbanPro.
Real words from learners who trained with F1 Macro Technologies.
I joined this data analyst coaching and it was really helpful. The teacher explained every concept in a simple and clear way. The classes covered Excel, SQL, Power BI, and Python with real examples. Doubt sessions were great, and I got personal help whenever needed. Best for beginners who want to start a career in data analysis
Sahil Panwar
Data AnalyticsF1 Macro is Referred By My Friend After That I Join the Classes for Data Analysis Course My Excel Class is Complete Good To Understand, Power BI Class is Running, Excellent To Understand the Classes Of Power BI from Rohit Sir, Advance Excel, SQL, VBA and Python By Krishna Sir All Doubt are Clear at Same time. Thanks
Ankur Pandey
Data AnalyticsHello I'm Vivek Yadav...I have enrolled master of data analytics thanks for giving me the opportunity to be a part of F1 macro. I have learned a lot from here which I am gonna cherish all my life .. thank you so much teachers for your kind support.
Vivek Yadav
Data Analytics - MDAThe institute has amazing and supportive faculty members. They provide with multiple assignments along with study material as well as resolve any queries related to the assignment. I highly recommend F1 Macro Technologies for anyone looking to build a strong foundation in data analysis.
Divya R Nair
Data AnalyticsI have just completed my Data Analyst Training from F1 Macro Technology, Delhi. I enjoyed my training over there. The course was designed by experts and not only theory but hands on experience was good in class. Each and every concept was taught from the basics. They covered all the aspects which will help you in Future.
Tarun Gupta
Data Analyst Training | Placed in MNCI have done MCCA course from F1 Macro and I am lucky because I got a good and supportive teaching staff here. Now I got a job in India's biggest IT company Telus International - all thanks to the entire team of F1 Macro Technologies.
Ali Jawad Zaidi
MCCA + Data Skills | Placed at Telus InternationalHi, I am Amit from Bangalore. I have attended Data Analytics basic tools like Excel, SQL, Python, Power BI from F1 Macro Technologies and I can proudly say one should go for their courses as the faculties and the study materials are really good.
Amit Prakash
Data Analytics (Excel, SQL, Python, Power BI)My name is Mukesh Goyal from Jaipur. It's a wonderful platform for good learning. I really learnt from F1 Macro Technologies courses - SQL Server, Advance Excel, Power BI, VBA, Python. Overall good experience. Thanks to all staff and management for this opportunity to learn and earn.
Mukesh Goyal
Data Analytics + ML | Career Switcher from JaipurMy name is Ankur Sharma, and I live in Gandhi Nagar, Delhi. I enrolled in the Data Analyst course at F1 Macro technologies Institute Laxmi Nagar, and my experience has been very positive. The institute provides highly knowledgeable and supportive teachers who explain concepts clearly and help students understand even complex topics with ease. They are always available to solve doubts and provide guidance whenever needed. One of the best things about the institute is the digital notes and study materials, which make learning more convenient and effective. The course content is well-structured and industry-oriented, helping students build practical skills in Data Analytics. I would highly recommend F1 Macro Institute to anyone looking to learn Data Analyst and improve their technical skills in a supportive learning environment.
Ankur Sharma
Data AnalyticsI am Avinash Singh, currently pursuing the Data Analytics course at F1 Macro Technologies. The training is well-structured, and the instructors explain concepts clearly. The hands-on projects and practical approach have helped me improve my skills in Excel, SQL, Power BI, and Data Analytics. I highly recommend this institute to anyone looking to build a career in data analytics.
Avinash Singh
Data AnalyticsGuides and career stories from our trainers and students.
Accounting
Financial Accounting: A Beginner-to-Job-Ready Guide
Learn the basics of accounting: the main rules, Profit and Loss, Balance Sheet, Cash Flow, the accounting cycl...
Read article
Web Design
Web Design: The First Impression of Every Business
Your website is often the first thing a customer sees. See what web designers build, the skills they need and...
Read article
Data Analytics
Data Analyst: The Rising Power of Data
Businesses now plan sales, stock and hiring from data. See what a data analyst does each day, the tools they u...
Read article
Check your eligibility and apply online.
12th pass
For 12th Passed in Current & Previous Year
Apply Now
Commerce & arts
For College Students in B.Com / BBA/ B.A/ M.Com/ MBA/ M.A
Apply Now
IT & computers
For College Students in BCA/ BSC (IT), B.Tech, MCA, MSC (IT), M. Tech
Apply Now
Special support
For Students with Disabilities & Economically Weaker Section (EWS)
Apply Now
We do not own these logos. Company names and logos belong to their owners. We show them only to mark where our students got jobs. F1 Macro Technologies is not a partner of these companies and is not endorsed by them.
Learners from our placement records, now working in the roles they trained for.
Placed
Placed
Placed
Placed
Placement assistance helps you prepare and apply; it is not a job guarantee.
See how F1 Macro Technologies is bridging the gap between education and employment. Explore where our students are working today.
to understand your profile and plan the next career move!
Call us+91 98188 45002
We use cookies to understand how people use our site and to improve our ads. You can accept all, reject the optional ones, or choose. Privacy Policy
