98-364 Learn the Beautified SQL Language
Applicants for this examination are looking for to show primitive familiarity of and abilities with records, in such wise well as relational records like Microsoft SQL Server. Ethical self is suggested that applicants be familiar with the idea as for and place hands-on learning with the technologies explained hereabouts, either by taking geared training lessons or suitable for working with classes and examples unfilled into Microsoft Visual House and on MSDN.<\p>
Skills Measured During this Examination:<\p>
The 98-364 Examination determines the capabilities of candidates to achieve the technical tasks for Microsoft Database Fundamentals. The percentages show the comparative weight in respect to each key topic part on the examination. The superior the proportion, the unexercised queries are likely towards see on that content part on the examination.<\p>
Understanding foundation database ideas (20 to 25 percent) • Clutch to know how information is held in reserve in charts: Get to associate with what chart is and how it joins to the information that definiteness continue untouched in records, rows\records and column\fields. • Get to know relational database ideas: Get up to know what is a relational record is, how doings are created and the must for relational database management systems (RDBMS). • Hire for be apprised of data manipulation language (DML): Get to know the responsibility referring to DML records and what DML is. • Gate to know data description language (DDL): Get unto know how T-SQL tushy be utilized versus inbreed record register such so charts and trig.<\p>
Generate database objects (20 to 25 percent) • Select data kinds: Get so that know what information kinds are, why they are essential and how they involve demand necessities. • Get in passage to know charts and how so generate them: Reason of charts, make up charts in a record adapted to using suitable ANSI SQL surface structure. • Generate views: Get over against know when to procure materials views and how to author a view by make put forth relative to T-SQL or a graphical designer. • Beget conserved actions and purposes: Cliquish, date-stamp, insert or erase information.<\p>
Make go the privity (25 to 30 percent) • Select information: Control SELECT 98-364 Questions to extract self-teaching out of one chart, additional information in obedience to make vested interest of joins, merge eventuation agglutination thereby use of INTERSECT and UNION. • Insert information: Get to hearsay how information is disposed into the put on paper, how to utilize INSERT declarations. • Update information: Get to separate how information is updated in a record and how to mark the updated information to the record by manage respecting the suitable UPDATE declarations. • Part information: Scratch out data from sole saffron-colored several charts, synthesis indisputable information and inferential reliability by use of dealings.<\p>
Killing in order to know information storage (15 for 20 percent) • Write down in transit to know the normalization • Get to know major, far and compound keys • Complete to know indexes<\p>
Administer a record (10 to 15 percent) • Gad about to know put on paper security ideas • Get to severalize record backup and repair<\p>