Location:Main Road, Bangalore

courses@bangalore.com

The Complete Sql Server For Developers

Course

THE COMPLETE SQL SERVER FOR DEVELOPERS

Category

SQL Online Certification

Eligibility

Lateral Entry Professionals and Freshers

Mode

Regular Offline and Online Live Training

Batches

Week Days and Week Ends

Duration :

45 Days

SQL Objectives

•Learn about SQL Practices and guidelines.
•Build and run your first application in SQL.
•Learn SQL from scratch. Code like a PRO
•Read explore clean and prepare your script in SQL.
•Learning and Creating a complete SQL project in depth
•SQL – Learn how to set up your SQL script.
•Learn How to code in SQL in simple and easy way.
•Understand SQL and how to use it to write styles programmatically in SQL.
•Gain the ability to adapt to any coding language with the concepts of SQL

the complete sql server for developers Course Features

•Additional Sessions for Doubt Clearing
• First step to landing an entry-level job
•Job Placement Assistance with Good Companies
•Best Opportunity To Both Learn And Work From Home
•We Also provide Case studies for Online Training Courses
•Training by Proficient Trainers with more than a decade of experience
•We also provide Normal Track, Fast Track and Weekend Batches also for Working Professionals
•Very in depth course material with Real Time Scenarios for each topic with its Solutions for Online Trainings.

Who are eligible for SQL

•Cloud Computing, Cyber Security, Iot, Big Data, Business Analytics, Data Science, Python, Node.js, React.js, Hadoop, Aws, Qa
•Cognos Developer, Ab initio developer, Java Developers, .net Architects, Informatica, MSBI, Tivoli Monitoring, Oracle Apps functional and technical, change
•Java, Net, C#, Manual Testing, Automation Testing, Manual Testing With Healthcare, Android And Ios Developer
•networking, Test Cases, Automation Testing, perl, python, Protocol Testing, http, l4, l7, dns, tcp, ip, smtp, Cloud Computing, l3, l2, pig
•UI/UX Architect, C#, Asp.Net, Javascript, CSS, Ajax, HTML, MS SQL, Azure, SugarCRM, Php, MVC, MYSQL, CodeIgniter, Android Developer, HTML5, CSS3, JQuery

THE COMPLETE SQL SERVER FOR DEVELOPERS Syllabus

•Introduction to SQL Server and Cloud Databases
•Introduction to The Course
•What is Relational Databases and SQL Server
•Relational Databases Article
•Install SQL Server
•SQL Server Article
•Management Studio
•Cloud Databases
•SQL Server Database on Microsoft Azure
•Microsoft Azure Article
•SQL Server Database on AWS
•Amazon Web Services AWS RDS Article
•Databases Users and Authentications In SQL Server
•Create Your First Database
•Create and Manage Users
•Database Schema
•Exercise Create User
•AdventureWorks Database
•Database Tables Primary and Foreign Keys In SQL Server
•Introduction to The Chapter
•Database Tables
•Data Types
•Constraints
•Drop and Truncate Tables
•Exercise Create Tables Employees and Jobs
•Column Properties
•Primary Keys
•Foreign Keys
•Exercise Edit Country Column in Employees Table
•Exercise Create Table Previous Experience
•Import and Export Data
•Create Table Using Import Wizard
•Exercise Primary and Foreign Keys for Status Table
•Entity Relationship Diagram ERD
•Select Statements In SQL Server
•Select Statement
•Exercise Select data from AdventureWorks
•Where Clause
•Exercise Select data from AdventureWorks based on conditions
•Order by
•Create Table From Existing Table
•Exercise Create Table From Another Table
•And Or Not Is Null Operators
•Exercise And Or Not Is Null
•Like and Wildcards
•Exercise Like and Wildcards
•Advanced Like and Wildcards
•In
•Between
•Exercise Between
•Advanced Select Statements In SQL Server
•Distinct
•Percent
•Change The Rule of
•Union Operator
•Exercise Union Operator
•Intersect and Except
•CASE Statement
•Exercise CASE Statement
•Exercise Fill PreviousExpereince Table with Data
•Subqueries
•Exercise Subquery
•Aggregate Functions In SQL Server
•Aggregate Functions Min and Max
•Aggregate Functions Count
•Exercise Create Table Budget with Some Queries
•Aggregate Functions Avg and Sum
•Group By
•Having
•Exercise All in one
•Data Manipulation In SQL Server
•DML and DDL
•Insert Into Statement
•Exercise Insert Into Statement
•Insert Into Select Statement
•Delete Statement
•Update Statement
•Exercise Update Statement
•Exercise Update Status of Employees
•Generate Scripts
•String Functions in SQL Server
•Upper Lower and Reverse
•Replace Substring and Concat
•Exercise Gender
•Exercise Country Name
•Len
•CharIndex
•Exercise Extract Email Username
•Exercise Extract Email Service Provider
•Coalesce
•Replicate
•Right and Left
•Trim
•Numeric and Date Functions in SQL Server
•GetDate and DateAdd
•Exercise Add Two Years to birth date
•DateDiff
•DateName
•Exercise Get Age of Each Employee
•Round Ceiling and Floor
•Abs Rand and Sign
•Joins and Views in SQL Server
•Inner Joins
•More Inner Joins
•Multiple Inner Joins
•Exercise Joining Cities and Countries
•Exercise No of Cities in Each Country
•Right Outer Join
•Left Outer Join
•Create a View using SQL Script
•Modifying The Structure of a View
•Create a View using Management Studio
•Exercise Create View For Status of Each Employee
•Stored Procedures in SQL Server
•TSQL
•Stored Procedures
•Exercise Stored Procedures
•Stored Procedure with One Parameter
•Default Parameter Value
•Multiple Parameters
•Insert Statement Stored Procedure
•Exercise Delete Statement Stored Procedure
•Exercise Update Statement Stored Procedure
•Questions and Answers
•Part Questions to
•What is Relational Databases and SQL Server?
•Relational Databases (Article)
•SQL Server (Article)
•Microsoft Azure (Article)
•Amazon Web Services – AWS RDS (Article)
•Databases, Users and Authentications In SQL Server
•Exercise : Create User
•Database Tables, Primary and Foreign Keys In SQL Server
•Exercise : Create Tables Employees and Jobs
•Exercise : Edit Country Column in Employees Table
•Exercise : Create Table Previous Experience
•Exercise : Primary and Foreign Keys for Status Table
•Entity Relationship Diagram (ERD)
•Exercise : Select data from AdventureWorks
•Exercise : Select data from AdventureWorks based on conditions
•Exercise : Create Table From Another Table
•And, Or, Not, Is Null Operators
•Exercise : And, Or, Not, Is Null
•Exercise : Like and Wildcards
•Exercise : Between
•Change The Rule of 1000
•Exercise : Union Operator
•Exercise : CASE Statement
•Exercise : Fill PreviousExpereince Table with Data
•Exercise : Subquery
•Aggregate Functions – Min and Max
•Aggregate Functions – Count
•Exercise : Create Table Budget with Some Queries
•Aggregate Functions – Avg and Sum
•Exercise : All in one
•Exercise : Insert Into Statement
•Exercise : Update Statement
•Exercise : Update Status of Employees
•Upper, Lower and Reverse
•Replace, Substring and Concat
•Exercise : Gender
•Exercise : Country Name
•Exercise : Extract Email Username
•Exercise : Extract Email Service Provider
•Exercise : Add Two Years to birth date
•Exercise : Get Age of Each Employee
•Round, Ceiling and Floor
•Abs, Rand and Sign
•Exercise : Joining Cities and Countries
•Exercise : No of Cities in Each Country
•Exercise : Create View For Status of Each Employee
•T-SQL
•Exercise : Stored Procedures
•Exercise : Delete Statement Stored Procedure
•Exercise : Update Statement Stored Procedure
• (Questions 1 to 5)
• (Questions 6 to 10)
• (Questions 11 to 15)