SQL Programming Training near me in HSR Layout, Bangalore

I am a data scientist in a reputed investment bank and have 10 years of experience in the field of data analytics and data science. I am willing to give lectures on the following topics/areas. 1. Core Java 2. SAS 3. Python 3. Data Structure 4. SQL 5. machine Learning. Also, I have delivered lectures in the same domain/areas for 2 years. you can reach out to me to get the commands over any topic/area as mentioned above.

SQL Programing Relational Database Fundamentals ? Overview of Relational Database Concepts ? Relational Databases and Relational Database Management Systems ? Data Normalization ? DDL Syntax Creating a Database ? Database Development Methodology Overview ? Building a Logical Data Model ? Identifying Entities and Attributes ? Isolating Keys ? Relationships Between Entities ? Creating Entity-Relationship Diagrams ? Transforming to Physical Design ? Migrating Entities to Tables ? Selecting Primary Keys ? Defining Columns ? Enforcing Relationships with Foreign Keys ? Constructing the Database Using DDL ? Creating Tables, Indexes, Constraints and Views ? Dropping Tables, Indexes, Constraints and Views ? Modifying Tables, Indexes, Constraints and Views Writing Basic SQL Queries ? Displaying Table Structures ? Retrieving Column Data From a Table or View ? Selecting Unique Values ? Filtering Rows Using the WHERE Clause ? Sorting Results Using ORDER BY ? Joining Multiple Tables ? Using Column and Table Aliases Manipulating Query Results ? Using Row Functions ? Character ? Numeric ? Date and Time ? Data Conversion (CAST and CONVERT) ? Using the CASE Function ? Handling Null Values Advanced Query Techniques ? Inner Joins ? Outer Joins (Left, Right, Full) ? Performing Self-Joins ? Subqueries ? Simple ? Correlated ? Using the EXISTS Operator ? Tips for Developing Complex SQL Queries ? Using Aggregate Functions ? AVG ? COUNT ? SUM ? MIN ? MAX ? Performing Set Operations ? UNION ? INTERSECT ? EXCEPT/MINUS ? Aggregating Results Using GROUP BY ? Restricting Groups with the HAVING Clause ? Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) ? Inserting Data into Tables ? Updating Existing Data ? Deleting Records ? Truncating Tables ? Performing Bulk Inserts ? Using the OUTPUT Clause ? Merging Data ? Working with Identity Columns and Sequences Stored Procedures ? Definition and Benefits of Use ? CREATE PROCEDURE ? Syntax ? Defining Input Parameters ? Defining Output Parameters ? Defining Optional Parameters ? ALTER and DROP PROCEDURE ? Implementation Differences complex Queries ? Using Wildcard Characters with Like ? Allowing Users to Build SQL Queries Dynamically ? Pivoting Data ? Summarizing Data with ROLLUP and CUBE ? Using Partitioned Aggregates Working with Data Types and Functions ? Effective Use of Data Types in SQL ? String ? Numeric ? Time/Date ? Other ? Substitution of Non-null Values with the COALESCE and ISNULL Functions ? Analyzing Data Points Using Ranking Functions Working with Table Expressions ? Overview of Table Expressions ? Working with Views ? Using Derived Tables ? Common Table Expressions ? Table-Valued Functions T-SQL Code Constructs ? Exploiting the Programming Features of T-SQL ? Conditional Constructs ? Looping Constructs ? Building Multi-Batch Scripts ? Invoking System Functions ? Using Variables in Scripts ? Using Temporary Tables in Scripts ? Handling Errors ? Using TRY...CATCH Blocks ? Using System Variables and Functions Triggers ? Definition and Benefits of Use ? Alternatives (e.g., Constraints) ? CREATE TRIGGER ? Syntax ? Trigger Types ? "Inserted" (or "NEW") and "Deleted" (or "OLD") Tables ? Event Handling and Trigger Execution ? ALTER and DROP TRIGGER Using T-SQL Cursors ? Overview of Cursors ? Declaring a Cursor ? Using OPEN CURSOR, CLOSE CURSOR, DEALLOCATE CURSOR Statements ? FETCHing Results ? Testing @@FETCH_STATUS and @@CURSOR_ROWS ? Updating Records with Cursors

I am a Software professional with 6+ years of experience in the IT industry and worked for TCS/Microsoft in the past. My key skills are .NET, SQL, SSIS and Azure. I have completed my M.Tech in CSE (full time). I have a passion for teaching and have an experience of teaching Maths in the past.

Working Professional with 4+ years of experience. 2+ years in taking Excel and SQL Classes -both at Student and Industry Level. 2+ Experience in coaching students for various competitive exams like CAT,MAT,XAT, Bank PO.

I am a data analyst having professional experience of 4+ years ,I expertise in providing Data driven business solutions to various verticals of MNC's such as Marketing, Sales, Forecasting etc. I am a part time tutor who enjoys teaching for my love towards statistics and how it can be used to make smart decisions in life.

I am having a very different approach towards learning and making others learn. Students will find the study easy and exciting under my guidance.

I am a graduate from Bits Hyderabad. I have worked as a Business Analyst in organisations such as Flipkart, Jupiter Money, Newton School. Have nearly 2 years of experience in coding SQL. I am a great mentor, you can learn the SQL fundamentals, problem solving and the art of logic building with me :)

I am having 6 yr teaching experience of all board. I have completed post graduation in MCA (computer). I have personal interest in teaching and make future of kids by motivating them.

Qualifications: 1. Mtech(Computer Scicence) from National Institute of technology karnataka (NITK) 2. B.E.(Information Technology) from RGPV Bhopal M.P. Work Experience: 1. 1 year internship In HP Research and Development Mahadevpura Bangalore. 2. Working In Oracle Server Technology Bangalore as software Engineer. I would like share my knowledge with the students and will be happy to help them to progress.