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 from 5 learner reviews

I have taken class from Scholarhat it exceptionally changed my mind set and approach about development I can say that after getting training from Scholarhat I’m very much confident about my work whatever I’m doing because now I’m knowing what, where and how to implement things in my project, thanks Scholarhat for giving me in depth skills.
Parmanand Kumar Parmanand KumarSoftware Engineer

I have gone through Scholarhat blogs many times for learning AngularJS from that time, I was waiting for AngularJS training batch. I was confused before the training because I wanted to get training on real time project which they have delivered according to my expectation now I’m so much confident about AngularJS development.
vibhu mishra vibhu mishraSoftware Programmer

Scholarhat is a good training institute for learning real time projects. Our knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often. Mr. Shailendra always teaches latest technologies. So, I found its worth to learn in Scholarhat and coding actually becomes rhyme.
Manju Lata Yadav Manju Lata YadavSoftware Professional

Scholarhat is a good training company for real time Software Development. I have taken training over MVC Development with AgularJs. Mr. Shailendra Sir always teaches latest technologies. So, I found its worth to learn in Scholarhat and coding actually becomes rhyme.
Ajeet Singh Ajeet SinghSoftware Developer

I am Pushpendra Singh, Managing Director of Techsan India Technologies Pvt. Ltd. I am truly impressed with the quality of development training delivered by ScholarHat and their continued commitment to building strong and creative career paths for students. I highly recommend ScholarHat for Java and Spring Boot training. He is highly skilled, intuitive, dedicated, and genuinely cares about his students’ growth. His training approach is always aligned with the latest technologies and real-world industry requirements.
Puspendra Singh Puspendra SinghManaging Director
Hi! Need Help?
Chat with us on WhatsApp
×