SQL Database Training Course - Simplilearn | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

SQL Database Training Course - Simplilearn

Location

Format What’s this?
Starting From
RM 2145.70
  1. 6 Hours
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  3. 180 days of access from date of purchase
  1. 0 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.

SQL Database Training Course - Simplilearn

WHAT YOU WILL LEARN

This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn to correctly structure your database, author efficient SQL statements and clauses, and manage your SQL database for scalable growth.

AUDIENCE

• Freshers, Programmers, Software Developers, Testing professionals who want to learn SQL

• Marketing, Sales people who want to understand their company data better


PREREQUISITES

There are no prerequisite for the course. This course can be taken up by anyone who wants to learn SQL.

COURSE OBJECTIVES

• Understand Databases & Relationships

• Use Common Query Tools and work with SQL commands

• Understanding Transactions, create Tables and Views

• Comprehend and Execute Stored Procedures


Expand All

Modules

Module 1 – Relational Databases

• What are Databases?

• What's the Role of Databases in Application Programming?
• Tables and Relations
• Primary and Foreign Keys and Other Constraints

Module 2 – SQL Querying

• What is Querying?

• The ANSI SQL Standard

• DML, DDL and More

• Common Query Tools


Module 3 – Your First Queries

• The SELECT Statement

• Limiting Output Columns

• Formatting and Sorting Output

• Column Aliases


Module 4 – Filtering Your Results

• The WHERE Clause

• Creating a Filter Condition

• Applying Multiple Filter Conditions

• More Filter Options


Module 5 – Consolidating Your Data

• Counting Records

• Common Aggregate Functions: SUM, AVG, MIN, MAX

• Do's and Dont's When Consolidating

• Unions and Other Multiset Consolidations


Module 6 – Grouping Your Data

• Grouping Your Data

• The HAVING Clause

• Do's and Dont's When Grouping


Module 7 – Joining Tables

• Table Aliases

• Inner Joins

• Outer Joins

• Self Joins

• Complex Multi Table Joins


Module 8 – Subqueries

• Filtering Using Subqueries

• The EXISTS Clause

• Subqueries as Alternative to Joins

• Derived Tables


Module 9 - Manipulating Your Data

• The INSERT Statement

• The UPDATE Statement

• The DELETE Statement


Module 10 - Transaction Control

• What are Transactions

• Initiating a Transaction

• The COMMIT and ROLLBACK Commands


Module 11 – Creating Database Objects And Adding Business Logic

• Creating Tables

• Creating and Using Views

• Developing and Calling Stored Procedures

• Implementing Triggers


To Be Confirm

To Be Confirm

Read More

Course Reviews

No Remarks

0

0 Ratings