Uncategorized

Happy Pongal From SQL School Training Institute

 

SQL School Training Institute is one of the world’s leading training providers. We partner with companies and individuals to address their unique needs, providing training and coaching that helps working professionals achieve their career goals.

We provide Online Training, Classroom Training and Video Training in disciplines such as SQL Server, SQL DBA, MSBI, Azure SQL, Power BI, Oracle PL-SQL, Oracle DBA, GoldenGate, RAC DBA, Python and Data Science among others, where technologies and best practices are changing rapidly and demand for qualified candidates significantly exceeds supply.

Website:

http://www.sqlschool.com

Call us:

Email: contact@sqlschool.com

India (+91): (0)40 64577244 (Office) | +91(0) 9666440801 (Mobile) | +91(0) 90 1434 1434 (24×7)

USA (+1): (510) 400-4845

#sqlserver #sqldba #msbi #plsql #Oracledba #python #datascience #powerbi #azuresql

Using of And, OR and NOT in SQL Server

AND: The AND operator displays a record if all the conditions separated by AND is TRUE.

Syntax:

SELECT column1, column2, …
FROM table_name
WHERE condition1 AND condition2 AND condition3 …;

Example:

SELECT * FROM Customers
WHERE Country=’India’ AND City=’Hyderabad’;

The above SQL statement selects all fields from “Customers” where country is “India” AND city is “Hyderabad”

OR:The OR operator displays a record if any of the conditions separated by OR is TRUE.

Syntax:

SELECT column1, column2, …
FROM table_name
WHERE condition1 OR condition2 OR condition3 …;

Example:

SELECT * FROM Customers
WHERE City=’Hyderabad’ OR City=’Pune’;

The following SQL statement selects all fields from “Customers” where city is “Hyderabad” OR “Pune”

NOT:The NOT operator displays a record if the condition(s) is NOT TRUE.

Syntax:

SELECT column1, column2, …
FROM table_name
WHERE NOT condition;

Example:

SELECT * FROM Customers
WHERE NOT Country=’India’;

Why to use SSIS?

PURPOSE OF SSIS:
E 1. TO PERFORM DATA EXTRACTION OPERATION FROM HETEROGENOUS (DIFFERENT FORMAT) SOURCES
EX: GATHER DATA FROM SQL DATABASE + EXCEL SHEET + TXT FILE

T 2. TO PERFORM DATA TRANSFORMATION OPERATIONS
EX: DUPLICATE DATA TO MULTIPLE SERVERS, COMPARE & MERGE

L 3. TO LOAD DATA ONTO ANY DESTINATIONS, OF ANY FORMAT.
EXTRACTION OF DATA(E), TRANSFORMATION (T), DATA LOADS (L)

4. TO DESIGN “DATAWAREHOUSE” (DWH). ALSO FOR DATA LOAD OPERATIONS @ ETL TECHNIQUES

DATAWAREHOUSE IS A DATABASE USED TO STORE HISTORICAL, BUSINESS LEVEL INACTIVE
INFORMATION. SSIS CAN BE USED TO COMPARE THE LIVE (REAL-TIME) DATA WITH EXISTING
WAREHOUSE DATA AND IDENTIFY NEW ROWS / UPDATES TO EXISTING ROWS.

5. TO PERFORM WINDOWS ADMIN ACTIVITES EX: IIS, WMI

6. TO PERFORM SQL DATABASE ADMIN ACTIVITES EX: DATABASE MIGRATIONS

7. TO PERFORM ANY TYPE OF SQL OPERATIONS (T-SQL, PL/SQL, EXCEL SQL…)

SSIS School of Training

 

How to Learn SQL DBA Course?

SQL DBA Training

Ensure you start to learn in the following order:
Step 1: Learn what is database and what is SQL?
Step 2: Learn what is DBMS and what is SQL Server?
Step 3: Learn basics of SQL Server and T-SQL Queries
Step 4: Learn Routine / Common SQL DBA Activities
Step 5: Learn Maintenance DBA Activities
Step 6: Learn Emergency DBA Activities
Step 7: Implement all above concepts in your PC ++ in on a Remote Sandbox provided in your Training Organization
Step 8: Learn and Implement / Simulate common errors and solutions that come in Real-time. There are POCs for various common errors and solutions. These are very much expected in almost every interview
Step 9: Attend minimum of FOUR to FIVE Mock Interviews from your trainining Institute.

SQL DBA Training

SQL DBA Training from SQL School

SQL DBA TRAINING

 

Register today for SQL DBA Training

   +91-9666440801 (INDIA)
   +91-9542916779 (INDIA)
   +91-(0)40 64577244 (INDIA)
   +1-510-400-4845 (USA/Canada)
Reach us on our Toll Free Number:
+91 90 1434 1434  (Available : 24 x 7)
Website: http://www.sqlschool.com

SQL School Training Courses & Jobs

SQL School Training Courses & Jobs

 

SQL School provides real-time trainings, projects and Jobs on various technologies including SQL Server, SQL DBA, MSBI, Power BI, Microsoft Azure, PL SQL, Oracle DBA, RAC DBA, Oracle Golden Gate and DataScience. We have experienced and certified trainers on these technologies.  

 

SQL School (www.sqlschool.com) have been providing trainings, placements and projects for more than TEN years and working with many MNCs for their direct training requirements including ADP, MindTree, Sonata, L& T, and many more. Few of the recent invoices can be found at www.sqlschool.com/clients 

 

Call us today for free demo.  

Toll Free: +91 90 1434 1434 

 

For Microsoft Technologies:  http://www.sqlschool.com 

 

For Oracle Technologies:  http://www.sqlschool.com/oracle 

 

For DataScience Technologies:  http://www.sqlschool.com/DataScience 

 

SQL School Training Courses & Jobs

#SQLSchool #Trainings #Projects #Jobs #SQLServer #T-SQL #SQLDBA #MSBI #PowerBI #Azure #PLSQL #OracleDBA #RACDBA #DataScience #Trainers 

SQL School Training Courses on Microsoft, Oracle and Data Science

SQL School Training Courses & Jobs

SQL Server FETCH & OFFSET Statements

OFFSET 10 ROWS
FETCH NEXT 20 ROWS ONLY
Constants for the OFFSET and FETCH NEXT can be dynamic.

— OTHER EXAMPLE WITH CTE, OFFSET:

WITH C AS
(
SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, SalesOrderID) AS rownum,
SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM Sales.SalesOrderHeader
)
SELECT SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM C
WHERE rownum BETWEEN 1 AND 10
ORDER BY OrderDate, SalesOrderID;

— OTHER EXAMPLE WITH CTE, OFFSET, PARAMETERIZATION:
DECLARE
@pagenum AS INT = 2,
@pagesize AS INT = 10;

WITH C AS
(
SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, SalesOrderID) AS rownum,
SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM Sales.SalesOrderHeader
)
SELECT SalesOrderID, OrderDate, CustomerID, SalesPersonID, SubTotal
FROM C
WHERE rownum BETWEEN (@pagenum – 1) * @pagesize + 1 AND @pagenum * @pagesizeORDER BY OrderDate, SalesOrderID

SQL DBA Training from Jan 16th

SQL DBA Training from Jan 16th

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 Realtime Project included in the course. Versions: SQL Server 2012, SQL Server 2014 & 2016.

Register today @ http://sqlschool.com/Register.html

MSBI (SSIS, SSAS, SSRS) Training with Real-time Project

MSBI (SSIS, SSAS, SSRS) Training with Real-time Project

Microsoft Business Intelligence – MSBI Online Training (LIVE, Instructor-Led)
This impeccable MSBI (SQL BI) course is carefully designed for aspiring BI Developers, Consultants and Architects. Program includes basic to advanced Business Intelligence and Data Warehouse concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). Complete practical and realtime training course with 24×7 free LIVE server access and Lab.

MSBI (SSIS, SSAS, SSRS) LIVE Online Training

MSBI (SSIS, SSAS, SSRS) LIVE Online Training

MSBI (SSIS, SSAS, SSRS) Training with Real-time Project