SQL (Database) Training Course

SQL or Structured Query Language is a standard language used to communicate with almost any database including MySQL, Microsoft SQL Server, Microsoft Access and Oracle.

Course Details

This course will teach you all you need to know about SQL from basics to advanced joins.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Kyalami, Midrand - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Light finger meals are supplied for part time courses.

Audience

• Web developers wanting to add database interaction to their web sites.
• Programmers who quickly wants to add SQL to their skills set.
• The hobbyist who wants to begin creating SQL scripts for upload to their own ISP.
• Students, and to those seeking a career in computing, who need a fundamental understanding of database administration with SQL.

Pre-Requisites

Above average computer literacy

Course Duration

3 Days

Cost using our PC's as from 1st of March 2012

R 4,281.82 excl vat
R 4,881.27 incl vat

Cost using your own PC's as from 1st of March 2012

R 3,681.82 excl vat
R 4,197.27 incl vat

Note: information may change without notice.

Course Outline

• Introduction
  • What is SQL
  • Relational Databases
  • SQL and Standards
  • SQL Implementations
  • Client - Server
  • SQL Syntax
• Select Statements
  • Overview of select
  • Selecting One Field
  • Selecting Multiple Fields
  • Using a Wild Card
  • Calculations
• Filtering Results
  • Limiting rows
  • Exercise
  • Using WHERE
  • Using AND/OR and NOT
  • Using LIKE
• Functions
  • String Functions
  • Numeric Functions
  • Date Functions
  • Aggregate (Group) Functions
• Sorting and Grouping
  • Sorting Results
  • Grouping Results
  • Column Aliases
  • Filtering Using Having
• Joins
  • Inner Joins
  • Self Joins
  • Outer Joins
  • Joining Multiple Tables
• Sub Queries
• Create,Drop Delete and Alter
  • Create Database
  • Create Schema
  • Create TablData Types
  • Field Modifiers
  • Create Select
  • Create View
  • Drop Queries
  • Delete
  • ALTER TABLE
• INSERT
  • INSERT Se
• INDEXES
• Update Queries
• Transactions
• Database Design

Scheduled Dates

To apply for a booking, click on the relevant "Book" link below.
Note: places are only fully secured once payment has been made.

From Date	To Date	Duration	Venue
Mon 18 Jun 2012	Wed 20 Jun 2012	3 days	Kyalami	Book
Mon 16 Jul 2012	Wed 18 Jul 2012	3 days	Kyalami	Book

Provisional Dates

These dates have not yet been confirmed. If you are interested in attending please enquire below.

From Date	To Date	Duration	Venue
Mon 13 Aug 2012	Wed 15 Aug 2012	3 days	Kyalami
Mon 3 Sep 2012	Wed 5 Sep 2012	3 days	Kyalami

Course Enquiry

If you have a query relating to this course, please complete the form below.

Name
Email
Contact Number
Query
Security Code
Verify Code

Accounting Skills for New Supervisors   Administrator Bootcamp   Adobe Captivate   Advanced PHP   Advanced Project Management   Advanced Skills for the Practical Trainer   Advanced Web Application Programming   Advanced Writing Skills   Anger Management: Understanding Anger   Assertiveness as a Business Tool   Basic Computer Skills   Budgets and Managing Money   Building Better Teams   Building Relationships for Success in Sales   Building Your Self Esteem and Assertiveness Skills   Business and Report Writing   Business Etiquette: Gaining That Extra Edge   Business Leadership: Improving Management Performance   Business Succession Planning: Developing and Maintaining a Su   Business Writing that Works   Call Center Training: Sales and Customer Service Training for   Change and How to Deal with It   Change Management   Coaching for Growth and Performance   Coaching In The Call Centre Environment   Coaching: A Leadership Skill   Communicating Across Cultures   Communication Strategies   Concepts of Information Technology   Conducting Effective Performance Reviews   Conflict Resolution   Conflict Resolution: Dealing with Difficult People   Conflict Resolution: Getting Along in the Workplace   Conquering Your Fear of Speaking in Public   Creating a Dynamite Job Portfolio   Creating a Top Notch Talent Management Program   Creating and Managing Your Corporate Brand   Critical Thinking   CRM: An Introduction to Customer Relationship Management   Customer Service   Customer Service Training: Critical Elements of Customer Serv   Customer Service Training: Managing Customer Service   Delegation - The Art of Delegating Effectively   Developing Your Training Program   Dreamweaver CS5   Drupal Administration   Dynamite Sales Presentations   Effective Business Writing   Effective Planning and Scheduling   Emotional Intelligence: Its Not What You Think   Employee Dispute Resolution: Mediation through Peer Review   Facilitation Skills   Finance for Non Financial Managers   Flash CS5   Fundamentals of Selling   Generation Gap: Closing the Generation Gap in the Workplace   Getting Stuff Done: Personal Development Boot Camp   Getting Your Job Search Started   Graphic Design Practicals   High Performance PA and Management Skills for the Administrator   Hiring for Success   HTML and CSS   HTML5 upgrade   Human Resources Training for the Non HR Manager   Human Resources Training: HR for the Non-HR Manager   Illustrator CS4   Illustrator CS5   InDesign CS5   Intermediate Project Management   Interpersonal Skills   Introduction to Neuro Linguistic Programming   Introduction to PC   Introduction to Programming Using Python   Introduction to UML   Inventory Management - The Nuts and Bolts   Java   Javascript   Joomla Basic   Joomla Intermediate   jQuery   Leadership Skills for Supervisors   Linux Essentials   Linux Master Bundle   Linux Networking   Linux Point&Click Admin   Linux Security   Linux Single Sign On   Linux System Administration 1   Linux System Administration 2   Linux Ubuntu 199   Management and Supervisory Skills   Marketing and Sales   Mastering the Interview   Meeting Management - The Art of Making Meetings Work   Microsoft Access 2007   Microsoft Excel 2007: Advanced   Microsoft Excel 2007: Basic   Microsoft Excel 2007: Intermediate   Microsoft Outlook 2010   Microsoft PowerPoint 2007   Microsoft Project 2007   Microsoft Visio   Microsoft Word 2007   Motivating Your Employees   Motivation Training: Motivating Your Workforce   MySQL   MySQL Administration   Negotiating For Results   Negotiation Skills   NLP Tools for Real Life   Office Administration   Onboarding: The Essential Rules for Successful Onboarding   Open ICDL Module 1   OpenOffice   Orientation Handbook: Getting Employees Off to a Good Start   Overcoming Objections to Nail the Sale   PC Networking   Performance Management: Managing Employee Performance   Perl Fundamentals   Photoshop CS5   Photoshop Refresher   PHP   PostgreSQL Administration   Practical Leadership   Presentation Skills (US 13925)   Presentations Skills   Problem Solving & Decision Making   Project Management   Project Management   Project Management Fundamentals   Prospecting for Leads Like a Pro   Protecting Intellectual Property   Public Speaking: Presentation Survival School   Public Speaking: Speaking Under Pressure   Python   Risk Management   Search Engine Optimization   Selling Smarter   Sexual Harassment Awareness for Employees   Sexual Harassment Awareness for Supervisors   Skills for the Administrative Assistant   SQL (Database)   Stress Management   Survival Skills for the New Trainer   TCP/IP Networking   Team Building:Developing High Performance Teams   Team Leadership   Telemarketing - Using the Telephone as a Sales Tool   Telephone Etiquette   Telephone Skills for Call Centres   The ABCs of Supervising Others   The Minute-Taker's Workshop   The Practical Trainer   The Professional Supervisor   Time, Performance and People Management   Tough Topics: Talking to Employees about Personal Hygiene   Train the Trainer   Using Activities to Make Training Fun   Web Design Practicals   Web Developer   Webmaster   Windows 7   WordPress   Working Smarter:Using Technology to Your Advantage   Writer   Writing Reports and Proposals   XML