21st-24th Nov 2023 (8:00PM IST to 9:30PM IST) 1007 (Registered Users)
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 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 Intensive Live Job-Oriented Programs
Advanced Full-Stack .NET Developer Certification Training
Dear Shailendra Sir, this training helped me lot for improving my skills and I also learn so many new technologies. During training, I got hike in my current company. Shailendra Sir doing a great job and he explains every topic briefly, it’s very helpful to clear so many doubts. Yes, I also want to learn new technology in future from Shailendra Sir. Thank you Very Much Sir.
Nitish Gugnani
(Asstt. Programmer )
It was a great learning experience at ScholarHat. I am totally satisfy with their teaching practices. The trainer's was well informative and tried his level best to trained us. The support staff was also very quick, whenever we need any assistance. All the best ScholarHat
Varun Gupta
(Software Consultant and IT Trainer)
I really have an amazing experience with ScholarHat. It helps me to explore MVC and other different technologies like Angular 2 & 4, Web API, LINQ and Bootstrap Etc. It's an honor to practice these technologies under the guidelines of Mr. Shailendra Chauhan, who has encouraged our work and motivated us to learn APS.NET MVC. I gained much knowledge from ScholarHat and now I'm flexible enough to work for this technology.
Abhishek Kumar
(Software Engineer at Zenesys)
I have attended the ASP.NET MVC Development Training program from ScholarHat. I have improved my skills and knowledge. He gives some really simple examples to explain the complicated scenarios. I am satisfied with course and its content. again i want to say thank you very much ScholarHat , thanks ScholarHat staff for your cooperation.
Manu Mishra
(Software Engineer )
I have attended Shailendra Sir class for Asp.Net MVC with Angular2 & 4 He cleared many concepts of MVC and Angular and also tells us about the real life scenario where you can use these concepts. He answers whatever questions are raised during training course by students. He never gets irritated. I have cleared many basic concepts of web application development also.. which are very necessary to know when you are gradually moving to bigger companies. I have attended many training session but this training is different than others and i think more beneficial than others. I recommend professionals to join this training session.