Querying Microsoft SQL Server 2012 Exam No 70461
What you’ll learn
List different SQL data types
Make, amend and delete various database structures
Modify constraints
Make new data storing procedures
Maximize querying
Work with various functions
Know to handle errors
Manage transactions
Requirements
Knowledge of TSQL, javascript and C++ will be an added advantage for any particpant who is taking up this course. awareness about RDMS would be an added advantage.
Description
Querying Microsoft SQL Server (Exam 70-461) training has been designed to help learners ace the Microsoft SQL Server 70-461 exam. The course is based on the curriculum prescribed by Microsoft.Taking leap into the data management system had Microsoft come up with a new, authentic and infallible version of SQL Server, Microsoft SQL Server 2012. It offers a trustworthy storage of data for not so important websites and other desktop applications. In this course you will be introduced to the construction and usage of databases in this platform.In this course, students who are preparing themselves for this exam will be showcased with all the necessary technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2012. Also, another point that adds value to this course is that it is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence—are few among them. This course is more or less a guide that will help you with exam 70-461 preparation, known as Querying Microsoft SQL Server 2012. It is the advent of cloud that has made this exam so popular amongst the professionals. Apart from cloud, other enterprises are considers SQL Server 2012 as a strong platform as there are many other trivial systems founded on it.By the end of the course you will be trained in creating as well as managing databases in SQL Server 2012. Apart from learning about various database objects including tables, columns, keys and others, there will be an overall understanding of how these objects help store data by providing a well-constructed structure. As add-ons you will also know to query for stored data, add new data, update and delete existing and unwanted data.All these and more are combined in 137 lecture with demos to help you out. There are end of the lesson quiz sections which will check your understanding of the lessons.15 hours of learning provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. Passing the Querying Microsoft SQL Server 2012 (70-461) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieve an MCSE certification.
Overview
Section 1: Introduction to SQL Server 2012
Lecture 1 Introduction to SQL Server 2012
Lecture 2 RDBMS – An Introduction
Lecture 3 SQL Server 2012
Lecture 4 SQL Server Components
Lecture 5 SQL Server Tools
Lecture 6 SQL Server Management Studio
Lecture 7 Managing Databases
Lecture 8 SSMS Windows
Lecture 9 Demo – Exploring SSME
Lecture 10 Understanding Database Objects
Lecture 11 Demo – Creating Database Objects using SSMS
Lecture 12 Conclusion
Section 2: Working with T-SQL
Lecture 13 Working with T – SQL
Lecture 14 Demo Viewing a Table Structure
Lecture 15 Querying
Lecture 16 T – SQL
Lecture 17 Demo Writing a Simple Query
Lecture 18 Managing Database Objects
Lecture 19 Demo – Add, Modify, and Delete Database Objects
Lecture 20 Constraints
Lecture 21 Demo – Adding Constraints
Lecture 22 SELECT
Lecture 23 Demo – Querying Data from Tables
Lecture 24 CASE
Lecture 25 Demo – Advanced Queries
Lecture 26 Conclusion
Section 3: Understanding SQL Data Types
Lecture 27 Understanding SQL Data Types
Lecture 28 String Types
Lecture 29 MAX Setting
Lecture 30 Demo – Using Character, UNICODE, and Binary Strings
Lecture 31 Numeric Types
Lecture 32 Demo – Working with Numeric Data
Lecture 33 Date and Time
Lecture 34 Demo – Working with Date and Time
Lecture 35 Advanced Data Types
Lecture 36 Demo – Exploring Some Advanced Data Types
Lecture 37 Conclusion
Section 4: Sorting and Filtering
Lecture 38 Sorting and Filtering
Lecture 39 Sorting with ORDER BY, and Performing Multiple Column and Ascending – Descending
Lecture 40 Extended Capabilities for Sorting
Lecture 41 Demo – Using TOP, OFFSET, and FETCH
Lecture 42 Filtering Results
Lecture 43 Demo – Filter using WHERE, and Different Predicates and Operators
Lecture 44 Advanced Filtering
Lecture 45 Demo – Unicode, ANY, and ALL filters
Lecture 46 Conclusion
Section 5: Query Multiple Tables using JOINs
Lecture 47 Query Multiple Tables using JOINs
Lecture 48 Multiple Tables
Lecture 49 Demo – Querying Multiple Tables without a JOIN
Lecture 50 Using JOIN
Lecture 51 Simple Join
Lecture 52 Demo – Using Implicit Join between Tables
Lecture 53 JOINs
Lecture 54 Demo – Using CROSS, INNER, and OUTER JOINs
Lecture 55 Advanced JOINs
Lecture 56 Demo – Using MERGE, HASH, and LOOP
Lecture 57 Conclusion
Section 6: Modifying Table Data
Lecture 58 Modifying Table Data
Lecture 59 Demo – Using Different Forms of INSERT to Add Data to a Table
Lecture 60 Other Methods to Add Data
Lecture 61 Demo – Using Bulk Adding Methods
Lecture 62 Modifying Data in a Table
Lecture 63 Demo – Modifying Data with UPDATE
Lecture 64 Removing Data from Tables
Lecture 65 Demo – DELETE and TRUNCATE Data from Tables
Lecture 66 Synchronizing Data between Tables
Lecture 67 Demo – Synchronizing Data using MERGE
Lecture 68 Conclusion
Section 7: Programming in SQL Server
Lecture 69 Programming in SQL Server
Lecture 70 Function Categories
Lecture 71 String Functions
Lecture 72 Conversion Functions
Lecture 73 Logical Numeric Functions
Lecture 74 Date and Time Functions
Lecture 75 Demo – Using Different Functions in SQL Server
Lecture 76 Working with Groups and Aggregates
Lecture 77 Aggregate Functions
Lecture 78 Demo – Grouping and Using Different Aggregates
Lecture 79 Variables and Batches
Lecture 80 Demo – Using Variables and Batches
Lecture 81 Control Flow Statements
Lecture 82 Demo – Using Control Flow Statements
Lecture 83 Working with Stored Procedures
Lecture 84 Demo – Working with Stored Procedures
Lecture 85 Conclusion
Section 8: Writing Advanced Queries in T-SQL
Lecture 86 Writing Advanced Queries in T – SQL
Lecture 87 Using Subqueries Demo
Lecture 88 Table Expressions
Lecture 89 Using Table Valued Expressions Demo
Lecture 90 Set and Conditional Operators
Lecture 91 Using Different Set Operators Demo
Lecture 92 Window Functions
Lecture 93 Using Window Functions Demo
Lecture 94 Creating User – Defined Functions
Lecture 95 Create and Use UDF Demo
Lecture 96 Conclusion
Section 9: Data Manipulation
Lecture 97 Data Manipulation
Lecture 98 Using PIVOT to Analyze Data Demo
Lecture 99 Grouping Sets
Lecture 100 Grouping Sets Demo
Lecture 101 Handling Transactions
Lecture 102 Using Transactions Demo
Lecture 103 Conclusion
Section 10: Advanced Querying
Lecture 104 Advanced Querying
Lecture 105 Master Database
Lecture 106 System Stored Procedures
Lecture 107 Work with System Stored Procedures Demo
Lecture 108 Query Plans
Lecture 109 Viewing Query Plans Demo
Lecture 110 Manage Indexes
Lecture 111 Manage Views
Lecture 112 Using Indexes and Views Demo
Lecture 113 Windows Azure SQL Database
Lecture 114 Overview of Windows Azure SQL Database Demo
Lecture 115 Conclusion
Section 11: Test Paper
This is intended for professionals who want to excel in querying. Therefore working professionals like database administrators, developers, system engineers and business professionals can take up this exam. This the first level so if you’re looking for an advanced version this course is not for you.
Course Information:
Udemy | English | 6h 25m | 1.59 GB
Created by: Compaq learning
You Can See More Courses in the Developer >> Greetings from CourseDown.com