Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get Training in SQL and Database Design

Amaratunga A.Status: Offline
Amaratunga A. Amaratunga A.
4.8
Preview imagePreview imagePreview imagePreview image

Let a pro handle the details

Buy Online Coding Lessons services from Amaratunga, priced and ready to go.
Amaratunga A.Status: Offline
Amaratunga A. Amaratunga A.
4.8
Preview imagePreview imagePreview imagePreview image

Let a pro handle the details

Buy Online Coding Lessons services from Amaratunga, priced and ready to go.

Project details

SQL Course Level I: Offering a Comprehensive SQL Course with Tutorials
========================================================
1. Installing SQL Server & SQL Server Management Studio
2. Quick Reference Guide
3. SQL Server Data Types
4. SQL Server/MySQL Syntax
5. Create, Modify, Delete, and List Tables using SQL Commands in SQL Server
6. Sorting with DESC and ASC in SQL Server/MySQL
7. Joining Two Tables in SQL Server/MySQL
8. Joining Three Tables in SQL Server/MySQL
9. Self Joins in SQL Server/MySQL
10. Using the WITH Statement in SQL Server
11. Understanding CROSS APPLY & OUTER APPLY in SQL Server
12. Aggregate Functions (MAX, MIN, AVG, COUNT, SUM) in SQL Server/MySQL
13. Using ISNULL in SQL Server
14. Conditional Statements in SQL Server
15. String Functions: RTRIM, LTRIM & TRIM in SQL Server
16. Using UNION in SQL Server/MySQL
16. SQL Server Functions
17. Stored Procedures in SQL Server
18. Views and Triggers in SQL Server
19. Sub Queries in SQL Server
20. Logical Operators (IN, ANY, ALL, >=, <=, AND, OR, NOT) in SQL Server/MySQL
21. Transactions in SQL Server
22. String Concatenation & Splitting in SQL Server
23. Understanding Collation in SQL Server
24. Practical Exercises
Lesson Purpose
Database
Student Age
Child (12 & Under), Teen (13-17), Adult (18-65), Senior (65+), Other
Development Technology
SQL, NoSQL
What's included
Service Tiers Starter
$15
Standard
$45
Advanced
$300
Delivery Time 3 days 7 days 30 days
Number of Lessons
1320
Lesson Length (Minutes)
40120800
Exercises & Supporting Materials
4.8
11 reviews
82% Complete
(9)
18% Complete
(2)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)

MR

Maanish R.
5.00
Mar 11, 2025
Seeking SQL Trainer for Beginner

AM

Alex M.
4.85
Apr 19, 2022
Communicating with OData v4 service using C# Did a good job at understanding the requirements and correctly interpreting ambiguities in the specification docs. Delivered code was easy to read.

MR

Maanish R.
5.00
Jul 1, 2021
Seeking SQL Trainer for Beginner 3 students class Lindul completed this contract successfully. He is excellent SQL instructor. I will hire him again. I highly recommend him.

ZT

Zakaria T.
5.00
May 16, 2021
Making changes to some windows forms, c#, sql server Very Good Developer, thank you.

JL

Justin L.
5.00
Oct 2, 2020
SQL Technical Writer Very good work delivered, with very detailed instructions, and super high quality !
Amaratunga A.Status: Offline

About Amaratunga

Amaratunga A.Status: Offline
Senior .NET Developer (Full-stack | Back-end | Desktop) + SQL Trainer
4.8  (11 reviews)
Seinaejoki, Finland - 5:09 pm local time
I am a Senior Developer having ✔️13+ years of software development experience including
✔️6+ years of Backend experience in C# ASP.NET Core, Web API & REST API Backend Services
✔️6+ years of Full stack experience in C# ASP.NET (Web Forms, MVC, Core) Web Applications
✔️6+ years of Desktop experience in C# Core WinForms, WPF Windows, Visual Basic & Reports
🎯 10+ Successful Upwork Projects ⏱ 250+ Upwork Hours Completed
👉 13+ Years Software Experience with USA, UK, Belgium, Australian & Sri Lankan Clients
👉 BTech Eng (Hon) in Computer Engineering

► TECHNICAL SKILLS
✔️ Backend [C#, .NET 9.0, ASP.NET Core, Web API, REST API, API Integration, Swagger, Node.js]
✔️ Frontend [ASP.NET Core MVC, Razor Pages, JavaScript, jQuery, HTML, CSS, Bootstrap]
✔️ Desktop [C#, .NET 9.0 Desktop Application (WinForms, WPF), Visual Basic, Crystal & RDLC Reports]
✔️ Databases [SQL Server 2022, Database Design, Stored Procedures, MySQL, PostgreSQL, MongoDB]
✔️ Design [Clean Architecture, MVC, Microservices, N-tire, Dependency Injection, Factory, Service/Repository, Request/Response patterns, DTO, SOLID, OOD, DDD, EF Code First, LINQ, AutoMapper, TDD, Agile, Waterfall]
✔️ Deploy [GIT Version control, Bitbucket, CI/CD Pipelines, Docker, Azure, AWS]
✔️ Quality Standards [Clean Code, Code Review, Unit Testing, Testing, Documentation, UML, Jira]
✔️ LLMs and Tools [Claude, GPT, Cursor AI, GitHub Copilot]
✔️ Electrical [Theoretical & Practical knowledge of electronics, electrical systems & power]

► SOFT SKILLS:
✔️ Analytical Problem Solving, Self-Motivation, Effective Communication
✔️ Time Manage, Teamwork, Leadership, Emotional intelligence (EQ)

► WORK EXPERIENCE
🎯 2019 - Now | Freelance Developer | Remote
✅ HR application for multiple companies (C# ASP.NET Core MVC & Web API)
✅ Successfully analyzed requirements, designed solutions & managed deployments on an HR system.
✅ Contributed to full-stack developments and testing with a team. Performed code reviews.
✅ • Utilized C#.NET 8.0, ASP.NET Core MVC, Web API, Razor Pages, Microsoft Identity, SQL Server 2022, jQuery, LINQ, RDLC Reports, EF, Clean Architecture, Dependency Injection, API Integration, HTML, CSS, DTO, SOLID, OOD, DDD, LINQ, AutoMapper, Agile
✅ Streamlined development processes with GIT, Bitbucket, CD/CD Pipelines, Azure integrations & Agile.

🎯 Software Engineer | January 2018 - December 2018 | Pulztec | Sri Lanka - On-site
✅ AI-driven digital human application for a premier bank in Sri Lanka (C# WPF & ASP.NET Web API)
✅ Contributed to WPF developments and backend developments with a team.
✅ Utilized C#, WPF, MVVM, MySQL, Web API, Artificial Intelligence, Google Speech API, & multithreading.

🎯 Senior Software Engineer | March 2017 - December 2017 | Jigsaw | Sri Lanka - On-site
✅ Backend services for a taxi-hiring Mobile App (node.js & MongoDB)
✅ Contributed to the backend design and development with a team.
✅ Utilized node.js, MongoDB, MySQL, REST API, JSON, Postman, OOD, multitier, GIT, Jira, and Heroku.

🎯 Senior Software Engineer | January 2007 - 2016 | Zeropoint | Sri Lanka - On-site & Remote
✅ During my nine years with this company, I worked on several projects in various capacities.
✅ Between 2013 and 2016, I was a Developer, Requirement Analyst, Designer and Team Leader on
the projects of developing an HR Management System and Factory Management System for a garment manufacturer with clients based locally and overseas.
✅ I utilized C# ASP.NET Web Forms, SQL Server, Stored Procedures, Crystal Reports and GIT.

✅ Between 2011 and 2012, I worked as a Developer, Requirement Analyst and Designer on a Medical Care Management System in Belgium.
✅ Technologies utilized included C#.NET WinForms, Multi-tier, SQL Server, and Stored Procedures.

✅ In 2010, I was a Developer, Designer and Team Leader on a Wholesale Distribution System in Belgium.
✅ Technologies utilized on this project included C#.NET WinForms, Multi-tier, and SQL Server.

✅ Between 2007 and 2009, I was involved with developing a Warehouse Management System in Belgium. I worked as Developer, Designer and Team Leader.
✅ Technologies utilized included C#.NET WinForms, Multi-tier, SQL Server and ADO.NET.

Steps for completing your project

After purchasing the project, send requirements so Amaratunga can start the project.

Delivery time starts when Amaratunga receives requirements from you.

Amaratunga works on your project following the steps below.

Revisions may occur after the delivery date.

Step 1

Start Online Session

Finish

Finish Online Session

Review the work, release payment, and leave feedback to Amaratunga.