1. Trailer for SQL 2012 Developer tutorial: "Design and Deployment"

    01:30

    from LearnNowOnline / Added

    44 Plays / / 0 Comments

    Trailer for SQL 2012 Developer tutorial: "Design and Deployment" with Expert Instructor -- Don Kiely. Get full course details @ http://bit.ly/11Hfhc8 In this course you will learn about a number of useful features in Data Tools, including its use for both online and offline database development. In online mode you can use the new SQL Server Object Explorer that provides many of the same features as Object Explorer in SQL Server's Management Studio. You'll see how to create databases and other objects as well as change existing objects. You'll also see how to compare database schemas, a very useful tool used internally by the data tools that you can also use directly. In offline data base development you can create a database project using a Visual Studio template. You can ether import an existing database schema or create objects from scratch. You will see how both these modes work and see how you can publish changes to an existing database.

    + More details
    • Trailer for SQL 2012 Developer tutorial: "Coding Techniques"

      01:54

      from LearnNowOnline / Added

      16 Plays / / 0 Comments

      Trailer for SQL 2012 Developer tutorial: "Coding Techniques" with Expert Instructor – Frank Tillinghast. Get full course details @ http://bit.ly/11DDBve As business systems become more intricate, so does the T-SQL development needed to get at that data. In this course we’ll discuss some of the challenges facing developers including complex data types and structures; the “art” of writing efficient queries; and how to tackle and simplify multi-step processes. First we’ll discuss data types, implicit and explicit conversion, and precedence. Next, we’ll move on to discuss working with multinational data and understanding collation—which are SQL Server’s rules for sorting and comparing strings. We’ll discuss working with and storing hierarchical data using the hierarchyid data type. Next you’ll learn that even little things make a difference. We’ll explore how to boost data operations by using JOINs rather than subqueries, and how to check for inclusion using EXISTS. We’ll finish up by discussing temporary tables, table variables, user-defined table-valued functions, CTEs, worktables, and user-defined table type parameters. I’ll show you how using implicit transactions can help in the debugging process and why keeping things simple usually makes the most sense.

      + More details
      • SQL 2012 Developer tutorial: Advanced SQL CLR

        12:44

        from LearnNowOnline / Added

        90 Plays / / 0 Comments

        Tutorial for "SQL 2012 Developer: Advanced SQL CLR" with Expert Instructor Don Kiely. Get full course details @ http://bit.ly/10Sfggl In this course you will explore two kinds of code modules that can be implemented with only .NET code. Those are Aggregates and User Defined Types. These module types are not support by T-SQL You will also see how to improve performance with ordered tabled valued functions that return data that is already sorted by defining them correctly in the database.

        + More details
        • Trailer for SQL 2012 Developer tutorial: "Common Language and Runtime"

          01:25

          from LearnNowOnline / Added

          7 Plays / / 0 Comments

          Trailer for SQL 2012 Developer tutorial: "Common Language and Runtime" with Expert Instructor – Don Kiely. Get full course details @ http://bit.ly/ZuPZLy In this course you’ll learn how to write various kinds of code modules using C# code. You’ll learn the details of creating SQLCLR code manually as well as with Visual Studio. You’ll also learn about the Sql data types and how using them can avoid data conversion issues.

          + More details
          • Trailer for SQL 2012 Developer tutorial: "Transactions"

            01:24

            from LearnNowOnline / Added

            7 Plays / / 0 Comments

            Trailer for SQL 2012 Developer tutorial: "Transactions" with Expert Instructor – Don Kiely. Get full course details @ http://bit.ly/ZKHeQv In this course you’ll learn about transaction concepts and the ACID test that SQL Server uses to protect the integrity of data. You’ll also learn about locking and blocking, and how to avoid these inevitable effects of heavily used relational databases. You’ll see how to use transactions in applications, as well as how to handle compile and run time errors caused by your code. Then you’ll learn about how to take control of transactions and defined them explicitly in your code. Then we’ll wrap with a look at a relatively new feature of T-SQL, structured exception handling that has long been a feature of general purpose programming languages.

            + More details
            • SQL 2012 Developer: Functions – Trailer

              01:19

              from LearnNowOnline / Added

              4 Plays / / 0 Comments

              Trailer for SQL 2012 Developer: Functions tutorial with Expert Instructor – Don Kiely. Get full course details @ http://bit.ly/16o48tX In this course you’ll learn about the three kinds of UDFs available in SQL Server and will see several examples of functions and how to use them. We’ll start by looking at scalar functions that return a single value, then will explore the two types of table-valued functions.

              + More details
              • SQL 2012 Developer tutorial: Views

                18:48

                from LearnNowOnline / Added

                18 Plays / / 0 Comments

                SQL 2012 Developer tutorial: Views with Expert Instructor – Don Kiely. Get full course details @ http://www.learnnowonline.com/learndevnow/topic/316 In this course you’ll learn how to make use of views. We’ll start by exploring how to create views, reviewing the syntax and the various options you can use. Then we’ll look at the Management Studio tools that help create views. Next you’ll learn how to create a view with a select statement.

                + More details

                What are Tags?

                Tags

                Tags are keywords that describe videos. For example, a video of your Hawaiian vacation might be tagged with "Hawaii," "beach," "surfing," and "sunburn."