Differences

no way to compare when less than two revisions

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+<button type="primary" size="xs" icon="glyphicon glyphicon-bookmark">[[programming_lagugages| Programming Language]]</button>
+====== SQL ======
+<data programminglanguage>
+Full Name: Structured Query Language
+Short Name: SQL
+Description: Domain-specific language used in programming and designed for managing data held in a relational database management
+Company: ISO/IEC
+Web: No
+Mobile: No
+Enterprise: Yes
+Embedded : Yes
+</data>
+<accordion>
+<panel title='What is SQL?'>
+SQL (Structured Query Language) is a standard programming language used to manage and manipulate data in relational databases. It is used to create, modify, and query databases, and is commonly used in web development, data analysis, and other applications.
+</panel><panel title='What are some popular relational database management systems (RDBMS) that use SQL?'>
+Some popular RDBMS that use SQL include MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, and SQLite.
+</panel><panel title='What is a database schema?'>
+A database schema is a blueprint for a database that defines the structure of the tables, fields, and relationships within the database. It provides a framework for organizing and storing data, and is a fundamental concept in database design.
+</panel><panel title='What is a query in SQL?'>
+A query in SQL is a request for data from a database. It is typically used to extract specific information from one or more tables, and can involve filtering, sorting, and joining data.
+</panel><panel title='What is a join in SQL?'>
+A join in SQL is a method for combining data from two or more tables based on a common field or set of fields. There are several types of joins in SQL, including inner join, left join, right join, and full outer join.
+</panel><panel title='What is normalization in database design?'>
+Normalization is the process of organizing data in a database to eliminate redundancy and reduce data inconsistencies. It involves breaking down a database into smaller, more manageable tables, and establishing relationships between the tables.
+</panel><panel title='What is an index in SQL?'>
+An index in SQL is a data structure that improves the speed of data retrieval operations on a database. It is typically used to speed up queries that involve searching or sorting data, and can significantly improve database performance.
+</panel><panel title='What is a transaction in SQL?'>
+A transaction in SQL is a sequence of database operations that must be completed as a single unit of work. Transactions ensure data consistency and integrity by guaranteeing that either all of the operations in the sequence are completed, or none of them are. Transactions are used to implement the ACID (atomicity, consistency, isolation, durability) properties of a database.
+</panel><panel title='What is a stored procedure in SQL?'>
+A stored procedure in SQL is a precompiled block of SQL code that is stored in a database and can be executed multiple times. Stored procedures are commonly used to encapsulate complex database operations, and can improve performance by reducing the amount of data that is sent between the database and the application.
+</panel></accordion>
+{{wp>SQL}}
+<callout type="" title="GitHub Topics" icon="fa fa-github">
+  * https://github.com/topics/sql
+SQL stands for structured query language. It uses commands such as "select", "insert", "update", "delete". Some common relational database management systems that use SQL are: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, etc.
+</callout>
+<jumbotron>
+===== Hello World =====
+<sxh sql>
+Declare @Output varchar(16)
+Set @Output='Hello, world!'
+Select 'Output' = @Output
+</sxh>
+<WRAP column right><wrap lo>Source: [[https://en.wikibooks.org/wiki/Computer_Programming/Hello_world|Wikibooks]]</wrap></WRAP>
+</jumbotron>
+See also: [[dev:programming_lagugages]]
+{{tag>programminglanguage dev-db}}