Practical SQL Skills

Practical SQL Skills, available at $49.99, has an average rating of 4.3, with 29 lectures, based on 199 reviews, and has 2896 subscribers.

You will learn about Construct SQL queries to retrieve data Understand how relational databases work Harness the power of Microsoft SQL Server This course is ideal for individuals who are An employee working within a business that is looking to use SQL or A business owner who needs to better understand and utilise the data being used within their business or Someone looking to add SQL to their skills It is particularly useful for An employee working within a business that is looking to use SQL or A business owner who needs to better understand and utilise the data being used within their business or Someone looking to add SQL to their skills.

Enroll now: Practical SQL Skills

Summary

Title: Practical SQL Skills

Price: $49.99

Average Rating: 4.3

Number of Lectures: 29

Number of Published Lectures: 29

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $27.99

Quality Status: approved

Status: Live

What You Will Learn

Construct SQL queries to retrieve data
Understand how relational databases work
Harness the power of Microsoft SQL Server

Who Should Attend

An employee working within a business that is looking to use SQL
A business owner who needs to better understand and utilise the data being used within their business
Someone looking to add SQL to their skills

Target Audiences

An employee working within a business that is looking to use SQL
A business owner who needs to better understand and utilise the data being used within their business
Someone looking to add SQL to their skills

This course is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. More and more companies rely on IT systems that store information in databases. This information is typically retrieved using SQL and its use is becoming widespread amongst not just IT teams but business users also.

The course contains walk through videos, printed documents of the course material as well as links to resources you need to be able to carry out the course.

The course is laid out over 3 levels starting with the very basics and assumes no prior SQL knowledge, right up to level 3 where we will be looking at Microsoft SQL Server specific functionality to really harness the power of a SQL database.

If you need to access any data be it online or within your own company then this course is for you. Financial systems form the hub of any business these days and many job roles require some level of SQL ability. This course will equip you with the knowledge you need to perform these tasks within your business or employment to improve your prospects.

Most business systems utilise some form of SQL database, typically Microsoft SQL Server which is why this course focuses on that particular product. Additionally we can download a free 'express' version of the product to work through the course.

And the unconditional, Udemy backed, 30 day money-back guarantee is not just any old guarantee, it's my personal promise to you that you will succeed … just like my thousands of other Udemy students.

Course Curriculum

Chapter 1: Introduction and Getting Started

Lecture 1: Course Introduction

Lecture 2: What if I'm on Mac?

Lecture 3: Downloading Microsoft SQL Server

Lecture 4: Installing Microsoft SQL Server

Lecture 5: Installing AdventureWorks Database

Lecture 6: Connecting to a Remote Adventureworks Database

Chapter 2: Level 1 Introduction to SQL

Lecture 1: Before We Begin

Lecture 2: A Quick Introduction to SQL Server Management Studio

Lecture 3: Let's write some SQL!

Lecture 4: Using the ORDER BY Clause

Lecture 5: Grouping and Aggregating Data

Lecture 6: Using JOIN to return data from 2 or more tables

Lecture 7: Using UNION to return data from 2 or more tables

Chapter 3: Level 2 – Sub-queries, Views and Modifying Data

Lecture 1: Sub-queries

Lecture 2: Conditional Processing using CASE

Lecture 3: Pivoting Data

Lecture 4: Using VIEWs

Lecture 5: Modifying Data – the INSERT statement

Lecture 6: Modifying Data – the UPDATE statement

Lecture 7: Modifying Data – the DELETE statement

Chapter 4: Level 3 – Stored Procedures, Functions, Triggers and Cursors

Lecture 1: Stored Procedures

Lecture 2: Functions

Lecture 3: Triggers

Lecture 4: Cursors

Chapter 5: Course Wrap-Up

Lecture 1: What we Covered

Chapter 6: Bonus Section

Lecture 1: Bonus 1 – Dynamic SQL

Lecture 2: Bonus Lecture 2 – Using PIVOT

Lecture 3: Bonus Lecture 3 – Using PIVOT with dynamic SQL

Lecture 4: Additional Video for Remotely Connecting.

Instructors

Gary Kind
Techie with Marketing and Business Startup Knowledge

Rating Distribution

1 stars: 4 votes
2 stars: 4 votes
3 stars: 32 votes
4 stars: 71 votes
5 stars: 88 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu