SQL Server 2014

First Normal Form (1NF)

First Normal Form (1NF)
A database table is said to be in 1NF if it contains no repeating fields/columns.

• Make a separate table for each set of related attributes and give each table a primary key. In simple words we can say it as
• There are no repeating or duplicate fields.
• Each cell contains only a single value.
• Each record is unique and identified by primary key

Example:

ITEM COLORS PRICES TAX
Pen Red,Blue 3.0 0.40
Scale Red,Yellow 3.0 0.40
Pen Red,Blue 3.0 0.40
Bag Blue,Black 120.0 12.52

This table is not in first normal form because:

• A. There are multiple fields in color lab.

• B. Records are repeating (Duplicate records) or no primary key. First Normal Form (1NF)

ITEM COLORS PRICES TAX
Pen Red 3.0 0.40
Pen Blue 3.0 0.40
Scale Red 3.0 0.40
Scale Yellow 3.0 0.40
Bag Blue 120.0 12.52
Bag Black 120.0 12.52

This table is now in first normal form.

SQL DBA Training – LIVE Online Training

SQL DBA Training with Real-time Project, Job Support

SQL DBA Online Training (LIVE, Instructor-Led)
Real-time Practical SQL DBA LIVE Online Training designed to work with all major SQL Database Administration activities including DB Design, Normalized Views, Stored Procedures, Indexes, Joins, DB Maintenance, Query Tuning, HA/DR, AAG and SQL Cluster Issues. Study Material, 24×7 Online Lab, Certification, Job Support with One Real-time Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.

Register Today
contact@sqlschool.com
+91-9666440801 (India)
+91-9542916779 (India)
+91-(0)40 64577244 (India)
+1-510-400-4845 (USA/Canada)

Trainer Profile, Duration, Pricing

Trainer: Mr Sai Phanindra T (9+ Yrs Exp, MS FTE)

Duration: 7 Weeks (Mon – Fri/Sat). Installment Pay.

Total Course Fee: INR 18000/- ~ USD 300

Register Today
contact@sqlschool.com
+91-9666440801 (India)
+91-9542916779 (India)
+91-(0)40 64577244 (India)
+1-510-400-4845 (USA/Canada)

SQL DBA Online Training – Highlights
Completely Practical and Real-time
Suitable for Starters + Working Professionals
Session wise Handouts and Tasks + Solutions
TWO Real-time Case Studies, One Project
Certification & Interview Guidance
Detailed SQL Server Architecture, DB Design
Query Tuning, Stored Procedures, Linked Servers
In-Memory, DAC and Contained Databases
Routine DBA Activities, Emergency DBA Activites
High Availability, Disaster Recovery, Always-On

More Details and Free demo registration @ http://sqlschool.com/SQLDBA-Online-Training.html

SQL DBA LIVE Online Training with Real-time Project

SQL DBA LIVE Online Training with Real-time Project

All Training sessions are completely practical, real-time.

One Real-time Project included in the course.

Free demo today @ June 16th 7 PM India Time.

Register Now.

 

Microsoft SQL Server Training from SQL School

Mail: contact@sqlschool.com
Skype: SQL School
Address/Map
USA: +1 (510) 400 – 4845
India: +91 (040) 64577244 / 66343536 (Off)
India: +91 09666440801 (Mob)

 

 

SQL DBA LIVE Online Training with Real-time Project

 

One Real-time Project included in the course.

Free demo today @ June 16th 7 PM India Time.

Register Now.

 

SQL DBA LIVE Online Training with Real-time Project

 

http://sqlschool.com/Register.html

Register today for free demo!!

Call us on +91 9666440801 (INDIA)
Call us on +1 (510) 400-4845 (USA/CANADA)

Mail us on contact@sqlschool.com
Website: http://www.sqlschool.com

SQL School is rated the BEST Training Center for SQL Server and MSBI

https://www.google.co.in/?gfe_rd=cr&ei=OnhhVZfHG6_v8wequYHAAQ&gws_rd=ssl#q=sql+school

https://www.google.co.in/?gfe_rd=cr&ei=OnhhVZfHG6_v8wequYHAAQ&gws_rd=ssl#q=sql+school

 

SQL School Training Institute (www.sqlschool) offers you complete practical real-time trainings.

Courses Offered:
1. SQL Server Developer Course (http://sqlschool.com/TSQL-Online-Training.html)
2. SQL DBA Course (http://sqlschool.com/SQLDBA-Online-Training.html)
3. MSBI Course (http://sqlschool.com/MSBI-Online-Training.html)
4. SSIS Course (http://sqlschool.com/SSIS-Online-Training.html)
5. SSAS Course (http://sqlschool.com/SSAS-Online-Training.html)
6. SSRS Course (http://sqlschool.com/SSRS-Online-Training.html)

To register for free demo:
http://sqlschool.com/contact.html

Call Us:
Mail: contact@sqlschool.com
Skype: SQL School
USA (001): (510) 400 – 4845
India (0091): 9666440801

SQL Server Training with Realtime Project

SQL Server Introduction & Installation

  • SQL Server 2012 & 2014 Installation
  • Service Accounts & Types, Usage
  • Authentication Modes & Usage
  • Instance Configurations Options
  • SQL Server Features & Purpose
  • Using Management Studio (SSMS)
  • Configuration Tools & Use
  • Naming Conventions & Collation
Indexes and Query Tuning

  • Need for Indexes & Usage?
  • Indexing Table & View Columns
  • Index SCAN and SEEK
  • INCLUDED Indexes & Usage
  • Materializing Views (storage level)
  • Composite Indexed Columns & Keys
  • Indexes and Table Constraints
  • PRIMARY KEYS and NonClustered Indexes
SQL Server 2012 Database Design

  • SQL Server Database Architecture
  • Database Creation using GUI
  • Database Creation using T-SQL scripts
  • DB Design using Files and File Groups
  • File locations and Size parameters
  • DB Log Files and Placement
  • Database Structure modifications
Stored Procedures and Benefits

  • Why to use Stored Procedures?
  • Types of Stored Procedures
  • Use of Variables and parameters
  • SCHEMABINDING and ENCRYPTION
  • INPUT and OUTPUT parameters
  • System defined Stored Procedures
  • Dynamic SQL Queries and parameterization
SQL Server Tables & Queries

  • SQL Server Database Tables
  • Table creation using T-SQL Scripts
  • Naming Conventions for Columns
  • Single Row and Multi-Row Inserts
  • Table Aliases, Column Aliases & Usage
  • Table creation using Schemas
  • Basic INSERT, UPDATE, DELETE
  • SELECT queries and Schemas
User Defined Functions and Joins

  • Where to use Functions?
  • Scalar Valued Functions
  • Types of Table Valued Functions
  • SCHEMABINDING and ENCRYPTION
  • System Functions and Joins
  • Date Functions, Time Functions
  • String and Operational Functions
  • ROW_COUNT, GROUPING Functions
Data Validations and Constraints

  • Need for Data Integrity
  • Table creation using Constraints
  • NULL and IDENTITY properties
  • UNIQUE KEY Constraint and NOT NULL
  • PRIMARY KEY Constraint & Usage
  • CHECK and DEFAULT Constraints
  • Naming Composite Primary Keys
  • Disabling Constraints & Other Options
Triggers and Memory Limitations

  • Why to use Triggers?
  • DML Triggers and Performance impact
  • INSERTED and DELETED memory tables
  • Triggers for Audit operations
  • Triggers for Data Sampling
  • Database Triggers and usage
  • Server Triggers and limitations
  • Triggers for Bulk Operations
JOINS and Sub Queries

  • Variants of SELECT statement
  • Use of WHERE, IN and BETWEEN
  • ORDER BY, GROUPING, HAVING
  • Use of Predicates and TOP
  • Sub Queries and Nested Queries
  • DELETE FROM SELECT query variants
  • INSERT INTO … SELECT statement
Cursor Variables and Programming

  • Benefits of Cursor variables
  • Cursor declaration and life cycle
  • STATIC and DYNAMIC cursors
  • SCROLL and FORWARD_ONLY cursors
  • LOCAL and GLOBAL cursors
  • KEYSET Cursors and usage
  • Embedding Cursors in SPs and UDFs
Views, Joins and Queries

  • Benefit of Views in SQL Database
  • Views on Tables and Views
  • SCHEMABINDING and ENCRYPTION
  • Issues with Views and ALTER TABLE
  • Common System Views and Metadata
  • Common Dynamic Management views
  • Working with JOINS inside views
Transactions & Realworld Scenario

  • Transactions and Use
  • ACID Properties and Scope
  • EXPLICIT Transaction types
  • IMPLICIT Transactions and options
  • AUTOCOMMIT Transaction and usage
  • SAVEPOINT and Query Blocking
  • Complex SPs with Transactions
SQL School contact@sqlschool.com USA: +1 (510) 400 – 4845 India: +91 (0) 9666440801    /    +91 (040) 64577244

SQL DBA Training : Free Demo Session

https://www.facebook.com/events/739819492768746/?context=create&previousaction=create&source=49&sid_create=3654046097

Best Reviews for SQL School

SQL School Reviews

Please register for SQL Server & DBA Free Demo on Dec 25, 2014 6:00 AM IST at:

https://attendee.gotowebinar.com/register/8075895677041444865

LIVE Online Training

SQL Server Traning : Free Demo from www.sqlschool.com

SQL Server Traning : Free Demo from www.sqlschool.com

SQl School Trainings

SQL School Training Instutue : ISO Certified

 

Please register for SQL Server (T-SQL) Training Free Demo on Nov 24, 2014 7:00 AM IST at:

https://attendee.gotowebinar.com/register/7182435826248399362

After registering, you will receive a confirmation email containing information about joining the webinar.

SQL Server Traning : Free Demo from www.sqlschool.com

http://sqlschool.com/SQL-Server-Course.html