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

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

(Sr .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

(Software Developer at Chipsoft India)

This training helped me to learn ASP.Net MVC and Angular Development Program to develop web applications in more efficient way. I got what I was looking for, basically to learn Typescript. Training quality is excellent and the trainer also has good Teaching skills to teach each and every topic, well explained. Real-Time project Development helped me for basically the payment gateway process and AngularJS integration with MVC. The ScholarHat Staff is very supportive and provides all the help that we used to be required.

Ashutosh Trivedi

(Sr. Software Developer.)

This training helped me a lot in terms of improving my skills for learning New technologies. I enhanced my skills through the latest and most popular skills. Training material is very helpful and given in strategic way & whenever we require any help they are always with us. The process of providing training by the Trainer is excellent. With this training, I improved my problem-solving skills. Yes, I was looking for a hike and I did it due to ScholarHat. Thank you Sir thank you all.

Sandeep Shukla

(Sr. Software Engineer.)

The trainer has a profound understanding and knowledge on the subjects he chooses to teach. ScholarHat Faculty has been utterly helpful. Staff members are supportive and motivating too. Just beyond expectations!! Training touches upon on all the topics talked about in a particular course curriculum without giving any of them a miss. The training is a great deal to accomplish a particular skill-set in your profile as the training covers all the important aspects and topics of the technology one needs to know to have a good understanding of that technology. I am sure it will be of immense help and importance to my career from ScholarHat.

Shweta Talraj.

(Sr. Software Developer.)