Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/content/77/8880177/html/ipartner/db.php on line 2
SQL Developer, SQL DBA Training -iPartner
loading...

SQL Developer, SQL DBA Training

  1. SQL Developer, SQL DBA Training
30hr / 332*
(* including all taxes.)


Key Features
SMALL
BATCHES
MENTORING
BY EXPERTS
FLEXIBLE
SCHEDULE
LEARN
BY DOING
GOAL
ORIENTED



Course Agenda


  • Types of Database
  • Client server Architecture
  • File server v/s client server DB’s
  • Client communication manager
  • Relational query processor
  • What SQL exactly is?
  • How to open SSMS
  • Introduction of SQL 2012
  • Windows authentication
  • Skima
  • T-sql
  • Keywords
  • Identification
  • System table
  • Data types
  • Functions
  • Data Manipulation
  • Data control language
  • Drop table
  • The commit/Rollback
  • Coolum
  • Select statement clauses
  • Using group by and having clauses
  • Logical and relational operators
  • Joins
  • Relational & logical opera
  • group function
  • Joins Constraints:-
  • Primary key
  • Foreign key
  • Unique key
  • check
  • Not null
  • Joins
  • Types of Joins
  • Complete explanation by using figures and query
  • Inner Join
  • Outer join
  • Self join
  • Creation of tables
  • Cross join
  • Set operators
  • Types of Set operators
  • Union
  • Union all
  • Intersect
  • Except
  • Rules of Set operators
  • Temporary Table creation
  • Facts about temporary tables
  • Table variables
  • Example of Function creation
  • Table variables limitations

  • System function
  • Single row function
  • Number function
  • Char/String function
  • Date function
  • General function
  • Inline function
  • Duplicate function
  • Sub queries
  • Sub queries used with IN or NOT IN
  • Sub queries used ANY or ALL
  • Sub queries used with EXISTS and NOT EXISTS
  • The update statement
  • Using the set clause to modify
  • Using the where clause
  • using the from clause
  • The DELETE statement
  • The TRUNCATE table statement
  • How to create view
  • Type of view
  • Views
  • Usage
  • Create view
  • Alter view
  • Drop view
  • Rename view
  • Modifying data using view
  • TSQL
  • Stored procedure
  • Advantage of stored procedure
  • How to create stored procedure
  • Drop procedure
  • Error handling in stored procedure
  • User defined function (UDF)
  • Scalar UDFs
  • Inline table value UDFs
  • Multi-statement table UDFs
  • Limitation of UDFs

  • Stored procedure:-
  • Try catch block
  • User stored procedure (UDFs)
  • Inline table value UDFs
  • Limitation of UDFs
  • User stored procedure (USP)
  • Rank function:-
  • Rank function:-
  • DENSE Rank
  • Row Number
  • Triggers
  • How to create Triggers
  • Pivot
  • SQL server management studio
  • Pivot in excel
  • Pivot in SQL server
  • Stuff
  • For XML path
  • Example for XML path
  • Difference between CHAR, Varchar and NVarchar
  • How to change values
  • Indexes
  • With no Indexes defined
  • How to create an Index
  • How Indexes works
  • Index advantages
  • Searching for records
  • Sorting records
  • Grouping records
  • Index drawbacks
  • Indexes and Data modification
  • Clustered Indexes
  • How to create a Clustered Index
  • Composite Indexes
  • Covering queries with an index
  • Additional Index guidelines
  • Common Table Expression
  • Example of CTE

Learn & Get

  • Understand Client/Server Architecture and types of Databases
  • Get an in-depth understanding of SQL, data types, Functions and Data Manipulation Language
  • Execute various Joins, Set Operators, Table Variables and Temporary Table Creation
  • Perform Indexing, Searching, Sorting and Grouping on records
  • Select and modify data through Views, T-SQL and Stored Procedures
  • Understand User-Defined functions (UDFs) and limitations of UDFs
  • Apply concepts of Triggers and how to create triggers
  • Understand functioning of different databases

Payment Method

PAYMENT METHODS
You need to pay through PayPal. We accept both Debit and Credit Card for transaction.
SCHOLARSHIPS
We subsidize our fees by 10% for military personnel, and college students with exceptional records. To apply for a scholarship, email info@ipartner.ca
FREQUENTLY ASKED QUESTIONS
In our iPartner self-paced training program, you will receive the training assessments, recorded sessions, course materials, Quizzes, related softwares and assignments. The courses are designed in such a way that you will the get real world exposure; the solid understanding of every concept that allows you to get the most from the online training experience and you will be able to apply the information and skills in the workplace. After the successful completion of your training program, you can take quizzes which enable you to check your level of knowledge and also enables you to clear your relevant certification at higher marks/grade where you will be able to work on the technologies independently.
In Self-paced courses, the learners are able to conduct hands-on exercises and produce learning deliverables entirely on their own at any convenient time without a facilitator whereas in the Online training courses, a facilitator will be available for answering queries at a specific time to be dedicated for learning. During your self-paced learning, you can learn more effectively when you interact with the content that is presented and a great way to facilitate this is through review questions and quizzes that strengthen key concepts. In case if you face any unexpected challenges while learning, we will arrange a live class with our trainer.
All Courses from iPartner are highly interactive to provide good exposure to learners and gives them a real time experience. You can learn only at a time where there are no distractions, which leads to effective learning. The costs of self-paced training are 75% cheaper than the online training. You will offer lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24*7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Please send an email. You can join our Live chat for instant solution.
We will provide you the links of the software to download which are open source and for proprietary tools, we will provide you the trail version if available.
You will have to work on a training project towards the end of the course. This will help you understand how the different components of courses are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the class.
Yes, we do keep launching multiple offers that best suits your needs. Please email us at: info@ipartner.ca and we will get back to you with exciting offers.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
Sure! Your feedbacks are greatly appreciated. Please connect with us on the email support - info@ipartner.ca.