Lesson 1: Understanding Core Database Concepts Crossword

a subset of the Transact-SQL language, which deals with creating database objects like tables, constraints, and stored procedures
they are limitations or rules placed on a field or column to ensure that data that is considered invalid is not entered
the language element that allows you to use the core statements INSERT, UPDATE, DELETE, and MERGE to manipulate data in any SQL Server tables
an organized collection of data, typically stored in electronic format. it allows you to input, organize, and retrieve data quickly
most users do not access a database directly, instead they use this to access a database indirectly
databases are often found here so that they can be accessed by multiple users and provide a high level of performance
they are simplistic in design, and most commonly used in plain-text formats
they are similar to a tree structure, where each "parent" table can have multiple "children", but each child can have only one parent
a data structure that improves the speed of data retrieval operations on a database table
they are similar to another database in that data is stored in tables and any new information is automatically added into the table without the need to reorganize the table itself
a command-line application that comes with Microsoft SQL Server and exposes the management features of SQL Server. It allows SQL queries to be written and executed from the command prompt
it is the primary tool for managing the server and its databases using a graphical interface
these consists of rows and columns, where each column is referred to as a field and each row can be referred to as a record
the primary means of programming and managing SQL Server. This exposes keywords so that you can create and manage databases and their components and monitor and manage the server itself
a query and functional programming language that is designed to query collections of XML data