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

Mr. Shailendra is very experienced and highly competent. I attended a .NET course under his guidance. His presentation is confident and extremely perceptive of the various existing skills and he knows well about the latest technology trends in the market and needs of his audience. I would like to thank him and congrats for his initiative. I want to suggest if you need the best in your career go with ScholarHat.

Rajneesh Joshi

(UI Developer)

It was very good experience. I have enrolled for Azure Developer Certification Training. Top quality of training by Mr. Shailendra Chauhan Project Implementation was superb!. Join this place for quality training.

Mayank Agarwal

(Sr. Software Engineer )

My experience with the Scholarhat has been phenomenal. The center has set a bar of expectation that I am not sure other centers would ever be able to meet! I learned so much, had fun, made friends and truly enjoyed time at the Scholarhat. I suggest you to update your project implementation skills.

Mahesh Verma

(Software Engineer)

There is no doubt about quality of Dot Net Tricks real time project base training. There project implementation is impressive that help me lot to develop my company project easily by this training, I have got confidence about where to implement what. If you have been facing problem in development you should try Scholarhat.

Pankaj Tiwari

(Software Engineer)

I have been working on ASP.NET for 2 years i was getting confusion while working on project. Due to that my performance was not up to mark, I was looking for some real time project based training, after lots of research I come to know about Scholarhat I have got training from there on real time project that overcome my technical confusion and it boost my package. You should also at list try ones.

Richa Dhimaan

(Senior Software Engineer )