SQL for Beginners - Level 1

Duration: 6 Hours total (3 HOURS ONSITE TRAINING + 3 HOURS OF ONLINE ZOOM TRAINING)

This training program is designed to address all the major topics required to get started with Analytics in SQL with no prior experience necessary.

The program helps in critical thinking and implementation:

• Create a DB design for your day to day work data that you use in Excel
• Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.Understand Data Wrangling using Group, Joins, and UNION to get data in the format you need
• For any data that comes through new tools get new insights
• Get Excel equivalent functions for SQL commands
• Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)

OTHER AREAS COVERED 

• Understand why SQL is needed as a solution to the limitation of excel
• Connect to the SQL Server database and execute a simple query.
• Includes search condition in a simple query.Use various functions to perform calculations on data.
• Organize data obtained from a query before it is displayed on-screen.
• Use New York City data for running on SQL

Why will this workshop help you?

The 3-hour on-site workshop will get you started with data analytics using SQL, which is one of the most commonly used tools for data analytics. A wide range of organizations and businesses in all industries use SQL for data analytics. SQL can serve as the solution for Microsoft Excel’s limitations. This training workshop will get you acquainted with how you can use SQL in your everyday work. No prior experience is necessary.

You will be trained on:

• The fundamentals of SQL, databases, and data analytics
• How to think like a SQL developer
• How to execute a simple queries to be used in your day to day work
• Filtering, sorting, grouping, and joining data
• Data wrangling terms used in data analytics that are also common in other languages such (Python & R)
• SQL commands for equivalent Microsoft Excel function
• How to perform calculations on data 

What you’ll take away from this course:

• Knowledge on how to create a database and querying
• Knowledge on how to sort, group, join, and filter your data
• Preparation to move on to the Level 2 Intermediate SQL for Data Analytics Executive Training
• Lines of SQL code to add to your portfolio

What to Bring:

• Laptop with minimum 8GB ram and Chrome installed on it.
• Notebook for writing down notes