SQL Server 2022 Workshop for Beginners

21st-24th Nov 2023 (8:00PM IST to 9:30PM IST)


Who is This Training For?
College Students
Freshers/Beginners
C#/.NET Aspirants
Freelancers/Solopreneurs
Women After a Career Gap
Anyone Looking for a Change

What You'll Learn?

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 YOUR INSTRUCTOR

Speaker image

Shailendra Chauhan (Microsoft MVP, Founder & CEO at Scholarhat by DotNetTricks)

Angular, Microsoft Azure, ASP.NET Core, React, Docker, Microservices Architecture, DevOps

Shailendra Chauhan is the Founder and CEO at ScholarHat by DotNetTricks which is a brand when it comes to e-Learning. He provides training and consultation over an array of technologies like Cloud, .NET, Angular, React, Node, Microservices, Containers and Mobile Apps development. He has been awarded Microsoft MVP 9th time in a row (2016-2024). He has changed many lives with his writings and unique training programs. He has a number of most sought-after books to his name which has helped job aspirants in cracking tough interviews with ease.

Our Students Reviews

Accept cookies & close this