Once you have learned how to use databases you will have a skill that will last into the future.

 

This course  provides a comprehensive introduction to SQL which is one of the most used database languages by professional IT businesses. This course will provide you with a solid foundation if you have very little or no experience in SQL at all.

 

By the end of the course, the student should be able to understand all the fundamentals and major aspects of SQL.

 

If you have no understanding of SQL or databases, this course will teach you the basics and give you a good foundation to expand your career and knowledge in IT. This course can also be a good for experienced IT staff who want to learn about SQL which may then give them more prospects for career growth!.

• A comprehensive introduction to the use of SQL
• Suitable for programmers and web developers
• Expand your knowledge and career opportunities
• Provide skill to branch into many different areas of IT

Duration - 100 Hours

 

 

Introducing SQL

SQL (structured query language) is the most common language used for communicating with relational databases.

Traditionally, programming languages such as Basic, C# and C++ are known as ‘procedural’ languages. This means that in order to do something, a procedure is written telling the computer what to do.

For example, to get the computer to draw a box, you would have a procedure similar to the following:

1) Move the pointer to the top left of the screen
2) Draw a line horizontally until it reaches the edge of the screen
3) Draw a line down until it reaches the bottom of the screen
4) Draw a line to the left until it reaches the left hand side of the screen
5) Draw a line up until it meets the top left corner of the screen

SQL is a ‘non-procedural’ language. Instead, you tell SQL what you want and it communicates with the DBMS to retrieve your request without you having to tell SQL exactly how to do it.

For example, to retrieve all records from a database where all people lived in Australia, you would use the following SQL command:

Select * from records where location=’Australia’

The DBMS then understands what SQL is asking and will go and retrieve the data and send it back to SQL.

SQL commands are performed in one of two ways:

1) Via a console

You can execute SQL commands via a console that is connected to a DBMS. This may be the SQL query builder in Microsoft Access, a web page connected to a database of some sort, or either via SQL Server Express, Enterprise Manager & Query Analyser for SQL Server. You would simply type in your request in SQL and after the task has been completed, you will see the result. This form of using SQL is generally only used by professional database administrators due to the large margin for error and lack of database security (someone could easily wipe out a database by typing the wrong command).

2) Via an application

This is the most common form of SQL programming. An application acts as a ‘front end’ for the database, allowing someone with basic computer knowledge to use a database. For example, a button that says ‘add record’ would appear on a page with blank fields for ‘name’ and ‘address’. The operator would enter the name and address then click the button. This button would then fire off an SQL command, telling the DBMS to add a new record to the database with the data the operator typed in.

Database Management System (DBMS)

A Database Management System (DBMS) is a software program that acts as a ‘go-between’ (interface) for the database information. When an application requires data, it sends its' request to the DBMS which searches the database records for the relevant data and then returns the result back to the application.

You can think of a DBMS as a librarian. You go to the library and ask them “have you got any books on car engine repairs”. The librarian then goes and looks through the shelves, finds all the relevant books and brings them back to you. Without the librarian, you would need to search through all the shelves yourself, which is slow and inefficient.

DBMSs make life easy and reduce the time it takes for an application to process data.

It is important to understand the difference between a Database and a DBMS. Many people confuse the two or do not realise there is a difference which can cause confusion.

DBMSs come in all shapes and sizes with different features and uses. Many have features that are unique and almost all DBMSs are incompatible with each other (although some have partial compatibility).

Some examples of popular DBMSs are:

•     Microsoft Access
•     Microsoft SQL Server
•     Microsoft MSDE
•     Oracle
•     Sybase SQL Server
•     MySQL

There are many other DBMSs around too. Some are general ones used for a variety of applications and some are specifically designed for certain applications (such as banking and finance).

SQL databases have been around for a long time and don't show any signs of going anywhere. Having this skill may be one of the best things you can do in order to change your career path. There are many job opportunities all over the world that require people with database skills. Even if you have a job doing something else, the things you will learn in this course can benefit you across a multitude of industries and jobs.

VALUABLE KNOWLEDGE LIKE THIS IS PRICELESS

Some of the titles you will find in the IT industry related to databases are:

Database Administrator(DBA)

Database Developer

Database support and maintenance

Database security

Data miner

Data reporting and business integration

 

Other areas of IT that relate/integrate to databases you can study in future to expand your skills even further include:

• Computer programming
• Computer security
• Web development
• Networking
• Business Analysis 
• Marketing