Developer Interview - JohnnyFoulds/firstrepo GitHub Wiki
This page contains some resources to prepare for a technical C# Developer position.
C# 5.0
Collections, Arrays and Generics
The use of the framework collection classes and the generic versions of these using C# 5.0.
Methods and Parameters
How methods are called in C# 5.0, including how parameters are passed and use of the void keyword.
Inheritance, Polymorphism and Interfaces
Object-oriented features of inheritance, polymorphism and interfaces using C# 5.0.
Error Handling
The mechanisms to handle errors, including exception handling, in C# 5.0.
Dynamic Programming
Reflection, generic covariance and contravariance, optional parameters and named arguments available in C# 5.0.
HTML5
HTML5 Local Storage
Checking for the availability of, and reading and writing to the Local Storage, Session Storage, and Client-Side Database facilities of HTML5.
HTML5 DOM
The Document Object Model interface, and manipulating the DOM using JavaScript.
JavaScript
Arrays and Collections
Arrays and collections and how JavaScript represents sets of related objects.
JavaScript Security and Client Side Data
Browser based JavaScript Security as well as persistent storage techniques on the client. Security issues such as same origin policy. Persistent storage techniques through the use of cookies in JavaScript.
SQL Server 2012
- SQL Server 2012 T-SQL Recipes (PDF) - http://dbmanagement.info/IT_Books/SQL_Server_2012_T-SQL_Recipes,_3rd_Edition_from_dbmanagement.info.pdf
Queries and Joins
Data selection queries, subqueries and joins in extracting data from SQL Server 2012 databases.
MSDN References
- Transact-SQL Reference [R] - https://docs.microsoft.com/en-us/sql/t-sql/queries/select-examples-transact-sql?view=sql-server-2017
Performance Tuning
Evaluate and improve SQL Server 2012 query response times. Monitoring tools and the impact of indices and partitions on query performance.
Transact-SQL Data Definition Language (DDL)
Working with SQL Server 2012 tables and views including the creation, update, insertion and deletion of values, and rows and columns including TOP.
MSDN References
- CREATE VIEW - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-2017
- CREATE TABLE - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-2017
- INSERT [R] - https://docs.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-2017
- UPDATE [R] - https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-2017
- DELETE - https://docs.microsoft.com/en-us/sql/t-sql/statements/delete-transact-sql?view=sql-server-2017
REST Web Services
Representational State Transfer (REST) style architecture, design and implementation for RESTful Web Services.