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