The various types of databases, introduction to Structured Query Language, distinction between client server and file server databases, understanding SQL Server Management Studio, SQL Table basics, data types and functions, Transaction-SQL, authentication for Windows, Data control language, Identification and Keywords in T-SQL, Drop Table.
Introduction to relational databases, basic concepts of relational tables, working with rows and columns, various operators used like logical and relational, domains, constraints, stored procedures, indexes, primary key and foreign key, understanding group functions, unique key.
Deep dive into SQL Tables, working with SQL functions, operators and queries, creation of tables, retrieving data from tables, combining rows from tables using Inner, Outer, Cross and Self joins, deploying Operators like Union, Intersect, Except, creation of Temporary Table, Set Operator rules, working with Table variables.
Understanding what SQL functions do, aggregate functions, scalar functions, functions that work on different data sets like numbers, characters & strings, dates, learning Inline SQL functions, general functions and duplicate functions.
Understanding of SQL Subqueries, rules of Subqueries, the statements and operators with which Subqueries can be used, modification of sub queries using set clause, understanding the different types of Subqueries – Where, Insert, Update, Select, Delete, etc., ways to create and view Subqueries.
Learning about SQL Views, ways of creating, using, altering, dropping, renaming and modifying Views, understanding Stored Procedures, key benefits of it, working with Stored Procedures, error handling, studying user-defined functions.
Detailed study of user-defined functions, various types of UDFs like Scalar, Inline Table Value, multi-statement Table, what are Stored Procedures? when to deploy Stored Procedures? What is Rank Function? Triggers, when to execute Triggers?
Detailed understanding of SQL Server Management Studio, learning what is Pivot in Excel and SQL Server, XL path, differentiating between Char, Varchar and NVarchar, working with Indexes, creation of Index, advantages, records grouping, searching, sorting, modifying data, creation of clustered indexes, using index to cover queries, index guidelines and Common Table Expression.
Project : Writing complex Sub Queries
Industry : General
Problem Statement : How to create sub queries using SQL
Topics : This project will give you hands-on experience in working with SQL sub-queries and utilizing it in various scenarios. Some of the sub-queries that you will be working with and gain hands-on experiences in are – IN or NOT IN, ANY or ALL, EXISTS or NOT EXISTS, and other major queries.
Project 2 : Querying SQL Server in an ecommerce enterprise
Industry : Ecommerce
Problem Statement : Simplifying the process of data extraction, update and modifying within an enterprise SQL Server of an ecommerce company.
Description : In this project you will deploy the various SQL queries for communicating with an MS SQL Server database. You will work on writing DDL; DML queries to get the task done that you are seeking or some additional actions that you need to perform.
Project 3 : Communicating with cloud database
Industry : General
Problem Statement : This project involves working with the MS SQL Server database deployed in the cloud. As part of the project you will learn the distinction between client server and file server databases, creating and updating database tables, using Primary Key & Foreign Key for linking two tables.
This Intellipaat SQL Developer training will make you fully proficient in SQL, the relational database concepts, mastering the technique of querying, creating Subqueries, joins and unions, coming up with indexing, optimization theory, installing SQL server and clustering. This entire course content is in line with the requirements of clearing the Microsoft SQL Server Certification Exam.
You will be working on real time SQL projects that have high relevance in the corporate world, step-by-step assignments and curriculum designed by industry experts. Upon completion of the training course you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 Support, and course material upgrading to latest version at no extra fees. Hence it is clearly a one-time investment.
This course is designed for clearing the Microsoft 70-761 SQL Server Certification Exam. The entire training course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in the top MNCs. As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.
At the end of this training program there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks in certification exam.
Intellipaat Course Completion certification will be awarded on the completion of Project work (on expert review)and upon scoring of at least 60% marks in the quiz. . Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Wipro, Standard Chartered, TCS, Genpact, Tata Communication etc.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org