Details
Course Objective:
Understanding SQL Scripting is now available as a SDF funded and SkillsFuture Funded course also known as NICF - SQL Scripting and Database Concepts
NICF - SQL Scripting and Database Concepts is a 3-day course which teaches database professionals about using SQL (Structured Query Language) to access and manipulate database. Usage of SQL statements to add, delete, insert, retrieve and update data in a SQL database will be covered.
You will create advanced SQL queries to manipulate and index tables. You will work with advanced queries to create and work with subqueries, creating and manipulating view and index tables.
You will learn how to do Table Design, creating tables with Constraints and Backing Up Tables. You will also create and committ transactions so that you can choose to save or cancel data entry process and learn rollback transactions.
Prerequisite:
No prerequisite required. Some database concepts and basic programming knowledge an added advantage.
Certificate Of Attendance:
Certificate Of Attendance will be awarded to participants completing the course.achieving minimum 75% attendance.
Training Methodology & Materials:
Practical case study sessions to enhance concept.
Well-designed lab sessions to further enhance the understanding of the courseware given.
Training Duration:
Full-Time : 3 weekdays / 3 Sats
Time : 9.30am - 5.30pm
Understanding SQL Scripting is now available as a SDF funded and SkillsFuture Funded course also known as NICF - SQL Scripting and Database Concepts
NICF - SQL Scripting and Database Concepts is a 3-day course which teaches database professionals about using SQL (Structured Query Language) to access and manipulate database. Usage of SQL statements to add, delete, insert, retrieve and update data in a SQL database will be covered.
You will create advanced SQL queries to manipulate and index tables. You will work with advanced queries to create and work with subqueries, creating and manipulating view and index tables.
You will learn how to do Table Design, creating tables with Constraints and Backing Up Tables. You will also create and committ transactions so that you can choose to save or cancel data entry process and learn rollback transactions.
Prerequisite:
No prerequisite required. Some database concepts and basic programming knowledge an added advantage.
Certificate Of Attendance:
Certificate Of Attendance will be awarded to participants completing the course.achieving minimum 75% attendance.
Training Methodology & Materials:
Practical case study sessions to enhance concept.
Well-designed lab sessions to further enhance the understanding of the courseware given.
Training Duration:
Full-Time : 3 weekdays / 3 Sats
Time : 9.30am - 5.30pm
Outline
Day 1 :
- Database Concepts and DBMS
- DBMS Fundamentals
- Types of Database
- Executing a simple Query
- Performing a Conditional Search
- Practice LAB
- Working with Function
- Organizing Data
- Retrieving Data from Tables
- Advanced Querying
- Using Subqueries to perform Advanced Querying
- Data Modeling
- Manipulating Table Data
- Working with Views
- Indexing Data
- Managing Transactions
- Presenting Query Results
- Database Design Concepts
- Stored Procedures
Reviews
Be the first to write a review about this course.
Write a Review
IT Enabler is incorporated in Singapore in year 2002. We aim to be a One-Stop IT Training Centre for aspired IT Professionals and IT Technopreneurs. We aim to bring the level of IT expertise from ground zero to the intermediate and advanced levels. We are offering our most successful flagship course Cisco Certified Network Associate CCNA with an impressive passing mark of over 90%. Some classes even achieved 100% passes.
We conduct courses like CCNA-R&S, CCNA Security, CCNP-R&S, CCNP Security, CCDA, CCDP, MCSA, MCSE, ITIL Foundation, VBA Excel, VBA Access, SQL Scripting, SQL Server Database Administration, SQL Server Database Query, Website Design, E-Commerce and Setting up Shopping Cart, Wordpress, HTML5 with Javascript and CSS3, Mobile Appns Development - Android, IOS, Windows, etc.
At iEnabler, we place the trainees/participants' interest at the highest priority.
We conduct courses like CCNA-R&S, CCNA Security, CCNP-R&S, CCNP Security, CCDA, CCDP, MCSA, MCSE, ITIL Foundation, VBA Excel, VBA Access, SQL Scripting, SQL Server Database Administration, SQL Server Database Query, Website Design, E-Commerce and Setting up Shopping Cart, Wordpress, HTML5 with Javascript and CSS3, Mobile Appns Development - Android, IOS, Windows, etc.
At iEnabler, we place the trainees/participants' interest at the highest priority.
Related Courses
iEnabler
iEnabler
Kore Infotech Training Centre
Inspizone Trainings
