MCSA Querying Microsoft SQL Server 2012 (Exam 70-461) Required Knowledge for SQL Server 2012 and 2014
Lesson Files: http://www.informit.com/content/images/9780789753984/downloads/Code_70-461.zip More than 12 hours of video instruction on Querying Microsoft SQL Server 2012 to help you pass the MCSA Querying Microsoft SQL Server 2012 (70-461) exam Learn the ins and outs of SQL Server in this practical...
| Otros Autores: | |
|---|---|
| Formato: | |
| Idioma: | Inglés |
| Publicado: |
Pearson IT Certification
2014.
|
| Edición: | 1st edition |
| Colección: | LiveLessons
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630035506719 |
| Sumario: | Lesson Files: http://www.informit.com/content/images/9780789753984/downloads/Code_70-461.zip More than 12 hours of video instruction on Querying Microsoft SQL Server 2012 to help you pass the MCSA Querying Microsoft SQL Server 2012 (70-461) exam Learn the ins and outs of SQL Server in this practical video tutorial. MCSA/MCSE Exam 70-461 Querying Microsoft SQL Server 2012 LiveLessons is a unique video product that provides a solid understanding of querying SQL Server 2012, a necessity for database administrators and developers and required knowledge for certifications on Microsoft SQL Server 2012 and 2014. Transact-SQL (T-SQL) is the main language used to manage data on Microsoft SQL Server. Understanding T-SQL is foremost in writing performance-based queries. The product takes the student from the basics of the language to the structures that will create optimal results. The student learns, step-by-step, creating database objects, working with data, modifying data, and troubleshooting and optimizing queries for a comprehensive study of querying. This video course contains an initial overview video and 4 modules with 17 videos lessons, subdivided into 155 sub lessons, for a total of 12 hours of instruction. The videos consist of audio instruction, animations, and video screen casts. Each video lab presents detailed objectives, lab diagrams, and video captures. Audio instruction throughout offers detailed explanations, tips, and configuration verifications. Skill Level Beginning Who Should Take This Course Primary Audience: The target audience for this course are administrators, developers, and power-users in the database world who want to expand their knowledge of Transact-SQL querying, as well as candidates considering taking the Microsoft SQL Server 2012 Administrator and Developer Certifications. Course Requirements Users should have a working knowledge of Microsoft SQL Server 2012, experience using SQL Server Management Studio (SSMS), as well as some experience writing Transact-SQL code. Access to a SQL Server 2012 instance including a sample database is also highly recommended. Learn How To: Create database objects, including: o Creating and Altering Tables Using T-SQL Syntax o Designing, Creating, and Altering Views o Creating and Modifying Constraints o Creating and Altering DML Triggers Working With Data o Querying Data by Using SELECT Statements o Implementing Sub-Queries o Implementing Data Types o Implementing Aggregate Queries o Qu... |
|---|---|
| Notas: | Title from title screen (viewed January 19, 2015). Sub-title on resource description page: Required knowledge for SQL Server 2012 and 2014. |
| Descripción Física: | 1 online resource (1 video file, approximately 11 hr., 37 min.) |
