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.