Querying Data with Transact SQL
This course is a piece of the MS Professional Program Certificate in Big Data and the MS Professional Program Certificate in Data Science.
$99.00
This course is a piece of the MS Professional Program Certificate in Big Data and the MS Professional Program Certificate in Data Science.
More Information:
- Learning Style: On Demand
- Provider: Microsoft
- Difficulty: Intermediate
- Course Duration: 30 Hours
- Course Info: Download PDF
- Certificate: See Sample
Need Training for 5 or More People?
Customized to your team's need:
- Annual Subscriptions
- Private Training
- Flexible Pricing
- Enterprise LMS
- Dedicated Customer Success Manager
Course Information
About This Course:
This course is a piece of the MS Professional Program Certificate in Big Data and the MS Professional Program Certificate in Data Science.
Transact-SQL is an important expertise for data developers and professionals functioning with the databases of SQL. With this arrangement of master demonstrations, instruction, and practical labs, start from your first statement of SELECT through to executing the logic of the transactional program.
Function through numerous modules, every one of which investigates a key zone of the language of Transact-SQL, with attention on modifying and querying information in Azure SQL Database or Microsoft SQL Server. In this course, the labs utilize a modest database that can be deployed effectively in the Database of Azure SQL, so you get hands-on involvement in Transact-SQL without configuring or installing a server of the database.
Course Objective:
- Make the queries for Transact-SQL SELECT
- Perform with subqueries and APPLY
- With the use of JOIN, query multiple tables
- Function with NULL and data types
- Sets group and pivot data
- Explore set operators
- Use aggregate data and functions
- Program with Transact-SQL
- Utilize table expressions
- Investigate set administrators
- Modify data
- Execute error handling and transactions
Audience:
- Developers
- Programmers
Prerequisite:
A fundamental comprehension of databases and IT frameworks.
Outline
Credly Badge
Reviews
Write Your Own Review
Customer Reviews
-
Querying Data with Transact SQLOverall course was very useful and informative regarding manipulation of data with SQL Queries.
Posted on
-
GreatExcellent course
Posted on
-
Challenging!I consider this course as ADVANCED! Even though the first sections are basic stuff, the more you go - the more challenging it is including programming, stored procedures, etc.
Posted on
-
Challenging!I consider this course as ADVANCED! Even though the first sections are basic stuff, the more you go - the more challenging it is including programming, stored procedures, etc.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLMahesh was a great instructor. The course overall felt a little fast there is so much to cover I have worked 7-10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked 7-10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLinstructor was outstanding and patient because instructor was able to solve many of the outdated materials within the course that simply did not work I have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLGood flow of course. Polite and respectful. Very Knowledgeable. Demo's were presented very well. Was able to resolve everyone's issues nicely. I have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLsome time when the instructor provide real life experience it takes a while for the story to be finished. the instructor add new slide or make changes a long the way which is good but the book does not have the changes and it would be nice to have the changes to review on after class is over I have worked 1-3 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLVery knowledgeable and patient. I have worked over 10 years in the IT industry when taking this training. I have rated this class as outstanding in terms of the knowledge and skills gained from taking it.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLThe instructor seemed very knowledgeable. He moved a little fast for ME. Jumped around a bit so following along was challenging however I am not sure that is HIS issue or the way the syllabus is layed out. Again he is very knowledgeable. I have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLHe was an excellent instructor and a very nice person. I have worked 5-7 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLPaul was great! I have worked over 10 years in the IT industry when taking this training
Posted on
-
Querying With Transact SQLI have worked over 10 years in the IT industry when taking this training.
Posted on
-
Querying With Transact SQLI have worked 5-7 years in the IT industry when taking this training.
Posted on
