Course Overview
Without exception, all the projects I have worked with or even just heard about uses SQL (Structured Query Language) in one way or another. Thus, learning it is very useful for anyone who wants to have a career in the online world. But for a Data Analyst (or Data Scientist) it's a definite must, since SQL is one of the most common data languages, too. Let's see why:
- SQL is easy to learn
- SQL performs extremely well on bigger data sets (even a few million lines)
- SQL has been around for more than 40 years and it will be here for at least the next 40
Course Benefits :
After completion of this course, you will learn how to :
- Collect point by point data utilizing R profiler
- Configure factual programming
- Make utilization of R circle works and investigating deviceq l Understand basic programming language ideas
Course Modules
You will learn :
- Table Creation
- - Design
- - Refinement
- - Building SQL Schema Statement
- Populating and Modifying Tables
- - Inserting Data
- - Updating Data
- - Deleting
- Select
- - Table Alias
- - From Clause
- - Where Clause
- Filtering records
- - Condition Evaluation
- - Building condition
- - Range conditions
- - Membership condition
- Nonunique Primary key
- Non-existent Primary key
- Joins
- - Cartesian Product
- - Inner Join
- - Outer Join
- - Full Outer join
- Set Theory Primer
- Union
- Intersect
- Except
- String generation
- String Manipulation
- Working with Numeric data
- - Performing Arithmetic Functions
- - Controlling number precision
- - Handling Signed Data
- Dealing with date and time functions
- - Dealing with time zones
- - Generating temporal data
- Implicit and Explicit Groups
- Counting Distinct Values
- Using Expression
- Handle Null values
- Generating Groups
- - Single Column Grouping
- - Multicolumn Grouping
- - Grouping via expression
- - Grouping Rollups
- What is a Subquery
- Subquery Types
- Correlated Subqueries
- Noncorrelated Subqueries
- Exists Operator
- Subquery as a data source
- Subquery as a filter condition
- Subquery As Expression Generators
- What is Conditional Logic
- The Case Expression
- - Searched Case Expression
- - Simple Case Expressions
- Case Expression Examples
- - Result Set Transformations
- - Selective Aggregations
- - Checking for Existence
- - Division by Zero Errors
- - Handling Null Values
- What are Views
- Data Security
- Data Aggregations
- Hiding Complexity
- Joining Partitioned Data
- Updatable Views
- - Updating Simple Views
- - Updating Complex Views
- Ranking
- - ROW_NUMBER()
- - RAK()
- - DENSE_RANK()
- - PERCENT_RANK()
- - NTILE()
- VALUE
- - LAG()
- - LEAD()
- - FIRST_VALUE()
- - LAST_VALUE()
- - NTH_VALUE()
Capstone Project
FAQ
Any graduate, fresher, experienced and looking to start or change their career into data analytics can attend. No prior experience is mandatory.
Absolutely. We start the training from scratch. After completing the course you will not feel that you have never programmed.
Yes
Our trainers are from the industry. Every class is followed by real time assignments which will make you feel confident when you get into a job.
Fully online. You can attend from anywhere. You just need a laptop and a good internet connection
Yes 100%. It is live and fully interactive. We dont believe in running through power point presentations.
Please contact on the given number.
Contact Us
+91 70198 30464 / +91 79911 97543
Enroll / Enquire
Address : Saroj Iris, No. 106 (Wing A), Gunjur, Varthur Hobli, Bangalore - 560087
Phone : +91 70198 30464 / +91 79911 97543
Email :
info@dakshahanalyticsacademy.com, dakshahanalyticsacademy@gmail.com