SQL Statements
Adds one or more new rows to a table
What is INSERT?
Microsoft's flagship tool for working with SQL Server.
What is SQL Server Management Studio (SSMS)?
A ______ combines columns from two or more tables into a result set based on the conditions you specify.
What is a join?
The first step in designing a data structure?
Statement that creates a new database.
What is CREATE DATABASE?
What DML stands for.
What is data manipulation language?
A graphical tool that you can use to start and stop the database server.
What is SQL Server Configuration Manager?
To join data from two tables, you code the names of the two tables in the ______ clause.
What is the FROM clause?
The fourth step in designing a data structure is to identify the _____ key and the _____ keys.
What are the primary and foreign keys?
What is ALTER TABLE?
Changes one or more existing rows in a table.
What is UPDATE?
These can be used to illustrate the relationships between the tables in a database.
What are database diagrams?
You can use temporary table names called _________ to make your queries shorter and easier to read
What are table aliases?
The formal process you can use to separate the data in a data structure into related tables.
What is normalization?
______ sets and encodings map a numeric code to each character.
What is character?
DDL allows you to work with ______ in the database.
What are objects?
To view the data for a table, expand the Tables node, right-click on the table, and click __________
What is Select Top 1000 Rows?
A join condition can include two or more conditions connected by _____ or ____ operators.
What are AND or OR operators?
When it uses an ______ , SQL Server can go directly to a row rather than having to search through all the rows until if finds the ones you want.
What is an index?
A _____ determines how character data is stored in a server, database, or column and how that data can be sorted and compared.
What is a collation?
Retrieves data from one or more tables.
What is SELECT?
To execute a SQL statement, press the F5 key or click the _______ button in the toolbar.
What is the Execute button?
Unlike an inner join, an ________ join returns all of the rows from one or both tables involved in the join, regardless of whether the join condition is true.
What is an outer join?
A database is typically considered to be normalized if it is in ______ normal form.
What is third normal form?
These determine the actions a user can take on a bases object, a database or a server.
What are permissions?