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