Giới thiệu
hocvietcode.com là website chia sẻ và cập nhật tin tức công nghệ, chia sẻ kiến thức, kỹ năng. Chúng tôi rất cảm ơn và mong muốn nhận được nhiều phản hồi để có thể phục vụ quý bạn đọc tốt hơn !
Liên hệ quảng cáo: trienkhaiweb@gmail.com
Introduction to Transact-SQL (T-SQL)
Introduction to Transact-SQL (T-SQL), introduces syntax, query concepts, Transact-SQL statement sequence, and SELECT clause
Introduction to Microsoft SQL Server
A basic introduction to Microsoft SQL server, the main components of this DBMS, and current versions.
Create and administer the database, create users in SQL Server
how to create and administer databases and users and assign database permissions to users in Microsoft SQL Server using T-SQL and SSMS
Common Table Expression (CTE) – Common Table Expression in SQL Server
Common Table Expression (CTE) Concept - Common Table Expression in SQL Server, how to use WITH clause to define CTE
Combine Data Using (SET OPERATORS) UNION, INTERSECT, and EXCEPT in SQL Server
Introducing a solution to combine data using SET OPERATORS (set operator), UNION, INTERSECT and EXCEPT operators in SQL Server
SQL Server Pivot and Grouping Set Operators
Introduction to SQL Server pivot concepts and unpivot, which change the direction of data when displayed to the user
Programming and control of flow in Transact SQL
Programming in T-SQL, introducing controls of flow SQL, IF...ELSE , CASE WHEN in SQL
Transaction in SQL Server
Introduction to transaction in SQL Server, commit transaction , rollback transaction, save transaction in SQL Server.
Subqueries (subqueries) in SQL Server
Subquery concept in SQL Server, nested subqueries concept, correlated queries in SQL Server
Step-by-step guide to installing Microsoft SQL Server and connecting to the database for beginners
How to install SQL Server 2019 and connect to CSQL step by step for beginners
Install NodeJS on windows environment
Instructions to install NodeJS on windows environment step by step, with detailed photos and video tutorials.
SQL Server GROUP BY clause
Introducing the GROUP BY clause in SQL Server, how to combine GROUP BY with WHERE, NULL, ALL , HAVING
Index in SQL Server
Introduction to index in SQL Server, explanation of clustered index, non-clustered index, unique index, columnstore index, filtered index, xml index, introduction to index
Fix error “The stream or file “laravel.log” could not be opened in append mode: failed to open stream: Permission denied ” Ubuntu/mac Os/Windows
I encountered this error when dealing with problems in the Mac Os environment, when I downloaded the laravel project and initialized it on the local environment for further development, because I was not familiar with the concept of decentralization in this environment, it took quite a while, so I write this article to guide you […]
ReactJS project initialization guide
Required environments nodejs npm yarn (recomend) Installation steps: After having the full environment, type the command By default reactJS will run port 3000 Ctrl+C to terminate the server’s service.
Constants in PHP and how to declare constants
Introduction to constants in PHP and how to define constants through the define() function. Introducing magic constants in PHP
Functions that work with strings in PHP
Introduce some built-in functions that work with string data type ( string ) in PHP and how to use
Expressions in AngularJS
Concept of expression in angualrajs and tutorial on using expressions, advantages and disadvantages of expression in angularjs
