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

I was looking to learn Asp.Net Core with Angular 2 &4 Development and then i start to search online training instituted and find Scholarhat. In my experience Scholarhat is the best place to learn new technology The instructor was very knowledge and it was an interactive session. And I am getting good co-ordination and helping on all the levels including mentor and Scholarhat also provide me job assistance. Thanks Scholarhat!

Nitin Mehta

(SOFTWARE DEVELOPER)

I was confused regarding which platform to choose to pursue my career after discussing with my facility and friends they suggest me to go with Asp.Net Core with Angular 2&4 real time project Development. So, start googling about online Course and then I found ScholarHat. I went through their sites read their testimonials and Feedback given by ex-students. Then I decided I’ll give the Institute a try. The Institute was fantastic what I loved about the Institute is real time hands on project development and their LMS so that I can learn about the course from anywhere and with any device. The Instructor is very encouraging and he also help me how to face Interview. Now I am very Confident that I am an Asp.Net Core with Angular Developer thanks to ScholarHat.

Gul Mohammad

(Software Developer)

Excellent online learning institute for technical training with Job Assistance. ScholarHat is the one of the best Institute to start first step in development career. I have taken Asp.net Core with Angular4 Development training from this institute and the learning path and skill assignment was the one of my favourite. Instructor will start the training from the basic level to the advance level. ScholarHat offer you the opportunity to start your career in development field with Asp.net Core and Angular 4 Development certification training program you can start your learning from scratch. I would definitely recommend ScholarHat for online training and job assistance.

Abhishek Kumar Upadhyay

(Team Leader, Dot Net Development Team at Indtech)

Scholarhat is one of the best online/ offline learning portals. I had enrolled for Mastering Asp.Net MVC5 with Angular4 certification. The trainer made the difficult topics very interesting he was very accommodating and put a lot of hard work to mark us understand the topics. Support team is also very prompt in solving any issue you are facing while doing the course. I would highly recommend Scholarhat to everyone who would like to brush up their skills or acquire a new skill set. Thanks Scholarhat!

Raushan Kumar

(Software Engineer)

These Days Technology is change at a fast pace. Becoming industry ready I Have to upgrade my skill to resolve challenging situation at job. One of my friend Recommended ScholarHat, but I am not convinced so I look into the website then I saw ScholarHat Course Content and Course Delivery management I was surprised then I Decided to join the Training Program. The one of best things about this training is LMS. I am really very happy with my Training that is now helping me in my appraisal. Thanks ScholarHat!!

Rajiv Singh

(Sr. Software Engineer at Pune)