SQL for Beginners with Microsoft SQL Server Database

SQL for Beginners with Microsoft SQL Server Database, available at $54.99, has an average rating of 4.95, with 26 lectures, based on 289 reviews, and has 904 subscribers.

You will learn about Database fundamentals Database Structure How to restore a backup database Write SQL queries with confidence Select the data from tables Join multiple tables Insert records into the database Delete records Create outer joins Manipulate selected data with SQL functions Import and Export data from SQL Server This course is ideal for individuals who are Marketing Analysts or Marketing professionals or Web Analytics professionals or Digital Analytics professionals or Aspiring Data Scientists or Financial Analysts It is particularly useful for Marketing Analysts or Marketing professionals or Web Analytics professionals or Digital Analytics professionals or Aspiring Data Scientists or Financial Analysts.

Enroll now: SQL for Beginners with Microsoft SQL Server Database

Summary

Title: SQL for Beginners with Microsoft SQL Server Database

Price: $54.99

Average Rating: 4.95

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 26

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Database fundamentals
Database Structure
How to restore a backup database
Write SQL queries with confidence
Select the data from tables
Join multiple tables
Insert records into the database
Delete records
Create outer joins
Manipulate selected data with SQL functions
Import and Export data from SQL Server

Who Should Attend

Marketing Analysts
Marketing professionals
Web Analytics professionals
Digital Analytics professionals
Aspiring Data Scientists
Financial Analysts

Target Audiences

Marketing Analysts
Marketing professionals
Web Analytics professionals
Digital Analytics professionals
Aspiring Data Scientists
Financial Analysts

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Installing SQL Server

Lecture 3: Understanding SQL Server Structure

Lecture 4: What is Normalization

Lecture 5: Restoring a Backup Database – Adventureworks

Chapter 2: Finding the Data in Database

Lecture 1: SQL Query to Select Data from a Table

Lecture 2: Selecting Top N records

Lecture 3: Narrowing down result set with WHERE clause

Lecture 4: Pattern Matching in WHERE clause using LIKE

Lecture 5: Where In… SQL Clause – Using Multiple values from a column in Where Clause

Lecture 6: Sorting the Result set

Lecture 7: Selecting unique result set

Lecture 8: Joining multiple tables to get the desired result set

Lecture 9: Using Alias in SQL

Lecture 10: Aggregating the data in SQL – Count, Min and Max

Lecture 11: Aggregating the data – Sum and Average

Lecture 12: Null Values in Aggregation

Lecture 13: Using Aggregated Values in WHERE Clause

Chapter 3: Manipulating Data in Select Statement

Lecture 1: Combining Multiple Columns and String Values

Lecture 2: Extracting Characters from a String – Learn Left, Right and Substring functions

Lecture 3: Find length of a string/column and position of a character in a column

Chapter 4: Other Key SQL Statements

Lecture 1: Inserting values in Tables using SQL

Lecture 2: Updating records in a Table

Lecture 3: Deleting records from a Table

Lecture 4: Outer Join – Left & Right

Chapter 5: Bonus Lecture

Lecture 1: Bonus Lecture

Instructors

Anil Batra
Speaker, Best Selling Instructor, Author and Executive

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 18 votes
4 stars: 106 votes
5 stars: 164 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