- Understanding SQL Server Management Studio
- Identifying keywords in T-SQL, such as Drop Table.
- Various types of databases
- The distinction between client-server and file server databases
- SQL Table basics
- Introduction to Structured Query Language
- Transaction-SQL
- Data control language
- Authentication for Windows
- Home
- Intellipaat
- Courses
- SQL Developer and SQL DBA Training Masters Program
SQL Developer and SQL DBA Training Masters Program
Get engaged in the learning and understanding of the various functions performed by a Database Administrator using SQL Server in this program.
Online
₹ 12,027
Quick facts
particular | details | |||
---|---|---|---|---|
Collaborators
Microsoft Corporation
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
SQL Developer and SQL DBA Training Master's Program is a certification program allowing the learner to be proficient in SQL Database. It is a combo training course designed for the complete understanding and implementation of the enroller. This course will enable the learner to create, build, maintain and manage all the concepts taught during the course in practical life.
The enrolled candidate will learn SQL queries, Relational database functionalities, securing databases and also Automation of SQL Server. This program offers both Self-paced training and an online classroom program, so that the candidate chooses the option of his preference and enjoy the learning at his own comfort. Post completion of the programme, candidates will be able to implement the learnings in real business scenarios.
In the online classroom training, the candidate will be presented with the official course material issued by "Administering Microsoft ® SQL Server ® 2014 Databases and Microsoft for “Querying Data with Transact-SQL.
The highlights
- 32 hours e-learning videos
- 24x7 Lifetime support and access
- 32-hour Instructor-led training
- Certificate from Intellipaat
- One to one Doubt Resolution Sessions
Program offerings
- Projects
- Self paced learning
- Online classroom training
- Project work
- Exercises
Course and certificate fees
Fees information
The SQL Developer and SQL DBA Training Master's Programme fees are as follows-
- The fee amount of Rs. 25023 needs to be paid for an online classroom session
- The fee amount of Rs. 12027 needs to be paid for self-paced training
- An IGST of 18% will be applicable
Head | Amount in INR (Without GST) |
Online Classroom (exclusive of taxes) | Rs 25,023 |
Self-paced Training (exclusive of taxes) | Rs 12,027 |
certificate availability
certificate providing authority
Eligibility criteria
Education
A basic understanding of computer programming is needed to enroll in this programme.
Certification Qualifying Details
This course content for SQL Developer and SQL DBA Training Master's Program comprises of project work, content and curriculum. The projects post-completion are submitted to the reviewer team of Intellipaat. They check the submissions and accordingly clear the candidates. Also, it is a must to secure 60% marks minimum in the qualifying exam. Only then the participants will get the certification.
What you will learn
After the completion of the SQL Developer and SQL DBA Training Master's Program course, the candidate will be able to-
- Comprehend the meaning of SQL Developer and SQL database administration
- Modify data using Views, Stored Procedures and T-SQL
- Deployment of security and authentication methods on SQL server
- Cluster and replicate SQL Server Agent
- Deploy Set operators, Joins and Table Variables
- Know about the type of dependency
- Explore the topic Normalization and its forms
- Understand SQL subqueries
- Create database programmability objects by using T-SQL
- Apply transactions
- Learn the advanced concepts of SQL tables
Who it is for
The SQL Developer and SQL DBA Training Master programme online course are ideally best suited for professionals who are:
- Big data Professionals
- Hadoop Professionals
- Project managers
- Database Administrators
- Project Analysts
- Database Developers
Admission details
Filling the form
The following are the steps to be taken for enrolling in this programme.
Step 1: Visit the Course Url.
Step 2: There is a tab Enroll Now. Click it and then it will land you to the fee section
Step 3: Select the preferred fee option. Click on checkout and log in via Facebook ID or Google ID to make the payment
Step 4: Once the payment is done, the candidate can check the entire programme and start studying from it.
The syllabus
Introduction to SQL
Optimizing Database Objects
- Formulating statistics maintenance tasks
- Identifying missing indexes
- Accuracy of statistics
- Dynamic management objects management
- The performance management of database instances,
- Examining and troubleshooting query plans
- QL server performance monitoring
- Consolidating the overlapping indexes
SQL Operators
- Introduction to relational databases
- Understanding group functions, the unique key
- Logical and relational operators, indexes, constraints, domains, stored procedures, primary and foreign keys
- Fundamental concepts of relational rows, columns and tables
Implementing Programmability Objects
- Designing the components of stored procedures
- Executing control logic in stored procedures
- Applying error handling
- Using T-SQL statements
- Implementing input and output parameters
- Explaining foreign key constraints
- Usage of Data Manipulation Language (DML)
- Designing trigger logic, DDL triggers
Database Normalization and Entity-Relationship Model
- Entity and Entity Set
- Entity Sets
- What is Normalization?
- Degree of Relationship
- Relationship Sets
- Attributes and types of Attributes,
- Mapping Cardinalities
- Many-to-many
- One-to-Many
- Many-to-one
- One-to-One
- Symbols used in E-R Notation
- Data Anomalies
- Insertion Anomalies
- Update Anomalies,
- Deletion Anomalies
- Types of Dependencies
- Functional Dependency, Fully functional dependency, Partial functional dependency, Transitive functional dependency, Multi-valued functional dependency
- Lossy decomposition
- Decomposition of tables
- Lossless decomposition
- First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form (BCNF), Fourth Normal Form
Managing Database Concurrency
- Learning about implicit and explicit transactions
- Applying transactions
- Isolation levels management,
- Using memory-optimized tables
- Using the transaction behavior to identify DML statements
- Understanding concurrency and locking behavior
Working with SQL: Join, Tables and Variables
- Table creation
- Advanced concepts of SQL tables
- Operators & queries
- Data retrieval from tables,
- Deploying operators such as ‘intersect,’ ‘except,’ ‘union,
- Set operator rules, table variables,
- Temporary table creation,
- Combining rows from tables using the cross, inner, outer, and self joins,
Designing and Implementing Database Objects
- Learning to compare between indexed and included columns
- Designing and deploying views and column store views.
- Designing and implementing indexes
- Implementing a clustered index
- Designing and implementing relational database schema
Working with Subqueries
- Understanding different types of subqueries - where, insert, select, update, delete, and more
- Using the set clause to modify subqueries, understanding SQL subqueries, rules; statements and operators with which subqueries can be used,
- Methods to create and view subqueries
Querying Data with Advanced Transact-SQL Components
- Constructing recursive table expressions to meet business requirements
- Querying data using table expressions
- Querying temporal data and non-relational data
- Querying data using subqueries and APPLY
- Using windowing functions to the group and rank the results of a query.
- Grouping and pivoting data using queries
Deep Dive into SQL Functions
- Functions that can be used on datasets, such as numbers, strings, characters, and dates
- Scalar functions, aggregate functions
- Inline SQL functions
- General functions,
- Duplicate functions
- Understanding SQL functions – what do they do?
Programming Databases Using Transact-SQL
- Implementing error handling and transactions
- Implementing data types and NULL.
- Implementing transaction control in conjunction with error handling in stored procedures
- Creating database programmability objects by using T-SQL.
SQL Views, Functions and Stored Procedures
- Learning SQL views
- Methods of creating, altering, using, renaming, modifying and dropping views
- Working with stored procedures
- Error handling
- Understanding stored procedures and their key benefits
- Studying user-defined functions
SQL Optimization and Performance
- Use of indexes to cover queries, common table expressions, and index guidelines.
- Indexes and their creation,
- SQL Server Management Studio, using pivot in MS Excel and MS SQL Server
- Clustered indexes creation,
- Advantages, searching, sorting, modifying data;
- XL path
- Records grouping,
- Differentiating between Char, Varchar, and NVarchar
Deep Dive into User-defined Functions
- Types of UDFs, such as scalar, inline-table value, multi-statement table
- What is the rank function?
- User-defined functions
- Stored procedures and when to deploy them
- Triggers, and when to execute triggers
Managing Data with Transact-SQL
- Determining the results of DDL statements on supplied tables and data
- Creating Transact-SQL queries,
- Implementing functions and aggregating data,
- Querying multiple tables using joins,
- Modifying data
- Constructing DML statements using the output statement
Advanced Topics
- Correlated Subquery, Grouping Sets, Rollup, Cube
- Implementing Correlated Subqueries, using Grouping Set Query, using EXISTS with a Correlated subquery, Using Union Query, Using Rollup, Perform a partial CUBE, using CUBE to generate four grouping sets
- Hands-on Exercise
Microsoft Courses
Study Material
- Querying Data with Transact-SQL
- Performance Tuning and Optimizing SQL Databases
MS SQL Server DBA Course Content
Managing Data
- Restoring Databases
- Importing and Exporting Data
- Implementing and Maintaining Indexes
- Configuring and Maintaining a Back-up Strategy
Installation and Configuration
- Configuring Additional SQL Server Components
- Plan Installation
- Implementing a Migration Strategy
- Installing SQL Server and Related Services
- Manage SQL Server Agent
Optimizing and Troubleshooting
- Collecting, Analysing, and Troubleshooting Data
- Auditing SQL Server Instances
- Identifying and Resolving Concurrency Problems
Managing Instances and Databases
- Configuring SQL Server Instances
- Managing SQL Server Instances
- Managing and Configuring Databases
- Implementing an SQL Server Clustered Instance
Implementing High Availability
- Troubleshoot replication problems and identify appropriate replication strategy
- Implement AlwaysOn availability groups and AlwaysOn failover clustering
- Implementing replication
- Implementing AlwaysOn
Implementing Security
- Troubleshooting Security
- Managing Users and Database Roles
- Managing Database Security
- Managing Logins and Server Roles
How it helps
This SQL Developer and SQL DBA Training Master programme are highly beneficial to clear exams like Microsoft Certified Database Administrator (MCDBA) Exam, Microsoft 70-761 SQL Server Certification Exam and Microsoft 70-762Â SQL Server Certification Exam. Clearing these examinations generates opportunities to join top MNCs.
Real-time projects and assignments help the candidate to excel in real-world industry scenarios. Upon completion of this course, the certificate is awarded by Intellipaat. This certificate is of high importance and equal significance as of the one working for a period of 6 months in real industries. Top companies like Cognizant, Saint-Gobain, Genpact, Hexaware, and many more recognize the certificate by Intellipaat.
FAQs
There will be two certificates received by the candidate. One will be “Administering Microsoft ® SQL Server ® 2014 Databases”, “Querying Data with Transact-SQL” and the other by Intellipaat after the course completion.
There will be 3 projects a candidate has to work on. They are Querying a Large Relational Database, Relational Database Design and Writing Complex Subqueries.
This course is for the Project managers, Database Administrators, Big Data Professionals, Hadoop Professionals, Project analysts as well as the Project testers.
The candidate can get enrolled either into the self-paced training program or the instructor-led online classroom training program, by paying the requisite fees.
This program offers 32 Hrs Instructor-led Training, 64 hours of project work & exercises, 32 hours of self-paced videos, 24 x 7-lifetime support and access and flexible scheduling, job assistance and many others.