learn sql

  • DISTINCT keyword in SQL

    DISTINCT keyword in SQL

    the distinct keyword in sql is used in conjunction with the select statement to remove all duplicate records and retrieve only records.
  • Sort results in SQL

    Sort results in SQL

    to sort data in sql, we use the order by clause.
  • The clause to combine JOIN data in SQL

    The clause to combine JOIN data in SQL

    in sql, the join clause is used to combine records from two or more tables in a database using common values ​​from each table.
  • INNER JOIN in SQL

    INNER JOIN in SQL

    inner join in sql is the most important and often used join type.
  • LEFT JOIN in SQL

    LEFT JOIN in SQL

    the left join in sql is the type of join that returns all records from the left table and matching records from the right table.
  • RIGHT JOIN in SQL

    RIGHT JOIN in SQL

    right join in sql is a type of join that returns all records from the right side table and matching records from the left side table.
  • FULL JOIN in SQL

    FULL JOIN in SQL

    full join in sql returns all records in the left table and the table must combine and fill in that null values ​​for values ​​do not match.
  • CARTESIAN JOIN in SQL

    CARTESIAN JOIN in SQL

    cartesian join in sql returns the cartesian product of record sets from two or more combined tables.
  • NULL value in SQL

    NULL value in SQL

    null in sql is the term used to represent a missing value.
  • Create a temporary name using ALIAS in SQL

    Create a temporary name using ALIAS in SQL

    sql alias is used to create a temporary name (called an alias) for a column or table.
  • Index (INDEX) in SQL

    Index (INDEX) in SQL

    sql index (index) is a special lookup table that database search engines can use to quickly increase the time and performance of data retrieval.
  • ALTER TABLE statement in SQL

    ALTER TABLE statement in SQL

    the alter table statement in sql is used to add, delete, and modify columns in an existing table.
  • Boolean operators AND and OR in SQL

    Boolean operators AND and OR in SQL

    the and and or operators are used to combine multiple conditions to narrow the data in sql statements. these two operators are called conjugate operators in sql. and and or allow multiple comparisons with other operators in the same sql statement.
  • [QUIZ] Test your understanding of SQL - Part 1

    [QUIZ] Test your understanding of SQL - Part 1

    sql is a familiar term if you pay attention to the computer field. so what do you know about sql?
  • [QUIZ] Check your understanding of SQL - Part 2

    [QUIZ] Check your understanding of SQL - Part 2

    continue series what do you know about sql? , part 2 continues with questions that revolve around basic knowledge in databases.
  • [QUIZ] Test your understanding of SQL - Part 3

    [QUIZ] Test your understanding of SQL - Part 3

    the test set comes with sql lessons that give you lots of useful knowledge.
  • [QUIZ] Test your understanding of SQL - Part 4

    [QUIZ] Test your understanding of SQL - Part 4

    let's try our knowledge with multiple choice questions about sql database management system.
  • [QUIZ] Test your understanding of SQL - Part 5

    [QUIZ] Test your understanding of SQL - Part 5

    multiple-choice questions on sql help you familiarize and review useful knowledge for work and learning sql language.
  • How to Learn PHP and MySQL

    How to Learn PHP and MySQL

    php is one of the most widely-used programming languages on the internet, and it allows you to do much more than simple html. mysql allows you to easily create and modify databases on your server. used together, these tools can create...
  • Learn about SQL Injection and how to prevent it

    Learn about SQL Injection and how to prevent it

    sql injection is one of the types of web hacking by injecting sql query / command codes into input before transferring to the web application, you can login without a username and password, remote execution (remote execution), dump data and retrieve the root of sql server.
  • Learn about Non-relational Database - NoSQL

    Learn about Non-relational Database - NoSQL

    nosql is gradually emerging as a force in the programming world. in this article, quantrimang will give an overview of nosql, the difference between traditional and nosql sql as well as the most outstanding features about nosql. invites you to read the track.
  • Learn about the architecture of MS SQL Server

    Learn about the architecture of MS SQL Server

    in the previous articles, you already know briefly about sql server, how to install sql server on the computer. in this section we will learn about the architecture of sql server.
  • To learn about SQL and databases, do not ignore these 23 online resources

    To learn about SQL and databases, do not ignore these 23 online resources

    if you intend to learn about sql and databases, you should not ignore these 23 online resources. these websites will provide you with basic and advanced knowledge of sql and databases.
  • Learn about the role concept in SQL Server

    Learn about the role concept in SQL Server

    in any database management system, security and security are always top priority. and with sql server, if we take advantage of the many advantages of this application, those who manage the system administration will greatly reduce the burden as well as the pressure on the job.