phone+91-87222 63165 / +1(510)-379-9024 contact@syncomint.com
Try Our Sample Training Videos

Course Info

SQL DBA

SQL Server offers a sophisticated platform for enterprise data management.Organizations rely on SQL Server database administrators who know how to manage their mission-critical databases correctly.

Benefits of the Program

Syncomint provides you an extensive hands-on course on SQL DBA, this course is designed for those new to SQL Server where you gain the fundamental knowledge and skills to create and configure SQL, and also learn about advanced database infrastructure design, optimization, maintenance, troubleshooting and security.

Topic List This course on SQL DBA will teach you fundamental SQL skills. You'll work on hands-on to analyze various aspects of SQL that will make you a pro in this field. Syncomint provides you Classroom Training as well as Live Virtual Training. Course Content
[formac-acc title="Lesson 1: Database Design"]Database Models,Beginnings, Some Introductory Terminology, Codd's 12 Rules, Normalization, First Normal Form, Higher Order Normal Forms[/formac-acc][formac-acc title="Lesson 1: Database Design"]Database Models,Beginnings, Some Introductory Terminology, Codd's 12 Rules, Normalization, First Normal Form, Higher Order Normal Forms[/formac-acc] [formac-acc title="Lesson 2:Oracle Standard Interfaces"]SQL,SQL*Plus, Oracle Architecture, Interfaces to Oracle, Command Line Interface, Viewing a Sample Table, The Graphical User Interface,The SQL Buffer, The Web-Based Interface[/formac-acc] [formac-acc title="Lesson 3: The Sample Database"]The Entity Relationship Model, Entity Relationship Diagrams, The Sample Database, ER Diagram for Sample Database, Creating the Sample Dat, , Viewing Sample Data, Data Types of the Sample Data[/formac-acc] [formac-acc title="Lesson 4: Data Definition Language"]Categories of SQL Statements, Oracle Datatypes, The CREATE Statement, The DROP Command, The ALTER Command, Integrity Constraints, Entity Integrity Constraints, Referential Integrity Constraints, Modifying Table to Use Constraints,Checking Constraints, The Data Dictionary[/formac-acc] [formac-acc title="Lesson 5: Data Manipulation Language"]DML Statements, The SELECT Statement, The INSERT Statement, The DELETE Statement, The UPDATE Statement, More SQL*Plus Commands[/formac-acc] [formac-acc title="Lesson 6: Transaction Control"]Transactions, Command Classification, Savepoints, The SET TRANSACTION Command[/formac-acc] [formac-acc title="Lesson 7: SQL Operators"]Introduction, The DISTINCT Keyword, Aliases, Miscellaneous Functions, Mathematical Functions, String Functions, Date Functions, Conversion Functions, Pseudo Columns[/formac-acc] [formac-acc title="Lesson 8: SQL Functions"]DML Statements, The SELECT Statement, The INSERT Statement, The DELETE Statement, The UPDATE Statement, More SQL*Plus Commands[/formac-acc] [formac-acc title="Lesson 9: Joining Tables"]Joins, Cartesian Product, Inner Joins, Equi-Join, Table Aliases, Non-Equi Join, Non-Key Join, Reflexive Join, Natural Join, Outer Joins, Right Outer Join, Left Outer Join, ull Outer Join, Oracle-Specific Syntax for OuterJoins[/formac-acc] [formac-acc title="Lesson 10: Set Operators"]Introduction, Selection Criteria, Union, Union All, Intersect, Minus[/formac-acc] [formac-acc title="Lesson 11: SQL Subqueries"]Introduction, Using a Subquery with a DML Statement, Typical Subqueries, Subquery Operators, Standard vs. Correlated Subqueries, Correlated Subquery Example, Predicate Operators[/formac-acc] [formac-acc title="Lesson 12: Groups"]SQL Statements, GROUP BY Clause, HAVING Clause, Order of a SELECT Statement[/formac-acc] [formac-acc title="Lesson 13: More Database Objects"]More Database Objects, Relational Views, Updating a View, Create or Replace, Forcing a View, The Data Dictionary Revisited, Indexes, Synonyms[/formac-acc] [formac-acc title="Lesson 14: Reports"]Report Features, Session Contro, The SET Comman, The COLUMN Comman,The BREAK Command,The COMPUTE Command[/formac-acc] [formac-acc title="Lesson 15: Introduction"]SQL vs. PL/SQL, A Few Simple Examples, Saving Procedures, A More Complete Picture, Comments, Variable Substitution, Simple Exception Handling, Advantages of PL/SQL, Assignments[/formac-acc] [formac-acc title="Lesson 16: Declarations and Data Types"]Declarations, tandard Data Types, Initialization, Variable Names, Specialized Data Types - %TYPE, Specialized Data Types - %ROWTYPE, Building Your Own Data Types -Records, A Quick look at Loops Arrays, Tables, Nested Blocks[/formac-acc] [formac-acc title="Lesson 17:Standard Data Types"]Declarations, tandard Data Types, Initialization, Variable Names, Specialized Data Types - %TYPE, Specialized Data Types - %ROWTYPE, Building Your Own Data Types -Records, A Quick look at Loops Arrays, Tables, Nested Blocks[/formac-acc] [formac-acc title="Lesson 18: Language Components"]Introduction, Assignments, Decision Making Statements, Simple Loops, Loops - for, Loops - indefinite, Loops - while, Simple Loops, Nested Loops, Boolean Variables, PL/SQL Relational Operators, PL/SQL Logical Operators, The CASE Construct[/formac-acc] [formac-acc title="Lesson 19: Exceptions"]Introduction, Cursor Manipulation, Using the Cursor, For Loops Cursors, Cursor Attributes, Cursor Parameters, Nested Cursors, Cursor Exceptions[/formac-acc] [formac-acc title="Lesson 20: Functions and Procedures"]Errors in Programs, Run Time Exceptions, Oracle Built In Exceptions, Unnamed Exceptions, Built in Exception Functions, Creating Your Own Exceptions,Building Non Terminating Exceptions[/formac-acc]

ClassRoom Schedule

Classroom Training - 10 Days

Day 1

11AM-5PM
Database Design
  • Database Models
  • Beginnings
  • Some Introductory Terminology
  • Codd's 12 Rules
  • Normalization
  • First Normal Form
  • Higher Order Normal Forms
  • Oracle Standard Interfaces
SQL
  • SQL*Plus
  • Oracle Architecture
  • Interfaces to Oracle
  • Command Line Interface
  • Viewing a Sample Table
  • The Graphical User Interface
  • The SQL Buffer
  • The Web-Based Interface

Day 2

11AM-5PM
The Sample Database
  • The Entity Relationship Model
  • Entity Relationship Diagrams
  • The Sample Database
  • ER Diagram for Sample Database
  • Creating the Sample Data
  • Viewing Sample Data
  • Data Types of the Sample Data
Data Definition Language
  • Categories of SQL Statements
  • Oracle Datatypes
  • The CREATE Statement
  • The DROP Command
  • The ALTER Command
  • Integrity Constraints
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Modifying Table to Use Constraints
  • Checking Constraints
  • The Data Dictionary

Day 3

11AM-5PM
Data Manipulation Language
  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • More SQL*Plus Commands
Transaction Control
  • Transactions
  • Command Classification
  • Savepoints
  • The SET TRANSACTION Command

Day 4

11AM-5PM
SQL Operators
  • Simple Selects
  • Comparison Operators
  • IN and NOT IN Operators
  • BETWEEN Operator
  • The LIKE Operator
  • Logical Operators
  • IS NULL and IS NOT NULL
  • ANY
  • ALL
SQL FUNCTIONS
  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Miscellaneous Functions
  • Mathematical Functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Pseudo Columns

Day 5

11AM-5PM
Joining Tables
  • Joins
  • Cartesian Product
  • Inner Joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Oracle-Specific Syntax for OuterJoins
Set Operators
  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus

Day 6

11AM-5PM
SQL Subqueries
  • Introduction
  • Using a Subquery with a DML Statement
  • Typical Subqueries
  • Subquery Operators
  • Standard vs. Correlated Subqueries
  • Correlated Subquery Example
  • Predicate Operators
Groups
  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement

Day 7

11AM-5PM
More Database Objects
  • More Database Objects
  • Relational Views
  • Updating a View
  • Create or Replace
  • Forcing a View
  • The Data Dictionary Revisited
  • Indexes
  • Synonyms
Reports
  • Report Features
  • Session Control
  • The SET Command
  • The COLUMN Command
  • The BREAK Command
  • The COMPUTE Command

Day 8

11AM-5PM
Introduction
  • SQL vs. PL/SQL
  • A Few Simple Examples
  • Saving Procedures
  • A More Complete Picture
  • Comments
  • Variable Substitution
  • Simple Exception Handling
  • Advantages of PL/SQL
  • Assignments
Declarations and Data Types Declarations
  • Standard Data Types
  • Initialization
  • Variable Names
  • Specialized Data Types - %TYPE
  • Specialized Data Types - %ROWTYPE
  • Building Your Own Data Types -Records
  • A Quick look at Loops Arrays
  • Tables
  • Nested Blocks

Day 9

11AM-5PM
Language Components
  • Introduction
  • Assignments
  • Decision Making Statements
  • Simple Loops
  • Loops - for
  • Loops - indefinite
  • Loops - while
  • Simple Loops
  • Nested Loops
  • Boolean Variables
  • PL/SQL Relational Operators
  • PL/SQL Logical Operators
  • The CASE Construct
Cursors
  • Introduction
  • Cursor Manipulation
  • Using the Cursor
  • For Loops Cursors
  • Cursor Attributes
  • Cursor Parameters
  • Nested Cursors
  • Cursor Exceptions

Day 10

11AM-5PM
Exceptions
  • Errors in Programs
  • Run Time Exceptions
  • Oracle Built In Exceptions
  • Unnamed Exceptions
  • Built in Exception Functions
  • Creating Your Own Exceptions
  • Building Non Terminating Exceptions
Functions and Procedures
  • Introduction
  • Creating a Procedure
  • Example Procedure
  • Using Parameters
  • Functions
  • Procedures and Exceptions
Appendix A: An SQL and SQL*Plus Reference
  • DDL Statements
  • DML Statements
  • Transaction Control Statements
  • Operators
  • Common SQL*Plus Commands

Live Virtual Class Schedule

Virtual Training - 5 Days

Day 1

8AM-12PM && 1PM-5PM
Database Models
  • Beginnings
  • Some Introductory Terminology
  • Codd's 12 Rules
  • Normalization
  • First Normal Form
  • Higher Order Normal Forms
Oracle Standard Interfaces
  • SQL
  • SQL*Plus
  • Oracle Architecture
  • Interfaces to Oracle
  • Command Line Interface
  • Viewing a Sample Table
  • The Graphical User Interface
  • The SQL Buffer
  • The Web-Based Interface
The Sample Database
  • The Entity Relationship Model
  • Entity Relationship Diagrams
  • The Sample Database
  • ER Diagram for Sample Database
  • Creating the Sample Data
  • Viewing Sample Data
  • Data Types of the Sample Data
Data Definition Language
  • Categories of SQL Statements
  • Oracle Datatypes
  • The CREATE Statement
  • The DROP Command
  • The ALTER Command
  • Integrity Constraints
  • Entity Integrity Constraints
  • Referential Integrity Constraints
  • Modifying Table to Use Constraints
  • Checking Constraints
  • The Data Dictionary

Day 2

8AM-12PM && 1PM-5PM
Data Manipulation Language
  • DML Statements
  • The SELECT Statement
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • More SQL*Plus Commands
Transaction Control
  • Transactions
  • Command Classification
  • Savepoints
  • The SET TRANSACTION Command
SQL Operators
  • Simple Selects
  • Comparison Operators
  • IN and NOT IN Operators
  • BETWEEN Operator
  • The LIKE Operator
  • Logical Operators
  • IS NULL and IS NOT NULL
  • ANY
  • ALL
SQL FUNCTIONS
  • Introduction
  • The DISTINCT Keyword
  • Aliases
  • Miscellaneous Functions
  • Mathematical Functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Pseudo Columns

Day 3

8AM-12PM && 1PM-5PM
Joining Tables
  • Joins
  • Cartesian Product
  • Inner Joins
  • Equi-Join
  • Table Aliases
  • Non-Equi Join
  • Non-Key Join
  • Reflexive Join
  • Natural Join
  • Outer Joins
  • Right Outer Join
  • Left Outer Join
  • Full Outer Join
  • Oracle-Specific Syntax for OuterJoins
Set Operators
  • Introduction
  • Selection Criteria
  • Union
  • Union All
  • Intersect
  • Minus
SQL Subqueries
  • Introduction
  • Using a Subquery with a DML Statement
  • Typical Subqueries
  • Subquery Operators
  • Standard vs. Correlated Subqueries
  • Correlated Subquery Example
  • Predicate Operators
Groups
  • SQL Statements
  • GROUP BY Clause
  • HAVING Clause
  • Order of a SELECT Statement

Day 4

8AM-12PM && 1PM-5PM
More Database Objects
  • More Database Objects
  • Relational Views
  • Updating a View
  • Create or Replace
  • Forcing a View
  • The Data Dictionary Revisited
  • Indexes
  • Synonyms
Reports
  • Report Features
  • Session Control
  • The SET Command
  • The COLUMN Command
  • The BREAK Command
  • The COMPUTE Command
Introduction
  • SQL vs. PL/SQL
  • A Few Simple Examples
  • Saving Procedures
  • A More Complete Picture
  • Comments
  • Variable Substitution
  • Simple Exception Handling
  • Advantages of PL/SQL
  • Assignments
Declarations and Data Types Declarations
  • Standard Data Types
  • Initialization
  • Variable Names
  • Specialized Data Types - %TYPE
  • Specialized Data Types - %ROWTYPE
  • Building Your Own Data Types -Records
  • A Quick look at Loops Arrays
  • Tables
  • Nested Blocks

Day 5

8AM-12PM && 1PM-5PM
Language Components
  • Introduction
  • Assignments
  • Decision Making Statements
  • Simple Loops
  • Loops - for
  • Loops - indefinite
  • Loops - while
  • Simple Loops
  • Nested Loops
  • Boolean Variables
  • PL/SQL Relational Operators
  • PL/SQL Logical Operators
  • The CASE Construct
Cursors
  • Introduction
  • Cursor Manipulation
  • Using the Cursor
  • For Loops Cursors
  • Cursor Attributes
  • Cursor Parameters
  • Nested Cursors
  • Cursor Exceptions
Exceptions
  • Errors in Programs
  • Run Time Exceptions
  • Oracle Built In Exceptions
  • Unnamed Exceptions
  • Built in Exception Functions
  • Creating Your Own Exceptions
  • Building Non Terminating Exceptions
Functions and Procedures
  • Introduction
  • Creating a Procedure
  • Example Procedure
  • Using Parameters
  • Functions
  • Procedures and Exceptions
Appendix A: An SQL and SQL*Plus Reference
  • DDL Statements
  • DML Statements
  • Transaction Control Statements
  • Operators
  • Common SQL*Plus Commands