Details
Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful and universal database programming language.
You'll learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques.
WHO SHOULD ATTEND
This course is valuable for anyone who needs to learn SQL programming for developing applications using databases, or for extracting and analyzing database contents. No previous SQL experience is required.
PREREQUISITE
No previous SQL experience is required.
Outline
Understanding Databases
- What is a database
- Introduction to relational databases
- Introduction to client server Technology
- Introduction to web based Database Systems
- Database Constructs – Tables, rows, columns
- Understanding SQL
- Introduction to SQL
- History of SQL
- SQL Components
- Defining Data Structures
- What is Data
- Basic Data types in SQL
- What are database objects
- Schema
- Table – an introduction
- Fields, Columns, Rows
- Syntax rules
- Creating a table
- Integrity Constraints
- Normalising a database
- A closer look at INSERT
- Importing data
- Using Select
- Use ORDER BY clause to sort data.
- Adding conditions to SQL statements
- SELECT command review.
- Use the WHERE clause to restrict the results of the query with a simple and compound condition.
- Comparison operators ( =, <, <=, >, >=, !=, < > )
- Conjunctive operators (AND, OR)
- Arithmetic Operators ( + , - , * , / )
- Modifying & Deleting
- Update
- Replace
- Delete
Working with Views
- Views - Introduction
- Importance
- Definition
- Advantages & Disadvantages
- Creating Views
- Updating & Deleting
- Selecting Data from Multiple tables
- Keys
- Simple Joins
- Join Types
- Join consideration
- Alias
- What is a subquery?
- Subquery Rules
- Embedding a subquery within a subquery
- Single queries versus multiple queries
- Use of compound queries
- Set operator types & Syntax
- Using order by & Group By with compound queries
- Aggregate Functions
- List of aggregate functions
- List of String Functions
- Numeric Functions
- List of Numeric Functions
- SQL Date & Time Functions
Reviews
Be the first to write a review about this course.
Write a Review
Futuretrend has been providing IT, Design, Financial and Business Skills training since December 2000.
With a solid reputation for delivering high quality programmes, Futuretrend has become a successful and well established training centre.
Year on year hundreds of learners come to this centre to pursue a course of study that will help them fulfill career aspirations, improve their job prospects or to simply learn more about a particular area of interest.
In today's competitive business environment the importance of up-to-date skills cannot be overstated.
With Futuretrend, you and/or your team will benefit immensely from our results-oriented training.
With a solid reputation for delivering high quality programmes, Futuretrend has become a successful and well established training centre.
Year on year hundreds of learners come to this centre to pursue a course of study that will help them fulfill career aspirations, improve their job prospects or to simply learn more about a particular area of interest.
In today's competitive business environment the importance of up-to-date skills cannot be overstated.
With Futuretrend, you and/or your team will benefit immensely from our results-oriented training.