This module introduces the usage of Transact-SQL, the SQL flavor used in the Microsoft SQL Server. The attendees will go through various features of Transact-SQL, along with practical exercises in designing and creating databases, inserting, updating and querying data, as well as in creating and executing stored procedures, triggers and indexes. As an end-result, the attendees are expected to be able to have all the necessary knowledge to work with databases in a Transact-SQL (Microsoft SQL Server) environment.
Introduction to databases / database design (database, relational database, RDBMS, database systems, SQL, SQL flavors, data integrity, Transact-SQL)
Common SQL statements (SELECT, INSERT, UPDATE, DELETE, JOIN, DISTINCT, UNION)
Advanced topics and concepts (stored procedures, table aliases, querying multiple tables, joins and functions, views, set operations, subqueries, indexes, triggers)
All Emerge trainings can be conducted in different locations globally, in customer offices, shared facilities, Emerge-provided training centers, online or through other means, depending on the requirements of the training participants.