Data Scientist(NQF L6) Information Technology: Database Development

Data Scientist(NQF L6) Information Technology: Database Development

Course Features

Course Details

NATIONAL CERTIFICATE: INFORMATION TECHNOLOGY: DATABASE DEVELOPMENT (SAQA ID 71850) NQF L6   Data science is a multi-disciplinary field that uses scientific methods, processes, algorithms and systems to extract knowledge and insights from structured and unstructured data. A data scientist is generally someone who knows how to extract meaning from and interpret data, which requires both tools and methods from statistics, machine learning and organisational teams. As data is never clean, time is spent in collecting, cleaning and transforming it into the correct formats for analysis. A data scientist, therefore, analyses data from across an organisation, identifies trends and uses that business acumen to recommend what problems to tackle and how to tackle them. Specific tasks include:
  • Identifying the data-analytics problems that offer the greatest opportunities to the organisation
  • Determining the correct data sets and variables
  • Collecting large sets of structured and unstructured data from disparate sources
  • Cleaning and validating the data to ensure accuracy, completeness, and uniformity
  • Devising and applying models and algorithms to mine the stores of big data
  • Analysing the data to identify patterns and trends
  • Interpreting the data to discover solutions and opportunities
  • Communicating findings to stakeholders using visualisation and other means
The Learnership modular breakdown covers all elements required for a Data Science Programme and is as follows:
MODULE ASSOCIATED EXIT OUTCOMES LEARNING OUTCOMES SUMMARY OF THE MODULE
MODULE 1   Database Development EL01 -Apply database development skills, using a Microsoft SQL Server 2008 program. - Develop/design of database - Design and create database solutions - Create structure to control database access A qualifying learners will acquire foundation-level theoretical and practical knowledge of the design, implementation and management of database systems. You will be taken through the process of database development and implementation using SQL Server.
  MODULE 2   SharePoint Configuration EL02-Install and implement SharePoint skills.    -Configure Microsoft SP Server 2007 -Configure Window SP 3.0 system This Module takes the learners through the skills and knowledge on the benefits of SharePoint skills. SharePoint empowers teamwork with dynamic and productive team sites for every project team, department, and division. Share files, data, news, and resources. Customize your site to streamline your team’s work. Collaborate effortlessly and securely with team members inside and outside your organisation, across PCs, Macs, and mobile devices.
  MODULE 3   Exchange Server Configuration EL03-Install and implement Server skills. -Configure exchange server 2007 The Module provides the learners with the skills on how to manage mail recipients and public folders, including how to perform bulk operations using Exchange Management Shell. Students also will learn how to manage client connectivity, message transport and hygiene, how to implement and manage highly available Exchange Server deployments, and how to implement back up and disaster recovery solutions.
  MODULE 4   Software Engineering EL04-Understand general database theory -Identify different types of database -Identify relational database model -Identify properties of data structures in a relational database -Identify the object orientated database model Developing and managing efficient and effective database applications requires understanding the fundamentals of database management systems, techniques for the design of databases, and principles of database administration. This course emphasized database concepts, developments, use and management in three main sections: database concepts, practice, and emerging trends. Relational database systems are the main focus, but other types, including object- oriented databases, are studied. Practical design of data- bases and developing database applications using modern software tools will be emphasized
MODULE 5   Data Wrangling EL05-Create database access for a computer application using structured query language. -Review requirements for database access for computer application using SQL -Design database access for a computer application using SQL -Write program code for database access for a computer application using SQL -Test programs for a computer application that accesses a database using SQL   Learners learn to use a database management system (DBMS) commonly encountered on single-user and networked microcomputers to solve business problems.  Learners will study data design theory. This course helps learners develop general knowledge of database design, development, and administration; and application development using a microcomputer database management system.  Learners  will learn how to develop a database including tables, queries, forms, and reports.  Learners  will also learn how to develop database applications.  
MODULE 6   Management of Data EL06-Understand Computer Database Management Systems.   -Describe database management issues by addressing a database management system -Describe commonly implemented features of commercial computer database management systems -Describe different types of database management systems Review database management system end user tools   Databases are at the heart of modern commercial application development. In addition, their use extends to many other environments and domains where large amounts of data must be stored for efficient update, retrieval, and analysis. The purpose of this module is to provide a comprehensive introduction to the use of data management systems for applications. Some of the topics covered are the following: data models (relational and JSON), query languages (SQL, datalog, etc.), transactions, parallel data processing, and database as a service.
  MODULE 7   Managing Systems Security EL07- Administer security systems for a multi-user computer system.   -Understand an organisation security policy -Manage security of desktop computers connected to the system -Maintain, manage and review security systems for a multi-user computer system   This Module provides a deep and comprehensive study of the security principles and practices of information systems. Topics include basic information security concepts, common attacking techniques, common security policies, basic cryptographic tools, authentication, access control, software security, operating system security, and legal and ethical issues in information systems security.     Through this course, students shall be able to understand the basic principles and practices in information systems security.    
  MODULE 8   Computer programming EL08-Apply the principles of creating a computer program using a procedural programming language in a GUI environment.   -Demonstrate an understanding of a graphical user interface (GUI) environment -Write a computer program using a procedural programming language for a GUI environment   -Test a written computer program using procedural programming language for a GUI environment   The course introduces the fundamental concepts of procedural programming. Topics include algorithms and problem solving, data types, control structures, functions, arrays, files, and the mechanics of running, testing, and debugging. The course also offers an introduction to the historical and social context of computing.
  MODULE 9   Configuration Change Management EL09-Understand change management for computer systems. -Describe an organisation change management policy -Provide guidelines of the implementation of changes to computer systems The Module provides in-depth details associated with that element of CM known as Configuration Change Management.  It covers the full spectrum from change proposal to change disposition to change implementation using what CMPIC believes to be the best practices model for understanding this complex subject.  Details will cover change workflow, change forms, change boards, change tracking, metrics and more. The role of automated tools in helping manage various aspects of Configuration Change Management will also be discussed.
  MODULE 10   Computer Information Management EL010- Manage computer-based systems.   -Implement procedures pertaining to the operation of computerized information management -Assess the selection of output and input hardware/equipment -Determine what modification/adjustment to be made to overcome problems -Provide support with the development and implementation of new systems -Monitor and evaluate the outcomes of new/revised operational procedures -Manage the competent application and utilization of all workplace computer-based systems   This Module provide learners with practical abilities in evaluating, designing, securing and maintaining computer information system
This course does not have any sections.

More Courses by this Instructor