Walking around any end user or technical department, auditors always find developments under way using the Microsoft SQL Server
...With the current explosion of data in today's enterprise environment, traditional methods of querying & reporting on information
...SQL Server is Microsoft's flagship database product & is a strong challenger to Oracle's long held dominant position as market
...Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications
...The objective of this course is to provide a comprehensive understanding of the advanced use of structured query language (SQL)
...This three-day instructor-led course provides students with the knowledge & skills to configure & administrate a complex Operations
...This course provides students with the knowledge & skills to design & author a professional management pack. The course is structured
...This five-day instructor-led course provides students with the knowledge & skills to managing a Systems Center Operations Manager
...This four-day instructor-led course provides students with knowledge & skills to install & configure System Center Service Manager.
...Elements of this syllabus may be subject to change.
This five-day instructor-led course provides students with the knowledge
...This course is aimed at SQL Server database developers, administrators and analysts who need a little bit more than SQL can do alone. SQL Server provides a powerful scripting language, Transact SQL, which enables developers to extend the capabilities
This course is aimed at SQL Server database developers, administrators & analysts who need a little bit more than SQL can do alone. SQL Server provides a powerful scripting language, Transact SQL, which enables developers to extend the capabilities of the SQL language. Using Transact SQL (TSQL) powerful scripts, stored procedures, functions & triggers can be produced to enable extracted information to be processed further, or to enable complex transformations of data prior to, during or after an insert, update or delete, or to implement automated updates & audit trails.
As well as looking at how to create & maintain scripts, stored procedures, user-defined functions & triggers this course will explore some of the additional TSQL features such as Views & Common Table Expressions (CTEs).
This training may be available onsite; please contact us if you are interested.