Ending In:
$438
91% off
Courses
3
Enrolled
541
Courses
3
Enrolled
541
What's Included
Microsoft Exam 70-461: Querying Microsoft SQL Server Course
$146.20 Value
Microsoft Exam 70-462: Administering SQL Server Databases Course
$146.20 Value
Microsoft Exam 70-463: Implementing a Data Warehouse Course
$146.20 Value
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
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