Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>Other IT & Software>Querying Microsoft SQL Server Databases using T-SQL
IT & SoftwareQuerying Microsoft SQL Server Databases using T-SQL
Price:Paid
Length:4.5 hours
Content type:video
level:beginner
Updated:05 March 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>Other IT & Software>Querying Microsoft SQL Server Databases using T-SQL
Querying Microsoft SQL Server Databases using T-SQL
3.3 (55.0)
4.5 hours
55 students
What you will learn
1Learn how to setup Microsoft SQL Server
2Learn how to connect to SQL Server using SSMS
3Learn how to install sample database
4Learn how to create a new Database
5Learn how to create a new Table
6Learn how to insert data into a Table
7Learn how to Update existing Database Data
8Learn how to delete Data in Database
9Learn how to query data using aggregate functions
10Learn how to extract and join data from multiple Tables
11Create Transact-SQL queries
Target audiences
1Beginners to SQL Server
2Beginners to using Transact-SQL
3Beginners to SQL Server Database Administration
Requirements
1A Computer and Internet access required.
2Basic knowledge of SQL advised but not mandatory
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Description

Microsoft SQL Server is one of the most popular and widely used relational database management systems (RDBMS) in the world.


T-SQL is Microsoft’s own version of the standard SQL language used to query Microsoft SQL Server Databases.  Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organisations.

In this course you will Learn how to setup an SQL Sever environment as well as connect to and query the database using SQL Server Management Studio also known as SSMS.  You will learn how to install the adventureworks2014  sample database  which we will use for this course .You will learn to query one or many different tables using SELECT statements and also about Aliases and why they are used. You will learn about the various types of tables joins used to get data from multiple tables.

You will be able to Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures , Update database content with SQL and transaction handling and Retrieve data with filter conditions and from multiple tables using various types of join

What you learn  include:


Writing SELECT queries
Write Transact SQL Queries
Table Joins
Aliases
Null Values
Query Multiple Tables


This is a hands-on practical course that is taught at a pace that you can follow along easily.


I look forward to welcoming you to the course.

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>Other IT & Software>Querying Microsoft SQL Server Databases using T-SQL
IT & SoftwareQuerying Microsoft SQL Server Databases using T-SQL
Price:Paid
Length:4.5 hours
Content type:video
level:beginner
Updated:05 March 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>Other IT & Software>Querying Microsoft SQL Server Databases using T-SQL
Querying Microsoft SQL Server Databases using T-SQL
3.3 (55.0)
4.5 hours
55 students
What you will learn
1Learn how to setup Microsoft SQL Server
2Learn how to connect to SQL Server using SSMS
3Learn how to install sample database
4Learn how to create a new Database
5Learn how to create a new Table
6Learn how to insert data into a Table
7Learn how to Update existing Database Data
8Learn how to delete Data in Database
9Learn how to query data using aggregate functions
10Learn how to extract and join data from multiple Tables
11Create Transact-SQL queries
Target audiences
1Beginners to SQL Server
2Beginners to using Transact-SQL
3Beginners to SQL Server Database Administration
Requirements
1A Computer and Internet access required.
2Basic knowledge of SQL advised but not mandatory
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Description

Microsoft SQL Server is one of the most popular and widely used relational database management systems (RDBMS) in the world.


T-SQL is Microsoft’s own version of the standard SQL language used to query Microsoft SQL Server Databases.  Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organisations.

In this course you will Learn how to setup an SQL Sever environment as well as connect to and query the database using SQL Server Management Studio also known as SSMS.  You will learn how to install the adventureworks2014  sample database  which we will use for this course .You will learn to query one or many different tables using SELECT statements and also about Aliases and why they are used. You will learn about the various types of tables joins used to get data from multiple tables.

You will be able to Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures , Update database content with SQL and transaction handling and Retrieve data with filter conditions and from multiple tables using various types of join

What you learn  include:


Writing SELECT queries
Write Transact SQL Queries
Table Joins
Aliases
Null Values
Query Multiple Tables


This is a hands-on practical course that is taught at a pace that you can follow along easily.


I look forward to welcoming you to the course.

Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot