eLearning Bundle - SQL Querying Online Course | Certstaffix® Training


eLearning Bundle - SQL Querying Online Course

eLearning Bundle - SQL Querying

by Certstaffix® Training

SQL Query Training

Length: 3 Course/s      Price: $600/person (US Dollars)      Bulk Pricing: 10+ Contact Us      Access Length: 6 Months      Category: SQL


This elearning bundle includes these 3 courses:

Microsoft 70-461: Querying SQL Server 2012
SQL for Beginners with Microsoft SQL Server Database
SQL for Non-Technical Users
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online SQL Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

This is a self-paced eLearning course that you can take on your own schedule. With eLearning, you can start or stop your training as needed and resume where you left off. You can also replay and navigate to specific parts of the training. eLearning is beneficial when a topic or specific subject needs to be learned quickly or on one's own schedule.

Course Features:

  • Learning at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any software needed for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
SQL Training

Microsoft 70-461: Querying SQL Server 2012 - 12 hours 22 minutes

Develop the technical skills for successful querying of Microsoft SQL Server 2012 in this detailed course, designed to get you up-to-speed quickly and ready for the certification exam. We'll begin with an overview of SQL Server 2012, its components and the various versions. We'll delve into the built-in SQL tools, including SQL tools such as SQL Server Management Studio (SSMS) and SQL Profiler. Importantly, you'll learn how to write Transact-SQL (T-SQL) queries for SQL. You'll also master the fundamentals of working with SQL data types, sorting and filtering data, querying and modifying data, writing select queries, implementing stored procedures, and more. By completing this in-depth course, you'll be equipped to successfully complete the Querying Microsoft SQL Server 2012 (70-461) exam. You'll gain a solid understanding of how to utilize the SQL database and query with confidence.


Get familiar with built-in SQL tools such as SQL Server Management Studio (SSMS)
Generate Transact-SQL queries within Microsoft SQL Server 2012
Identify the fundamentals of Microsoft SQL data types
Demonstrate an ability to sort and filter a wide range of data
Demonstrate knowledge in implementing stored procedures
Develop the know-how to query and modify data

SQL for Beginners with Microsoft SQL Server Database - 2 hours 17 minutes

This video course will teach you how to extract data on your own and will give you the confidence to use SQL with Microsoft SQL Server to pull data for conducting marketing analysis without relying on anyone.

The course begins with a brief introduction to SQL Server and its architecture and shows you how to install Microsoft SQL Server on your machine. Next, you’ll walk through the process of finding data in the database, learn how to use SQL queries, join multiple tables, and aggregate the data. As you advance, you’ll grasp the techniques used to manipulate data such as combining multiple columns and string values, extracting characters from strings, and finding the length of a string. Toward the end, you’ll wrap up key SQL statements for inserting data in a table, updating records, and deleting records from a table, and get an overview of joins.

By the end of this course, you’ll be well-versed with the basics of SQL and be ready to use Microsoft SQL Server to add, extract, and manipulate data for making profitable marketing decisions.


Get to grips with the database structure
Develop the skills to restore a backup database
Discover tips and tricks for joining multiple tables
Find out how to insert records into the database
Manipulate selected data with SQL functions
Import and export data from SQL Server

SQL For Non-Technical Users - 1 hour 15 minutes

Learn to Write Simple Queries to Get the Information You Need to Do Your Job

Do you often have to ask others to write SQL queries for you at work? Are you intimidated by the idea of writing your own SQL query? It’s time to take matters into your own hands.

In this course, you’ll learn how to write a basic SQL query from start to finish. We’ve designed the lessons specifically for those with little to no experience with writing queries, to teach you only what you need to know to get started writing queries today. By the end of the course, you’ll be able to retrieve data from multiple tables, sort and filter your query results, and use simple calculations. We’ll cover some commonly used functions so you can format dates and text as well as calculate sums and averages.

If you’re ready to stop waiting on someone else to pull data for you, this course is for you.

Note: This courses uses SQL Server Management Studio, but the language of an SQL query is not specific to any one tool.


Define basic SQL terminology and list the seven types of clauses in an SQL statement.
Write an SQL query that retrieves data from one table.
Clean your query results by sorting, filtering, and adding column aliases.
Use the WHERE clause to filter results based on comparisons to numbers and strings.
Write an SQL query that retrieves data from multiple tables using inner joins and WHERE clause joins.
Course Description: Print It | Download PDF | Email It