DP-080T00: Transact SQL Querying

What You Will Learn

Use SQL Server query tools
Write SELECT statements to retrieve columns from one or more tables
Sort and filter selected data
Use built-in functions to returned data values
Create groups of data and aggregate the results
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.

Course Outline

Introduction to Transact-SQL

Understand what SQL is for
Identify database objects in schemas
Identify SQL statement types
Use the SELECT statement
Work with data types
Handle NULLs
Lab: Work with SELECT statements

Sort and filter results in T-SQL

Sort your results
Limit the sorted results
Return paged results
Remove duplicates
Filter data with predicates
Lab: Sort and filter query results

Combine multiple tables with JOINs in T-SQL

Describe join concepts and syntax
Write queries that use inner and outer joins
Write queries that use cross joins
Write queries that use self-joins
Lab: Query multiple tables with joins

Write Subqueries in T-SQL

Understand what subqueries are
Use scalar or multi-valued subqueries
Use self-contained or correlated subqueries
Lab: Use subqueries

Use built-in functions and GROUP BY in Transact-SQL

Categorize built-in functions
Use scalar functions
Use ranking and rowset functions
Use aggregate functions
Summarize data with GROUP BY
Filter groups with HAVING
Lab: Use built-in functions

Modify data with T-SQL

Insert data into a table
Generate automatic values
Update data in a table
Delete data from a table
Merge data based on multiple tables
Lab: Modify data

Mr. Mohammed Gufran

Cisco Instructor

Gufran, a Cisco Authorized and CCIE certified instructor, possesses more than 15 years of training mastery in Networking, Security, SDN, and many other advanced courses and technologies. With CCNA, CCNP, and many other diverse Cisco specializations, he's achieved CCIE Security (50220). From foundational concepts to complex Cisco networks & and security topics like Identity Service Engine, Web Security, Email Security, Firewalls, VPN, NGIPS, and NGFW, he's a seasoned instructor. He aptly managed global training projects, collaborating with esteemed institutions like the Bank of Tanzania, EMAL - Abu Dhabi, PIC - Kuwait, and many clients based in the US & and UK. His journey empowers organizations and individuals through roles ranging from Training Consultant to Senior Training Consultant, including contributions to content management and trainer evaluation.

Students	Feedback
Emanuel Paun United State	Mohammad was an amazing professor. I do not have a strong networking background and Mohammad was very patient in teaching me the basics in topics like wireless. The way he taught (hands on/labs) really helped solidify everything we learned through the 5 days of classes. I have nothing but positive feedback for the way he taught these course and his personality was amazing. 10/10 professor.
Shreyas Deshpande India	The training helped me connect dots and taught me a lot new concepts as well. The instructor is very knowledgeable in the subject and the demonstrations are very helpful for me to understand issues, and related solutions. I really appreciate and enjoyed the lectures and learning from instructor. Thank you very much!
Yeiner Carrillo United State	The BGP class was very interactive and pleasant, I personally liked the instructor's methodology. Thankyou
James Ferrell United State	Very cordial and great expertise,Courteous, knowledgeable, detail orientated Mohammed was an awesome instructor. very knowledgeable.
Jason Pope United State	The instructor was an outstanding; very personable and presented the material well. I liked the fact that he worked with us on the daily schedule which helped us take care of some crucial tasks here at the end of the year.
Paul Martinez United State	Mohammed was great, super flexible and took my pervious experience into account. His adaptability made the learning sessions engaging, and his consideration of my background knowledge significantly enhanced the learning process. Overall, a fantastic experience with a teacher who understands how to make learning both effective and enjoyable."
Asadullah Osmani Afghanistan	Gurfan, is a very Knowledgeable instructor and delivered the material professionally and was welling to explain and help with questions during the session.Great instructor vert knowledgeable and knew the topic very well and he very knowledgeable , i do recommend others to take courses with him.
Pramod Vidwat India	Has a good knowledge on the subject and more important we had a lot of labs to practice and get the concepts cleared.
Helder Mozambique	Is a great instructor, explains very well about the classes, very attentive, dynamic and very motivated, I learned a lot from him and I always hope to count on him during my I.T. careers, he is a excellent teacher.
Hirofumi Takemi Japan	It was an excellent course and I was very lucky to have you as my trainer. Thanks a lot. Hope to see you again somewhere sometime.
Stevenson Kiteculo Africa	What to say about the coach, I don't know where to start but I tell you, you have a big picture in your company, he helped me even in having motivation that everything is possible when you believe. He is a great teacher and a great person congratulations on you having him.It was a great pleasure to have you as a teacher, in fact he marked my life and I really want to be able to count on your future help, especially the teacher because thanks to him I was able to motivate myself and smile thinking about a great career all this was possible thanks to the efforts , attention and dedication he had to help me thank you very much
Mark Powell United States	I learned a lot. His method of teaching and the way he made sure I understand everything will prove well for me passing my test.
Emmanuel A Bankole Angola	I really appreciate this training, it has really impacted great knowledge and you are cool and perfect instructor if I have to be honest.

Students

Feedback

Emanuel Paun

United State

Mohammad was an amazing professor. I do not have a strong networking background and Mohammad was very patient in teaching me the basics in topics like wireless. The way he taught (hands on/labs) really helped solidify everything we learned through the 5 days of classes. I have nothing but positive feedback for the way he taught these course and his personality was amazing. 10/10 professor.

Shreyas Deshpande

India

The training helped me connect dots and taught me a lot new concepts as well. The instructor is very knowledgeable in the subject and the demonstrations are very helpful for me to understand issues, and related solutions. I really appreciate and enjoyed the lectures and learning from instructor. Thank you very much!

Yeiner Carrillo

United State

The BGP class was very interactive and pleasant, I personally liked the instructor's methodology. Thankyou

James Ferrell

United State

Very cordial and great expertise,Courteous, knowledgeable, detail orientated Mohammed was an awesome instructor. very knowledgeable.

Jason Pope

United State

The instructor was an outstanding; very personable and presented the material well. I liked the fact that he worked with us on the daily schedule which helped us take care of some crucial tasks here at the end of the year.

Paul Martinez

United State

Mohammed was great, super flexible and took my pervious experience into account. His adaptability made the learning sessions engaging, and his consideration of my background knowledge significantly enhanced the learning process. Overall, a fantastic experience with a teacher who understands how to make learning both effective and enjoyable."

Asadullah Osmani

Afghanistan

Gurfan, is a very Knowledgeable instructor and delivered the material professionally and was welling to explain and help with questions during the session.Great instructor vert knowledgeable and knew the topic very well and he very knowledgeable , i do recommend others to take courses with him.

Pramod Vidwat

India

Has a good knowledge on the subject and more important we had a lot of labs to practice and get the concepts cleared.

Helder

Mozambique

Is a great instructor, explains very well about the classes, very attentive, dynamic and very motivated, I learned a lot from him and I always hope to count on him during my I.T. careers, he is a excellent teacher.

Hirofumi Takemi

Japan

It was an excellent course and I was very lucky to have you as my trainer. Thanks a lot. Hope to see you again somewhere sometime.

Stevenson Kiteculo

Africa

What to say about the coach, I don't know where to start but I tell you, you have a big picture in your company, he helped me even in having motivation that everything is possible when you believe. He is a great teacher and a great person congratulations on you having him.It was a great pleasure to have you as a teacher, in fact he marked my life and I really want to be able to count on your future help, especially the teacher because thanks to him I was able to motivate myself and smile thinking about a great career all this was possible thanks to the efforts , attention and dedication he had to help me thank you very much

Mark Powell

United States

I learned a lot. His method of teaching and the way he made sure I understand everything will prove well for me passing my test.

Emmanuel A Bankole

Angola

I really appreciate this training, it has really impacted great knowledge and you are cool and perfect instructor if I have to be honest.

Your shopping cart