SQL Lessons in New York – $40

This course is made so that you can do smooth transition from SQL to Data Science.

Outline
Executing a Simple Query
Connect to the SQL Database
Query a Database
Save a Query
Modify a Query
Execute a Saved Query

Performing a Conditional Search
Search Using a Simple Condition
Compare Column Values
Search Using Multiple Conditions
Search for a Range of Values and Null Values
Retrieve Data Based on Patterns

Working with Functions
Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values Organizing Data

Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators

Retrieving Data from Tables
Combine Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables
Check for Unmatched Records
Retrieve Information from a Single Table Using Joins

Presenting Query Results
Save the Query Result
Generate an XML Report

Appendix A: The OGCBooks Database

After completing this course, students will know how to:
Connect to the SQL Server database and execute a simple query.
Include a 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.
Retrieve data from tables.
Format an output, save a result, and generate a report.

Advanced Topics in SQL – SQL tutor / class in NYC New York Manhattan
SQL tutor / class in NYC New York Manhattan
Basic Topics:
Executing a Simple Query
Working with Functions
Organizing Data
Retrieving Data from Multiple Tables using Joins
Presenting Query Results
Querying Using Subqueries
Manipulating Table Data
Views
Indexing
Transactions
Decision
Format
Stored Procedures
Automation

Other topics if needed:

OLAP Cubes in SQL Server for Adventure Works

Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012, 2014 and 2016

SQL for Data Analytics / SQL for data science makes you ready for delving more into data science.

Learn SQL Server 2016 Querying & Analytics

Query, Arrange, Group, Join, merge data using SQL server.
If you have SQL server installed in your system and Adventure-work Database we can start with the Code from the official books.
The prep is similar to SQL MS certification so that you can also take certification in the future.
A very good foundation to move to SQL Business Intelligence Applications.