Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
6 Hours
-
HRDF SBL Claimable
-
Certificate of Attendance available
-
180 days of access from date of purchase
-
0 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
Request more information
Inquiry for: Myself My Company
By providing your contact details, you agree to our Privacy Policy
Thank You
Our learning consultant will get back to you in 1 business day
SQL Database Training Course - Simplilearn
WHAT YOU WILL LEARN
This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn to correctly structure your database, author efficient SQL statements and clauses, and manage your SQL database for scalable growth.
AUDIENCE
• Freshers, Programmers, Software Developers, Testing professionals who want to learn SQL
• Marketing, Sales people who want to understand their company data better
PREREQUISITES
There are no prerequisite for the course. This course can be taken up by anyone who wants to learn SQL.
COURSE OBJECTIVES
• Understand Databases & Relationships
• Use Common Query Tools and work with SQL commands
• Understanding Transactions, create Tables and Views
• Comprehend and Execute Stored Procedures
Modules
• What are Databases?
• What is Querying?
• The ANSI SQL Standard
• DML, DDL and More
• Common Query Tools
• The SELECT Statement
• Limiting Output Columns
• Formatting and Sorting Output
• Column Aliases
• The WHERE Clause
• Creating a Filter Condition
• Applying Multiple Filter Conditions
• More Filter Options
• Counting Records
• Common Aggregate Functions: SUM, AVG, MIN, MAX
• Do's and Dont's When Consolidating
• Unions and Other Multiset Consolidations
• Grouping Your Data
• The HAVING Clause
• Do's and Dont's When Grouping
• Table Aliases
• Inner Joins
• Outer Joins
• Self Joins
• Complex Multi Table Joins
• Filtering Using Subqueries
• The EXISTS Clause
• Subqueries as Alternative to Joins
• Derived Tables
• The INSERT Statement
• The UPDATE Statement
• The DELETE Statement
• What are Transactions
• Initiating a Transaction
• The COMMIT and ROLLBACK Commands
• Creating Tables
• Creating and Using Views
• Developing and Calling Stored Procedures
• Implementing Triggers
Course Reviews
0
0 Ratings