Microsoft Certified Solutions Associate (MCSA): SQL Server Certification Bundle

541 Enrolled
3 Courses
$35.99

What's Included

Microsoft Exam 70-461: Querying Microsoft SQL Server Course
  • Experience level required: All levels
  • Length of time users can access this course: 1 year

Course Curriculum

3 Lessons

  • Microsoft 70-461: Querying Microsoft SQL Server 2012
  • Microsoft 70-462: Administering Microsoft SQL Server 2012 Databases
  • Microsoft 70-463: Implementing A Data Warehouse With Microsoft SQL Server 2012

Microsoft Exam 70-461: Querying Microsoft SQL Server Course

i
iCollegeiCollege is a leading international provider of E-Learning courses, learning technologies, and development services. iCollege is a collaborative venture between XpertSkills and XpertEase Software. The synergistic result of the joint venture enable them to provide sophisticated, innovative, relevant, flexible, and cost-effective learning solutions. Their collective knowledge and experience in education and training provision sets the standard for service delivery in learning solutions. For more details on this course and instructor, click here.

Description

Whether or not you’ve dabbled with queries or databases, earning a MCSA certification will attract the eyes and wallets of company execs across the states and beyond. SQL is a go-to software for implementing data warehouses, as well as efficiently managing massive amounts of data. This first part of this three-part training will dive into the main job functions associated with querying, in order to prepare you to pass the first exam and beyond.
  • Understand the ins & outs of querying in SQL
  • Apply built-in scalar & ranking functions
  • Combine dataset
  • Design T-SQL stored procedures, views
  • Implement aggregate queries, error handling, sequence generation & data types
  • Manage transactions
  • Modify data by using INSERT, UPDATE, DELETE & MERGE statements
  • Optimize queries
  • Query data using SELECT statements
  • Return data w/ OUTPUT clause

Specs

Details & Requirements

  • Length of time users can access this course: 1 year
  • Access options: web streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 60 days of purchase
  • Experience level required: all level
  • Once you are ready for your exam, you can make an appointment to take the official exam at any center worldwide
  • Restrictions: exam vouchers not included

Compatibility

  • Internet required
  • Windows PC required

Terms

  • Instant digital redemption
Your Cart
Your cart is empty. Continue Shopping!
Processing order...