This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and
This two-day course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
After completing this course, students will be able to:
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
Lumify Group was previously known as DDLS Group. We help business and enterprise customers turn change into opportunity through instructor-led, vendor-certified, IT and process training.
Developed in partnership with the world’s leading tech vendors and delivered by industry-accredited experts, our courses are pragmatic, future-focused and real-world ready.
From cybersecurity to cloud computing, AI to agile, our award-winning trainers deliver cutting-edge content to over 20,000 students online, in classrooms and in workplaces, every year.
This five-day instructor-led course provides delegates with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
This course introduces the principles of database definition, design, access and implementation.
The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic select statement, the use of SQL functions, and the basic table and view handling statements are introduced.
This training course is designed for developers who need to create applications to analyze Big Data stored in Apache Hadoop using Pig and Hive.
Provides students with the necessary knowledge and skills to manage the complexity of software systems. It introduces systems development process concepts and activities, with a strong focus on understanding the problem and solution through modelling using structured Systems Analysis and Design .
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy