Advanced Data Analytics
About This Course
This course includes:
|
|
What you’ll learn:
|
|
Learning Objectives
Curriculum
Section 01: SQL Server Introduction, Configuration, Familiarization, Create Database, Tables and insert Data to the Tables.
Download SQL Server 2022 & SQL server management Studio8:52
Understanding SQL server connection with management Studio (SSMS)11:54
Familiarization and setup of SQL Server Tools18:53
How to Create a Project and save Files15:48
Use of SQL Server Configuration Manager11:11
By Graphical User interface to Creating Databases, Tables and File Extensions00:00:00
Guide to Creating a Database, Setting Up a Table, and Inserting Data using code00:00:00
Section 02: Database HRSchema, Tables, Data types, Table Schema, Import and Export Data set.
Section 03: Create Database, Table, insert data, how to fetch data from the table (Basic Queries) import-export Data (Exercises)
Section 04: Understanding Aggregation functions, key constraints, Primary key (Pk), Foreign Key (Fk) and Entity relationship diagram (ERD)
Section 05: Type of tables Joins. Draw multiple table diagram, types of Joins and Entity relationship diagram (ERD)
Section 06: Fetch data from the multiple tables and aggregated tables (Exercises)
Section 07: Type of SQL commands, DDL, DML, DQL, DCL, TCL, what is view, important of view and create different types of views.
Section 08: Temporary table, Importance, use of temporary tables. Union and Union ALL with Examples
Section 09: Understanding window functions (row_number, rank, dense_rank) Calculated columns (functions Cast, Convert, isnull, concat and Case Statement)
Section 10: Introduction to subqueries. Different types of Subqueries. Advanced Subquery Techniques and Advantages.
Section 11: Understanding Dynamic Queries, table variables, table index, constraints, and Date and Time Functions
Section 12: Learn Stored Procedure with Parameter, loop, conditional statement, Trigger and commit and rollback
Section 13: Learn Case studies, and real-world projects, solve business problems, and overall revision
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Your Instructors
Khondaker R Islam
Mr. Khondaker R Islam, a Microsoft-certified data science instructor with over 20 years of extensive experience in top-ranked pharmaceutical companies across the USA and Canada. With a distinguished background as a scientist and advisor in research and development, Mr. Islam has made significant contributions to numerous patents and drug discoveries, solidifying his reputation as a leading expert in the field.
Throughout his illustrious career, Mr. Islam has not only excelled in research and development but has also showcased his versatility by serving as a database administrator, software testing expert, and data analytics trainer. His expertise extends beyond theoretical knowledge, as he emphasizes real-world applications and industry-relevant curriculum design to empower learners and students for successful employment opportunities.
Currently serving as the President and CEO of KSI Data Research, Mr. Islam continues to drive innovation and excellence in the field of data science. Prior to this role, he held positions at esteemed organizations such as California Inc, Sallie Mae, Pfizer, WR Grace Com. Purdue Pharma, and Pharmacopeia Inc., among others. His tenure at these world-renowned companies speaks volumes about his exceptional skills and contributions to the industry.
Mr. Islam's academic journey is equally impressive, with degrees from prestigious institutions including the University of Notre Dame, Dhaka University, and Howard University. Additionally, he holds certifications from CBC, Canada in Database Diploma and is recognized as an Oracle and
With his wealth of knowledge, hands-on experience, and commitment to excellence, Mr. Khondaker R Islam continues to be a driving force in the field of data science, shaping industry solutions and empowering the next generation of professionals
As the President and CEO of KSI Data Research, thrilled to welcome you to our dynamic digital space. At KSI, we believe in the transformative power of knowledge and technology, and it is our mission to unlock limitless possibilities for individuals and businesses worldwide.
Student Feedback
Reviews (13)
Great course for beginners. Learnt a lot about PowerBi, Sql and advanced Excel.
it was very good course
Well
Excellent course
KSI data research is a institute where student learn here as like learn from home tutor.
Personal Skill Developed,its very helpful.Thanks to KSI mentors for your support.
The curriculum is well-structured and includes the latest industry trends.
Excellent program.
enhances learning experience
I am delighted to happy finish this type of Data Analytics course
very good
Instructor and the Learning Environment were really Great. I admire all the KSI stuffs for being friendly through out the entire journey. I pay my exceptional gratitude as of my current Job Placement has been secured for this outstanding training and guideline.
Good
$1,900
