Live Batches
Masterclasses
Menu
Free Courses
Account
Login / Sign Up

SQL Server 2022 Workshop for Beginners

21st-24th Nov 2023
8:00PM IST to 9:30PM IST
2 Hours
Live Session
1,007
Registered
FREE
No Cost
Shailendra Chauhan
Shailendra Chauhan

Microsoft MVP, Founder & CEO at ScholarHat

Overview

Welcome to the "SQL Server 2012 Workshop for Beginners/Freshers." This workshop is tailored to provide participants with a strong foundation in SQL Server, focusing on T-SQL various concepts like commands, joins and queries. Our primary goal is to empower beginners and freshers with the essential knowledge and competencies required to harness the power of SQL Server.

Agenda

Day 1: Getting Started with SQL Server

  • Introduction to SQL Server
  • Setting up the SQL Server for database management
  • SQL Keys and their real-life use cases.
  • SQL Commands

Labs: Creating a table, Creating various SQL Keys on a table, Altering the SQL table schema

Day 2: T-SQL with SQL Server

  • SQL Data Types, Variables
  • Control Flow Statements
  • SQL Query
  • SQL Clauses
  • SQL Predicates

Labs: Writing Control flow program in SQL Server, Writing Various SQL Queries to get data from Employee Table

#Project 1: Create a database for ECommerce Website

Day 3: SQL Joins

  • Types of SQL Joins
  • Inner Join
  • Outer Join: Left Outer and Right Outer
  • Cross Join
  • Self-Join

Labs: Writing various Join Queries on Adventures Database for getting sales and order details.

#Project 2: Building Food Delivery Website Database

Day 4: Stored Procedures and Functions

  • Stored Procedures in SQL Server
  • Need for Stored Procedures
  • Functions in SQL Server
  • Types of SQL Server Functions

Labs: Writing Stored procedure for fetching data fast, Creating function for doing intermediate calculation

What you will get?

  • Get Started from zero to learn SQL Server.
  • Build fun mini-apps, and share them with your friends.
  • Submit your apps to qualify for level 1.

By the end of this workshop, you'll be equipped with the tools and techniques needed to confidently work on SQL Server. Join us on this exciting journey and unlock the power of SQL Server.

About Speaker

Speaker image

Shailendra Chauhan (Microsoft MVP, Founder & CEO at ScholarHat)


He is a renowned Speaker, Solution Architect, Mentor, and 11-time Microsoft MVP (2016–2026). With expertise in AI/ML, GenAI, System Design, Azure Cloud, .NET, Angular, React, Node.js, Microservices, DevOps, and Cross-Platform Mobile App Development, he bridges traditional frameworks with next-gen innovations.

He has trained 1 Lakh+ professionals across the globe, authored 45+ bestselling eBooks and 1000+ technical articles, and mentored 20+ free courses. As a corporate trainer for leading MNCs like IBM, Cognizant, and Dell, Shailendra continues to deliver world-class learning experiences through technology & AI.

Learners who made the switch

4.7 Average Reviews

Shailendra sir has in-depth and sound knowledge of .NET and related stack. His way of conducting sessions and handling doubts/queries is awesome. And the staff are awesome they are eager to help that’s sounds Great. All the assignments and videos are also very helpful to enhance .NET knowledge. I would like to thank ScholarHat for providing training on the Advanced Full Stack .NET and grooming my career for future perspective.
Sameer Vyas Sameer Vyas Technical Lead at Wipro

I have joined the Full Stack .NET Development Training to upgrade web technologies skills and It was a great experience getting training with ScholarHat. Thanks to Trainer for his simple and effective technique of teaching. He is a very experienced and knowledgeable professional. ScholarHat provides the best course material and content. Video recordings are helpful for the revision of sessions, and videos are more understandable for clearing the concepts for doing practice thoroughly. ScholarHat Faculty is very cooperative and always ready to help us. I strongly recommend ScholarHat !!
Priyanka Kulkarni Priyanka KulkarniTechnical Lead at Lumedx

The training was absolutely superb and I genuinely enjoyed each and every moment of it. The content of Mastering MERN Stack was extremely informative and incredibly useful. I have attended several trainings before but I can't recall any of them having such a strong impact. You have done a wonderful job and I appreciate your efforts. ScholarHat staff is well-mannered and cooperative, they humbly pay attention to each professional and sort out everyone’s issues. I will surely recommend this training to all my colleagues and friends. I, myself, would love to attend future training organized or featured by you.
Tanuj Khurana Tanuj Khurana Software Engineer at Prometric

After joining the Full Stack .NET Developer Training, I enhanced my professional skills with the current technology in the market. The trainer has very rich technical knowledge and is very professional. He answered all the queries raised during the training. ScholarHat Faculty organized the online course very well. The online This was the best online course I have ever attended. After completion of each course, they are updating the online recorded videos & PPT materials available to us on the same day. I recommend this course to anyone who wants to become a master in .NET in a short span of time.
Rajesh Ramachandran Rajesh RamachandranSr .NET Consultant

I have learnt more new things from this training that enhanced my coding skills. Apart from my training, I have got knowledge for new technology that frequently changes in the IT industry. The Trainer Provides Training Very well. I am learning a lot of new things from him. And all staff of DNT are good. They are very helpful. With the help of real-time project theory concept has been clearer. The way of teaching is excellent. Definitely, I received all the information that was helpful for me.
Sandeep kumar Sandeep kumarSoftware Developer at Chipsoft India
Hi! Need Help?
Chat with us on WhatsApp
×