Python Cheat Sheet-1

 

SQL SERVER SYLLABUS

Module 1: Introduction to Basic Database Concepts

 ·         What are Data, Fields, Records, and databases?

·         Limitations of File Management System.

·         Basic Concepts of Advantages of DBMS.

·         Exploring Relational DBMS

·         Understanding Client and Server Architecture.

·         Introduction to RDBMS

 

Module 2: E-R Modelling and Normalization

 ·         Analyzing the Requirements

·         Identify Entities and their Relationships

·         Drawing E-R Diagram

·         Conversion of E-R Diagrams into Tables

 

Normalization

·         First Normal Form

·         Second Normal Form

·         Third Normal Form

·         Boyce-Codd Normal Form (BCNF)

·         Fourth Normal Form Practically Normalizing Tables

 

Module 3: Introduction to SQL

 ·         What is SQL? Why SQL? History of SQL.

·         How to Install and Run SQL[ORACLE]

·         Basics of SQL Types of SQL Statements

·         SQL Commands:

DDL - Data Definition Language

DML - Data Manipulation Language 

DCL - Data Control Language

DQL - Data Query Language

TCL - Transaction Control Language

·         Create a Database using ORACLE

·         SQL CREATE TABLE Statement

·         SQL ALTER TABLE Statement

·         SQL INSERT INTO Statement

·         SQL UPDATE Statement

·         SQL SELECT Statement

·         Datatypes in SQL

·         Creating Users & Roles

·         Granting & Revoking of Roles & Privileges

 

Module 4: SQL Operators

 

·         What is an Operator in SQL?

·         SQL Arithmetic Operators

·         SQL Comparison Operators

·         SQL Logical Operators

·         SQL AND & OR Operators

·         Set Operators

·         SQL Expressions

·         SQL - Boolean Expressions

·         SQL - Numeric Expression

·         SQL - Date Expressions

Module 5: Aggregate Functions

 

·         Using functions in Queries

·         Using predefined functions

·         Built-In Functions

·         Scalar Functions

·         Numeric Functions

·         Character Functions

·         Conversion Functions

·         Aggregate Functions

·         Convenient Aggregate Functions

·         Statistical Aggregate Functions

 

Module 6: Joins and Sub Queries

 ·         Introduction to Joins and SQL Join Types

·         Inner Join

·         Outer Join

·         Self - Join

·         Left JOIN

·         Right Join

·         Full Join

·         Cross Joins

·         Co-related Sub Queries

·         Set Operations using Unions, Intersect, and Except

 

SQL Sub Queries

·         Single Row Sub Queries

·       Multi Row Sub Queries

      Subqueries with the SELECT Statement

·         Subqueries with the INSERT Statement

·         Subqueries with the UPDATE Statement

·         Subqueries with the DELETE Statement

 

Module 7: Working with SQL Constraints

 

·         NOT NULL Constraint

·         DEFAULT Constraint

·         Drop Default Constraint

·         UNIQUE Constraint

·         DROP a UNIQUE Constraint

·         Primary Key

·         Default Check Foreign Key

 

Module 8: Implementation of SQL Clauses and Data Integrity

 ·         SQL DISTINCT Clause

·         SQL WHERE Clause

·         SQL AND/OR Clause

·         SQL IN Clause

·         SQL BETWEEN Clause

·         SQL Like Clause

·         SQL ORDER BY Clause

·         SQL GROUP BY Clause

·         SQL COUNT Claus

·         SQL HAVING Clause

Data integrity

·         Entity integrity

·         Domain integrity

·         Referential integrity

·         Types of constraints

·         Data Integrity

 

Module 9: Implementing SQL Views and SQL Indexes

 

·         Introduction & Advantages of Views

·         Creating, Altering, and Dropping Views

·         Inserting Rows into a View

·         Deleting Rows into a View

·         Dropping Views

·         Advance Options while Creating a View

·         SQL Views With CHECK OPTION

 

SQL Indexes

·         The Create Index

·         Single-Column Indexes

·         Unique Indexes

·         Composite Indexes

·         Implicit Indexes

·         Drop Indexes

 

Module 10: Implementing Sequences and Triggers

 

·         SQL – Using Sequences

·         Using AUTO_INCREMENT column

·         Obtain AUTO_INCREMENT Values

·         Starting a Sequence at a Particular Value

·         Introduction to triggers

·         Constraints vs Triggers