infyni

SQL Server with Tableau Course

This live course comes with a special offer. Register before April 30 and get a 10% discount. So grab your chance and enroll before its too late. Taken by experts you will have classes 5 days a week and learn through live and interactive sessions, with live projects and assignments.

Live Course

Live Class: Friday, 29 Apr

Duration: 22 Hours

Enrolled: 1

Offered by: infyni

Live Course

$318

Enrollment Closed Notify Me

About Course

You can now master the fundamentals of SQL Server along with Tableau. Learn how to create new databases, tables, and queries; manage query performance; create and restore a backup of a database; and lots more.

It is the leading database management platform from Microsoft and meant for beginners who want to create and manage SQL Server databases. Part of the course will be on how to create new databases, design tables, define relationships, write queries, and built-in functions. 

Here are some reasons why experts say you should learn an SQL course:

  • It is easy to install using a setup wizard
  • It has improved performance 
  • Several SQL server editions keep coming up 
  • It has a highly secure database that makes it nearly hard to breach security 
  • It has excellent data restoration and recovery mechanism
  • It costs lower to own

Offered along with Tableau this course can be the perfect training for the current market needs. So take a free trial and join us.


Skills You Will Gain

SQL Data tTypes Constraints Table statement Into Statement Data Mart Data Modelling Pivot TABLEAU interface Metadata

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (1)
1 Module 1
  • Introduction to databases
  • Sql server installation
  • Tables in sql
  • Data mart
  • Data modelling
  • Create, use and drop database
  • Data types
  • Constraints
  • Database normalization
  • Table statement
  • Into statement
  • Select statement
  • Where clause
  • And, or, not operators
  • Like and Between operators
  • Inner join
  • Left join
  • Right join
  • Full join
  • Delete and Truncate statements
  • Update statement
  • Order by clause
  • Group by clause
  • Having clause
  • Union and union all operators
  • Except operator
  • Intersect operator
  • Stored procedure
  • Views
  • Transactions
  • Exception handling
  • Rank function
  • Trigger
  • Pivot
  • Indexes
  • CTE
  • Assignment – SQL queries
  • SQL case study
  • Project – subqueries
  • Project – relational database design
  • TABLEAU overview and architecture
  • Introduction to TABLEAU
  • TABLEAU interface- working with metadata
  • Assignment-Joins
  • Marks card and hierarchies
  • Sorting and filtering
  • Groups, bins, sets
  • Parameters
  • Calculation in TABLEAU
  • Quick table calculation
  • Level of Detail
  • Advanced Assignment on module 1 to 3
  • Charts and graphs -1
  • Charts and graphs -2
  • Exercise 1
  • Exercise 2
  • Dashboards and stories -1
  • Dashboards and stories – 2
  • Assignment on Dashboard and Stories
  • Advanced Assignments on module 5 and 6
  • Maps in Tableau – 1
  • Maps in Tableau – 2
  • Data blending – Cross joins
  • Data extraction
  • Assignment- maps and data blending
  • Reference lines-bands
  • Forecasting-trend analysis
  • Tableau interactive dashboard
  • Assignment-visual analytics
  • Advanced assignment of module 8 and 9
  • Tableau prep PPT
  • Quiz
  • Covid 19 Data
  • UK bank Data, Product Data, Agricultural data

...
Uddipta Sarma
About Instructor

I am a Bachelor of Engineering (CSE) and PGDM in Marketing. Five years working experience as Data Analyst and 3 plus years as an online trainer for Power BI, Tableau, Excel, SQL Server for domestic and international clients and groups. I take courses in Python (basic to advanced), SQL server, Tableau Excel (basic to advanced), Excel with statistics, VBA and Google sheets. All my classes are live and online.

0

Rating

0

Review

168

Students

8

Courses