SQL For the Web Course (Distance Education)

By: ACS Distance Education  17/07/2013
Keywords: Distance learning, correspondence courses, distance education

SQL For the Web Course - This course provides a comprehensive introduction to SQL. By the end of the course, the student should be able to easily understand all the major aspects of SQL. Contents of each lesson Lesson 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 • Subqueries • 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 Find out more at http://www.acsedu.co.uk/Courses/Information-Technology/SQL-FOR-THE-WEB-BIT201-507.aspx

Keywords: correspondence courses, distance education, Distance learning, Study Courses

Contact ACS Distance Education

Email

Print this page

Other products and services from ACS Distance Education

15/07/2014

Marketing Psychology

This ebook is for any marketing student or professional or even a business owner hoping to develop more knowledge on marketing psychology and consumer behaviour. http://www.acsebooks.com/products/2317-marketing-psychology-understanding-consumer-behaviour.aspx


15/07/2014

Marketing Psychology

This ebook is for any marketing student or professional or even a business owner hoping to develop more knowledge on marketing psychology and consumer behaviour. http://www.acsebooks.com/products/2317-marketing-psychology-understanding-consumer-behaviour.aspx


15/07/2014

Working with Animals- New Ebook

If you enjoy interacting with animals, are interested in biological science, or are passionate about wildlife, pets or farming; you


15/07/2014

Working with Animals- New Ebook

If you enjoy interacting with animals, are interested in biological science, or are passionate about wildlife, pets or farming; you


10/07/2014

Plants and Permaculture (Permaculture II)

Plants and Permaculture (Permaculture II) has recently been upgraded and improved to include a more detailed focus on plants in


10/07/2014

Plants and Permaculture (Permaculture II)

Plants and Permaculture (Permaculture II) has recently been upgraded and improved to include a more detailed focus on plants in


10/07/2014

Animals in Permaculture Systems (Permaculture III)

Animals in Permaculture Systems (Permaculture III) has been upgraded. We are pleased to announce that this substantially improved 100 hour


10/07/2014

Animals in Permaculture Systems (Permaculture III)

Animals in Permaculture Systems (Permaculture III) has been upgraded. We are pleased to announce that this substantially improved 100 hour


27/06/2014

Beautiful new eBook on Carnations and Dianthus

Learn to grow and care for carnations and dianthus with this beautifully illustrated eBook.


27/06/2014

Working with Animals - Brand new eBook

Want a career working with animals? This eBook can help you find out which is the right career for you.


Landscaping and Gardening in the Shade from ACS Distance Education thumbnail
23/05/2014

Landscaping and Gardening in the Shade

Shady Garden? Then why not find out how to improve the flowers and shrubs growing in your garden.


14/04/2014

Growing and Knowing Nuts

Discover the many different varieties of nuts that you many not have ever heard of. Learn unique ways of using nuts and cooking with nuts.


14/04/2014

Growing and Knowing Nuts

Discover the many different varieties of nuts that you many not have ever heard of. Learn unique ways of using nuts and cooking with nuts.


14/04/2014

Growing and Knowing Nuts

Discover the many different varieties of nuts that you many not have ever heard of. Learn unique ways of using nuts and cooking with nuts.


25/03/2014

Growing & Knowing Fuchsias

Get to know fuchsias better. 124 pages of brilliant colour pictures and information about fuchsias. This ebook is a must read for anybody interested in fuchsias.