other · 2023

Diving into <scp>SQL</scp>

Cited by 0Open access

Abstract

Diving into SQL SQL is designed as a universal language to manage data stored in a relational database management system.In this lesson, we will look at some of the features of SQL before jumping into using it heavily to manage data.This includes the topic of working with null values and how to use them in MySQL.We will also take a look at indexing. Learning ObjectivesBy the end of this lesson, you will be able to: Discuss the origins of SQL Demonstrate syntax features of core SQL, including the use of letter case, spaces, quotation marks, and semicolons Explain what a null value is in a dataset Add null values to a table Explain how relational databases use indexes to improve retrieval efficiency Identify design features that can affect indexes 10.

Cite this paper

APA 7

(2023). Diving into <scp>SQL</scp>. https://doi.org/10.1002/9781394320615.ch6

MLA 9

“Diving into <scp>SQL</scp>.” 2023, pp. 105–21, https://doi.org/10.1002/9781394320615.ch6.

Chicago

2023. “Diving into <scp>SQL</scp>.” https://doi.org/10.1002/9781394320615.ch6.

Harvard

(2023) ‘Diving into <scp>SQL</scp>’. Available at: https://doi.org/10.1002/9781394320615.ch6.

BibTeX

@misc{anon2023diving,
  title = {{Diving into <scp>SQL</scp>}},
  pages = {105--121},
  year = {2023},
  doi = {10.1002/9781394320615.ch6}
}

Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.