I need someone who is proficient with all topics of Microsoft sql server 2014. You will have to take an assessment.
Transactions and Locks evaluates knowledge in managing concurrent changes to SQL Server 2014 database data in a multi-user environment and how to use transactions and locking to optimize queries and prevent data errors.
Security and Permissions evaluates understanding of the SQL Server 2014 configurable security features such as impersonation, the surface area configuration tool, user-schema separation, and granular permission sets. Addresses topics such as user access, object permissions, database access and denial, and the SQL commands Revoke and Grant.
Database Design measures proficiency in fundamental, relational database concepts, including normalization and database design best practices in SQL Server 2014.
Queries, Subqueries, and Joins evaluates the understanding of data selection queries, subqueries and joins in extracting data from SQL Server 2014 databases.
Data Types and Convert/Cast tests knowledge about different SQL Server 2014 data types, including native data types for numbers, money, dates, characters and binary values and user-defined data types. Also includes how to change data types in Transact-SQL.
Performance, Tuning, and Optimization measures knowledge and skill to evaluate and improve SQL Server 2014 query response times and performance. Covers monitoring tools and the impact of indices and partitions on query performance.
Stored Procedures tests knowledge of stored procedure concepts and types available in SQL Server 2014 and proficiency in designing and implementing a stored procedure. Also covers the use of the TRY-CATCH block and the testing and debugging of stored procedures.
SQL Server Triggers measures knowledge of how to use and create triggers in SQL Server 2014.
User-Defined Functions tests knowledge to design and implement user-defined functions (UDF) in SQL Server 2014. This covers functions written and called in Transact-SQL.
Transact-SQL Data Definition Language (DDL) measures proficiency in working with SQL Server 2014 tables and views including the creation, update, insertion and deletion of values.
Keys, Constraints and Indexes measures proficiency in the use of primary keys, foreign keys, constraints, indexes, and referential integrity in SQL Server 2014.
Transact-SQL Data Manipulation Language (DML) tests understanding of the Transact-SQL language used to administer instances of the SQL Server 2014 Database Engine, manage database objects, and to insert, retrieve, modify, and delete data. Also covers support for recursive queries with Common Table Expressions (CTEs).
Transact-SQL Functions and Cursors tests knowledge of Transact-SQL language used to administer instances of the SQL Server 2014 Database Engine, built-in functions, and cursors.
12 freelancers are bidding on average $152 for this job
Hi I have 15 years of experience in SQL server Database development, architecture and performance tuning with power bi. I can help you with the project. please ping me offline to discuss further.