Learn SQL Server 2016 Querying & Analytics For Just $29/hr!! (Elmhurst)

Mode: Batch of 3

Learn SQL Server 2016 Querying & Analytics

This course is for those who want to make the transition from SQL to Data Science Smooth!

Basic Outline of the Course:

1. Executing a Simple Query
2. Connect to the SQL Database
3. Query a Database
4. Save a Query
5. Modify a Query
6. Execute a Saved Query
7. Performing a Conditional Search
8. Search Using a Simple Condition
9. Compare Column Values
10. Search Using Multiple Conditions
11. Search for a Range of Values and Null Values
12. Retrieve Data Based on Patterns
13. Working with Functions
14. Perform Date Calculations
15. Calculate Data Using Aggregate Functions
16. Manipulate String Values Organizing Data
17. Sort Data
18. Rank Data
19. Group Data
20. Filter Grouped Data
21. Summarize Grouped Data
22. Use PIVOT and UNPIVOT Operators
23. Retrieving Data from Tables
24. Combine Results of Two Queries
25. Compare the Results of Two Queries
26. Retrieve Data by Joining Tables
27. Check for Unmatched Records
28. Retrieve Information from a Single Table Using Joins
29. Presenting Query Results
30. Save the Query Result
31. Generate an XML Report

Appendix A: The OGCBooks Database / Adventure works database

After completing this course, students will know how to:

1. Connect to the SQL Server database and execute a simple query.
2. Include a search condition in a simple query.
3. Use various functions to perform calculations on data.
4. Organize data obtained from a query before it is displayed on-screen.
5. Retrieve data from tables.
6. 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:
1. Executing a Simple Query
2. Working with Functions
3. Organizing Data
4. Retrieving Data from Multiple Tables using Joins
5. Presenting Query Results
6. Querying Using Subqueries
7. Manipulating Table Data
8. Views
9. Indexing
10. Transactions
11. Decision
12. Format
13. Stored Procedures
14. Automation

Other topics if needed:

1. OLAP Cubes in SQL Server for Adventure Works
2. Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012, 2014 and 2016
3 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.

Instructor:

Instructor: Ankit Vora, PhD/ Shivgan Joshi

Ankit Vora, PhD

Ankit Vora is a research scientist and a co-founder of a startup situated in the city of New York, and his research focuses on detecting cancer using machine learning algorithms. He also works on automating agricultural machinery using artificial intelligence and building smart robotics and drones for a host of applications. Ankit did his doctoral work on Meta-Materials for solar cells at the Michigan Technological University. He has an extensive teaching and mentoring experience; from mentoring university students, teaching to academic and industry professionals. Ankit has been teaching Python and other programming languages for the past five years to the industry professionals. As Python is gaining momentum and becoming popular, it is finding applications in the high demand fields such as data science, machine learning, artificial intelligence, big data, etc. Ankit has been actively involved in training and nurturing professionals into these high demand fields, especially data science and machine learning using Python. He also does professional consulting for industrial and academic projects.

LinkedIn (Ankit): https://www.linkedin.com/in/drankitvora

Google Scholar profile: https://scholar.google.com/citations?user=8rrNVZwAAAAJ&hl=en

Shivgan Joshi

Shivgan Joshi is an executive trainer and talent acquisition consultant at QcFinance and has worked in the field of data science across disciplines, including engineering, investment banking, and technology. Previously, Joshi served as data science manager for BaiNYC and co-founder of QcFinance. At QcFinance, Joshi developed Python, R, SQL, MatLab, VBA, and BAT courses focused on all aspects of finance, including trading and modeling of quantitative portfolios.

He is passionate about elevating businesses through the implementation of data science and data analytics. He has delivered online, live, and interactive training sessions to students and executives around the globe. Joshi realizes the value of adequately leveraging data and commits to helping businesses to do successfully. He holds an undergraduate and graduate degree in data science as well as a Master of Business Administration.

https://www.udemy.com/user/shivganjoshi2/

Shivgan Joshi (929 356 5046)
Linkedin (Instructor): https://www.linkedin.com/in/shivganjoshi/
Udemy: https://www.udemy.com/user/shivganjoshi2/

Or Call Us at : 1 31228 56886