Introduction To Transact-SQL (SQL Server Training)

by Interface Technical Training Claim Listing

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.

$2295

Contact the Institutes

Fill this form

Advertisement

Interface Technical Training Logo

img Duration

4 Days

Course Details

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.

You’ll gain a foundation understanding of a SQL Server database and use the tools available to discover the database definition, submit queries and view results.

We teach students how to write a query the same way that SQL Server processes a SQL statement – following a step-by-step process for creating SQL queries from business requirements. This approach uses the natural way of breaking down a problem into logical steps. Each step can be validated before moving to the next step. This differs from most courses, which present SQL as a set of features.

Class lectures highlight and explain Transact-SQL concepts which are reinforced with extensive follow-along demonstrations and hands-on labs.

You Will Learn:

  • Use the SQL Server Management Studio tool to browse the definition of the database, find necessary object names, create database diagrams, and execute a SQL query to return data rows.
  • Write a simple SELECT statement, returning all the columns and rows and formulate meaningful join strategy to bring together all necessary data.
  • Write a WHERE clause to filter the rows based on equality, a list of values, a range of values and a wildcard character condition.
  • Understand the impact on filtering based on implicit data conversions using data type precedence and how to create a proper search argument.
  • Control the display of data in a SQL SELECT including renaming columns, using simple expressions with function to change output values, conditionally change the output values using CASE expressions, sort the result set, eliminate duplicate rows and control the number of rows returned.
  • Write Transact-SQL queries that aggregate values across rows based a group and filter the result set based on aggregated values.
  • Encanto Village Branch

    3115 N 3rd Ave G130, Encanto Village, Phoenix, AZ

Check out more SQL Server courses in USA

ONLC Logo

MySQL Training

MySQL is an open-source relational database management system (RDBMS). Many Fortune 500 companies have adopted MySQL to reap the benefits of an platform-independent open source RDMS.

by ONLC [Claim Listing ]
Business Computer Skills Logo

MySQL Querying Fundamentals

The MySQL Querying Fundamentals class teaches students the fundamentals of how to write MySQL statements and perform simple queries of a database. Students will learn the core skills needed to access and manipulate data from MySQL databases. This course covers MySQL version 8.0.

by Business Computer Skills [Claim Listing ]
NYIM Training Logo

SQL (Level I)

Learn the fundamentals of relational databases and begin writing SQL queries to extract data from databases. Learn how SQL is used within relational database management systems. Connect to SQL Server and write queries with conditions.

by NYIM Training [Claim Listing ]
Kanshe Infotech Logo

SQL Developer

SQL Developer course training is offered by Kanshe Infotech for all skill level. We offer individual and corporate training in various technologies as well as technology functions through our Training arm Kanshe University. 

by Kanshe Infotech [Claim Listing ]
  • Price
  • Start Date
  • Duration
Austin Community College Continuing Education Logo

Oracle Certification

Oracle is a world's largest enterprise software company and the Oracle certification carries significant weight throughout the software industry.

by Austin Community College Continuing Education [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy