Description

This course introduces you to SQL and Microsoft SQL Server in a practical way. You'll be able to learn the basics of SQL quickly and understand how to use SQL queries and statements with Microsoft SQL Server to extract data and analyze it for making productive marketing decisions.

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.

What You Will Learn

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

Audience

If you are a beginner in marketing or an experienced marketer or digital analyst looking to learn SQL to extract data for marketing purposes, this video course is for you. This course will help you to upgrade your resume, setting you apart from other candidates. Basic computer, marketing, and digital analytic skills are needed to get started with this course.

Approach

With the help of simple narration, interesting examples, and compelling exercises, this video course prepares you to use SQL with Microsoft SQL Server for adding, extracting, and manipulating data to make smart marketing decisions.

Key Features

Familiarize yourself with Microsoft SQL Server database fundamentals * Gain the confidence to write flawless SQL queries * Discover how to import and export data from SQL Server

About the Author

Anil Batra

Anil Batra, founder of Global Analytics Academy and Optizent - a digital marketing and analytics consulting company, is a seasoned digital marketing and analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to various start-ups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He has taught and trained several marketing and analytics professionals in the past 9 years of teaching at UBC, University of Washington, and Bellevue College. Anil also teaches digital marketing, digital analytics, Google Analytics, Tableau, and social media courses.

Course Outline

1. Introduction

This video provides an introduction to the course.

2. Installing the SQL Server

This video shows you how to install the SQL server.

3. Understanding the SQL Server Structure

This video explains the structure of the SQL server.

4. What is Normalization?

This video explains the concept of normalization in SQL.

5. Restoring a Backup Database with AdventureWorks

This video shows you how to restore a backup database using AdventureWorks.

2. Finding Data in the Database

1. SQL Query to Select Data from a Table

This video explains how to write an SQL query to select data from a table.

2. Selecting Top N records

This video explains how to select the top N records in an SQL server.

3. Narrowing Down the Result Set with the WHERE Clause

This video explains how to narrow down the result set using the WHERE clause.

4. Pattern Matching Using LIKE in the WHERE Clause

This video explains how to perform pattern matching using the LIKE operator in the WHERE clause.

5. Specifying Multiple Values from a Column Using IN in the WHERE Clause

This video explains how to specify multiple values from a column using the IN operator in the WHERE clause.

6. Sorting the Result Set

This video explains how to sort the result set.

7. Selecting a Unique Result Set

This video explains how to select a unique result set.

8. Joining Multiple Tables to Get the Desired Result Set

This video explains how to join multiple tables to get the desired result set.

9. Using Aliases in SQL

This video explains how to use aliases in SQL.

10. Aggregating the Data in SQL - COUNT, MIN, and MAX

This video demonstrates how to aggregate the data in SQL using the COUNT, MIN, and MAX functions.

11. Aggregating the Data in SQL - SUM and AVG

This video demonstrates how to aggregate the data in SQL using the SUM and AVG functions.

12. Identifying Null Values Using an Aggregate function

This video explains how to identify null values using an aggregate function.

13. Using Aggregate Functions in the WHERE Clause

This video explains how to use aggregate functions in the WHERE Clause.

3. Manipulating Data Using the SELECT Statement

1. Combining Multiple Columns and String Values

This video demonstrates how to combine multiple columns and string values.

2. Extracting Characters from a String - Learn LEFT, RIGHT, and SUBSTRING Functions

This video explains how to extract characters from a string using the LEFT, RIGHT, and SUBSTRING functions.

3. Finding the Length of a String/Column and Position of a Character in a Column

This video explains how to find the length of a string/column and the position of a character in a column.

4. Other Key SQL Statements

1. Inserting Values in a Table Using SQL Statements

This video explains how to insert values in a table using SQL statements.

2. Updating Records in a Table Using SQL Statements

This video explains how to update records in a table using SQL statements.

3. Deleting Records from a Table Using SQL Statements

This video explains how to delete records from a table using SQL statements.

4. Outer Join - Left and Right

This video explains how to perform left and right outer join using SQL statements.

5. Conclusion

1. Conclusion

This video provides a conclusion of this course.

Course Images

SQL for Beginners with Microsoft SQL Server Database

By Packt

Booking options

Highlights

Description

Course Content

About The Provider

Tags

Reviews