-
Pulling the Data from Database
13 Lessons-
StartSQL Query to Select Data from a Table
-
StartSelecting top N records
-
StartNarrowing down result set with WHERE clause
-
StartPattern Matching in WHERE clause using LIKE
-
StartWhere In... SQL Clause - Using Multiple values from a column in Where Clause
-
StartSorting the Result set
-
StartSelecting unique values
-
StartJoining multiple tables to get the desired result set
-
StartUsing Alias in SQL
-
StartAggregating the Data in SQL - Count, Min and Max
-
StartAggregating Data - Sum and Average
-
StartNull Values in Aggregations
-
StartUsing Aggregated Values in WHERE Clause
-
SQL Fundamentals For Beginners with Microsoft SQL Server
Learn SQL using Microsoft SQL server. These fundamentals apply to any SQL environment.
Course Summary
Course Curriculum
Anil Batra
Anil is a Digital Marketing and Analytics professional with 18+ years of experience. He has worked with companies ranging from startups to Fortune 500 and has helped them improve marketing results as well as develop data-driven culture. He has vast experience in Web, Email, Social, Display, Search, Paid Search, and CRM.
He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from the University of Washington, Seattle.
Anil has taught and trained several Marketing and Analytics folks in past 18 years of teaching at UBC, University of Washington, and Bellevue College, and speaking engagements at various conferences as well as his blog. He conducts several training sessions and workshops on various topics in Digital Marketing and Digital Analytics. He has also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.
Anil has worked and trained teams at companies that include, Microsoft, Estee Lauder, HCL, Finning, ZiplyFiber, T-Mobile, AT&T, Wunderman, Wall Street Journal, ESPN, Starbucks
Anil has taught over 40,000 students from 152 countries.
