Soft Skills

After completing this course, students will be able to:

  • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts
  • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types
  • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered)
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints
  • Determine appropriate single column and composite indexes strategies
  • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure
  • Read and interpret details of common elements from execution plans
  • Design effective non-clustered indexes
  • Design and implement views
  • Design and implement stored procedures
  • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses
  • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues)
  • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency
  • Use both traditional T-SQL error handling code and structured exception handling
  • Design and implement DML triggers
  • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server
  • Store XML data and schemas in SQL Server
  • Perform basic queries on XML data in SQL Server
  • Work with the GEOGRAPHY and GEOMETRY data types
  • Implement and query a full-text index
Email This Page to a Friend
module by Spiral

Associate Microsoft Trainer

Associate with Nexgenn

As a Microsoft Certified Learning Partner we have a commitment to our customers to provide the highest level of training standards possible. To this end we continue to seek out talented individuals with a natural flair for communicating technical subject matter to a wide variety of audiences.

With customers both here in the UK and Europe, we deliver classess in native english covering a wide spectrum of products.

We are always looking to add to our existing portfolio of trainers. You must already have achieved your MCT qualification and have some commercial training delivery experience. Perhaps you may have already chosen a specialist subject to focus on such as Microsoft SharePoint Server, SQL Server, System Center, Exchange Server or generalise in Windows Server – We’d like to hear from you.

In the first instance please send us your CV to our Human Resources department. Please also include a link to your online transcript.

Need to know more about our associate program, give us a call on 0845 600 6061