get app

    The 3-in-1 Excel, VBA & SQL

    BY
    Udemy

    Learn the fundamentals of Excel, VBA, SQL, and programming and get a competitive job by progressing from beginner to expert.

    Brochure Enquire
    Mode

    Online

    Fees

    ₹ 2899

    Quick Facts

    particular details
    Medium of instructions English
    Mode of learning Self study
    Mode of Delivery Video and Text Based

    Course overview

    Mark Lengyel, Professional Lead Developer at tmsonic.com, created The 3-in-1 Excel, VBA, and SQL Master Course online certification, which is presented by Udemy and is meant for candidates who wish to master the core capabilities to improve their professional job prospects. The 3-in-1 Excel, VBA, and SQL Master Course online lectures by Udemy are designed to provide a thorough grasp of the fundamentals and advanced concepts related to Excel, SQL, and VBA to deal with real-world databases.

    The 3-in-1 Excel, VBA & SQL Master Course online classes are divided into three major portions, each of which covers all of the concepts relevant to one of three key topics: Excel, VBA, or SQL. With this course, candidates will be taught about topics like charts, graphs, data types, variables, lookup function, conditional function, querying data, conditional formatting, project automation, class-based programming, object-based programming, error handling, and debugging.

    The highlights

    • Certificate of completion
    • Self-paced course
    • 48 hours of pre-recorded video content
    • 642 downloadable resources

    Course and certificate fees

    Fees information
    ₹ 2,899
    certificate availability

    Yes

    certificate providing authority

    Udemy

    What you will learn

    After completing The 3-in-1 Excel, VBA & SQL Master Course online training, candidates will gain a solid understanding of the fundamentals of Microsoft Excel, SQL, and VBA. Candidates will learn about pivot tables, charts, lookup functions, data types, conditional formatting, conditional function, variables, and subroutines, among other Excel concepts. Candidates will learn also strategies for object-based programming, class-based programming, project automation, debugging, and error handling.

    The syllabus

    Introduction

    • Introduction
    • How to Use The Course
    • Select the appropriate plan for you
    • Install Office on Windows
    • Install Office on a Mac
    • Introduction
    • How to Use The Course
    • Select the appropriate plan for you
    • Install Office on Windows
    • Install Office on a Mac

    Excel: Introduction To Excel

    • What Is Excel
    • Overview Of The Worksheet
    • Overview Of The Ribbon
    • Overview Of The Top Area
    • The File Tab
    • Basic Data Organisation
    • What Is Excel
    • Overview Of The Worksheet
    • Overview Of The Ribbon
    • Overview Of The Top Area
    • The File Tab
    • Basic Data Organisation

    Excel: Basics Of Formulas, Functions And Formatting

    • The Sum Function - Part I
    • The Sum Function - Part II
    • The Sum Function - Part III
    • Addition
    • Subtraction
    • Multiplication - Part I.
    • Multiplication - Part II.
    • Division
    • Dynamic Cell References - Part I.
    • Dynamic Cell References - Part II.
    • Basic Formatting - Part I.
    • Basic Formatting - Part II.
    • Basic Formatting - Part III.
    • Basic Formatting - Part IV.
    • Formulas Bar - Part I.
    • Formulas Bar - Part II.
    • Formula Auditing
    • Error Checking And The Watch Window - Part I.
    • Error Checking And The Watch Window - Part II.
    • The Sum Function - Part I
    • The Sum Function - Part II
    • The Sum Function - Part III
    • Addition
    • Subtraction
    • Multiplication - Part I.
    • Multiplication - Part II.
    • Division
    • Dynamic Cell References - Part I.
    • Dynamic Cell References - Part II.
    • Basic Formatting - Part I.
    • Basic Formatting - Part II.
    • Basic Formatting - Part III.
    • Basic Formatting - Part IV.
    • Formulas Bar - Part I.
    • Formulas Bar - Part II.
    • Formula Auditing
    • Error Checking And The Watch Window - Part I.
    • Error Checking And The Watch Window - Part II.

    Excel: Some Important Math Functions

    • Average
    • Min
    • Max
    • Count
    • Average
    • Min
    • Max
    • Count

    Excel: Data Types And Formatting

    • Number Formatting - Part I.
    • Number Formatting - Part II.
    • Number Formatting - Part III.
    • Number Formatting - Part IV.
    • Date Formatting - Part I.
    • Date Formatting - Part II.
    • Epoch
    • Percentages
    • Currencies - Part I.
    • Currencies - Part II.
    • Fractions
    • Text - Part I.
    • Text - Part II - Character Set
    • Text - Part III - Numbers Formatted As Text
    • Formatting The Table - Part I - Text Filters I
    • Formatting The Table - Part II - Text Filters Ii
    • Formatting The Table - Part III - Text Filters Iii
    • Formatting The Table - Part IV - Number Filters I
    • Formatting The Table - Part V - Number Filters Ii
    • Formatting The Table - Part VI - Color Filters
    • Formatting The Table - Part VII - Date Filters
    • Formatting The Table - Part VIII - Sorting
    • Formatting The Table - Part IX - Multi-Level Sorting
    • Formatting The Table - Part X - Autofitting
    • Formatting The Table - Part XI - Wrapping Text
    • Formatting The Table - Part XII - Freeze Panes
    • Formatting The Table - Part XIII - Cut-Copy Rows And Columns
    • Named Ranges - Part I
    • Named Ranges - Part II
    • Inserted Tables - Part I
    • Inserted Tables - Part II
    • Number Formatting - Part I.
    • Number Formatting - Part II.
    • Number Formatting - Part III.
    • Number Formatting - Part IV.
    • Date Formatting - Part I.
    • Date Formatting - Part II.
    • Epoch
    • Percentages
    • Currencies - Part I.
    • Currencies - Part II.
    • Fractions
    • Text - Part I.
    • Text - Part II - Character Set
    • Text - Part III - Numbers Formatted As Text
    • Formatting The Table - Part I - Text Filters I
    • Formatting The Table - Part II - Text Filters Ii
    • Formatting The Table - Part III - Text Filters Iii
    • Formatting The Table - Part IV - Number Filters I
    • Formatting The Table - Part V - Number Filters Ii
    • Formatting The Table - Part VI - Color Filters
    • Formatting The Table - Part VII - Date Filters
    • Formatting The Table - Part VIII - Sorting
    • Formatting The Table - Part IX - Multi-Level Sorting
    • Formatting The Table - Part X - Autofitting
    • Formatting The Table - Part XI - Wrapping Text
    • Formatting The Table - Part XII - Freeze Panes
    • Formatting The Table - Part XIII - Cut-Copy Rows And Columns
    • Named Ranges - Part I
    • Named Ranges - Part II
    • Inserted Tables - Part I
    • Inserted Tables - Part II

    Excel: More Challenging Formulas

    • The Index Function - Part I
    • The Index Function - Part II
    • The Index Function - Part III
    • The Sum Function Combined With The Index Function
    • The Vlookup Function - Part I
    • A Quick Detour: The Search Functionality
    • The Vlookup Function - Part II
    • The Vlookup Function - Part III
    • The Vlookup Function - Part IV
    • The Vlookup Function - Part V
    • The Vlookup Function - Part VI
    • The Index Function - Part I
    • The Index Function - Part II
    • The Index Function - Part III
    • The Sum Function Combined With The Index Function
    • The Vlookup Function - Part I
    • A Quick Detour: The Search Functionality
    • The Vlookup Function - Part II
    • The Vlookup Function - Part III
    • The Vlookup Function - Part IV
    • The Vlookup Function - Part V
    • The Vlookup Function - Part VI

    Excel: Handling Errors

    • The Iferror Function - Part I
    • The Iferror Function - Part II
    • The Name Error
    • The Value Error
    • The Ref Error
    • The Num Error
    • The Div0 Error
    • The Null Error
    • The Iferror Function - Part I
    • The Iferror Function - Part II
    • The Name Error
    • The Value Error
    • The Ref Error
    • The Num Error
    • The Div0 Error
    • The Null Error

    Excel: Sanitizing Your Data

    • Trim - Part I
    • Trim - Part II - Len
    • Trim - Part III - Checking For Equality
    • Removing Blank Rows
    • Hiding And Unhiding Rows And Columns
    • Dropdown Lists - Part I
    • Dropdown Lists - Part II
    • Dropdown Lists - Part III
    • Trim - Part I
    • Trim - Part II - Len
    • Trim - Part III - Checking For Equality
    • Removing Blank Rows
    • Hiding And Unhiding Rows And Columns
    • Dropdown Lists - Part I
    • Dropdown Lists - Part II
    • Dropdown Lists - Part III

    Excel: Conditional Functions And Formatting

    • If - Part I
    • If - Part II
    • The Ifs - Part I
    • The Ifs - Part II
    • The Ifs - Part III
    • And - Part I
    • And - Part IiIOr - Part I
    • Or - Part II
    • Countif - Part I
    • Countif - Part II
    • Countifs
    • Sumif - Part I
    • Sumif - Part II
    • Sumifs
    • Conditional Formatting - Part I
    • Conditional Formatting - Part II
    • Conditional Formatting - Part III
    • Conditional Formatting - Part IV
    • Conditional Formatting - Part V
    • Conditional Formatting - Part VI
    • If - Part I
    • If - Part II
    • The Ifs - Part I
    • The Ifs - Part II
    • The Ifs - Part III
    • And - Part I
    • And - Part IiIOr - Part I
    • Or - Part II
    • Countif - Part I
    • Countif - Part II
    • Countifs
    • Sumif - Part I
    • Sumif - Part II
    • Sumifs
    • Conditional Formatting - Part I
    • Conditional Formatting - Part II
    • Conditional Formatting - Part III
    • Conditional Formatting - Part IV
    • Conditional Formatting - Part V
    • Conditional Formatting - Part VI

    Excel: Cells And References

    • Cell References - Part I
    • Cell References - Part Ii
    • Cell References - Part Iii
    • Cell References - Part Iv
    • Cell References - Part V
    • Referencing Other Worksheets - Part I
    • Referencing Other Worksheets - Part Ii
    • Referencing Other Workbooks - Part I
    • Referencing Other Workbooks - Part Ii
    • Cell References - Part I
    • Cell References - Part Ii
    • Cell References - Part Iii
    • Cell References - Part Iv
    • Cell References - Part V
    • Referencing Other Worksheets - Part I
    • Referencing Other Worksheets - Part Ii
    • Referencing Other Workbooks - Part I
    • Referencing Other Workbooks - Part Ii

    Excel: Advanced Lookup Formulas

    • Match
    • Index Recap
    • Index Match
    • Index Match Match
    • Match
    • Index Recap
    • Index Match
    • Index Match Match

    Excel: Array Formulas

    • Working With Multiple Values - Part I
    • Working With Multiple Values - Part Ii
    • Working With Multiple Values - Part Iii
    • Basic Array Formula Example
    • Conditional Array Formula
    • Single Result Array Formula
    • The Unique Function
    • Array Formula For Finding Unique Values - Part I
    • Array Formula For Finding Unique Values - Part Ii
    • Array Formula For Finding Unique Values - Part Iii
    • Array Formula For Finding Unique Values - Part Iv
    • Returning First Distinct Value
    • Returning Non-Duplicates
    • Working With Multiple Values - Part I
    • Working With Multiple Values - Part Ii
    • Working With Multiple Values - Part Iii
    • Basic Array Formula Example
    • Conditional Array Formula
    • Single Result Array Formula
    • The Unique Function
    • Array Formula For Finding Unique Values - Part I
    • Array Formula For Finding Unique Values - Part Ii
    • Array Formula For Finding Unique Values - Part Iii
    • Array Formula For Finding Unique Values - Part Iv
    • Returning First Distinct Value
    • Returning Non-Duplicates

    Excel: Charts

    • Introduction To Charts
    • Bar Chart - Part I
    • Bar Chart - Part Ii
    • Bar Chart - Part Iii
    • Bar Chart - Part Iv
    • Bar Chart - Part V
    • Column Chart - Part I
    • Column Chart - Part Ii
    • Column Chart - Part Iii
    • Column Chart - Part Iv
    • Column Chart - Part V
    • Pie Chart - Part I
    • Pie Chart - Part Ii
    • Pie Chart - Part Iii
    • Pie Chart - Part Iv
    • Line Chart - Part I
    • Line Chart - Part Ii
    • Combo Chart
    • Moving And Copying Charts
    • Sparklines - Part I
    • Sparklines - Part Ii
    • Sparklines - Part Iii
    • Sparklines - Part Iv
    • Sparklines - Part V
    • People Graph
    • Introduction To Charts
    • Bar Chart - Part I
    • Bar Chart - Part Ii
    • Bar Chart - Part Iii
    • Bar Chart - Part Iv
    • Bar Chart - Part V
    • Column Chart - Part I
    • Column Chart - Part Ii
    • Column Chart - Part Iii
    • Column Chart - Part Iv
    • Column Chart - Part V
    • Pie Chart - Part I
    • Pie Chart - Part Ii
    • Pie Chart - Part Iii
    • Pie Chart - Part Iv
    • Line Chart - Part I
    • Line Chart - Part Ii
    • Combo Chart
    • Moving And Copying Charts
    • Sparklines - Part I
    • Sparklines - Part Ii
    • Sparklines - Part Iii
    • Sparklines - Part Iv
    • Sparklines - Part V
    • People Graph

    Excel: Pivot Tables And Charts

    • Pivot Table - Part I
    • Pivot Table - Part Ii
    • Pivot Table - Part Iii
    • Pivot Table - Part Iv
    • Pivot Table - Part V
    • Pivot Table - Part Vi
    • Pivot Table - Part Vii
    • Pivot Table - Part Viii
    • Pivot Table - Part Ix
    • Pivot Table - Part X
    • Pivot Table - Part Xi
    • Pivot Table - Part Xii
    • Pivot Table - Part Xiii
    • Pivot Table - Part Xiv
    • Pivot Table - Part Xva
    • Pivot Table - Part Xvb
    • Pivot Table - Part Xvi
    • Pivot Table - Part Xvii
    • Pivot Table - Part Xviii
    • Pivot Table - Part Xix
    • Pivot Table - Part Xx - Pivot Cache I
    • Pivot Table - Part Xx - Pivot Cache Ii
    • Pivot Table - Part Xx - Pivot Cache Iii
    • Pivot Table With Dates
    • Pivot Charts
    • Pivot Table - Part I
    • Pivot Table - Part Ii
    • Pivot Table - Part Iii
    • Pivot Table - Part Iv
    • Pivot Table - Part V
    • Pivot Table - Part Vi
    • Pivot Table - Part Vii
    • Pivot Table - Part Viii
    • Pivot Table - Part Ix
    • Pivot Table - Part X
    • Pivot Table - Part Xi
    • Pivot Table - Part Xii
    • Pivot Table - Part Xiii
    • Pivot Table - Part Xiv
    • Pivot Table - Part Xva
    • Pivot Table - Part Xvb
    • Pivot Table - Part Xvi
    • Pivot Table - Part Xvii
    • Pivot Table - Part Xviii
    • Pivot Table - Part Xix
    • Pivot Table - Part Xx - Pivot Cache I
    • Pivot Table - Part Xx - Pivot Cache Ii
    • Pivot Table - Part Xx - Pivot Cache Iii
    • Pivot Table With Dates
    • Pivot Charts

    Excel: Useful Worksheet Operations

    • Useful Worksheet Operations
    • Useful Worksheet Operations

    Excel: Useful Excel Features

    • Comments And Notes
    • Copy & Paste - Part I
    • Copy & Paste - Part Ii
    • Copy & Paste - Part Iii
    • Copy & Paste - Part Iv
    • Copy & Paste - Part V
    • Filling Cells
    • Find And Replace - Part I
    • Find And Replace - Part Ii
    • Find And Replace - Part Iii
    • Find And Replace - Part Iv
    • Grouping
    • Importing External Data
    • Merging Cells
    • Opening Multiple Excel Files
    • Printing
    • Comments And Notes
    • Copy & Paste - Part I
    • Copy & Paste - Part Ii
    • Copy & Paste - Part Iii
    • Copy & Paste - Part Iv
    • Copy & Paste - Part V
    • Filling Cells
    • Find And Replace - Part I
    • Find And Replace - Part Ii
    • Find And Replace - Part Iii
    • Find And Replace - Part Iv
    • Grouping
    • Importing External Data
    • Merging Cells
    • Opening Multiple Excel Files
    • Printing

    Excel: A Challenging Job Interview Question - Text Manipulation

    • Swap Names - Part I
    • Swap Names - Part Ii
    • Swap Names - Part Iii
    • Swap Names - Part Iv
    • Swap Names - Part V
    • Swap Names - Part I
    • Swap Names - Part Ii
    • Swap Names - Part Iii
    • Swap Names - Part Iv
    • Swap Names - Part V

    Excel: A Simplified Live Project

    • Seat Planning - Part I
    • Seat Planning - Part Ii
    • Seat Planning - Part Iii
    • Seat Planning - Part Iv
    • Seat Planning - Part V
    • Seat Planning - Part Vi
    • Seat Planning - Part Vii
    • Seat Planning - Part I
    • Seat Planning - Part Ii
    • Seat Planning - Part Iii
    • Seat Planning - Part Iv
    • Seat Planning - Part V
    • Seat Planning - Part Vi
    • Seat Planning - Part Vii

    Vba: Intro And Basic Interface

    • Intro
    • Visual Basic Editor
    • Intro
    • Visual Basic Editor

    Vba: Subroutines, Variables, Data Types

    • Our First Subroutine
    • Compiling
    • Saving A Macro Enabled Workbook
    • Enabling Macros
    • Integer Variables - Part I
    • Integer Variables - Part Ii
    • String Variables - Part I
    • String Variables - Part Ii
    • Cells And Ranges
    • Working With Numbers - Part I
    • Working With Numbers - Part Ii
    • Working With Numbers - Part Iii
    • Working With Numbers - Part Iv
    • Working With Numbers - Part V
    • About Bits And Bytes
    • Our First Subroutine
    • Compiling
    • Saving A Macro Enabled Workbook
    • Enabling Macros
    • Integer Variables - Part I
    • Integer Variables - Part Ii
    • String Variables - Part I
    • String Variables - Part Ii
    • Cells And Ranges
    • Working With Numbers - Part I
    • Working With Numbers - Part Ii
    • Working With Numbers - Part Iii
    • Working With Numbers - Part Iv
    • Working With Numbers - Part V
    • About Bits And Bytes

    Vba: Core Programming Concepts

    • Modules
    • If - Part I
    • If - Part Ii
    • If - Part Iii
    • If - Part Iv
    • Select Case - Part I
    • Select Case - Part Ii
    • Select Case - Part Iii
    • Arrays - Part I
    • Arrays - Part Ii
    • Dynamic Arrays
    • Range To Array - Part I
    • Range To Array - Part Ii
    • The For Loop - Part I
    • The For Loop - Part Ii
    • The For Loop - Part Iii
    • The For Loop - Part Iv
    • The For Loop - Part V
    • The For Loop - Part Vi
    • The For Each Loop
    • The Do Loop - Part I
    • The Do Loop - Part Ii
    • The Do Loop - Part Iii
    • The Do Loop - Part Iv
    • The Do Loop - Part V
    • The While Wend Loop
    • Modules
    • If - Part I
    • If - Part Ii
    • If - Part Iii
    • If - Part Iv
    • Select Case - Part I
    • Select Case - Part Ii
    • Select Case - Part Iii
    • Arrays - Part I
    • Arrays - Part Ii
    • Dynamic Arrays
    • Range To Array - Part I
    • Range To Array - Part Ii
    • The For Loop - Part I
    • The For Loop - Part Ii
    • The For Loop - Part Iii
    • The For Loop - Part Iv
    • The For Loop - Part V
    • The For Loop - Part Vi
    • The For Each Loop
    • The Do Loop - Part I
    • The Do Loop - Part Ii
    • The Do Loop - Part Iii
    • The Do Loop - Part Iv
    • The Do Loop - Part V
    • The While Wend Loop

    Vba: Intro To Objects

    • Collections - Part I
    • Collections - Part Ii
    • Collections - Part Iii
    • Collections - Part Iv
    • The Activesheet Object
    • Range Object - Part I
    • Range Object - Part Ii
    • Range Object - Part Iii
    • Range Object - Part Iv
    • Worksheet Object - Part I
    • Worksheet Object - Part Ii
    • Worksheet Object - Part Iii
    • Workbook Object - Part I
    • Workbook Object - Part Ii
    • The Nothing Keyword
    • Object And Non-Object Variables - Part I
    • Object And Non-Object Variables - Part Ii
    • Collections - Part I
    • Collections - Part Ii
    • Collections - Part Iii
    • Collections - Part Iv
    • The Activesheet Object
    • Range Object - Part I
    • Range Object - Part Ii
    • Range Object - Part Iii
    • Range Object - Part Iv
    • Worksheet Object - Part I
    • Worksheet Object - Part Ii
    • Worksheet Object - Part Iii
    • Workbook Object - Part I
    • Workbook Object - Part Ii
    • The Nothing Keyword
    • Object And Non-Object Variables - Part I
    • Object And Non-Object Variables - Part Ii

    Vba: Ways Of Running Your Code

    • Part I
    • Part Ii
    • Part Iii
    • Part I
    • Part Ii
    • Part Iii

    Vba: Functions And More Challenging Concepts

    • Application Object
    • Functions
    • Option Explicit
    • Arguments
    • Byval And Byref - Part I
    • Byval And Byref - Part Ii
    • Getlastrow - Part I
    • Getlastrow - Part Ii
    • Getlastcolumn
    • Getcolumnletterperindex
    • Calling With Named Arguments
    • Declaring Arguments
    • Optional Arguments
    • Ways Of Calling Functions And Subs
    • Data Type Conversion - Part I
    • Data Type Conversion - Part Ii
    • Worksheet Functions
    • Vartype
    • Constants
    • Module Level Variables And Constants
    • Global Variables And Constants
    • Application Object
    • Functions
    • Option Explicit
    • Arguments
    • Byval And Byref - Part I
    • Byval And Byref - Part Ii
    • Getlastrow - Part I
    • Getlastrow - Part Ii
    • Getlastcolumn
    • Getcolumnletterperindex
    • Calling With Named Arguments
    • Declaring Arguments
    • Optional Arguments
    • Ways Of Calling Functions And Subs
    • Data Type Conversion - Part I
    • Data Type Conversion - Part Ii
    • Worksheet Functions
    • Vartype
    • Constants
    • Module Level Variables And Constants
    • Global Variables And Constants

    Vba: Macros, Recordings And Enhancing Them

    • Recording Macro With Absolute Reference - Part I
    • Recording Macro With Absolute Reference - Part Ii
    • Running A Macro With Relative References
    • Copy Paste Macros - Part I
    • Copy Paste Macros - Part Ii
    • Recording Macro With Absolute Reference - Part I
    • Recording Macro With Absolute Reference - Part Ii
    • Running A Macro With Relative References
    • Copy Paste Macros - Part I
    • Copy Paste Macros - Part Ii

    Vba: Debugging And Error Handling

    • Part 1
    • Part 2
    • Part 3
    • Part 4
    • Part 1
    • Part 2
    • Part 3
    • Part 4

    Vba: Essential Operations

    • Getting User Input - Inputbox
    • Getting User Input - Msgbox
    • Opening A New Workbook
    • Opening An Existing Workbook
    • Closing A Workbook
    • Saving A Workbook
    • Getting User Input - Inputbox
    • Getting User Input - Msgbox
    • Opening A New Workbook
    • Opening An Existing Workbook
    • Closing A Workbook
    • Saving A Workbook

    Vba: Events

    • Workbook Events - Part I
    • Workbook Events - Part Ii
    • Worksheet Events
    • Workbook Events - Part I
    • Workbook Events - Part Ii
    • Worksheet Events

    Vba: Managing Your Code

    • Exporting And Importing Modules
    • Calling A Function Or Sub Of Another Workbook
    • Personal Macro Workbook
    • Exporting And Importing Modules
    • Calling A Function Or Sub Of Another Workbook
    • Personal Macro Workbook

    Vba: Classes And Object-Based Programming

    • Intro To Object-Based Programming - Part I
    • Intro To Object-Based Programming - Part Ii
    • Class Modules
    • Private Member Variables
    • Properties
    • Init
    • Order Object
    • Car Object
    • Associate An Order With A Car
    • Calculating The Order Price
    • Private And Public Keywords In Subs And Functions
    • Intro To Object-Based Programming - Part I
    • Intro To Object-Based Programming - Part Ii
    • Class Modules
    • Private Member Variables
    • Properties
    • Init
    • Order Object
    • Car Object
    • Associate An Order With A Car
    • Calculating The Order Price
    • Private And Public Keywords In Subs And Functions

    Vba: Simplified Live Project Automation

    • Seat Planning Overview
    • Check Worksheets
    • Deletews
    • Delete Data
    • Add Employee Data
    • Copy Employee Data
    • Add Location Formula
    • Add Free Seats Formulas
    • Create Pivot Table Macro - Part I
    • Create Pivot Table Macro - Part Ii
    • Seat Planning Overview
    • Check Worksheets
    • Deletews
    • Delete Data
    • Add Employee Data
    • Copy Employee Data
    • Add Location Formula
    • Add Free Seats Formulas
    • Create Pivot Table Macro - Part I
    • Create Pivot Table Macro - Part Ii

    Sql: Intro To Sql

    • What Are Sql And Databases
    • Installing Xampp
    • Setting Database Password
    • Stopping Mariadb
    • What Are Sql And Databases
    • Installing Xampp
    • Setting Database Password
    • Stopping Mariadb

    Sql: First Steps

    • Creating A Database And A Database Table
    • Adding Rows To Tables
    • Our First Query
    • Creating A Database And A Database Table
    • Adding Rows To Tables
    • Our First Query

    Sql: Using Vba With Sql

    • Installing Obdc Driver
    • Setting Up Vba For Sql - Part I
    • Setting Up Vba For Sql - Part Ii
    • Setting Up Vba For Sql - Part Iii
    • Installing Obdc Driver
    • Setting Up Vba For Sql - Part I
    • Setting Up Vba For Sql - Part Ii
    • Setting Up Vba For Sql - Part Iii

    Sql: Querying Data

    • Where
    • Adding More Data
    • Order By
    • And
    • Or
    • Combining And And Or
    • Not
    • Where Field Is Not Null
    • As
    • No Records Returned
    • Between
    • Like
    • In
    • Select Distinct
    • Where
    • Adding More Data
    • Order By
    • And
    • Or
    • Combining And And Or
    • Not
    • Where Field Is Not Null
    • As
    • No Records Returned
    • Between
    • Like
    • In
    • Select Distinct

    Sql: Important Basic Statements

    • Changing The Table
    • Insert Ignore Into - Part I
    • Insert Ignore Into - Part Ii
    • Update
    • Delete
    • Changing The Table
    • Insert Ignore Into - Part I
    • Insert Ignore Into - Part Ii
    • Update
    • Delete

    Sql: Working With A Table

    • Reinserting The Data
    • Exporting A Database
    • Sql For Creating A Table
    • Create A Table Using Sql
    • Alter Table Add Column
    • Alter Table Modify Column
    • Alter Table Drop Column
    • Drop Table
    • Unique
    • Reinserting The Data
    • Exporting A Database
    • Sql For Creating A Table
    • Create A Table Using Sql
    • Alter Table Add Column
    • Alter Table Modify Column
    • Alter Table Drop Column
    • Drop Table
    • Unique

    Sql: Limit

    • Limit

    • Limit

    Sql: Joins

    • Inner Join - Part I
    • Inner Join - Part Ii
    • Left Join
    • Inner Join - Part I
    • Inner Join - Part Ii
    • Left Join

    Sql: Functions

    • The Min Function
    • The Max Function
    • The Count Function
    • The Group By Function
    • The Avg Function - Part I
    • The Avg Function - Part Ii
    • The Sum Function
    • The Having Keyword
    • The Min Function
    • The Max Function
    • The Count Function
    • The Group By Function
    • The Avg Function - Part I
    • The Avg Function - Part Ii
    • The Sum Function
    • The Having Keyword

    Sql: Adding Sql To The Live Project

    • Seat Planning Automation Vba And Sql

    • Seat Planning Automation Vba And Sql

    Instructors

    Mr Mark Lengyel
    Senior Software Developer
    Freelancer

    Trending Courses

    Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

    Popular Courses

    General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Cyber Security Courses Programming Courses Data Science Courses Law Courses Digital Marketing Courses Mechanical Engineering Courses Explore all courses

    Popular Platforms

    upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses NPTEL Courses IIT Kharagpur Courses Emeritus Courses IIT Kanpur Courses Explore all platforms

    Learn more about the Courses

    10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management
    Providers
    Close

    Download the Careers360 App on your Android phone

    Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

    Careers360 App
    150M+ Students
    30,000+ Colleges
    500+ Exams
    1500+ E-books