About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Beginning T-SQL for SQL Server Developer, Data Analyst and DBA
Introduction
Course Contents Covered in this Course
Preview
What is a Relational Database
What is Relational Database Mananagement System
SSMS and SQL Server Database Engine
SQL Server and SSMS Installation
Basic T-SQL
Creating DB Tables & Inserting Data into the tables
Primary Key and Foreign Key
Demonstration Scripts
Basic Select Commands
Aggregate Functions with SELECT Command
Group By Clause using Single and Multiple Columns
Difference Between WHERE and HAVING Clause
Syntax of SELECT Command
T-SQL Joins to query SQL Server
Inner Join
T-SQL with Inner Join and Group By Together
Practice Activity
Demonstration Scripts
Left Right Full Cross Joins
Self Join
Union UnionAll Intersect Except Operations
Working with Schema
What is Schema and its Importance
Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL
SubQueries
Demonstration Scripts
Getting Started with first SubQuery Example
Common Interview Question on SubQuery
Joins Group by Derived table Subquery combined TSQL
SubQuery as a Column
SubQuery using NOT IN
ALL ANY SOME Keywords in SubQuery
Correlated SubQuery
Not Exists Keyword Scenario of Correlated SubQuery to speed up query performance
DataTypes
Demonstration Scripts
Datatypes
Datatype Conversion Implicit & Explicit -Type Casting
DML Operations and Contraints
Demonstration Scripts
Many Different Options while performing insert update and delete operations
Primary Key, Foreign Key, Unique, Not NULL, Default, Check Constraints
Joining more than two tables
Demonstration Scripts
Joining three tables
Joining four Tables
One more examples in joining four tables
Working with CASE Statements and Inbuilt Functions
Demonstration Scripts
Performing Select and Update operation using case statement
Explaining WHILE Loop in T-SQL
InBuilt Functions - EOMONTH,IIF, CHOOSE,DatePart,String Functions etc
Working with Schema
Beginning T-SQL for SQL Server Developer, Data Analyst and DBA
By:
Vikas Munjal
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
We'll cover the following topics in this section:
What is Schema and its Importance
Schema Creation & Transfer and Viewing the objects inside Schema using T-SQL
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts