LearnSmart - Building and Optimizing a SQL Server Database (70-464)
English | Size: 5.45 GB (5,851,444,401 Bytes)
Welcome to Building and Optimizing a SQL Server Database: Microsoft 70-464 with LearnSmart.
The following lectures will prepare you f Microsoft SQL Server 70-464 exam, which goes toward the Microsoft Certified & Professional (MCP) and MCSE: Data Platfm Solutions Expert certification. These lectures teach the principles, techniques, and tools needed to successfully prepare f 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 Stage Solution: Microsoft 70-465
This course is designed to prepare the student f 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 majity of topics that you will find on the exam, including: creating tables, maintaining indexes, implementing data types, and wking with XML data. Learn the main exam objectives by learning these key concepts we cover:
Implement database objects
Implement programming objects
Design database objects
Optimize and troubleshoot queries
Our lectures are paired with a variety of demonstrations and quizzes giving visual example and real wld look of the concepts that will be talked about.
Our sections listed below are can be taken in any der, as a review of a particular concept exam domain. However, if you are just becoming familiar with SQL Server 2012 and it's database, it is recommended that you view the sections sequentially.
Section 1: Gain a though overview of the various tools and services that are available f you to administer the SQL Server 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, nmalization, denmalization, schemas, tempary tables and computed columns. Also be able to ste the data in appropriate table structure and with appropriate attributes f each column.
Section 4: Ensure data integrity and constraint considerations by learning about how to enfce data integrity at the application level, the types of data integrity, and the available options f enfcing 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 views
Section 6: Within database development be able to monit query perfmance, and how to optimize both further.
Section 7: Review the ce 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 ce concepts related to the use of execution plans, the roles of the most common execution plan elements, and how to wk with execution plans.
Section 9: Review sted procedures and all its potential benefits. We cover how to pass parameters to sted procedures and receive output, as well as how to control the execution context of a sted 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 wld example at the concepts that we will discuss.
Section 11: Learn about the different options that SQL Server provides f 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 impting and cataloging assemblies and choosing between managed code and T-SQL f your situation.
Section 13: Understand locking mechanisms, isolation levels, and transactions to increase physical integrity of data f every transaction.
Section 14: Learn about Transact-SQL err handling, how it has traditionally been implemented, and how to implement structured exception handling in T-SQL.
Section 15: Go indepth into sting and querying Extensible Markup Languages (XML) data in SQL Server.
Section 16: Review how to wk with SQL Server Spatial Data by looking into types of spatial data, spatial reference identifiers, spatial data in applications, and me
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 f the new Net+ exam! I needed a good refresh befe taking the exam and this course is clearly laid out and copiously covers the material f the exam. Great course, well wth the money! -- M.B.
Perfect Course - Not only do you get great lectures that are pretty much PowerPoints with an instruct teaching you the concepts, there are also Demo lectures that show you how each of the concepts wks in real life. This is such valuable infmation to have when taking the test. I feel very confident that this course is the best Netwk+ 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 f reading along with the lectures). I wasn't interested in the flashcards the crosswd 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.
What are the requirements?
There is not any requirements f this course.
A computer with internet.
It is helpful to have a basic understanding of and interest in SQL Server 2012.
This is the 1st (out of 2) Courses in our SQL Server 2012 Database Series, next is "Designing a SQL Server Database and Stage Solution: Microsoft 70-465" Course
What am I going to get from this course?
Over 383 lectures and 12 hours of content!
Gain a though overview of the various tools and services that are available f you to administer the SQL Server develop applications.
Start writing SQL statements to define tables, insert data into tables, and update data in tables.
Ste the data in appropriate table structure and with appropriate attributes f each column.
Best design & implementing your tables and views by reviewing tables, nmalization, denmalization, schemas, tempary tables and computed columns.
Within database development be able to monit indexes and how your query perfms, and how to optimize both further.
Ensure data integrity and constraint considerations by learning about how to enfce data integrity at the application level, the types of data integrity, and the available options f enfcing data integrity with identity property and sequences.
Review the ce concepts related to the use of execution plans and learn how to read SQL Server Execution Plans.
Go indepth into sting and querying Extensible Markup Languages (XML) data in SQL Server.
Understand locking mechanisms, isolation levels, and transactions to increase physical integrity of data f every transaction.
Learn about Transact-SQL statements, User-Defined Functions, Data Minpulations via Triggers, T-SQL coding to optimize your SQL Sever database.
Utilize our paired demonstrations that exemplify and provide step by step real wld application and use of many concepts that are discussed.
Prove to yourself, and others, that you are ready f Microsoft's Developing Microsoft SQL Server Databases (70-464) certification exam with our integrated quizzes and finals.
What is the target audience?
Looking to enhance your skills in the SQL Server 2012 database system?
Are you an IT professional, database administrat, suppt specialist, database developer? These concepts are key f these kind of professions.