SQL for Beginners with Microsoft SQL Server Database

Preview this course
30-Day Money-Back Guarantee
Full Lifetime Access.

- OR -

Get this course, plus 250+ of our top-rated AI & Data courses, with a Subscription.
Starting at $20 per month.
Enjoy a Free Trial. Cancel Anytime.
34 on-demand videos & exercises
Level: Beginner
English
2hrs 17mins
Access on mobile, web and TV

Who's this course for?

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.

What you'll 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.

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.

Course Curriculum

What to know about this course

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.

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.