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

  • SQL Training
    • 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
  • Free Course
    • {{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.

    Contact Us

    +1-844-532-7688

    (Toll Free)

    People Also Bought

    Full Stack Web Developer - MEAN Stack Full Stack Web Developer - MEAN StackMasters Program Includes: 9 Courses Explore
    Certified Android App Developer Certified Android App Developer Course Explore
    Java Certification Training Java Certification Training Course Explore
    Certified iOS App Developer Certified iOS App Developer Course Explore
    Angular Training Angular Training Course Explore
    Selenium 3.0 Training Selenium 3.0 Training Course Explore
    Choose your Location

    Let us know your convenient schedule

    Name *
    Email *
    Phone Number
    Date (MM/DD/YYYY)
    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
    Help and Support