SQL database training course
Simplilearn Americas LLC
Course Summary
With SQL Training course, master SQL and improve your career prospects as it is one of the most in demand tech skills!
-
+
Course Description
How would a certificate from Simplilearn help me?
In today’s era where technologies and best practices are changing rapidly, and demand for qualified candidates is significantly increasing, a certificate from Simplilearn is the key to your success and a valuable add-on in your resume. Our training courses are designed and updated by 2000+ renowned industry experts, and more than 40 global training organizations have recognized us as an official provider of certification training.Who are the trainers?
All our trainers are certified and are highly qualified, with multiple years of experience in working with front-end development technology.What are the prerequisites for SQL training course?
There are no prerequisites for this SQL Training course.What are the payment options?
Payments can be made using any of the following options and a receipt will be issued to you automatically via email.Visa debit/credit card
American Express and Diners Club card
MasterCard
PayPal
Can I cancel my enrollment? Do I get a refund?
Yes, you can cancel your enrollment. We provide a complete refund after deducting the administration fee. To know more, please review our refund policy.
-
+
Course Syllabus
Course preview
SQL Training
Lesson 1 - Rational Databases 42:00
1.1 What are Databases? 07:24
1.2 What's the Role of Databases in Application Programming? 07:56
1.3 Tables and Relations 14:40
1.4 Primary and Foreign Keys and Other Constraints 12:00
Lesson 2 - SQL Querying 20:13
2.1 What is Querying? 02:40
2.2 The ANSI SQL Standard 03:59
2.3 DML, DDL and More 05:07
2.4 Common Query Tools 08:27
Lesson 3 - Your First Queries 32:55
3.1 The SELECT Statement 06:17
3.2 Limiting Output Columns 04:57
3.3 Formatting and Sorting Output 15:22
3.4 Column Aliases 06:19
Lesson 4 - Filtering Your Results 31:50
4.1 The WHERE Clause 04:57
4.2 Creating a Filter Condition 07:19
4.3 Applying Multiple Filter Conditions 08:13
4.4 More Filter Options 11:21
Lesson 5 - Consolidating Your Data 32:55
5.1 Counting Records 05:14
5.2 Common Aggregate Functions: SUM, AVG, MIN, MAX 08:06
5.3 Do's and Dont's When Consolidating 08:38
5.4 Unions and Other Multiset Consolidations 10:57
Lesson 6 - Grouping Your Data 21:44
6.1 The GROUP BY Clause 09:59
6.2 The HAVING Clause 05:36
6.3 Do's and Dont's When Grouping 06:09
Lesson 7 - Joining Tables 1:03:57
7.1 Table Aliases 06:54
7.2 Inner Joins 14:58
7.3 Outer Joins 14:08
7.4 Self Joins 08:00
7.5 Complex Multi Table Joins 19:57
Lesson 8 - Subqueries 33:46
8.1 Filtering Using Subqueries 14:09
8.2 The EXISTS Clause 06:49
8.3 Subqueries as Alternative to Joins 07:09
8.4 Derived Tables 05:39
Lesson 9 - Manipulating Your Data 40:02
9.1 The INSERT Statement 20:46
9.2 The UPDATE Statement 12:50
9.3 The DELETE Statement 06:26
Lesson 10 - Transaction Control 14:03
10.1 What are Transactions 05:24
10.2 Initiating a Transaction 04:17
10.3 The COMMIT and ROLLBACK Commands 04:22
Lesson 11 - Creating Database Objects And Adding Business Logic 46:00
11.1 Creating Tables 16:39
11.2 Creating and Using Views 09:15
11.3 Developing and Calling Stored Procedures 10:41
11.4 Implementing Triggers 09:25
That was just a sneak-peak into the lesson.
Enroll for this course and get full access.
Enroll now
