1. TechSpot is dedicated to computer enthusiasts and power users. Ask a question and give support. Join the community here.
    TechSpot is dedicated to computer enthusiasts and power users.
    Ask a question and give support.
    Join the community here, it only takes a minute.
    Dismiss Notice

Validate your IT skills with these Microsoft SQL Server courses

By TS Dealmaster · 4 replies
May 4, 2018
Post New Reply
  1. The Microsoft SQL Server environment is one of the go-to data management systems for companies in a host of different industries, and as such certified administrators are in demand and handsomely paid for their services. The MCSA SQL Server Certification Training Bundle can get you up and running with Microsoft SQL Server and help demonstrate your knowledge to potential employers -- all for $19.

    Across two comprehensive courses, this collection will prepare you to ace two core Microsoft certification exams: 70-764 and 70-765, which demonstrate that you can administer a Microsoft SQL Server 2016 server and provision databases on Microsoft SQL Server 2016 and Microsoft Azure.

    Make your way across more than 50 hours of training, and you'll learn how to configure data access, permissions, and auditing, perform encryption on server data, and a myriad of other skills to help you ace the exams. TechSpot readers can get the MCSA SQL Server Certification Training Bundle on sale for $19, saving more than 90 percent off the usual price.

    Note: TechSpot may receive a commission for sales from links on this post through affiliate programs.

    Permalink to story.

  2. jobeard

    jobeard TS Ambassador Posts: 12,443   +1,415

    Be advised: The Microsoft SQL Server is not compatible with the SQL used by web servers. It's still good to learn the SQL but some of there 'grammar' is non-standard and the server itself is rare to find other than inside large companies.
  3. TheBigFatClown

    TheBigFatClown TS Evangelist Posts: 729   +267

    Whaaaaa? Do you buy white bread or whole wheat when you spread your FUD? Not compatible with SQL used by web servers? That depends on the web servers your talking about specifically now doesnt it?

    I'm not in the know on the statistics for Microsoft's percentage of SQL Server web servers versus everybody else but I don't think we could seriously scare anybody into thinking it's low enough not to be of extreme value.

    Furthermore, aren't large companies the ones that people might wanna be working at?
  4. jobeard

    jobeard TS Ambassador Posts: 12,443   +1,415

    It's not FUD, it's information to avoid bad assumptions on the compatibility of MS SQL. One would normally assume that a DBMS grammar would be uniform and thus 'portable' and applicable to other environments. Yes it's valuable - - doubt if it's extreme except in making a false assumption.

    Having had the experience of moving from one DBMS to another, IT IS A CHORE to inspect and edit every SQL statement use by the company. I invite you to enjoy the experience.
  5. jobeard

    jobeard TS Ambassador Posts: 12,443   +1,415

    BTW: SQL is big and has evolved over the years since envisioned by Dr Codd in 1970.

    By 2011:
    ANSI publishes SQL: 2011 or ISO/IEC 9075:2011, the seventh revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language.

    They split the new ANSI SQL standards into nine parts, including:

    • Part 1 — ISO/IEC 9075-1:2011 SQL/Framework, which offers logical concepts.

    • Part 2 — ISO/IEC 9075-2:2011 SQL/Foundation, includes central elements SQL.

    • Part 3 ISO/IEC 9075-3:2008 SQL/Call-Level Interface (CLI), explains interfacing components, like procedures, structures and variable bindings for executing SQL statements in various coding languages, like COBOL and C++, for example.

    • Part 4 ISO/IEC 9075-4:2011 SQL/Persistent Stored Modules (PSM), outlines standards for procedural extensions for SQL, including condition handling and the flow of control, as well as statement condition signals and resignals, and local variables and cursors. Assigns expressions to parameters and variables. Addresses the maintenance of persistent database language routines, like stored procedures.

    • Part 9 ISO/IEC 9075-9:2008 SQL/Management of External Data (MED), includes extensions to SQL to define datalink types and foreign-data wrappers that enable SQL to manage external data. External data is accessible, but not managed by an SQL-based DBMS.

    • Part 10 ISO/IEC 9075-10:2008 SQL/Object Language Bindings (OLB), defines the semantics and syntax of SQLJ. SQLJ is the embedding of SQL into Java. The standard specifies mechanisms for the binary portability of SQLJ applications. It also defines several Java packages along with their contained classes.

    • Part 11 ISO/IEC 9075-11:2011 SQL/Information and Definition Schemata, specifies the Information Schema and Definition Schema, offering tools to make SQL objects and databases self-describing. Includes the SQL object identifier, security and authorization specifications, as well as the security and integrity constraints. Supports the features and packages of ISO/IEC 9075, as well as the features provided by SQL-based DBMS implementations.

    • Part 13 — ISO/IEC 9075-13:2008 ISO/IEC 9075-13:2008: SQL Routines and Types Using the Java Programming Language (JRT), Specifies the capacity to utilize Java classes as SQL structured user-defined types, as well as invoke static Java methods as routines from within an SQL application, known as Java in the Database.

    • Part 14 — ISO/IEC 9075-14:2011 SQL/XML-Related Specifications, defines SQL-based extensions when using XML with SQL. It outlines XML data types, routines and functions. It also describes XML to SQL data type mappings for the storage and managing of XML inside an SQL database.
    see the timeline at whoishostingthis.com

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...