Using databases is a skill that, once learned, will last you far into the future. This course will provide you with an in-depth introduction to SQL – which is one of the most used database languages by professional IT businesses. Understanding of all of the fundamental features and aspects of SQL will be achieved by the end of this Warnborough Online Course.
You don’t have to have any prior knowledge of SQL. This course will start you off in the right place and provide you with the basics and a strong foundation to expand upon. This course may be of use to those who are experienced in IT and want to learn about SQL, as it can excel your 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
A database is a place in which data is stored. They can come in all different sizes – anywhere from holding a few records to millions at a time. So SQL can be useful to small family run businesses as well as big, well established companies handling millions of customer details.
Course Structure:
The duration of this online course is 100 hours. This consists of 12 in-depth lessons:
1. Introduction to Databases
- What is a database
- DBMS
- The relational model
- Primary keys
- Foreign keys
- Relationships
- Normalisation
- Other normal forms
- De normalisation
2. Fundamentals of SQL
- Installing a DBMS
- SQL
- The select statement
- Common errors
- Identifiers
3. Building a database with SQL
- Building a database: RAD tool, CSV file, opening database, commands, etc
- Data types and MS access
4. Retrieving, Storing, Updating and Deleting Data
- Retrieving data
- Retrieving from tables with relationships
- Creating column aliases
- Eliminating duplicate rows with DISTINCT
- Filtering rows with WHERE
- Matching patterns with LIKE
- Escaped and unescaped patterns
- Range filtering with BETWEEN
- List filtering with IN
- Evaluating conditional values with CASE
- Sorting rows by ORDER BY
- Storing, updating and deleting data
- Updating rows with UPDATE
- Deleting rows with DELETE
5. Advanced SQL database access methods
- Relational databases
- Creating outer joins with OUTER JOIN
- Sub-queries
- Summarising data
- Grouping rows
- Using HAVING for filtering rows
- Set operations
- Union
- Intersect
- Except
- Handling duplicates
6. Database Security
- Security is important
- Triggers
7. Using SQL in applications
- Using SQL in an application
- Using SQL in web sites
- Using SQL in desk top applications
- Using SQL in mobile devices
- Embedded SQL
- SQL injection
8. Cursors
- What are cursors
- Preventing updates and deletions
- Scrollable Cursors
9. Stored procedures
- Introduction
- Compound statements
- Stored functions
- Stored modules
- Views
- Indexes
- Controlled flow statements
10. Error Handling
- Stability
11. Dynamic SQL
- Introduction
- Execution of dynamic SQL
- Single step execution
- Two step execution
- Dynamic cursors
12. Advice and Tips
- Common mistakes
- Assuming the client knows what they need
- Underestimating project scope
- Only considering technical factors
- Not seeking client feedback
- Skipping beta testing
- INTRODUCING SQL
- SQL (structured query language) is the most common language used for communicating with relational databases
Knowledge like this is Priceless
All businesses you work for will have some sort of database – all holding valuable information. SQL will give you the knowledge and skill you need to be able to handle and manipulate this data. This can help a business drastically, giving them insite into information they once thought was useless. This skill will help you branch out into different IT areas and opportunities.
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
How does a Warnborough Online Course work?
You can start the course whenever is convenient for you. You will be studying from home and have access to support from our qualified tutors. Practical exercises and research tasks will be set at the end of each lesson – including an assignment. You will submit this assignment to your course tutor, who will mark your work and give you constructive feedback and suggestions.
If you have any questions please contact us.
