Key features

MONEY BACK GUARANTEE

How this works :

At Simplilearn, we greatly value the trust of our patrons. Our courses were designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Self Placed Learning :

Raise refund request within 7 days of purchase of course. Money back guarantee is void if the participant has accessed more than 25% content.

  • Author efficient SQL statements and clauses
  • Understand Databases & Relationships
  • Use Common Query Tools and work with SQL commands
  • Understanding Transactions, create Tables and Views
  • Comprehend and Execute Stored Procedures

Course description

  • What is the focus of this course?

    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.

  • What are the 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

  • Who should take this course?

    • Freshers, Programmers, Software Developers, Testing professionals who want to learn SQL
    • Marketing, Sales people who want to understand their company data better

  • What is the prerequisite for this course?

    There are no prerequisite for the course. This course can be taken up by anyone who wants to learn SQL.

Course preview

    • Lesson 1 - Relational 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 Relations14:40
      • 1.4 Primary and Foreign Keys and Other Constraints12:00
    • Lesson 2 - SQL Querying 20:13
      • 2.1 What is Querying?02:40
      • 2.2 The ANSI SQL Standard03:59
      • 2.3 DML, DDL and More05:07
      • 2.4 Common Query Tools08:27
    • Lesson 3 - Your First Queries 32:55
      • 3.1 The SELECT Statement06:17
      • 3.2 Limiting Output Columns04:57
      • 3.3 Formatting and Sorting Output15:22
      • 3.4 Column Aliases06:19
    • Lesson 4 - Filtering Your Results 31:50
      • 4.1 The WHERE Clause04:57
      • 4.2 Creating a Filter Condition07:19
      • 4.3 Applying Multiple Filter Conditions08:13
      • 4.4 More Filter Options11:21
    • Lesson 5 - Consolidating Your Data 32:55
      • 5.1 Counting Records05:14
      • 5.2 Common Aggregate Functions: SUM, AVG, MIN, MAX08:06
      • 5.3 Do's and Dont's When Consolidating08:38
      • 5.4 Unions and Other Multiset Consolidations10:57
    • Lesson 6 - Grouping Your Data 21:44
      • 6.1 The GROUP BY Clause09:59
      • 6.2 The HAVING Clause05:36
      • 6.3 Do's and Dont's When Grouping06:09
    • Lesson 7 - Joining Tables 1:03:57
      • 7.1 Table Aliases06:54
      • 7.2 Inner Joins14:58
      • 7.3 Outer Joins14:08
      • 7.4 Self Joins08:00
      • 7.5 Complex Multi Table Joins19:57
    • Lesson 8 - Subqueries 33:46
      • 8.1 Filtering Using Subqueries14:09
      • 8.2 The EXISTS Clause06:49
      • 8.3 Subqueries as Alternative to Joins07:09
      • 8.4 Derived Tables05:39
    • Lesson 9 - Manipulating Your Data 40:02
      • 9.1 The INSERT Statement20:46
      • 9.2 The UPDATE Statement12:50
      • 9.3 The DELETE Statement06:26
    • Lesson 10 - Transaction Control 14:03
      • 10.1 What are Transactions05:24
      • 10.2 Initiating a Transaction04:17
      • 10.3 The COMMIT and ROLLBACK Commands04:22
    • Lesson 11 - Creating Database Objects And Adding Business Logic 46:00
      • 11.1 Creating Tables16:39
      • 11.2 Creating and Using Views09:15
      • 11.3 Developing and Calling Stored Procedures10:41
      • 11.4 Implementing Triggers09:25
    • {{childObj.title}}
      • {{childObj.childSection.chapter_name}}
        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

FAQs

  • 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.

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.