SQL Server 2022 Workshop for Beginners

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

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

---

Shailendra Chauhan, Founder and CEO of ScholarHat by DotNetTricks, is a renowned expert in System Design, Software Architecture, Azure Cloud, .NET, Angular, React, Node.js, Microservices, DevOps, and Cross-Platform Mobile App Development. His skill set extends into emerging fields like Data Science, Python, Azure AI/ML, and Generative AI, making him a well-rounded expert who bridges traditional development frameworks with cutting-edge advancements. Recognized as a Microsoft Most Valuable Professional (MVP) for an impressive 9 consecutive years (2016–2024), he has consistently demonstrated excellence in delivering impactful solutions and inspiring learners.

Shailendra’s unique, hands-on training programs and bestselling books have empowered thousands of professionals to excel in their careers and crack tough interviews. A visionary leader, he continues to revolutionize technology education with his innovative approach.

Our Students Reviews

View All

The online training in this course set a good foundation that can be applied practically. The online classes were brilliant and Mr. Shailendra took each class with lot of examples and explanations. his style of training was easily understandable and informative. The course was very useful for me to develop .net MVC, RAZOR framework and Web API applications. All sessions are interactive sessions, and Mr. Shailendra answered all the questions raised during the online training. The course fee is very nominal and the course really helps me in understanding the developing the .net Applications.

Emmanuel Job

(Sr. Consultant at The World Bank)

It was a very good experience to take training at Scholarhat. I got what i wanted to learn in MVC. The project that we completed during the training was very helpful. Shailendra Sir's teaching method is awesome. He has In-depth knowledge of technology and is very cooperative.

sunil yadav

(Sr. Software Developer )

It has been a great learning experience at Scholarhat  Trainer is quit professional and focuses on concepts until we gain the confidence. All the materials shared are good sources for any level of professionals. This session boosts my career and knowledge. From past few months I am eager to learn MVC 5. But I was confused. When I reached Scholarhat. I gained various technologies practical experience. I learned Angular 2 & 4 MVC5, Web API. I also got what is going on current development and future development of technology, I have got Vast experience and knowledge. But really I got what I wanted from Scholarhat. Thank you all thanks Scholarhat staff for your coordination, and your encouragement.

Rohit Singh

(Team Lead )

Dear Shailendra Sir, this training helped me lot for improving my skills and I also learn so many new technologies. During training, I got hike in my current company. Shailendra Sir doing a great job and he explains every topic briefly, it’s very helpful to clear so many doubts. Yes, I also want to learn new technology in future from Shailendra Sir. Thank you Very Much Sir.

Nitish Gugnani

(Asstt. Programmer )

It was a great learning experience at ScholarHat. I am totally satisfy with their teaching practices. The trainer's was well informative and tried his level best to trained us. The support staff was also very quick, whenever we need any assistance. All the best ScholarHat

Varun Gupta

(Software Consultant and IT Trainer)