Get $1 credit for every $25 spent!

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

Courses
3
Enrolled
541

What's Included

Product Details

Access
1 year
Lessons
3

Microsoft Exam 70-461: Querying Microsoft SQL Server Course

Learn to Successfully Write Queries & Manage Data in SQL

By iCollege | in Online Courses

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
iCollege 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.

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

Course Outline

  • 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

View Full Curriculum


Microsoft Exam 70-462: Administering SQL Server Databases Course

Install, Maintain & Configure Databases as Your Profession

By iCollege | in Online Courses

Become the go-to database expert with this in-depth SQL operations course. From setting a database up from scratch, to maintaining efficiency, to backing up regularly, you will master all tasks a database administrator may be asked to perform. Plus, and perhaps most importantly, you will take on the responsibility of data safety, blocking any unauthorized access.
  • Audit SQL Server instances
  • Back up databases
  • Configure additional SQL Server components, Instances & Services
  • Deploy a SQL Server
  • Implement strategies, column stores & High-Availability and Disaster Recovery solutions
  • Seamlessly import & export
  • Install SQL Server & related services
  • Perform maintenance
  • Manage & configure permissions, alerts, logins & roles
  • Optimize & troubleshoot
iCollege 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.

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

Microsoft Exam 70-463: Implementing a Data Warehouse Course

Create Business Intelligence Solutions with Data Developer Expertise

By iCollege | in Online Courses

Learn to manipulate data and perform functionality that delivers meaningful insights to your team. Business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation can be the starting point for making better business decisions, and this course will teach you the skills to contribute to your fullest extent.
  • Master data using Master Data Services
  • Cleanse data using Data Quality Services
  • Dive into data loading, transfer & transformation
  • Study data synchronization
  • Perform a one-time data or application migration
  • Perform ad-hoc data manipulations & transformations
  • Schedule ETL jobs
  • Manage, configure & deploy SQL Server Integration Services (SSIS) packages
iCollege 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 solution For more details on this course and instructor, click here.

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