Webzone - All things tech tips web development: SQL

Background

Break News

How to add local font to Tailwind Css and NextJS? - Tutorial Design Pattern? - Blockchain Technology, How to create own Bitcoin virtual currency - Zustand mordern management state - Design Pattern - Flyweight Pattern? - Docker Full training Topic

SLUG GENERATOR TOOL

INPUT STRING: (Article title, tutorial title or any web page title)

COLOR SUGGESTIONS

Showing posts with label SQL. Show all posts

Showing posts with label SQL. Show all posts

[Tips] How to "Monitor Data Changes in SQL Server Tables with Triggers"

Monday 7 August 2023

Vi Ly (Zidane)

Comment:

SQL Server is a powerful and popular relational database management system that supports various data operations. However, sometimes you...

[DevOps] How to create a Docker Compose file for MSSQL Database Service

Microsoft SQL Server

Monday 19 September 2022

Vi Ly (Zidane)

Comment:

Hello everyone, welcome back to Learn Tech Tips Blogspot . I am Zidane (大家好，我是雞蛋🥚🥚) Nice to meet you back. Today I will show you how to c...

[Database InnoDB Engine] Some knowledge useful when working with MySQL Database - InnoDB Engine

Friday 29 April 2022

Vi Ly (Zidane)

Comment:

👋👋 Hello everybody, Today I will share with you some basic knowledge you should know when working with MySQL database 😁 Do you know what ...

[Tips] How to "mapping SQL DataType with .NET C# data Type"

Microsoft SQL Server

Saturday 11 August 2018

Vi Ly (Zidane)

Comment:

Today I'll show you how to mapping SqlDataType vs .NET C# data type! Ref: https://msdn.microsoft.com/en-us/library/...

[Microsoft SQL Server Tips] How to get TOP n rows on database use Microsoft SQL Server

Microsoft SQL Server

Sunday 5 August 2018

Vi Ly (Zidane)

Comment:

Topic to day!!! How to get TOP n rows on database use Microsoft SQL Server Hello everyone, welcome back to Learn Tech Tips channel, I am Zid...

[Tutorial] Registration form in PHP with MySQL database

Friday 22 May 2015

Vi Ly (Zidane)

Comment:

Registration form in PHP with MySQL database Registration form is one of techniques should know for web developer when you need t...

[PHP] How to prevent SQL injection with PHP

Sunday 5 April 2015

Vi Ly (Zidane)

Comment:

SQL injection is a type of attack that allows malicious users to execute arbitrary SQL commands on a database, potentially compromising i...

[Tips] How to Set an Instance of SQL Server to Start Automatically

Microsoft SQL Server

Thursday 8 January 2015

Vi Ly (Zidane)

Comment:

Sometimes, your need to set an Instance of SQL Server to Start Automatically I’ll show you how yo set an instance of SQL Server to start...

[Tips] Dump Microsoft SQL Server database to an SQL script

Microsoft SQL Server

Vi Ly (Zidane)

Comment:

Good Morning Everybody, Today i walkup early and will show you an topic which many people is mention it. That is how to dump SQL S...

What are you looking for?

Way to become FullStack developer

1. Backend

1.1 PHP ( CakePHP Mangento Laravel)

2. Frontend

2.1 Basic ( HTML CSS Tailwind CSS)

4. Database

Microsoft SQL Server

5. Design Pattern

Singleton Pattern

Composite Pattern

Flyweighr Pattern

Facade Pattern

Adapter Pattern

Template Method

Builder Pattern

As a student, I found Blogspot very useful when I joined in 2014. I have been a developer for years . To give back and share what I learned, I started Webzone, a blog with tech tips. You can also search for tech tips zidane on Google and find my helpful posts. Love you all,

I am glad you visited my blog. I hope you find it useful for learning tech tips and webzone tricks. If you have any technical issues, feel free to browse my posts and see if they can help you solve them. You can also leave a comment or contact me if you need more assistance. Here is my blog address: https://learn-tech-tips.blogspot.com.

My blog where I share my passion for web development, webzone design, and tech tips. You will find tutorials on how to build websites from scratch, using hot trends frameworks like nestjs, nextjs, cakephp, devops, docker, and more. You will also learn how to fix common bugs on development, like a mini stackoverflow. Plus, you will discover how to easily learn programming languages such as PHP (CAKEPHP, LARAVEL), C#, C++, Web(HTML, CSS, javascript), and other useful things like Office (Excel, Photoshop). I hope you enjoy my blog and find it helpful for your projects. :)

Thanks and Best Regards!

Follow me on Tiktok @learntechtips and send me a direct message. I will be happy to chat with you.
Webzone - Zidane (huuvi168@gmail.com)

WebDevZone

I'm developer, I like code, I like to learn new technology and want to be friend with people for learn each other

I'm a developer who loves coding, learning new technologies, and making friends with people who share the same passion. I have been a full stack developer since 2015, with more than years of experience in web development.

I enjoy learning new technologies, researching, and upgrading my current frameworks to the latest versions for better performance and security
I have strong skills in both backend and frontend development, with more advanced skills in backend. For backend, I'm good at PHP (especially CAKEPHP), NodeJS / NestJS, .NET C# (4.5), ASP.NET, Webservice, C++ 11, and lua script 4.0 5.0.
For backend, I'm good at PHP (especially CAKEPHP), NodeJS / NestJS, .NET C# (4.5), ASP.NET, Webservice, C++ 11, and lua script 4.0 5.0.
For frontend, I can work with HTML, CSS (TailwindCSS, bootstrap), Javascript ES6, JQuery, JS Framework, and NextJS
For database, I can work well with Mysql, SQL Server, PostgreSQL, and TypeORM.
Experienced working with RemoteThread, ASM byte code, Send Package, Send Key
I have experienced in using Aliyun Cloud Service (https://www.alibabacloud.com/): ECS, RDS (postgresQL).
I have experienced in building docker compose file: SQL, Redis, PHP8: https://learn-tech-tips.blogspot.com/2022/09/how-to-create-a-dockerfile.html
I have experienced in integrating with various payment gateways such as Paypal, Payme, AsiaPay, HANG SENG NTT Payment gateway (using CryptoJS.enc.Base64.stringify / base64_encode; CryptoJS.enc.Hex.stringify / bin2hex; CryptoJS.HmacSHA256 / hash_hmac, etc.)
I have used various technologies such as Restful API, WebService, Process, WindowForm, Window Message, GraphQL, Network, Multi-thread, I/O Read Write File, Synchronous and Asynchronous, Inject DLL, Hook, Window Message, File, MFC, Firebase Push Notification, JWT authentication
I have knowledge of obfuscation .net source code and reverse engineering.
I understand basic Assembly language (ASM) to compile engine code.
I can create websites and single page applications with PHP (Cakephp 2+/ 4+ framework)
I can use shell script in Linux.
I have basic skills in Android for Java and Swift IOS development
I have experienced in uploading apps to Google Play.
I can use Photoshop for image editing, coloring, background decoration, banner, logo, etc.
I have experienced in using Figma for design.
I can manage source code with Git and SVN.
I can communicate well in written English.
I can communicate well in spoken/written Chinese (Cantonese/mandarin).
I can set up servers using VPS (Virtual Private Server) and use Nginx for config balancing (Ip_hash, least_conn), IIS, Apache.
...
This is a brief introduction of myself and my skills. If you want to know more about me or my projects, please feel free to contact me or visit my blog. Thank you for reading

Copyright @2022(November) Version 1.0.0 - By Webzone, all things Tech Tips for Web Development Zidane

https://learn-tech-tips.blogspot.com