![]() A database index is a data structure that improves the speed of data retrieval operations on a database table.A query language is a computer language used to make queries (or questions about data) in databases and information systems.A database is a collection of schemas, tables, queries, reports, views and other objects.A database is an organized collection of data.Practice displaying and examining the database tables, columns and data.Read Microsoft: Manage Objects By Using Object Explorer.Watch YouTube: Exploring SQL Server Management Studio.In the Object Explorer, click on the AdventureWorks database to expand folders to display database structure:.In the E-R diagram, identify the displayed tables, columns and relationships.Read Microsoft: Open Database Diagram Designer (Visual Database Tools).Watch YouTube: SQL Server Database Diagram in SQL Management Studio.Create an Entity Relationship (E-R) diagram to display database relations:.Practice downloading either a database script or table script to identify DDL (use, create, alter, drop, truncate, delete) and DML (select, insert, update, delete, merge) commands.Read Microsoft: Generate a Script (SQL Server Management Studio).Watch YouTube: How to generate scripts for complete Microsoft SQL Server database (including data).Generate a script from the AdventureWorks database to view the database and tables scripts:.Practice learning how to use Microsoft SQL Server 2014 and SQL Server Management Studio on your computer.Read Tutorial: SQL Server Management Studio.Watch YouTube: Microsoft SQL Server 2014 - Introductory Tutorial.Install Microsoft Adventureworks Database in SQL Server on your computer.Download Microsoft: AdventureWorks Sample Database and SQL Server Script.Watch YouTube: Install Adventure Works 2014 Sample Database SQL Server 2014.Microsoft AdventureWorks Sample Database:.Install Microsoft SQL Server 2014 Express and SQL Server Management Studio on your computer.Download Microsoft: Microsoft SQL Server 2014 Express.Watch YouTube: How To Download and Install Microsoft SQL Server 2014 management studio.Set up an environment to learn about relational databases:.YouTube: SQL Server Management Studio Intro.Microsoft Virtual Academy: Introduction to Core Database Concepts.Understand what DML is and its role in databases.Understand data manipulation language (DML).Understand how T-SQL can be used to create database objects, such as tables and views.Understand data definition language (DDL).Understand what a table is and how it relates to the data that will be stored in the database columns/fields, rows/records. ![]() Understand how data is stored in tables.Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established.Understand relational database concepts. ![]() Objectives and skills for the database concepts portion of Microsoft Exam 98-364 Database Fundamentals include:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |