Find Jobs
Hire Freelancers

Sql server 2014 Programmer

$30-250 CAD

Închis
Data postării: circa 3 ani în urmă

$30-250 CAD

Plata la predare
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.
ID-ul proiectului: 29467465

Despre proiect

11 propuneri
Proiect la distanță
Activ: 3 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
11 freelanceri plasează o ofertă medie de $155 CAD pentru proiect
Avatarul utilizatorului
Hello , How are you? I just saw your project description carefully. I am very interested in your project. I have rich experience in SQL. I am ready to start your project immediately. I am sure I can satisfy you surely and complete in a short time. Please send your message so that we can discuss about your project.
$100 CAD în 7 zile
4,6 (59 recenzii)
4,8
4,8
Avatarul utilizatorului
Hello I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient way.I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable and all its usages. I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems. I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management. I am looking for long term stable remote work and good client with not only work but good values also. I can join immediately.
$278 CAD în 5 zile
5,0 (5 recenzii)
3,4
3,4
Avatarul utilizatorului
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.
$30 CAD în 15 zile
5,0 (3 recenzii)
2,0
2,0
Avatarul utilizatorului
I have gone through the job description and I am a senior web and app developer having more than 5 years of experience in the field of website development. I can develop and design the website for you as per your requirements with the full functionality. My expertise is Node JS, React JS, Angular JS, Vue JS, Codeigniter, WordPress, PHP, Magento, Shopify, Bootstrap, Woo-commerce MySql: Responsive theme development, Ecommerece, API’s Integration, Backup and Restore at a different domain, React Native, Android, iOS and a lot more. I need to discuss your project in detail with you so that I can assist you much better. I will be available more than 40 hours per week and able to start your project as soon as possible according to you. Thank you for your consideration Abhishek
$120 CAD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
$140 CAD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I have experience +7 years with MS SQL > T-SQL I worked in financial system and work with complex queries
$30 CAD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Microsoft certified technology specialist having 13+ years of experience in SQL server design and development
$215 CAD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hi, I am a senior SQL Developer, having 6+ years of experience. I have worked on different areas of SQL and its services. I have worked on small to large scale products like VUE, PaperSave, Banking domain, etc. • 6+ Years experience as a SQL Developer where I have worked on Database Architecture, Stored Procedures, Triggers, Views, Cursor, XML-SQL Operations, JSON-SQL Operations, Query optimization & migration, etc. • 2+ Years experience as a SQL DBA where I have worked on various types of Backups, Restoration, Security, High Availability, Replication, SQL Jobs, etc. • 5+ Years experience in SSRS where I have configured SSRS and worked on different types of report like Tabular, Matrix, Drill Down, Chart, Live report, KPI Reports, etc. • 1+ Year experience in SSIS • 1+ Year experience in Azure SQL • 1+ Year of experience in Mongo DB • 1.5+ Year experience in Azure Cloud & Windows administration • 2+ Year of experience in PowerShell • 1+ Year of experience in .Net Core application If you find my profile is suitable for your project then please accept my proposal and let's work together. Thanks & Regards, Rajvi Sanghvi
$250 CAD în 2 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul CANADA
Vancouver, Canada
0,0
0
Membru din mar. 4, 2021

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.