CP307 SQL AND SQL Server

3 Semester Credit Hours

In this course students will gain an understanding of relational database design and SQL programming presented in a business context using database management systems such as SQL Server, MySQL and Oracle. Major topics include: introduction to relational database design, E-R diagrams, nomalization and SQL. Students will use SQL to create tables, modify tables, update records, retrieve data from single and multiple tables, create subqueries, create views and store procedures. Labs consist of assigned practice, projects and/or case studies relating to topics covered. Course contains 2 semester credit hours (30 clock hours) of lecture and 1 semester clock hour (30 clock hours) of laboratory work. Prerequisite: DB201

Profile Information

Application afterLoad: 0.000 seconds, 0.41 MB
Application afterInitialise: 0.026 seconds, 3.34 MB
Application afterRoute: 0.040 seconds, 4.81 MB
Application afterDispatch: 0.072 seconds, 7.86 MB
Application afterRender: 0.083 seconds, 8.12 MB

Memory Usage


17 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '2nqn8gha2i7kr05o0pfta57ct4'
      FROM jos_session
      WHERE ( TIME < '1508508053' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '2nqn8gha2i7kr05o0pfta57ct4'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '2nqn8gha2i7kr05o0pfta57ct4','1508567993','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. CREATE TABLE IF NOT EXISTS `jos_ualog` (
              `id` INT(11) NOT NULL AUTO_INCREMENT,
              `user_id` INT(11) NOT NULL,
              `option` VARCHAR(255) NOT NULL,
              `task` VARCHAR(255) NOT NULL,
              `action_link` text NOT NULL,
              `action_title` text NOT NULL,
              `item_title` VARCHAR(255) NOT NULL,
              `cdate` INT(11) NOT NULL,
              PRIMARY KEY  (`id`))
  8. SELECT *
      FROM jos_redj
      WHERE ( (('/resources/other-resources/course-descriptions/189-cp307-sql-and-sql-server?tmpl=component&print=1&layout=default&page=' REGEXP BINARY fromurl)>0
      AND case_sensitive<>'0') OR (('/resources/other-resources/course-descriptions/189-cp307-sql-and-sql-server?tmpl=component&print=1&layout=default&page=' REGEXP fromurl)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  9. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
      FROM jos_content
  12. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 120)
      ORDER BY menuid DESC
      LIMIT 0, 1
  13. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.SECTION
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 189
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-21 06:39:53' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-21 06:39:53' )   )    OR  ( a.state = -1 )  )
  14. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='189'
  15. SELECT g.*
      FROM jos_core_acl_aro_groups AS g
      INNER JOIN jos_core_acl_groups_aro_map AS gm
      ON gm.group_id = g.id
      INNER JOIN jos_core_acl_aro AS ao
      ON ao.id = gm.aro_id
      WHERE ao.VALUE='62'
      ORDER BY g.id
  16. SELECT *
      FROM jos_tagmeta
      WHERE ( (('/resources/other-resources/course-descriptions/189-cp307-sql-and-sql-server?tmpl=component&print=1&layout=default&page=' REGEXP BINARY uri)>0
      AND case_sensitive<>'0') OR (('/resources/other-resources/course-descriptions/189-cp307-sql-and-sql-server?tmpl=component&print=1&layout=default&page=' REGEXP uri)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  17. SELECT config
      FROM jos_pi_aua_config
      WHERE id='aua'
      LIMIT 1

Language Files Loaded

Untranslated Strings Diagnostic


Untranslated Strings Designer