Over

120,000

Worldwide

Saturday - Sunday CLOSED

Mon - Fri 8.00 - 18.00

Call us

 

Selenium 3.0 Training

Selenium 3.0 Training

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.

 

Key Features

  • Author efficient SQL statements and clauses
  • Understand Databases & Relationships
  • Use Common Query Tools and work with SQL commands
  • Understanding Transactions, create Tables and Views
  • Comprehend and Execute Stored Procedures

Lesson 1 – Rational Databases

1.1 What are Databases?

1.2 What’s the Role of Databases in Application Programming?

1.3 Tables and Relations

1.4 Primary and Foreign Keys and Other Constraints

Lesson 2 – SQL Querying

2.1 What is Querying?

2.2 The ANSI SQL Standard

2.3 DML, DDL and More

2.4 Common Query Tools

Lesson 3 – Your First Queries

3.1 The SELECT Statement

3.2 Limiting Output Columns

3.3 Formatting and Sorting Output

3.4 Column Aliases

Lesson 4 – Filtering Your Results

4.1 The WHERE Clause

4.2 Creating a Filter Condition

4.3 Applying Multiple Filter Conditions

4.4 More Filter Options

Lesson 5 – Consolidating Your Data

5.1 Counting Records

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

5.3 Do’s and Dont’s When Consolidating

Lesson 6 – Grouping Your Data

6.1 The GROUP BY Clause

6.2 The HAVING Clause

6.3 Do’s and Dont’s When Grouping

Lesson 7 – Joining Tables

7.1 Table Aliases

7.2 Inner Joins

7.3 Outer Joins

7.4 Self Joins

7.5 Complex Multi-Table Joins

Lesson 8 – Subqueries

8.1 Filtering Using Subqueries

8.2 The EXISTS Clause

8.3 Subqueries as Alternative to Joins

8.4 Derived Tables

Lesson 9 – Manipulating Your Data

9.1 The INSERT Statement

9.2 The UPDATE Statement

9.3 The DELETE Statement

Lesson 10 – Transaction Control

10.1 What are Transactions

10.2 Initiating a Transaction

10.3 The COMMIT and ROLLBACK Commands

Lesson 11 – Creating Database Objects And Adding Business Logic

11.1 Creating Tables

11.2 Creating and Using Views

11.3 Developing and Calling Stored Procedures

11.4 Implementing Triggers

 

  • Freshers, Programmers, Software Developers, Testing professionals who want to learn SQL
  • Marketing, Sales people who want to understand their company data better
  • Understand Databases & Relationships
  • Use Common Query Tools and work with SQL commands
  • Understanding Transactions, create Tables and Views
  • Comprehend and Execute Stored Procedures

FAQ

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
Working Hours

  • Monday9am - 6pm
  • Tuesday9am - 6pm
  • Wednesday9am - 6pm
  • Thursday9am - 6pm
  • Friday9am - 6pm
  • SaturdayClosed
  • SundayClosed
Latest Posts

Teacher

Lorem Ipsum

What is Lorem Ipsum?