SQL Foundation Course
|
Summary
|
|
|||||||||||||
SQL Foundation Course
SQL Foundation - 1 day course in Crawley
The course aims to give an introduction to SQL and aims to be as much as possible vendor independent. The course primarily uses the SQL 2003 ANSI/OSI standard so can be applied to any number of databases including SQL Server, Oracle, Access and MySQL.
By the end of the course delegates will be able to:
- Decompose real data into a form suitable for implementation within a relational database.
- Apply key/foreign key relationships between tables of a relational database.
- Choose appropriate column types for a table.
- Create tables using SQL and populate them with data.
- Modify existing data within tables using SQL statements·
- Perform table joins to retrieve data from multiple tables using SQL Select statements.·
- Perform simple database administration tasks.
Interested in learning more about this SQL Foundation Course? Contact Thales Training here.
If you want to find out more about SQL Foundation Course, you can make an information request below and the school will contact you with further information.
Suitability and application
This SQL Foundation Course is designed for experienced PCs users.
Pre-requisites: No prior knowledge of SQL is required.
Enquire to see if this SQL Foundation Course is suitable for you here.
SQL Foundation Course Content
This SQL Foundation Course is designed to cover the following areas:
Introduction to Relational Databases·
- The nature of data and data systems in general·
- Relational fundamentals - tables, rows and columns·
- Overview of the SQL language.·
- Client-server architecture for database systems.·
- Programming interfaces and embedded SQL.
Database Design·
- Rules for first, second and third order normalisation·
- Normalising via Entity Relationship diagrams·
- Resolving many-to-many relationships·
- Establishing key/foreign key relationship·
- The concept of referential integrity
Table Creation·
- Deciding on column data types·
- Constructing tables using SQL·
- Specifying key fields·
- Populating the tables with data
Modifying tables·
- Modifying rows using update·
- Removing rows using delete·
- Inserting rows using insert·
- Replacing rows
Creating Queries·
- Anatomy of the Select statement·
- Role of key/foreign key in table joins·
- Inner and outer table joins·
- The On clause for avoiding Cartesian products·
- The Order By clause·
- The Group By clause and group functions·
- The Having clause·
- Creating views.
Operators, functions and formats·
- Introduction to character, numeric and conversion functions·
- Review of logical, relational and set operators·
- Datetime and number formats
Database Administration·
- SQL Data Control Language·
- Creating users/schemas·
- Controlling access to data
Expenses
The cost of this SQL Foundation Course is £560.00 + VAT.
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
To request information from SQL Foundation Course, please fill out the following details:
