Building and Optimizing a SQL Server Database (70-464) (Udemy.com)

Learn how to build and optimize database solutions while preparing for the Microsoft SQL Server 70-464 Exam

( 0 Reviews )

Created by: LearnSmart LLC

Produced in 2016

What you will learn

Gain a thorough overview of the various tools and services that are available for you to administer the SQL Server or develop applications.
Start writing SQL statements to define tables, insert data into tables, and update data in tables.
Store the data in appropriate table structure and with appropriate attributes for each column.
Best design & implementing your tables and views by reviewing tables, normalization, denormalization, schemas, temporary tables and computed columns.
Within database development be able to monitor indexes and how your query performs, and how to optimize both further.
Ensure data integrity and constraint considerations by learning about how to enforce data integrity at the application level, the types of data integrity, and the available options for enforcing data integrity with identity property and sequences.
Review the core concepts related to the use of execution plans and learn how to read SQL

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 0 / 100

Course Description

Welcome to Building and Optimizing a SQL Server Database: Microsoft 70-464 with LearnSmart.
The following lectures will prepare you for Microsoft SQL Server 70-464 exam, which goes toward the Microsoft Certified & Professional (MCP) and MCSE: Data Platform Solutions Expert certification. These lectures teach the principles, techniques, and tools needed to successfully prepare for and pass the Developing Microsoft SQL Server Databases exam.
This is the 1st Course in our 2 Course SQL Server 2012 Database Series including:
Building and Optimizing a SQL Server Database: Microsoft 70-464 Designing a SQL Server Database and Storage Solution: Microsoft 70-465Course Overview:
This course is designed to prepare the student for the Microsoft SQL Server 2012 Exam 70-464 Students will like a look at how to best build and implement databases. This course covers a majority of topics that you will find on the exam, including: creating tables, maintaining indexes, implementing data types, and working with XML data. Learn the main exam objectives by learning these key concepts we cover:
Implement database objectsImplement programming objectsDesign database objectsOptimize and troubleshoot queries

Our lectures are paired with a variety of demonstrations and quizzes giving visual example and real world look of the concepts that will be talked about.
Our sections listed below are can be taken in any order, as a review of a particular concept or exam domain. However, if you are just becoming familiar with SQL Server 2012 and its database, it is recommended that you view the sections sequentially.
Course Breakdown:
Section 1: Gain a thorough overview of the various tools and services that are available for you to administer the SQL Server or develop applications.
Section 2: Start writing SQL statements to define tables, insert data into tables, and update data in tables. Section 3: Best design & implementing your tables and views by reviewing tables, normalization, denormalization, schemas, temporary tables and computed columns. Also be able to store the data in appropriate table structure and with appropriate attributes for each column.
Section 4: Ensure data integrity and constraint considerations by learning about how to enforce data integrity at the application level, the types of data integrity, and the available options for enforcing data integrity with identity property and sequences.
Section 5: Go over how to design and implement views in SQL Server, and will also talk about partitioned and indexed viewsSection 6: Within database development be able to monitor query performance, and how to optimize both further.
Section 7: Review the core concepts related to the use of execution plans and learn how to read SQL Server Execution Plans.
Section 8: Take a look at how to determine the outcomes of the decisions that SQL Server makes. We will cover the core concepts related to the use of execution plans, the roles of the most common execution plan elements, and how to work with execution plans.
Section 9: Review stored procedures and all its potential benefits. We cover how to pass parameters to stored procedures and receive output, as well as how to control the execution context of a stored procedure. Section 10: Compare the user-defined functions in SQL Server to functions in high-level languages and become familiar with will be functions, procedures, and reusable components. This course will be paired with several demos that offer a real world example at the concepts that we will discuss.
Section 11: Learn about the different options that SQL Server provides for manipulating data with triggers. Be able to determine when to use constraints and when to use triggers.
Section 12: Meet complex business requirements by implementing managed code in SQL server and review importing and cataloging assemblies and choosing between managed code and T-SQL for your situation.
Section 13: Understand locking mechanisms, isolation levels, and transactions to increase physical integrity of data for every transaction.
Section 14: Learn about Transact-SQL error handling, how it has traditionally been implemented, and how to implement structured exception handling in T-SQL.
Section 15: Go indepth into storing and querying Extensible Markup Languages (XML) data in SQL Server.
Section 16: Review how to work with SQL Server Spatial Data by looking into types of spatial data, spatial reference identifiers, spatial data in applications, and moreRecommendations:
Learn from others! Here are some reviews from participants (Click on reviews to see full list of reviews)Great Material - This course is a great reference and way to refresh your skills for the new Net+ exam! I needed a good refresh before taking the exam and this course is clearly laid out and copiously covers the material for the exam. Great course, well worth the money! -- M.
B.
Perfect Course - Not only do you get great lectures that are pretty much PowerPoints with an instructor teaching you the concepts, there are also Demo lectures that show you how each of the concepts works in real life. This is such valuable information to have when taking the test. I feel very confident that this course is the best Network+ course on Udemy. -- D.
R. Jr.
A Complete Jumpstart - What has impressed me the most is the depth of the content to this coarse. Each HD video is crystal clear in both the visual and audio, even including quality closed captioning (great for reading along with the lectures). I wasn't interested in the flashcards or the crossword puzzles when I started the program, but I've found them to be very useful in staying engaged in the class when away from home. This is everything you need to get started and have a classroom quality experience from home. Dive in and stay focused! -- P.
C.
Who this course is for:
Looking to enhance your skills in the SQL Server 2012 database system?
Are you an IT professional, database administrator, support specialist, or database developer? These concepts are key for these kind of professions.

Time: 12h

Instructor Details

LearnSmart LLC

0.0 Rating
0 Reviews

LearnSmart has served the learning community with high-quality professional skills and IT certification training since 1997. In that time, the company has helped thousands earn career-related certifications from respected vendors, such as Project Management Institute (PMI), Cisco, Microsoft, CompTIA, Oracle, and. LearnSmart offers over 1,000 courses covering IT, project management, administrative, HR, and workplace safety topics. With a rapidly growing clientele of individuals and corporations, LearnSmart serves a broad range of Fortune 500 companies to universities, as well as government institutions and the armed forces.
LearnSmart is able to meet diverse career and learning needs through its extensive selection of training. LearnSmart uses industry experts to give learners the most up-to-date content in a video format as well as training resources including; reference tools, pretests, study guides and labs. For more information about how we can help pinpoint and solve your individual or multi-user training challenges.
PMI isa registered trademarkof theProject Management Institute, Inc.