Best Microsoft SQL Courses

Find the best online Microsoft SQL Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Microsoft SQL Courses.

Microsoft SQL Server Development for Everyone!

Learn the fundamentals of database design, development and querying using Microsoft SQL Server 2017

Created by Trevoir Williams - Mr.

"]

Students: 86276, Price: $129.99

Students: 86276, Price:  Paid

Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. This course provides you with fundamental SQL Server training and is enough to get you started at a Database Developer or Junior Database Administrator.

Why Learn Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications

We will explore best practices in database development using SQL Server Express 2017 (Free Edition) and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, to creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What you’ll learn

  • Install SQL Server and SQL Server Management Studio

  • Connect to a Database Instance

  • Create a Database

  • Create Tables

  • Run Queries against Tables

  • General use of the Management Studio

  • Create Relationships (Normalization)

  • Use Aggregate functions to do quick mathematical operations

  • Export data to Excel using the Management Studio

  • Practical use of SQL

  • Creating and Managing Database Views

  • Creating and Managing Custom Functions; Table Triggers and Stored Procedures

  • How to Backup and Restore Databases

Are there any course requirements or prerequisites?

  • A Windows PC (or Windows running on a Virtual Machine if using Linux/Mac)

Who this course is for:

  • This course is for beginners with absolutely no experience.

  • This course is for you if you are already comfortable with basic database operations.

  • This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.

  • This course is for you if you want to understand design principles in database development.

  • This course is for you if you are proficient in Microsoft Access and want to learn a new Database Management System

  • This course is for EVERYONE!

Content and Overview

This is a complete course. Over 6 hours of premium content, all put together to ensure that you get up and running with becoming a Database Developer and/or Administrator. I take you through various scenarios and techniques to write queries, build a database and further administrate, then we touch more advanced topics that are in great demand in the workplace.

By the time you have finished the course you will have moved around in Microsoft SQL Manager Studio so much, that it will become second nature for you when interacting with your databases, found on different servers. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files and scripts, making it easy for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income and marketability! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

It's time to take action! This deal will not be available forever!

See you in the course!

SQL for Data Analysis: Weekender Crash Course for Beginners

Using MySQL but applicable to Oracle SQL, Microsoft SQL Server, and PostgreSQL. Taught by a Data Scientist and PM.

Created by A Course You'll Actually Finish - A Course Series

"]

Students: 65932, Price: $124.99

Students: 65932, Price:  Paid

Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.

This SQL course has been taken by fine marketing folks at Google, Facebook, Amazon, Lyft, and Udemy.

Your Story:

Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw.  He wanted to add "SQL" as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview.  But getting there would take forever. Better to just "fake it til' you make it"... right?

Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?

Our Story:

David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They've since helped many team members buff up their data analysis skills and helped students land jobs!

What You'll Learn:

If you have no technical background, don't be afraid! We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. Note: this courses teaches you real-world SQL - not just the theory in abstract, but real skills you can use to get more data-driven in your current job. 

How This Course is Structured:

  • In this course we'll be pretending we're a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.
  • We'll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes
  • To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing
  • We'll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)
  • We'll be actively involved in the discussion board answering any questions you might have! Don't be afraid to ask!

A Note About Pedagogy:

We know what it's like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don't want that to happen with this course. We want this to be a course you'll actually finish. We believe half of learning is motivation and engagement, so we've tried extra hard to make this course fun, relevant, entertaining, and punchy - no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us)!

FAQs:

  1. Do I need to purchase any software to take this course? Nope! Everything we use to do data analysis with MySQL is completely free. We'll walk you through the installation and set-up of any software we'll be using.
  2. Can I take this course with Linux? The set-up and installation lectures we've created are for Windows and Mac, and we don't currently have specific installation lectures for Linux.

Microsoft SQL for Beginners

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

Created by Brewster Knowlton - Business Intelligence Expert

"]

Students: 50710, Price: $44.99

Students: 50710, Price:  Paid

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, exams 70-461 and 70-761

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 38912, Price: $129.99

Students: 38912, Price:  Paid

Previously available as seven separate courses, now presented in one big course.

Reviews

"The instructor explain the things in great details. Very easy to follow." - Linda Shen

"Excellent course, valuable lessons, very well taught at a great pace." - Shane Tanberg

"Must get tutorial. Love it" - Hayford I Osumanu

"Perfect step by step guide to learning. Best I've seen." - Charles Schweiger

"This course is very well thought out. Its one of the better 70-461 courses on Udemy." - Isrrael M

-------------------------

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012" and 70-761 "Querying Data with Transact-SQL".

Session 1

The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

Session 2

We'll create tables which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables. This will allow up to fully complete objective number 1 from the 70-461 exam.

Session 3

We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam

Session 4

We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW.

We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement. By doing this, we will complete objectives 11, 12, 13 and parts of 6 and 18 from the 70-461 exam.

Session 5

We'll will now be creating aggregate queries, working through objective 9 of the exam 70-461. We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.

We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. If you want to take the 70-461 exam, we'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.

Session 6

We'll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions using the WITH statement, and we'll be using what we have learned to solve a common business problem.

We'll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We'll also look at sequences.

We'll have a look at XML. Finally, for SQL Server 2016 and later (exam 70-761), we'll examine JSON and Temporal Tables.

Session 7

In this session we'll be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to indexes and their role in optimising queries. 

We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and the impact of using scalar UDFs.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

Microsoft SQL Server 2019: For Beginners

Everything you need to know about Microsoft SQL Server in one place

Created by Bradley Coetzee - IT System Engineer & Instructor

"]

Students: 21294, Price: $19.99

Students: 21294, Price:  Paid

SQL (Structured Query Language) is a very high in demand skill and a great way to boost your career. Databases gets used so often in today's modern world but not a lot of people realize it. After this course you will be able to setup a SQL Server, create databases and tables and be able to use SQL to query data. SQL is also a great way to boost your passive income, there is a lot of freelancing websites where they are looking for people who knows their way around SQL.

Social media and a lot of other applications uses databases like for example an application that recognizes a song and gives you the songs name. The application would listen to the song and use an API to connect to a database with millions of songs to see which songs match the one that you are listing to. Banks uses databases to keep track of their customers and websites can use databases to store the user’s data or even the comments that is posted on the website. You do not need any prior knowledge of SQL or databases to take this course, because we will go through everything you need to know chapter by chapter.

In the past few years, the rate of SQL jobs has been increasing. With the average salary ranging between being $63 000 per year for entry level SQL developers & $89,000 for developers with 10 - 20 years of experience. It does not look like the demand for SQL is slowing down anytime soon.

  • In this course you will learn how to:

  • Setup your own SQL Server

  • Create databases and tables

  • Add data to your tables

  • Learn about the basic folder structure

  • Sort and Group data using SQL

  • Learn about NULL & NOT NULL

  • Learn how to use Primary & Foreign keys

  • Backup & Restore your database

  • Use SQL statements to query data from a single table

  • Use JOINs to query data from multiple tables

Microsoft SQL for beginners : ( MS-SQL Server,T-SQL, SSMS )

Practical Hands-on Data Query and Manipulation with SQL

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 20785, Price: $59.99

Students: 20785, Price:  Paid

The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft  SQL Server Oracle, PostgreSQL,MySQL etc.

Different database management systems have their own proprietary  version of the SQL language  but they all conform to using some commands in SQL the same way.   Microsoft SQL Server's version of SQL is known as Transact-SQL  (T-SQL).    In this course you will learn the basics of the SQL language and Transact-SQL since  both use certain commands in the same way.

T-SQL is also popularly referenced to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database. Along the way, we will be creating our own t-SQL queries to get data into a database and also out of a database.  But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go. I will introduce you to the data types available so you can make the appropriate selection when creating a column. Then, we will talk about joins, functions, tables, procedures, triggers, indexes, and much more. By the time you are done with this course, you will be very comfortable using T-SQL.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.

What You will learn includes:

  • Installing SQL Server

  • Install SSMS

  • Basic Database  Concepts

  • Creating Database

  • Creating Table

  • Creating Views

  • Creating stored procedures

  • Reading data from a database

  • Updating database records

  • Backing up database

  • Deleting Records

  • Truncating Table

  • Dropping Table

  • Dropping Database

  • Restore Database

  • Query Multiple Database Tables

  • Change query output column names using case expressions

  • Perform Various table joins

  • Filter records and remove duplicates

  • Write basic T-SQL Statements

  • Understand T-SQL TOP Command

  • Understand Normalisation

  • Know how to use SSMS

  • Create Views

  • Create Stored Procedures

  • Understand NULL Values

  • Data Types

  • Functions

Microsoft SQL from scratch – Beginner to Expert

Practical Hands-on Real World SQL Skills

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 19537, Price: $89.99

Students: 19537, Price:  Paid

Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media.

Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand  to help interact with various databases to help business intelligence and other sectors that relies on data.

This course will teach you from absolute beginner to expert so you can be confident with enough skills to build simple to complex queries to communicate and interact with databases.

SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.T-SQL  - Transact SQL is Microsoft's implementation of SQL.  There are a lot of similarities between them but also proprietary parts that are specific to SQL Server.

We will be using Microsoft's version of SQL  ( T-SQL )  popularly referred to as T-Sequel  with Microsoft SQL Server .

SQL Server is a relational database management system  -RDBMS  developed and owned by Microsoft.Thousands of companies all over the world use SQL Server for their data solution .

What You Will Learn include:

  • How to extract  data from multiple Database Tables using Joins

  • How to insert new data into database with SQL

  • How to update existing data inside a database

  • How to delete data from a database

  • How to filter data

  • How to sort data

  • How to create and query views

  • How to  build a stored procedure

  • How to use Aggregate functions to summarize returned data

  • How to group data

SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.

This course is a beginners guide to performing data analysis using SQL to  interrogate SQL Server to provide answers to data related questions.  You will learn to write useful SQL queries that is applicable to the Real World  production environment.

Everywhere data is being collected, every transaction, every web page visit,every payment—all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.

There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.

Microsoft SQL from A to Z

The Complete Guide to SQL Querying

Created by Brewster Knowlton - Business Intelligence Expert

"]

Students: 16818, Price: $74.99

Students: 16818, Price:  Paid

This course is an extension of our previous course, "Microsoft SQL for Beginners".  This course, "Microsoft SQL from A to Z" contains all the course material and content from the previous course plus the additional MANY new lectures on more intermediate and advanced-level SQL querying topics.  Students who sign up for this course will also have access to our 150+ page "Complete T-SQL Querying Guide" as an added bonus to assist you in the learning process.

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

Microsoft SQL Server 2012 Certification Training Exam 70-461

To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

Created by Infinite Skills - High Quality Training

"]

Students: 15850, Price: $49.99

Students: 15850, Price:  Paid

This Microsoft SQL Server 70-461 Exam training course by Infinite Skills teaches you everything you need to know to pass the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.

The course takes you through each of the topics that you will need to master in order to pass the SQL Server 2012 70-461 exam. Throughout this video tutorial, you will learn how to setup the interface, create and alter tables using T-SQL, and understand SQL queries. You will learn about SELECT statements, how to modify data, and use joins and subqueries. This course will teach you about triggers and different trigger types, how to work with XML, and how to optimize queries. Finally, you will run through the exam basics and what you can expect from the exam.

Once you have completed this computer based training course for the Microsoft SQL Server 70-461 exam, you will have developed the knowledge and skills necessary to pass the Querying Microsoft SQL Server 2012 Exam and continue towards earning your SQL Server MCSA certification.

How to take the Microsoft 70-461 Exam:

1. Find a test center near you to take the SQL Server 70-461 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-461 examination. This course covers the material that is within the 70-461 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4) Take our Microsoft Windows Server 70-462 and 70-463 courses which will prepare you for the 70-462 and 70-463 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

5. Tell your friends how easy passing the Microsoft 70-461 exam was using Infinite Skills training courses

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

70-462: SQL Server Database Administration (DBA)

Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 15122, Price: $124.99

Students: 15122, Price:  Paid

Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.

Do you want to gain practical experience in Database Administration in SQL Server? Welcome.

In this course, learn some of the skills that Microsoft want you to know, and add another tool to your CV or resume, and even go for the official Microsoft certification.

SQL Server is one of the main database tools that is requested in the job market, and the ability to being able to do DBA for SQL Server could be very useful for your current work, and your next job hunt.

We'll download and install for free SQL Server Developer, which gives you all of the capabilities of the full-cost Enterprise edition (though without being able to use it for commercial purposes). We'll start by downloading a demonstration database, and learning how to backup and restore this database, and what recovery models are appropriate for other databases, to enable you to offer Point in Time recovery.

We'll manage logins and server roles, so you can control who gets access to what data, implement and maintain indexes, so you can speed up searches, and import and export data. We'll look at managing SQL Server Agent, so you can automate routine tasks, and also be alerted to problems, we'll manage and configure databases, and look at compression, both of which aids with administrating big databases. And much more.

The course will take around 10 hours to complete, but completing this will enable you to versed in Database Administration tasks, giving you hands-on experience.

The course increases in difficulty slowly, so you'll manually backup a database, but then later we'll use SQL Server Agent to automate this. In this course, we will only do activities that require one computer, instead of multiple servers or virtualization.

The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual DBA will be at a basic level, and I'll introduce every component as we go on.

No knowledge of T-SQL is required, as I'll demonstrate everything I can through the GUI (Graphical User Interface) as well as T-SQL. However, if you are going to go for the official Microsoft exam, the equivalent knowledge as per my first two courses in 70-461 T-SQL is essential.

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and continue your preparations for the official Microsoft certifications.

The course is recorded on SQL Server 2017, but will also work fully in 2016, 2014 and 2012, and mostly in 2008R2 and 2008.

The Comprehensive SQL Course 2021

A bootcamp designed to help you master SQL and work with databases like Oracle, MySQL and Microsoft SQL Server

Created by Malvik Vaghadia - Data and BI specialist

"]

Students: 14766, Price: $59.99

Students: 14766, Price:  Paid

Want to learn one of the most in-demand skills in the business and technology sector?

Then this course is for you!

SQL skills are highly marketable everywhere, especially in companies like Netflix, Facebook, Amazon, Google… the list goes on and on… The simple fact is that if you want to do any work involving data, then the chances are that you need to know SQL!

This course has been designed for:

  • Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language

  • Those with some experience looking to brush up on their SQL knowledge

No downloads or software installation required! We will be using Oracle APEX which is a web-based application – you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

The lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every technical section of the course will be rounded off with quizzes / assignments and give you an opportunity to develop your practical skills.

The course will provide students with an extensive Question Bank section which is full of questions and walkthroughs designed to emulate real world scenarios and combine together all of the different SQL clauses, operations and commands taught in this course!

In this course you will learn about:

  • Data Definition Language Commands such as CREATE, DROP, TRUNCATE, ALTER and RENAME

  • Data Query Language Commands using the SELECT statement

  • Data Manipulation Commands such as INSERT, UPDATE and DELETE

  • Data Control Language Commands such as GRANT and REVOKE

  • Transaction Control Language commands such as COMMIT and ROLLBACK

  • Data Types

  • Qualifying Column Names

  • Aliasing Columns and Tables

  • Row Level Functions

  • Aggregation Functions

  • The Where Clause

  • The Group By and Having Clauses

  • The Order By Clause

  • Single Table and Multiple Table Joins

  • SET Operators

  • Subqueries

  • Database Constraints

  • Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas

  • Views

Microsoft SQL Server Reporting Services (SSRS)

Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 12783, Price: $99.99

Students: 12783, Price:  Paid

Reviews:

"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." -- Koos ten Bras

"Excellent course, well presented and clear examples." - Peter Cawthorne

This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.

We will download a version of SQL Server which includes SSRS - for free. We'll also download a database called AdventureWorks, which we will use in our reports.

We'll create various reports, developing our skills bit by bit. As part of designing a report, we will:

  • Select report components (matrix, table, chart and other data visualisation component),

  • Identify the data source and parameters,

  • Design a grouping structure,

  • Create drilldown reports and drillthrough reports.

As part of implementing a report layout, we will:

  • Find out how to format, including formatting colours, dates and numbers;

  • Configure the page;

  • Implement headers and footers;

  • Implement matrices, tables, chart, images, indicators, maps and groupings in reports;

  • Create a range of reports using different data regions;

  • Define custom fields;

  • Implement global collections;

  • Define expressions; and

  • Implement data visualisation components.

As part of implementing interactivity in a report, we will:

  • Create drilldown reports;

  • Create drillthrough reports;

  • Add interactive sorting;

  • Investigate parameters, including multi-value parameters;

  • Create dynamic reports in SSRS using parameters;

  • Implement show/hide property;

  • Add actions (jump to report and URL);

  • Add Fixed headers and a document map.

By the end of this course, you should be confident in creating your own reports in SSRS.

Microsoft SQL Server And T-SQL Course For Beginners

Learn benefits of SQL, how SQL Server stores data and how to use T-SQL in SQL Server Management Studio to query data.

Created by Avetis Ghukasyan - Web Developer

"]

Students: 12369, Price: $99.99

Students: 12369, Price:  Paid

Microsoft SQL Server also known as SQL Server is a mature technology which can be used not just by developers but by marketers, sales teams, product managers and much more - it is a query language that allows you to ask questions from securely stored data.

Think of it this way - any business on this planet makes money with data. The fancy user interfaces, cool animations are nice but that's not what makes the money. Think about it... when you go to Facebook or Instagram do you care about the fancy animations and user interface or do you care to see your friends, what they are up to, check out events and be part of the goings on of that entire digital ecosystem?

Of course it is the second choice... the fancy user interfaces are cool and make the experience pleasant but in the end you care about your friends and what they are up to, you care about being part of the ecosystem...

Now your friends, followers, events, what everyone is up to is data and as I mentioned before that is what makes companies money.

Microsoft SQL Server (SQL Server) is one of the most mature technologies that allows companies to handle data, store it securely, access it quickly and much more.

Now if you know about Microsoft SQL Server (SQL Server) and you know how to create database objects, how to normalize tables, how to retrieve data, prepare reports, insert and delete data safely and you know about best practices then you are an amazingly valuable asset to the company.

If you have a business that you are trying to grow and have data which you are trying to handle then Microsoft SQL Server (SQL Server) is a great choice which is another reason for you to learn this skill.

Now guess what? All of those things we will be learning in this course and MUCH more!

Take my advice and learn this valuable skill, you will not regret it. After dedicating only a few days and really focusing you can acquire this valuable skill and set a new course for your life.

Administering Microsoft SQL Server 2012 Databases – 70-462

Learn how to build and use databases in SQL Server platform

Created by Compaq learning - One stop to learn and succeed

"]

Students: 7575, Price: $59.99

Students: 7575, Price:  Paid

Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 2012, a step higher into the administration of the data system. It is an excellent platform for students to build database systems, ensure effective operation of the systems apart from storing, and securing data from any kind of unauthorized access. The course intends to target all data professionals including data analysts and other aspiring professionals who wants to get ready for exam 70-462, also known as Administering Microsoft SQL Server 2012 Databases.

Towards the end of this course our participants will have a thorough knowledge on maintaining various databases including the instances, trouble shooting and optimizing apart from data management and contriving high availability and security.

This course is that is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence. The main idea of this course is to make our students cognize SQL Server 2012 databases administration. You will be comprehending a lot about the various issues and other decisions that are part of SQL Server installation and configuration.

Apart from this as a student you will keen to look into the various operations involved including backup and restore operations that can be performed. You will also find it both challenging and interesting to learn how databases and database files are moved. There will also be a discussion on some of the important topics namely, instance, database and object security strategies. Some of the high availability technologies will also be discussed as part of the training.

Our training is broken down to 115 lecture sessions that will cover all objectives. As add on, we are also providing demos on other major concepts so that participants understand how the steps learned are implemented in real time.

Microsoft SQL Server Integration Services (SSIS) Training

Learn how to deal with loading of different kinds of data into SQL Server

Created by Intelligence Guru - BI training

"]

Students: 7152, Price: $34.99

Students: 7152, Price:  Paid

Now is your chance to learn Microsoft SQL Server Integration Services (SSIS) with this extensive course that will give you the confidence and skills to use this Business Intelligence tool. It will be the golden ticket to your success in this industry. You will learn the basics about the development tools and what they are capable of, clear instruction on how to handle various issues that you might face when designing your packages and how to overcome them. By the end of this course you will understand many basic concepts and how to perform data integration and transformation. This course also includes the process of cleansing data and how to get the end result after applying different transformations. It also gives some real world scenarios that you might face and what salary to expect from working as an SSIS/ETL developer.

By taking this course you will learn about:

  • Creating an Integration Services Project
  • Basic SQL Server Data Tools features
  • Creating Integration Services Tasks
  • Creating connections to and from an Integration Services Package
  • Writing data to a SQL Server database
  • Executing a package from SQL Server Data Tools
  • Creating a Foreach Loop and map Variables
  • Controlling Data Flow for multiple Flat Files
  • Changing a Flat File Connection using Expressions
  • Changing command-line application arguments using Expressions
  • Change Data Capture(CDC) database objects
  • Preparing data for CDC and performing Incremental loading
  • Most Familiar Data Transformations concepts

Microsoft SQL Server 2012 Certification Training Exam 70-462

Study For The Microsoft 70-462 Exam - Administering Microsoft SQL Server 2012 Databases

Created by Infinite Skills - High Quality Training

"]

Students: 6533, Price: $49.99

Students: 6533, Price:  Paid

This SQL Server 70-462 exam training course by Infinite Skills teaches you everything you need to know to pass the Administering Microsoft SQL Server 2012 Databases Server 2012 exam. It is required that you pass the 70-462 Exam in order to earn your MCSA and MCSE certifications from Microsoft.

The course takes you through each of the topics that you will have to master in order to pass the SQL Server 2012 70-462 exam. Throughout this tutorial video, you will learn how to install and configure the SQL Server, maintain instances and databases, optimize and troubleshoot, manage data, and implement security and high availability. Each topic is broken down into step-by-step lessons, allow you to quickly learn and retain the information more effectively.

Once you have completed this video based training course for the Microsoft SQL Server 70-462 exam, you will have a comprehensive understanding of how to Administer Databases with Microsoft SQL Server 2012. You will be fully prepared to write, and pass, your 70-462 exam and continue towards earning your MCSA and MCSE certifications.

How to take the Microsoft 70-462 Exam:

1. Find a test center near you to take the SQL Server 70-462 certification exam, their will provide details on test center locations and schedules. This exam is typically priced around $150 dollars.

2. Study the required material to pass the 70-462 examination. This course covers the material that is within the 70-462 certification exam, and will help put you in a great position to succeed in the exam

3. Pass your exam!

4) Take our Microsoft Windows Server 70-461 and 70-463 courses which will prepare you for the 70-461 and 70-463 exams. Upon passing the 70-461, 70-462, and 70-463 exams you will become a Microsoft Solutions Certified Associate in Microsoft SQL Server 2012.

5. Tell your friends how easy passing the Microsoft 70-462 exam was using Infinite Skills training courses

The information laid out above is given in good faith, we are not endorsing and third party company by offering a link to their site. You should always do your own research prior to making a purchase or using any service linked to via this website. Prices or details may alter and any information listed can not be guaranteed to be accurate. Note: While this course is comprehensive in regards to covering material on the exam, we do recommend using other aids to guide your study.

Microsoft Access SQL: SQL for Non-Programmers

Learn How You Can Use SQL in Microsoft Access with the Tips, Tools, and Exercises in This Best-Selling Course.

Created by IsáBel . - Microsoft Certified IT Professional. Trainer of 21 Years

"]

Students: 6234, Price: $119.99

Students: 6234, Price:  Paid

SQL Is One Of The Most Sought-After Skills By Employers.

If there was an easy, step-by-step method for learning a little bit of SQL EVERY SINGLE DAY without the confusion, tech

overwhelm , or "What the heck do I do next?" syndrome, would you finally feel confident enough to make learning SQL your priority?

You Can Quickly Learning How To Query Your Microsoft Access Databases with SQL

If you are already familiar with Microsoft Access databases, and would like to:

  •  Have more employable skills

  •   Learn an in-demand programming language

  •   Get the answers that you want, when you want them from your database

  •   Break free of the Query Design window, or Query Wizards

Then this course will enable you to discover how you can use SQL to query your Access databases. There is enormous value in knowing the basics and being efficient in SQL.

You can start using SQL today.
Here's your first example,

SELECT [SQL Course]
FROM Udemy
WHERE Instructor = 'IsáBel.'

               

The Tools You Need to Tell the Query Design Window "Good-bye",

Microsoft SQL for Database Creation

Enhance your SQL knowledge

Created by Grant Gamble - Developer, trainer and author

"]

Students: 5088, Price: $19.99

Students: 5088, Price:  Paid

This course will enable you to enhance your basic knowledge of Microsoft Transact SQL by learning the key SQL statements involved in the creation of databases.

Although you can create a complete database manually, using the SQL Server Management Studio interface, knowing the SQL commands for database creation is essential if you are preparing yourself for a role as a database administrator, a database engineer or Microsoft web developer.

This course assumes that you know the basics of SQL; but we do begin with a revision of some key SQL CRUD syntax: Create, Read, Update and Delete.   

The course will explain the mechanics of, and SQL syntax for, the creation of the three types of database relationship used in SQL Server: one-to-many, one-to-one and many-to-many; and the use of primary and foreign key constraints. 

You will learn how to use SQL to create database schemas; how to create tables within a schema; move tables between schemas; and the security benefits of using schemas.   

We also take an in-depth look at the creation of database columns of different data types; and the SQL techniques for inserting data in the correct format.   

You will also learn the SQL syntax for creating database constraints to enhance the integrity of your data.   

And the course will also show you how to use SQL statements to create clustered and non-clustered indexes, to improve the performance of your databases.   

So, if you need a Transact SQL course to take your basic knowledge to the next level, this could be just the course you are looking for.

Learn SQL with Microsoft SQL Server

Understanding Databases and SQL

Created by John Elder - Founder of Codemy

"]

Students: 4612, Price: $109.99

Students: 4612, Price:  Paid

In this course I'll teach you Structured Query Language - SQL for short - the fast and easy way.

We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it like a pro.

Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're actually pretty easy to use if you know just a few things...and I'll teach you those things in this course. 

We'll start out by learning fundamental database concepts, like... what is a database, what is a table, what are rows and columns, and what are data types.

After that I'll show you how to set up and use Microsoft SQL Server. 

Then we'll dive right in to SQL itself.  I'll teach you basic concepts like 

- Select Statements
- Where, And or Not 
- How to Order and Group By
- And cool things like that.

Then we'll move into slightly more difficult concepts like 

- Having and Top Clauses
- Select Distinct
- Union
- And Functions

Then we'll jump into more advanced concepts like 

- Insert and Update Statements
- Deleting and Altering Tables
- Joining Tables 
- Primary Keys
- Indexing 
- And more!

When you get right down to it, using Databases with SQL is pretty easy, and actually a lot of fun.

Join me today and I'll see you inside!

Microsoft SQL for Beginners (SQL Server and T-SQL)

Learn the basic of SQL and SQL Server with no previous experience needed!

Created by Vimal Vachhani - Business Intelligence Expert

"]

Students: 4545, Price: $29.99

Students: 4545, Price:  Paid

Are you interesting in learning a skill that can start you in a job between $85,000-$125,000?

In this course you will learn Structured Query Language - SQL and how to use Microsoft SQL Server

Databases are incredibly important in our modern world with many organizations using data to run and drive their business and learning SQL is the staring point to roles in Data Science and Big Data.

This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server

This course covers a series of topics including...

- Setting up and installing SQL Server

- Installing a sample database

- Select Queries

- Where Clauses

- Advanced SQL Queries

- Joins

- Aggregate Functions

- Subqueries

- Stored Procedures and Views

Click the Signup button to sign up for the course!

  • A PC or Mac is required

  • No prior knowledge of Databases, SQL or SQL Server  is needed.

Microsoft SQL Server Failover Cluster

Learn Ms SQL Servers Failover Clustering and maintain secure, performant and efficient Ms SQL Server databases

Created by Oak Academy - Web & Mobile Development, IOS, Android, Ethical Hacking, IT

"]

Students: 3696, Price: $99.99

Students: 3696, Price:  Paid

Hello everyone!

Welcome to Microsoft SQL Server Failover Clusters

SQL is the standard language for the Relationship Database System. All relational database management systems such as SQL Server, MySQL, MS Access, Oracle, and others use SQL as the standard database language. SQL is used to communicate with a database.

In this MS SQL Failover Cluster course, you will keep your database running 24/7 without interruption. If we want a smooth operation in the database field, we must know the Failover Cluster issue. As we will experience with various examples in our course, our operations will continue without any loss.

You will have an excellent introduction to SQL with MS Management Studio, which allows you to manage the MS SQL database and retrieve data from the database with a graphical interface.

Basic level SQL Database knowledge is enough!

No previous experience!

We will start learning from the basics and build the Failover cluster structure step by step. First, you will learn some terminology. Then the show will begin and you will learn everything with hands-on exercises. I will also teach you the best practices and shortcuts.

In this MS SQL Cluster course you will learn;

  • How are these requirements set up and adjusted?

  • How to set up Active Directory,

  • How to create required user and OU for SQL server,

  • How to create a Share Disk system,

  • How to connect more than one server to the shared disc system,

  • How to set up the cluster service,

  • You will also learn SQL operations and transaction commands,

At the end of this course, you will be able to run your database uninterruptedly. As a result, you will create and manage your own database.

Fresh Content

MS SQL is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. And this course introduces all the features of MS SQL Server Failover Clusters

Step-by-Step Way, Simple and Easy With Exercises

If you want to learn MS SQL Cluster from scratch, you are in the right place. You will learn step by step with hands-on examples.

Why would you want to take this course? 

Our answer is simple: The quality of teaching.

When you enroll, you will feel our seasoned developers' expertise. 


Video and Audio Production Quality

All our videos are created/produced as high-quality video and audio to provide you the best learning experience.

You will be,

  • Seeing clearly

  • Hearing clearly

  • Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Udemy Certificate of Completion Ready for Download

Dive in now to our  course

We offer full support, answering any questions.

See you in the course!

70-461 Session 3: Querying Microsoft SQL Server (T-SQL)

Using T-SQL in SSMS, add constraints, store queries in views, add triggers. SQL Server 2012, 2014, 2016, 2017 (70-761)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 3542, Price: $49.99

Students: 3542, Price:  Paid

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and JOINing multiple tables together.

We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam.

No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL.

70-461 Session 4: Querying Microsoft SQL Server (T-SQL)

Using TSQL, merge databasets together, create procedures & incorporate error handling. SQL Server 2012-2017, inc. 70-761

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 2650, Price: $49.99

Students: 2650, Price:  Paid

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Session 1, we learned all about dates, strings and number data types, and in Session 2 we constructed SELECT queries, JOINed multiple tables together and used DML commands, and in Session 3 we created views, constraints and triggers to encapsulate language and improve security.

We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW.

We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement. By doing this, we will complete objectives 11, 12, 13 and parts of 6 and 18 from the 70-461 exam.

No prior knowledge other than what we covered in Sessions 1 to 3 is required. However, prior experience with Excel or Access would be beneficial.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write procedures, add error handling, and combine datasets together, and we'll have expanded on our current knowledge of T-SQL.

70-461 Session 6: Querying Microsoft SQL Server (SQL code)

Using SQL, correlated subqueries, CTEs, Pivots, UDFs and Sequences. SQL Server 2012 to 2017 (inc. 70-761).

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 2632, Price: $49.99

Students: 2632, Price:  Paid

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets, and in session 5 we learned about ranking and aggregate functions.

We'll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions using the WITH statement, and we'll be using what we have learned to solve a common business problem.

We'll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We'll also look at sequences.

No prior knowledge other than what we covered in Sessions 1 to 5 is required. This course builds on the knowledge previously gained in those previous sessions.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write subqueries, functions, sequences and more, and we'll have expanded on our current knowledge of T-SQL.

70-461 Session 5: Querying Microsoft SQL Server (write SQL)

Using SQL, create analytical functions, grouping sets, ranking functions, spatial aggregates. SQL Server 12-17 (70-761)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 2537, Price: $49.99

Students: 2537, Price:  Paid

If you are in UfB, welcome.

If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012".

In Sessions 1 and 2, we learned all about dates, strings and number data types and DML statements. In sessions 3 and 4, we created views, procedures, triggers, constraints and combining datasets.

We'll will now be creating aggregate queries, working through objective 9 of the exam 70-461. We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.

We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. We'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.

No prior knowledge other than what we covered in Sessions 1 to 4 is required. This course builds on the knowledge previously gained in those previous sessions.

There are regular quizzes to help you remember the information.

Once finished, you will know what how to write ranking functions, analytic functions, grouping sets and spatial aggregates, and we'll have expanded on our current knowledge of T-SQL.

Querying Microsoft SQL Server 2012 – (Exam No. 70-461)

Master in SQL Server 2012 in a step-by-step manner

Created by Compaq learning - One stop to learn and succeed

"]

Students: 2495, Price: $84.99

Students: 2495, Price:  Paid

Querying Microsoft SQL Server (Exam 70-461) training has been designed to help learners ace the Microsoft SQL Server 70-461 exam. The course is based on the curriculum prescribed by Microsoft.

Taking leap into the data management system had Microsoft come up with a new, authentic and infallible version of SQL Server, Microsoft SQL Server 2012. It offers a trustworthy storage of data for not so important websites and other desktop applications. In this course you will be introduced to the construction and usage of databases in this platform.

In this course, students who are preparing themselves for this exam will be showcased with all the necessary technical skills to write basic Transact-SQL queries for Microsoft SQL Server 2012. Also, another point that adds value to this course is that it is the basis for all other SQL Server-related disciplines—Database Development, Database Administration, and Business Intelligence—are few among them. This course is more or less a guide that will help you with exam 70-461 preparation, known as Querying Microsoft SQL Server 2012.

It is the advent of cloud that has made this exam so popular amongst the professionals. Apart from cloud, other enterprises are considers SQL Server 2012 as a strong platform as there are many other trivial systems founded on it.

By the end of the course you will be trained in creating as well as managing databases in SQL Server 2012. Apart from learning about various database objects including tables, columns, keys and others, there will be an overall understanding of how these objects help store data by providing a well-constructed structure. As add-ons you will also know to query for stored data, add new data, update and delete existing and unwanted data.

All these and more are combined in 137 lecture with demos to help you out. There are end of the lesson quiz sections which will check your understanding of the lessons.

15 hours of learning provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. Passing the Querying Microsoft SQL Server 2012 (70-461) exam is a requirement to getting MCSA certified, which in turn is a prerequisite to achieve an MCSE certification.

SQL for Beginners with Microsoft SQL Server Database

Step by Step guide for learning SQL. Go from Zero to Hero and learn SQL with Microsoft SQL Server Database.

Created by Anil Batra - Speaker, Best Selling Instructor, Author and Executive

"]

Students: 502, Price: $99.99

Students: 502, Price:  Paid

Data is a every where. SQL is a skill that is required across industries, functions and roles. . Application of Big Data starts with understanding the fundamentals of data and SQL. 

If you are already familiar with SQL then you can skip this course. This course teaches you all the SQL you need start using it with confidence  This course won't go into advanced level SQL concepts. I strongly believe in short and simple courses that can get you ready in few hours as opposed to days.

However, if you ever get stuck or need something that I don't cover in this course then feel free to reach out to me.

If you are trying for a job as a Marketing Analysts, Financial Analyst, IT Analyst, SQL Developer etc. then this course is a must for you. This will help your resume shine and put you ahead of other similar candidates. The more you can handle technology and data these days the better it differentiates you from the rest of the pack.

I have used the same course to train members of my team as well the course I use to conduct in person workshops, so you can be assured that this is tried and tested curriculum.

Why you should learn from me?

I have been in Digital Marketing, Data and Analytics for over 15 years. I have trained people from diverse backgrounds and have converted them into high performing Digital Marketers and Analysts.  I understand both the technology and marketing side of business.  I have dealt with many analytics technologies way before Google Tag manager existed and know the inner working of Digital Analytics. 

I have extensively worked with companies like Microsoft, Starbucks, Wall Street Journal, ESPN, T-Mobile to name few and helped them Data Driven Marketing Decisions.

In addition, I have developed various course and taught students from all over the world. I am online instructor for University of British Columbia (Canada), University of Washington (USA), Bellevue College (USA) and Digital Analytics Association.

I have an engineering degrees and an MBA.

The Complete Microsoft SQL Masterclass: Beginner to Expert

Master course using Microsoft SQL Server 2019.These SQL can also used in Oracle, MySQL, PostgreSQL, SQLite, DB2, etc.

Created by Sandeep Kumar - Founder of a Training company. IT Consultant, Coach, Mentor

"]

Students: 310, Price: $89.99

Students: 310, Price:  Paid

'This Course covers SQL using Microsoft SQL Server 2019 and you can apply the logic of these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, MongoDB, IBM DB2, Redis, ElasticSearch, Cassandra, Splunk, MariaDB, Teradata, Hive, Solr, HBase, FileMaker, SAP HANA, Amazon DynamoDB, SAP Adaptive Server, Neo4J, CouchBase, Memcached, and Microsft Azure SQL'.

"Welcome to the most popular Quality complete Course on Microsoft SQL Server(MS SQL Server)"

  • Covers different forms of SELECT Statements

  • Explains how to filter the Records

  • All the Arithmetic operators are explained

  • NULL Values are explained

  • Beautiful examples of all the operators

  • ORDER BY, GROUP BY, HAVING clauses has examples in detail

  • The course covers all the Aggregate Functions and other Functions

  • UNION and JOINs are explained with real-life examples

  • I have explained all types of Joins

  • Data types used in Microsoft SQL

  • Keys and Constraints are explained in detail

======================================================================================

Join this course which is the best "Microsoft SQL" course. I will share all the syntax of SQL with multiple examples along the way!!!

Want to start learning SQL from scratch with no previous coding experience?

You have come to the right place. Please have a look at the Course content carefully and ask a few questions from yourself?

  • I have shared all the codes which are used in this course

  • Is the Course taught by a real-time expert? I have more than 15  years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.

  • Is the Course content clear and Precise? The content is short, crisp, and clear.

  • The course assumes no prior knowledge on MS SQL(Microsoft SQL Server) and teaches you from scratch to advanced level

  • Once you Enroll for this Course, you get lifetime access to this course and you will get all the future updates.

  • The course does not cover T-SQL directly but it will help you to learn T-SQL also.

  • This will also help you to get Microsoft certification.

  • This Course is not for DBA(Database Administration) but certainly, helps you to become better.

  • If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.

  • If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.

Do you want to start on SQL but have no experience with SQL? 
If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.

There’s no risk involved in taking this Course!
I am sure that this is the best complete course on SQL and it is the perfect starting point to master complete Microsoft SQL.

What if you are stuck?

I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.

Are you getting updated content?

Yes, I keep updating the content always to make sure, I provide all the information to my students.

Once you enroll for this course, you will master these concepts in detail-

1) Selecting Records from Table - SELECT statement in SQL

2) Filtering the Records - Using WHERE clause in SQL

3) Sorting Records - Using ORDER BY clause

5) Grouping data - using GROUP BY clause

6) complete guide with examples of all the Functions - All aggregate functions covered

7) Creating simple and advanced Tables - with constraints and without constraints

8) Keys, Index - PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX

9) Inserting records(loading) - with INSERT Statement

10) Updating the records of a Table - Using UPDATE statement

11) Combining multiple tables - Using UNIONS

12) Joining multiple columns of different tables - Using JOINs

13) Modify table properties - ALTER statement

14) Deleting records from the table - DELETE statement

15) Removing tables from the database permanently - DROP statement

Note: This course helps to learn Microsoft SQL using Microsoft SQL Server 2019 but you can also use Microsoft SQL Server 2012, Microsoft SQL Server 2016, Microsoft SQL Server 2017, etc. It will also help to learn SQL in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, MongoDB, IBM DB2, Redis, ElasticSearch, Cassandra, Splunk, MariaDB, Teradata, Hive, Solr, HBase, FileMaker, SAP HANA, Amazon DynamoDB, SAP Adaptive Server, Neo4J, CouchBase, Memcached, and Microsft Azure SQL'.

Microsoft SQL Server Backup and Recovery Course

Manage and safeguard your database with MS SQL Server Backup and Restore ( Recover) strategy.Be ready for the emergency

Created by Oak Academy - Web & Mobile Development, IOS, Android, Ethical Hacking, IT

"]

Students: 47, Price: $89.99

Students: 47, Price:  Paid

Hello there,

Welcome to Microsoft SQL Server Backup and Recovery Course

  • Did you know that you can perform with your BACKUP?

  • Are you sure you have an effective and robust BACKUP strategy in place?

  • Have you ever heard of the TRANSACTION LOG BACKUP?

One of the most important roles of a database administrator is to constantly protect the integrity of the databases and maintain the ability to recover quickly in case of a failure. In light of this, it’s critically important to have a backup-and-recovery strategy in place in order to be ready for an emergency.

In this course we will discuss the BACKUP LOGS and DIFFERENTIAL BACKUP, and why it is absolutely necessary to implement them in your BACKUP strategy.

We will see the different full recovery model on a database (FULL, SIMPLE and BULKED LOGGED), and why this is (very) important for our BACKUPs.

Why start SQL administration?

SQL Server is one of the skills very actively sought after on the job market.

Administering an SQL server today is ensuring that you have a full-time job.

Moreover, SQL Server, because of its simplicity, allows you to quickly become competent in very specific areas.

Following this course will help you to stand out technically from your colleagues, or during a job interview.

In this course you will learn;

  • What is the recovery model? What are the differences between the Full, Bulked Logged, and Simple recover model?

  • What is a full backup? Why does every backup have to start with a full backup?

  • What is a differential backup? what is it used for?

  • What is a transaction log backup? what does it do

  • How do we reinstall if the database is completely deleted?

  • How do we return the database to a specific time?

Why would you want to take this course?

We have prepared this course in the simplest way and have prepared many different exercises to help them understand better.

No prior knowledge is needed! 
This course starts with very basics. First, you will learn some terminology. Then the show will start and you will learn everything with hands-on practices.  I'll also teach you the best practices and shortcuts.

Step-by-Step Way, Simple and Easy With Exercises

If you are a software developer or familiar with other programming languages and you want to start a new world, you are also in the right place. You will learn step by step with hands-on examples.

You'll also get:

  • Lifetime Access to The Course

  • Fast & Friendly Support in the Q&A section

  • Udemy Certificate of Completion Ready for Download

Dive in now Microsoft SQL Server Backup and Recovery Course course

We offer full support, answering any questions.

See you in the course!

Microsoft Certification SQL server Exam (70-761) :Exam Tests

Best Exam Preparation for Microsoft SQL server 70-761 exam (Updated latest questions )

Created by Chandrika patel - IT Trainer and Professional

"]

Students: 37, Price: $24.99

Students: 37, Price:  Paid

Microsoft Certification SQL server Exam (70-761) :Exam Tests

Microsoft Querying Data with Transact-SQL certification is mainly targeted to those students who want to build their career in Microsoft SQL Server domain. Exam 70-761 is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

I have prepared this practice test course for all those candidates who are planning  of taking 70-761 exam in near future.

This is an Unofficial course and this course is not affiliated, licensed or trademarked with Microsoft in any way.

Exam Topics covered as per syllabus 70-761 exam Certification skill questions :

1 Manage data with Transact-SQL

  • Create Transact-SQL SELECT queries

  • Query multiple tables by using joins

  • Implement functions and aggregate data

  • Modify data

2 Query data with advanced Transact-SQL components

  • Query data by using subqueries and APPLY

  • Query data by using table expressions

  • Group and pivot data by using queries

  • Query temporal data and non-relational data

3 Program databases by using Transact-SQL

  • Create database programmability objects by using Transact-SQL

  • Implement error handling and transactions

  • Implement data types and NULLs

You can do more practice multiple time for better exam preparation for exam 70-761

Wish you all the best !!