This course is a self-paced learning solution to fit your own schedule. Certstaffix Training eLearning courses you take on your own schedule in a web browser.
This is a lecture only eLearning course. If you wish to practice with hands-on activities, you must provide the software and environment.
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.