Users Online
· Guests Online: 3
· Members Online: 0
· Total Members: 185
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 185
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
DEMO - SQL Database for Beginers
DEMO - SQL Database for BeginersDatabase Courses |
| Categories | Most Recent | Top Rated | Popular Courses |
 | Uploader | Date Added | Views | Rating |
| Superadmin | 14.03.16 | 688 | No Rating | |
| Description | ||||
| SQL Database for Beginers Course Description Have you started learning about SQL Databases, only to get stuck while trying to teach yourself? Or are you a developer whose never felt totally at ease with database work? Have you been looking for an easy and comprehensive way to go beyond the basics and start using SQL Databases in a professional and efficient way? Perhaps, you just want to get your SQL queries to work the first time! In this thorough and easy-to-follow course, LearnToProgram's database expert Martin Holzke shows you how to achieve success. From the very first lesson, you'll learn how to correctly structure your database, how to author efficient SQL statesments and clauses, and how to manage your SQL database for scalable growth. 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. Martin will invite you to work along with him as he demonstrates the ins and outs of database management and database for application development. If you're developing web or mobile apps-- or even games-- there is much to be learned about this important facet of development. If you're brand new to SQL Database work, or a professional developer looking to learn the best practices, then SQL Database for Beginners is the perfect course for you! Lesson Description Section 1 RELATIONAL DATABASES Lesson 01 What are Databases Lesson 02 What is the role of Databases in Application Programming Lesson 03 Tables and Relations Lesson 04 Primary and Foreign Keys, and Other Constraints Lesson 05 Chap 1 Lab Exercise Section 2 SQL QUERYING Lesson 06 What is Querying Lesson 07 The ANSI SQL standard Lesson 08 DML, DDL and More Lesson 09 Common Query Tools Lesson 10 Chap 2 lab Exercise Section 3 YOUR FIRST QUERIES Lesson 11 The Select Statement Lesson 12 Limiting Output Columns Lesson 13 Formatting and Sorting Output Lesson 14 Column Aliases Lesson 15 Chapter 3 Lab Exercise Section 4 FILTERING YOUR QUERIES Lesson 16 The WHERE Clause Lesson 17 Creating a Filter Condition Lesson 18 Multiple Filter Conditions Lesson 19 More Filter Operations Lesson 20 Chapter 4 Lab Exercise Section 5 CONSOLIDATING YOUR DATA Lesson 21 Counting Records Lesson 22 Common Aggregate Functions : SUM, AVG, MIN, MAX Lesson 23 Dos and Donts When Consilidating Lesson 24 Union and Other Multiset Consolidations Lesson 25 Chapter 5 Lab Exercise Section 6 GROUP YOUR DATA Lesson 26 The Group by Clause Lesson 27 The Having Clause Lesson 28 Dos and Donts When Grouping Lesson 29 Chapter 6 Lab Exercise Section 7 JOINING TABLES Lesson 30 Table Aliases Lesson 31 Inner Joins Lesson 32 Outer Joins Lesson 33 Self Joins Lesson 34 Complex Multi Table Joins Lesson 35 Chapter 7 Lab Exercise Section 8 SUBQUERIES Lesson 36 Filtering using Subqueries Lesson 37 The EXISTS Clause Lesson 38 Subqueries as alternative Joins Lesson 39 Derived Tables Lesson 40 Chapter 8 Lab Exercise Section 9 MANIPULATING YOUR DATA Lesson 41 The INSERT Statement Lesson 42 The UPDATE Statement Lesson 43 The DELETE Statement Lesson 44 Chapter 9 Lab Exercise Section 10 TRANSACTION CONTROL Lesson 45 What are Transactions Lesson 46 Initiating a Transaction Lesson 47 The COMMIT and ROLLBACK Commands Lesson 48 Chapter 10 Lab Exercise Section 11 Creating Database Objects and Adding Business Logic Lesson 49 Creating Tables Lesson 50 Creating and Using Views Lesson 51 Developing and Calling Stored Procedures Lesson 52 Implementing Triggers Lesson 53 Chapter 11 Lab Exercise | ||||
Ratings
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.