The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is Database Administrators, Database Developers and BI professionals.
The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
Who Should Attend
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren't necessarily database-focused; namely, report writers, business analysts and client application developers.
Pre-requisites
Working knowledge of relational databases.
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Knowledge of writing formulas in Microsoft Excel
Learner is expected to write SQL statements or scripts during class
Transforming Lives Through Lifelong Learning
NTUC LearningHub is the leading Continuing Education and Training provider in Singapore which aims to transform the lifelong employability of working people.
Since our corporatisation in 2004, we have helped over 29,000 organisations and achieved more than 2.6 million training places.
As a Total Learning Solutions provider, we forge partnerships to offer a wide range of relevant end-to-end training. The NTUC LearningHub Learning eXperience Platform (LXP) — a one-stop online learning mobile application — offers timely, bite-sized and quality content to upskill anytime and anywhere. Beyond learning, LXP serves as a platform for jobs and skills development for both workers and companies.
Our Vision
To be the leader and trusted lifelong partner in Continuing Education and Training
Our Mission
To provide learning that makes Every Worker a Better Worker, Every Job a Better Job, Every Company a Better Company
People are our Priority
Passion is our Goal
Performance is our Business
MongoDB is consistently ranked as the most popular NoSQL database according to the DB-Engines monthly rankings. MongoDB is a free, open-source, cross-platform document database, which stores its data in JSON-like documents.Â
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and features.
SQL Server is a relational database management system (RDBMS) from Microsoft that is designed for the enterprise environment.
Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases can join this course.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy